I'm packaging SQL 2005 Express as part of the installer for a custom program. The installer works fine and everything runs fine, but I don't want users to see the sql server > configuration tools start menu group and start playing around with settings.
Is there a command line option to not create the start menu group that anyone knows about, or another way to have the installer not create the icons?
Thanks,
Michael
Hi,
does it possible to compltely deactivate the "open in report builder" menu in sharepoint integrated mode?
thanks.
Hello,
I´ve made a mistake on my part. I have deleted my complete program icons for "Microsoft SQL Server" in my start menu.
Is there a simple way to just renew all the icons in my start menu without reinstalling the complete sql server.
Thank you very much for any tips.
I have a 2003 Server which has two Named Instances of SQL Server 2000.
I need to add a third Named Instance, but when I logged onto the Server this morning, I noticed that all of the
'Microsoft SQL Server' Entries are missing from the START/PROGRAMS menu !! Enterprise Manager, BOL... everything!! The SQL Server Service Manager is running and both of my Instances are up and running (this is a production box). I can launch Enterprise Manager from MMC.EXE in WINDOWSSystem32 folder... very weird!!!!
In my Add/Remove Programs, I see MS SQL Server listed Twice.. one time for each of the two named Instances.
Has anyone ever seen this before??? Do you think it's safe to run SQL Server Installation to Install a Third Instance on this box???
Hello,
I have installed SQL server 2005 enterprise edition on Windows 2003 virtual PC (full installation). The installation went through successfully. However, after install completed, I cannot find any of the client tools under the start menu -> all programs -> Microsoft SQL server 2005 menu. The only item listed under the SQL server 2005 is Configuration Tools, which is used to configure the database server.
I have tried to install the client component again (in case I didn't install them at the first place) but the installation process cannot be started since it detected that the client components have been installed already. I can also see the sql server native client running in the services.
The server engine is working fine since I can connect to that sql server using another machine where I have the client tool (SQL server management studio).
One of my friends has exactly the same problem. He installed the sql server 2005 Standard edition on windows 2003 server (full installation), but the client tools are not showing up in the start menu either.
I also checked the location for the SQL server management studio (Microsoft SQL server/90/Tools/Binn/VSShell/Common7/IDE), there is only one folder called publicAssemblies listed under. Is this correct or something is missing?
Thanks
Excel 2007 Documents Not Displayed in Windows XP Professional sp2
Start Menu's Recent Documents List:
Dear Microsoft Support:
I can't figure out how to get recently used Excel 2007 (new file formats) documents to show up in the Windows XP Professional (sp2) Start Menu's Recent Documents List. I checked the Internet, the knowledgebase, many parts of the MS web site, etc. for an answer but can't find one.
Are Excel 2007 documents supposed to show up in the XP Start Menu's Recent Document List? Is this a bug or do I have to do some sort of configuration to make it do so? If it's a bug, when will a fix be available?
Are these new Excel 2007 files filtered out like EXE files are which will not appear in the Recent Document List?
The Excel 2007 file types are listed in the Registry.
This question is also posted on Experts-Exchange...No solutions yet.
Thanks.
Jim.
I'm trying to pull records from a source/staging table where there is a duplicate row in it.I don't need that as the requirement is to garbage in /garbage out.when I do that from mart and use joins btw fact and dimensions, Im not getting this duplicate record as Im using distinct/group by. If I removed it, then it returns more than 3000 rows which is not correct. Is there a way I can keep these duplicates without removing group by...Im using correct joins and filters.
View 5 Replies View RelatedI setup SQL Server 2012 on Windows Server 2012 with the service accounts in the local Administrator group, but now that I'd like to remove the accounts from this group I'm finding they don't have the appropriate access to the network storage. notes on setting the per-service SID's for SQL (SQL Engine, Analysis Services, Reporting Services, and Agent Service) so they can read the Data, Log, and TempDB mount points?
View 2 Replies View RelatedHello,
I'm using SQLServer 2005 and I build a report in the visual studio.
I need a way to pass as parameter whether to break at start of a specific group or not.
Thanks, Talia.
I have an SSRS 2012 table report with groups; each group is broken ie. one group for one page, and there are multiple groups in multiple pages.
'GroupName' column has multiple values - X,Y,Z,......
I need to group 'GroupName' with X,Y,Z,..... ie value X in page 1,value Y in page 2, value Z in page 3...
Now, I need to display another column (ABC) in this table report (outside the group column 'GroupName'); this outside column itself is another column header (not a group header) in the table (report) and it derives its name partly from the 'GroupName' Â values:
Example:
Value X for GroupName in page 1 will mean, in page 1, column Name of ABC column must be ABC-X Value Y for GroupName in page 2 will mean, in page 2, column Name of ABC column must be ABC-Y Value Z for GroupName in page 3 will mean, in page 3, column Name of
ABC column must be ABC-Z
ie the column name of ABC (Clm ABC) Â must be dynamic as per the GroupName values (X,Y,Z....)
Page1:
GroupName          Clm ABC-X
X
Page2:
GroupName          Clm ABC-Y
Y
Page3:
GroupName          Clm ABC-Z
Z
I have been able to use First(ReportItems!GroupName.Value) in the Page Header to get GroupNames displayed in each page; I get X in page 1, Y in page 2, Z in page 3.....
However, when I use ReportItems (that refers to a group name) in the Report Body outside the group,
I get the following error:
Report item expressions can only refer to other report items within the same grouping scope or a containing grouping scope
I need to get the X, Y, Z ... in each page for the column ABC.
I have been able to use this - First(Fields!GroupName.Value); however, I get ABC-X, ABC-X, ABC-X in each of the pages for the ABC column, instead of ABC-X in page 1, ABC-Y in page 2, ABC-Z in page 3, ...
How do you create a php or html page with a drop down menu from a table a database? Please show any code or helpful links,
Thanks!
Hi,As subj says. A simple menu is defined in a table. But how to extract it?Heres the deal:Table menu has these 3 columns: menuid parent menudescOk this should be easy right? Those menu-rows that has parent=0 is"toplevel". And so forth. An example:1 0 "Items"2 0 "Standings"3 0 "Test"4 2 "Liverpool"5 2 "AC Milan"6 1 "Itemno1"This menu should in layout come in this order:ItemsItemno1TestStandingsAC MilanLiverpoolThat is: Alphabetically sorted and with the children underneath the parents.Right? Yes - and selecting the menu and doing some gymnastics in ASP isntthat hard. But ASP must be the language that has the "crapiest" way ofhandling arrays...so a simple task is really messy. Creating a storedprocedure involes 2-3 temporary tables as I see it. Not vey elegant either.So my question is: Isnt there any way of selecting this order directly usingSQL?? Some nice clean and beautiful way?--Thanks,Summa
View 2 Replies View RelatedI followed an article which was recently published by Jeff Prosise in his "Wicked Code" column in MSDN magazine and I was able to make it work.My problem is that I do not know how to refresh the menu. If I add new record in the sitemap table what needs to happen to refresh the menu.
View 2 Replies View RelatedHello,I am upgrading my (simple) cms from one menu layer to two layers. So i have two tables in de my DB- table_mainmenu- table_submenuThe submenu records are linked to the mainmenu records on the mainmenu id. So far so good. Heres my problem, i cant figure out how to change the order of the pages...!? What is the theory behind recording the stacking order of the menu items? How can i record this information in the DB?I just need the theory, i can figure out the details for myself. Thanks in advance!Corstiaanp.s. is the the right forum to post this?
View 4 Replies View RelatedHow do I get a distinct value of menu from tables
Here is my script
select distinct menu, others, clientele,menuID from myrestaurant where username = 'mary' and batch = 238335
hi all,
I have a table called suppliers where i type my suppliers details.
I have also a table called supp_corellation in which i have the proffesion of my suppliers.
there is one column in the table of suppliers which it takes data from the table supp_corellation . Is it possible to choose the values from a list instead of typing in my table (lets say drop down list)???
Hi
is there any way of getting the values of a row in a table to be reflected as the values of a drop down menu?
Hello, I need permission to work with SQL jobs on particular sever, currently I'm not able to see SQL agent menu.
What permissions should i need to have to view SQL Agent Menu.
Please some one help in this.
Thanks,
Malathi.
Is it possible in SQL Reporting 2005 to have dropdown menu(eg..on mouseover list of static menu appears from which i can navigate to other rdl files while passing all parameters) ..
I am now starting to create actual database projects in SSMS but the problem is that when I go to create add a new item by right-clicking on the project all i get is
Existing Item
New Connection
New Query
So, can anyone tell me how do I get the 'Add New Item' menu item to appear so I don't have do the riduculous way of creating a new query, then open another non-project script item from template explorer, then copy the contents from latter to former and then close the superfluous non-project script item.
Instead of explaining my question here I've made a seperate
html page with a full explanation of my problem with pictures
and examples.
I've posted the question to this URL
http://miona.com/listmenus/
Hello,
I installed SQL Server 2005 Standard Edition and SQL Server Management Studio Express. I am trying to set up merge replication. When I right-click the Replication folder in Object Explorer, the Configure Distribution menu item is not there. Also missing is the New - Publication menu item. All I can do is add New Subscriptions. I am logged in as admin with full priveledges. Am I missing something? Thanks!
FYI: I am running Windows XP SP2 and have installed SQL Server 2005 SP2. Thanks again...
Hi Friends,
I have created a report using SSRS 2005, and I am able to call another reports by clicking a column (using jump to report) from my first report. I would like to know is it possible to have a pulldown menu by right clicking a column at runtime in SSRS 2005? Please let me know
Thanks & Regards,
Naveen J V
Hey Geeks,
I have found in the SQL Server Logs under Management Menu that says something like this :
Login failed for user 'sa'. [CLIENT: 59.144.69.233], Time : 3/9/2006 3:41:53 PM
And for every second there is addition in the messages.
Why is it happening? Can anyone tell me?
Thanks in Advance.
Snehal
Is anyone else having an issue with SSRS menus not being able to be clicked on?
When I roll the mouse over the menu item, it highlights, but when I click, nothing happens.
It affects the top menu items, and any right click menu.
This is an intermittent problem, but it does happen daily. I have to shut down VS to fix.
BobP
Hi,
I have created a menu using code behind i.e from c#.
is there a property of menuitem, with which i can expand i particular menutiem.
following is my code:-
*****************************************************
Menu objmnu = new Menu();
MenuItem objmnu1 = new MenuItem();
objmnu1.header = "Root"
objmnu.Items.Add(objmnu1);
MenuItem objm1 = new MenuItem();
objm1.header = "Child1"
objmnu1.Items.Add(objm1);
MenuItem objm2 = new MenuItem();
objm2.header = "Child2"
objmnu1.Items.Add(objm2);
MenuItem objm21 = new MenuItem();
objm21.header = "Node1"
objm2.Items.Add(objm21);
MenuItem objm22 = new MenuItem();
objm22.header = "Node2"
objm2.Items.Add(objm22);
*****************************************************
what i want is on click of a button i want to expand "Child2" node.
i need help.
bye
Mohan Nautiyal
I have a multivalued drop down menu that isn't wide enough to display the entire label. It only displays about half of the label. The text it is trying to display should look like "Global Zone 1 - Global Zone 2 - Global Zone 3 - Global Zone 4", and the only visible text is "Global Zone 1 - Global Zone2". It does have a scroll bar at the bottom, but it is ridiculous.
When I set it to not be multivalued, the drop down menu grows to the size of my label. The menu has plenty of space to grow, it is only taking up a very small amount of the screen.
Is there any way to correct this issue?
Thanks
When using SQL Server Management Studio Express I get multiples of all the standard Windows menu items as well as in the dropdowns. I have also experienced this in the Visual Basic 2005 Exprerss edition IDE. What is causing this?
View 10 Replies View RelatedHi Everyone,I'm drawing a blank here and I am hoping someone can point me in the right direction. I have a table with the following columns (some omitted)IDGUIDPageNameParentPageID I want to build a hierarchical navigation system (2-tier). The conceptual problem that I am running into was getting this information from the same table. Initially I was going to use a nested repeater but I am thinking a treeview would be better. Anyway, the problem is the query. How would I start with something like this? Let's use the following as an exampleRows(ID '1', GUID '888....', PageName 'Page A', ParentPageID '-1')(ID '2', GUID '111....', PageName 'Page B', ParentPageID '-1')(ID '3', GUID '222....', PageName 'Page C', ParentPageID '-1')(ID '4', GUID '375....', PageName 'Page 1', ParentPageID '1')(ID '5', GUID '562....', PageName 'Page 2', ParentPageID '1')(ID '6', GUID '874....', PageName 'Page 3', ParentPageID '2')
(ID '7', GUID '388....', PageName 'Page 4', ParentPageID '3') So, I want to be able to build a query so that I can do the followingPage A Page 1 Page 2Page B Page 3Page C Page 4 Any help would be greatly appreciated. Thanks!
Hi,
I have created an SQL Server instance in SQL Server Management Studio. I have a few databases, and stored procedures in them. When I right click on the stored procedure, I have the menu for "New Stored Procedure, Modify, Script Procedure as, and so on". But, I could not see the "Execute Stored Procedure" item.
Could any one help to find out what could be the problem and solve it?
Thanks,
Luke.
Information stored within the database is as follows, although the number of sub levels could easily grow :
PageID - Title - ParentID
1 - Title1 - 0
2 - Title2 - 0
3 - Title3 - 1
4 - Title4 - 1
5 - Title5 - 4
Required outcome :
[+] Title1
.....[+] Title3
.....[+] Title4
..........[+] Title5
[+] Title2
Hi AllWondered if you could help me with the below query.I have 1 simple table called STOCKCATS that consists of 2 fields.These fields are called CATID and LEVEL.The contents of this table are as follows:CATID LEVELcat01 <nothing>cat02 <nothing>cat03 cat01cat04 <nothing>cat05 cat01cat06 cat02cat07 cat04etc.. etc...The way this table works is that I have an ASP page that allows the user tocreate a stock category at 2 levels, category level and sub-category level.When I file the entered data into the table, if the user has chosen tocreate a category level stock category then the LEVEL field is left blankand if they chose to create a sub-category level category then I post therelevant category level stock category code in the LEVEL field. Forexample, in the above list cat01 is a category level stock category andcat05 is a sub-category as it is a sub-category of cat01.My query is that I want to populate a simple HTML <SELECT> menu (using ASP),but instead of it being a straightforward 'select catid from stockcats orderby catid', I want to group this list into some kind of order, eg:instead of:cat01 <nothing> << I need to bring back this 2nd column so that I cando a simple IF THEN in asp to indent sub-catscat02 <nothing>cat03 cat01cat04 <nothing>cat05 cat01cat06 cat02cat07 cat04I would likecat01 <nothing> << dittocat03 cat01cat05 cat01cat02 <nothing>cat06 cat02cat04 <nothing>cat07 cat04Do you know if this is possible in pure SQL (I must confess that I'm usingMySQL, but I would have thought the SQL syntax would be the same if it ispossible) or a combo of ASP & SQL?ThanksRobbie
View 3 Replies View RelatedI'm stuggling to find information on how to use the Deploy menu within a project in solution explorer. I would like to understand how to setup modify and delete the attributes that affect the actions of the Deploy menu. How to set different settings so that I can deploy to a test server ad then later change it so that I can deploy to a production server.
All help is welcome.
Thanks