Edit: When I say "SQL Server", I'm really talking about the Management Studio. Sorry if that was confusing. Oh I hate when things like this happen. I was working with SQL Server yesterday and trying out the PIVOT command to try to figure out how it worked. So I created a new table with four columns, and the first column was going to hav...
I have created a new Schema in a database called Contexts. Now when I want to write a query, Management Studio doesn't recognize the tables that belong to the new Schema. It says: 'Invalid object name Contexts.ContextLibraries'... Transact-SQL: INSERT INTO [Contexts].[ContextLibraries] (ChannelId, [IsSystem]) VALUES (@ChannelId, 1) W...
Hi, i m using sql server 2005 with service pack-2. When I connect sql server with by registering the remote server with IP, username and password. I have done all the neccessary setting for connecting remotely "SQL Server 2005 Surface Area Configuration". i got following error while connection: This version of Microsoft SQL Server M...
When I go to File > Open > File and select a .sql script, or even when I drag a .sql file into the SQL Management Studio Express window, it opens the script in Notepad which is totally useless when I want to run the script. Since this is on an external server (Windows 2003 Server), I end up having to disconnect from RDP, disable the loc...
Question: Is it possible to stop SSMS from monitoring the service status of registered servers? Details: SSMS 2008 monitors the service status of every registered server. From what I have seen it seems to reach out to every registered server every minute or so to check it's status, in my case that is over 100 servers. This process has...
This happens intermittently and seems to be related to accidentally hitting a key. Any ideas what causes this? ...
By default, in Visual Studio and in SQL Server Management Studio, Ctrl+Tab opens a navigation popup which lists all the open windows. The idea is that you can press Tab multiple times while keeping Ctrl pressed; as soon as you release Ctrl, the navigation popup disappears and the selected document is activated. Unfortunately, as soon as...
I am attempting to create a Stored Procedure for a newly created database. However the SSMS intellisense does not recognize more than half of the tables which have been created. For example whilst in the left hand column under tables I have a table dbo.Room, when I type "dbo." in the new query window, that table is not listed, in fact ...
Guys, In SSMS when I try to execute: SELECT CONVERT(VARCHAR(MAX), REPLICATE('a',9000)) I see only the first 8000 characters displayed. The settings Tool >> Options >> Query Results >> Sql Server >> Results to Grid is set to 65534 and Results to Text is set to 8192. Also when I try to run this from SQLCMD sqlcmd -S Server -E -y ...
This is from SQL Server 2008, ssms When I create a table, it creates under dbo. I would like to create it under a different schema, but when I use the 'New Table' dialog, I can never find the field where to specify this. ...
When generating code/scripts, why does SQL Server Management Studio generate code using square brackets and not double-quotes? SELECT [NAME] FROM [TABLE] and is there a way (setting/registry entry) to configure it to use double-quotes (the standard) instead? SELECT "NAME" FROM "TABLE" This is very MSFT-ty feature, given that all th...
I have a long query that I'd like to replace the , with a carriage return to put all the fields on their own line but I can't figure out how to do it in the editor. It wont be fool proof, but better than doing it by hand. ...
I like to use SQL Server 2005 templates to run frequently used queries. You can include parameters in your templates using this syntax: <LastName, varchar, 'Bob'> I have a query that needs the less than or equals to operator <= but unfortunately the SQL Server 2005 template interprets that as the start of a parameter. I have been unab...
Do you know? PS: Some of you will tell me to check the Sql Server Management Studio features roadmap. But where is it? ...
I have the following error while I connect to SQL Server 2008 Management Studio with Windows authentication. "The request failed or the service did not respond in a timely fashion. Consult the event log or other applicable error logs for details." Is anybody tell me why i am getting this error, whereas my SQL Server is running under n...
I am using SQL Server 2005 database with SQL Server Management Studio. Is there a way to hide a relationship between two tables in the diagram without actually deleting the relationship from the database? Any help will be most appreciated. ...
I have a client that has a SQL Server 2008 installation. They have given me a windows domain username/password on their domain, however, my workstation is not on their domain. I'm trying to connect with Management Studio on Vista Professional. I've tried using the "network accounts" under "user accounts", and this works for other reso...
I have a typical dev scenario: I have a SQL 2008 database that I want to copy every so often to my local instance of 2008 Express so that I can do dev, make changes, etc. to the local copy. I have some constraints though: the source db is part of a live e-commerce site in shared hosting so I can't detach it and the hosting service wants ...
When I attempt to expand the stored procedures tab in Management Studio I am getting the following error and no stored procedures are displayed. I've tried re-running all stored procedure scripts (which works without errors) and refreshing the tab, but I still get the following error: =================================== Could not conti...
Does anyone have any good articles or even more preferable screencasts to using the table designer for SSMS 2008 to get the most out of it? To often I end up trying to fumble through it and just end up googling the sql script to do specifically what I'm trying to accomplish with keys or indexes etc and just end up repeating the process ...