Our database is about to reach 1000 stored procedures. Although we were wise and created a good scheme for naming the stored procedures, hunting for the stored procedure you need can be a bit frustrating as you scroll and scroll and scroll. If I know the exact name of the stored procedure I'm looking for, it would be great to identify ...
I'm connecting to a database server (MSSS 2005, 9.0 SP2) which is almost totally without my control. If I connect to it using Management Studio 2005 I can browse the list of tables, views, other objects in some of the databases using object explorer. If I connect to it using Management Studio 2008, I cannot see the list. I can write ...
When I generate scripts in sql server 2008 EM, it seems to insert the date/time in the script also. How can I remove that? ...
I have this query that spawns the following error: SELECT * FROM Quota WHERE LEFT(QtLabel, LEN(QtLabel)-2) IN ( '1032', '3300', '9682' ) Msg 536, Level 16, State 5, Line 1 Invalid length parameter passed to the SUBSTRING function. Am I doing something wrong? It tends to show up when I use the LEN() function. Might it be a datat...
Can I replace Sql Server Management Studio Express with the enterprise version without deleting the express version? If so can you tell me how? ...
A few minutes ago, while working out a new sproc, I executed the wrong delete statement. Something like this: Delete From SomeTable Where SomeStatusID=1 10 seconds into it, I realized that I typed in the wrong status and hit cancel. It said that the statement was canceled. I did a restore to a separate database to get back the table ...
Using SQLServer 2005 I have dropped some tables (via a T-SQL query) and they are still showing as tables when creating a database diagram! Already tried refreshing, disconnecting and reconnecting. ...
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. ...
Is there a way to change the location of the SQL Management Studio 2005 Registered Servers? We want to use the same registered servers inside our team, so it would be great to point to a network location, so after changing a server it will automatically be visible to other team members. The export / import functionality still needs manua...
I'm used to double-clicking *.sql script files to open them in SQL Server Management Studio. I recently upgraded to Win7, and now when I double-click a script file, SSMS opens with an empty environment. I can then use File/Open or File/Recent Files to open my script, but I would much prefer for it to just open whatever I double-clicked o...
I am trying to save an SSIS package on a sql server running 2005. The issue I have is that I am using SQL Server Management Studio 2008 on my local machine to do this and it won't let me save the package in on the server because its not compatible with 2008. Is their some kind of compatibility option in management studio that I don't kn...
Good day, When creating a new table in SSMS - right click on the "Tables" node, choose "New Table..." - the default definition for a new column is nchar(10). Can I change that? Let's say I would like the default column definition to be varchar(5) whenever someone creates a new table. I can't find any sort of option to change that, I'...
Hi there, I always have loads on windows open and i can very see the SQL Management Studio when it is minimised, the icon is too light a color Is there a way of changing the icon? ...
We run SQL Server 2005 exclusively for databases that we use (I'm trying to push to get them upgraded, but alas!). On the client side with Management Studio, are there any benefits to upgrading to SSMS2008 when only connecting to SQL Server 2005 databases? I've seen that Intellisense won't work, so I'm curious if it's worth the hassle. ...
As i get more and more tables, using the diagram view becomes harder and harder. is there anyway to have it auto order or sort to align joined tables, etc and avoid having to do it manually ...
Background I have a spreadsheet of data that I'm importing into SQL Server 2005. I'm using the Import Wizard in Management Studio to do this. Problem I'm importing the data into Table A. Table A has a foreign key reference to Table B. My spreadsheet contains a value in Table B and I need the key for that value so I can put it into Ta...
Is there anyway I can expand the names of any query tabs I have open in SQL Server Management Studio? It's almost impossible to navigate them properly if I have more than five open. See below for an example: http://img697.yfrog.com/i/41684451.jpg/ ...
Hi Within the next few weeks I plan to introduce SQL server to an office that is in dire need of a proper data server. Currently there is a heavy reliance on loose Excel and Access file (supplemented with frighteningly large amount of impenetrable VB code to do data manipulations) strewn all over the internal network. We need SQL serve...
I'm inserting rows into a table from other tables in the SQL Server management Studio and some records violates a unique constraint because initial data is 'dirty' and is inconsistent. How can I find which records violate? ...