In SqlServer Management Studio Express, Server Type Option Is Greyed Out, Also Publication Option Missing
Apr 27, 2008
Hi everyone
In my SqlServer Management Studio Express, on start up it shows the server type option, but greyed.
So that value is fixed to database engine. ( I'm trying to work on an SqlServer Compact Edition database through the SSMStudio
that's why I'm trying to get this to change.)
Besides, after I connect i go to the Object Explorer, expand the server node, and go to Replication.
When i expand replication, i get the "Local Subscription" option, but nothng for Publication.( I want to work on Merge Replication, that's why I desparately need Publication to work)
Am i missing something here?
I did not install SqlServer separately, I only have what comes bundled with the Visual Studio 2005 Setup.
I was hoping this would be fixed in SP1, but it is still missing. Particularly in a development environment, I find it very useful to have scripts DROP first, then do a CREATE for tables. There is an option called Script Behavior that is supposed to allow this, according to the help text. There are supposed to be 3 options, DROP only, CREATE only and DROP + CREATE. This third option (the one I need) is missing. It does not show up on the drop down.
Sorry, I don't want to be rude, but before anyone suggests it, yes, I know I can create a DROP script first and then go back in and create a CREATE script and then run both. And I don't want to change my methodology, and I don't want to do twice the work. All I would like to know is if anyone knows how to get this 3rd option to appear, or if its a known bug, is there a hotfix or a plan to fix it soon.
I am trying to install SQL Server 2005 using command prompt. I have gotten the latest download. My question is what is the commad prompt for the tag ADDLOCAL for SQL Server Management Studio Express. For SQL Server datatbase it is called SQL_Engine. In the same way what should I be using for "SQL Server Management Studio Express". I want to limit the choices that are installed on the user machines.
This is driving me a little nuts, I have been testing locally with SQL Server Express 2005 and this has not been a problem, however now that I have restored the databases to SQL Server 2005 (not express) When I go into SQL Server Management Studio open a table the option for changing a query type is greyed out has anyone seen this or have any ideas how I can get this working. Thanks, Terry
I'm trying to install SQL Server 2005 onto my XP Professional PC. When I get to the "Components to install" part, the "SQL server database services option" is greyed out. Infact, all options except "Workstation components..." are greyed out. I've tried uninstalling all previous versions of SQL server and trying again, but with the same results.
I have installed the advanced toolkit for Microsoft Sql server 2005, with the SQL server Business Intelligence Development Studio but I don't have the option the create a Integration Service project. I only have the Report Server project option available.
Do I have to download something else to get it?
I do not have a SQL server instance installed on the machine I installed the toolkit on.
Why is that some of the databases has their "Transaction Log" & "File and Filegroup" options in Backup greyed out? I was trying to create a backup job using the sql enterprise backup wizard. However, the database that is the backend of our erp application has its "Transaction Log" and "File and Filegroup" option greyed out.
I have a workstation that had an installation of SQL 2K5 that a tech set up for me. Naturally, it was the wrong edition AND no components were actually installed, making my laptop into a paperweight. I advised that we get SQL Developer for the DBA's and I am trying to install but the option for Reporting Services is greyed out.
I have uninstalled SQL (I think it was Standard) and I even went through the "complete uninstall" detailed in one of these threads thinking that was the problem. I am still unable to install Reporting Services.
I just installed SQL Server 2005 Express. I would like to import tables from another DB, and I read in the help files that I just need to (1) right-click on a non-system database in Management Studio Express, and (2) select Import/Export under the Tasks menu.
I tried this, but my Tasks menu only contains these options: Detach, Shrink, Backup, Restore, Generate Scripts.
I googled for "sql server 2005 "no import" tasks", and it appears that a couple of people have had this problem -- the only solution I read was to install the "Workstation Components," but I already have, and still no luck.
I downloaded and performed a full install of SQL Server Express 2008 Nov CTP. It was installed on a fresh installation of Windows Vista Enterprise x64.
During setup, I checked the 'Client Tools' box which has the description: "Includes management and development tools: SQL Server Management Studio, SQL Server Configuration Manager, SQL Server Profiler, and Database Engine Tuning Advisor"
The installation ran fine with no errors. After install I looked for the Management Studio but couldnt find it anywhere. No SQL Server Profiler or Database Tuning Advisor either. The only tool that appears to have installed is the SQL Server Configuration Manager.
If I check my Start Menu, the only 2008 items that exist are Microsoft SQL Server 2008 >
Configuration Tools >
SQL Server Configuration Manager SQL Server Error and Usage Reporting SQL Server Installation Center
I checked the summary log and everythign PASSED: Package results: Passed Execution statistics: Exit code: 0x00000000 Exit message: Passed Package start time: 12/13/2007 14:05:39 Package end time: 12/13/2007 14:09:06 Package install location: c:Program Files (x86)Microsoft SQL Server100Setup Bootstrap Package initial action: Install Media source location: Install Media version: 10.0.1075.23 Machine properties: Machine name: xxx Machine processor count: 2 OS version: Windows Vista OS service pack: OS language: English (United States) OS architecture: x64 Process architecture: 32 Bit Properties provided in package.xml file: LegalProductName: SQL Server Database Services 2008 Description: SQL Server Database Services 2008 Details: Install for SQL Server Database Services 2008 ProductName: SQL2008 Version: 10 SPLevel: 0 KBArticle: KB876234 KBArticleHyperlink: http://support.microsoft.com/?kbid=876234 Command line arguments provided: ACTION: Install INSTANCEIDSUFFIX: Product features discovered: Product: SQL2005 Product: SQL2008 Feature status after execution: Database Engine Services: Passed Replication: Passed Client Tools: Passed Windows Installer logs generated during execution: C:Program Files (x86)Microsoft SQL Server100Setup BootstrapLog20071213_1405T60-l3ac207_20071213_1405_Snac_Cpu64_1.log C:Program Files (x86)Microsoft SQL Server100Setup BootstrapLog20071213_1405T60-l3ac207_20071213_1405_Msxml6_Cpu64_1.log C:Program Files (x86)Microsoft SQL Server100Setup BootstrapLog20071213_1405T60-l3ac207_20071213_1405_Tools_Cpu32_1.log C:Program Files (x86)Microsoft SQL Server100Setup BootstrapLog20071213_1405T60-l3ac207_20071213_1405_SqlWriter_Cpu64_1.log C:Program Files (x86)Microsoft SQL Server100Setup BootstrapLog20071213_1405T60-l3ac207_20071213_1405_SqlBrowser_Cpu32_1.log C:Program Files (x86)Microsoft SQL Server100Setup BootstrapLog20071213_1405T60-l3ac207_20071213_1405_Sql_Cpu32_1.log
Much of the (full) SQL Management Studio tutorial works fine, until I come to "projects and solutions", which are supposed to be creatable at File - New ?
Found a list of missing features for the "Express" version, but that just tells of rather sophisticated stuff only.
I want to import a txt file data to a sql server database table, to do this i used sql server import and export wizard. In this when we choose a Data Source, the option Flat file source is not coming up in the combo box in the wizard.
I am using sql server 2005, Management Studio to do this.
steps 1. right click on the database --> all tasks --> import data --> sql server import export wizard --> choose data source dialog box....
I found a bug in Management Studio, which can be reproduced with following steps:
1. Create a new publication with the 'New Publication Wizard' 2. Select a database which contains at least 2 tables. 3. Select 'transactional publicatioon' 4. Select at least 2 tables as articles 5. Set article properties for all table articles 6. Change 'Statement Delivery' to 'Insert statement', 'Update statement' and 'Delete statement' and save the article properties. 7. If you now check the properties for a single article you find that the 'Statement Delivery' is set to 'Do not replicate...'. If you generate this publication and create a subscritpion you will see, that actual no replication take place.
It took me a while to find out why my replication doesn't work! :-((
I just did a clean install of SQL 2000 Personal edition. I am trying to DTS an excel file in but the excel icon is not there!!!!! There are the other excel ODBC sources but they each require me to setup a DSN (not normal!!!)
Anyone had this problem before? I am uninstalling and reinstalling.
I used Management Studio to copy a database from one server to another. It created a DTS package, which I can see when I log in to Integration Services through MS. However, when I right click on the name of the package, I don't see an export option. I am a member of the sysadmin group. Any idea why the option is not there and how to fix it? Thanks in advance for your help.
I want to start the SSIS wizard to import data from a flat file, but I right click the DB > select Task and the Import and Export options are not there. Is there something I have to enable before the options show up
I have a problem with deleting old bak files from a Cleanup Maintenance Task. I have backups in subdirectories and I read in SQL Server 2005 Books Online that:
In contrast to earlier versions of the Maintenance Cleanup task, the SQL Server 2005 version of the task does not automatically delete files in the subdirectories of the specified directory. This constraint reduces the surface area of any attack that could exploit the functionality of the Maintenance Cleanup task to delete files maliciously. To delete the first-level subfolders, you must explicitly elect to do this by checking the Include first-level subfolders option in the Maintenance Cleanup Task dialog box.
I cannot find such an option in my Maintenance Cleanup Task dialog box. I do not think I installed any service packs yet, could this be the problem?
On my workstation the option is there, but on a couple other workstations that option is not available from the file menu. I tested doing the exact same thing and the option just isn't there. Anyone have any idea's?
We have an application with SQL Server 2005 as his database. When I open the database in sql server management studio, under management > it does not give the option like "backup", "copy database", nor there is folder called maintenance plans.
I am a novice at SQl Server, so apologise in advance if you think this is a really stupid question.
I have a windows XP laptop with Visual Studio 2005. I installed SQl Server 2005 Developer Edition but do not see the SQl Server Management Studio anywhere. The only thing in Programs/ SQL Server 2005 is SQL Server Configuration Manager. I then uninstalled it & installed SQL Server Express but encountered the same issue.
I would like to install the Developer Edition if possible. I have tried uninstalling & reinstalling a few times but it does not work.
Could someone please help in resolving this. Appreciate it!
In the Project Web Access (PWA 2010), I have created Report Library which contains .rdl files --> Manage Subscription --> Add Subscription --> Email subscription is missing
Did i missed out some thing but other email functionalities like notifications, Approval workflow are working fine so no issue with SMTP.
So I started a new job recently and have noticed a few strange configurations. Typically I would never mess with min memory per query option and index create memory option configuration because i just haven't seen any need to. My typical thought is that if it isn't broke... They have been modified on every single server in my environment.
From Books Online: • This option is an advanced option and should be changed only by an experienced database administrator or certified SQL Server technician. • The index create memory option is self-configuring and usually works without requiring adjustment. However, if you experience difficulties creating indexes, consider increasing the value of this option from its run value.
I've just installed SQL Server 2005 Development Edition x64 on Windows XP x64bit. The actual server (as well as Integration, Reporting Services etc) installs fine, I can connect to it via Visual Studio 2005 fine. However, all of the software tools are missing including Management Studio, Business Intelligence Studio etc. They don't show up in the start menu at all and I can't find them in the Program Files directory.
Anyone know how I can get them back? I've tried reinstalling SQL Server 2005, reformatting Windows XP x64, I'm at my wits end!! Many thanks!
In Query Analyzer I could go to the Query menu and select Show ServerTrace and it would give me trace information with duration, CPU, Readsand Writes cost. I have been using SQL Server 2005 for a couple monthsnow and I can't seem to find that option in SQL Management Studio. Am Imissing something?Jason
I have several servers that do not have SSMS installed. A couple of them are running as a clustered server. How do I install SSMS on these servers? they are running and have production databases on them. I have tried re-installing the management tools but that didn't work.
I just installed SQL Server 2005 64bit on a fresh system with no other applications loaded on running on the new server.
The only other component that was installed with the SS2K5 database services is SSIS. The base installation and the SP2 patch went on perfect.
I went looking for the Management Studio thru the Start menu options and it is NOT under the Microsoft SQL Server 2005 group. The only options under the SS2K5 group are "Configuration Tools" and "Docs and Tutorials".
Here are file names that I downloaded from the MS website and installed.
SW CD SQL Svr Enterprise Edtn 2005 64Bit X64 English #1 x64 MLF.x11-57796 (which is a zipped)
SQLServer2005SP2-KB921896-x64-ENU
There was also another zipped file that I tried to install but it seems to be a duplicate of the zipped file above:
SW CD SQL Svr Enterprise Edtn 2005 64Bit X64 English #2 x64 MLF.x11-57797
I currently have SQL Server Management Studio Express 2005 and would like to upgrade my machine to SQL Developer 2005 as easily as possible. Keeping my databases and such.
Any recommendations on the best way to do this would be greatly appreciated.
I have a database in my "App_Data" folder of my visual studio project. I can view it fine in Visual Studio's built-in tools for managing a database attached to a solution. However i recently started playing around with the SQL Server Management Studio Express program. When i attach my database to Management Studio, and try to run my program it crashes. I think it might be a permissions error?!? When i detatch it and reattach it in visual studio it runs fine again. Any suggestions? ThanksJason
I have recently installed the SQL Server Management Studio Express but I do not find Management Tools in order to create scheduled backups and shrinking of the databases. I was under the impression that this should be included in the Management Studio. I use the SQL 2005 Express for smaller customers who run the SQL on a desktop unit. I need a way to backup the data to a server machine for backup purposes. I have uninstalled and reinstalled to no avail.
I'm trying to define a linked server using Microsoft OLE DB Provider for Data Mining Services. MSDMine data provider is missing. Do you know where I can get this? Thanks in advance.
I'm have a Xeon 64bit proc. using SP2. And had installed:
SQLServer2005_ADOMD_x64.msi, SLQServer2005_ASOLEDB9_x64.msi,SQLServer2005_OLAPDM_x64.msi, and SQLServer2005_XMO_x64.msi.
I found the following bug in Management Studio: I add an article with sp_addarticle and a value of 0x00 for @schema_option or via the wizard with all article properties set to false. Then I script the publication to a file. The result contains a sp_addarticle statement with @schema_option = 0x0000000000004071, which must be wrong. To prove that I recreated the article with the generated script and checked the article properties. As I feared 4 of the properties ('Copy clustered index', 'Copy nonclustered index', 'Copy unique key constaints' and 'Convert data types') are set to true!
I recently come to problem. I want to deploy my web site, which uses SQL2005EE extensively, so I began searching for host, SHARED HOSTING solution. I haven't find one offering SQL2005EE on .NET2.0 final frameworkI have been told that there isn't ONE host which would offer SQL2005EE on Final .NET2.0 shared hosting, that it is illegal! Only if the shared host provided is free, which is insufficient in my needs (free hosts have low trafic/disk space etc).Is it true? If I pay for hosting, I can't have SQL2005EE as an option in their hosting plan? Just SQL2005 full as an option? This way I need to pick up some expensive shared hosting plan?How you ppl solved this problem?