I am trying to connect to a Microsoft SQL 2005 server which is not on port 1433. How do I indicate a different port number when connecting to the server using SQL management Studio? Thank you, Brett ...
Does anyone know if there's an add-in that does autocomplete for queries on SQL Management Studio? ...
I did it using the commands as described here and it works but I want to do it using the SQL Management Studio. SQL Server 2008 Books Online says this: To create a full-text catalog: In Object Explorer, expand the server, expand Databases, and expand the database in which you want to create the full-text catalog. Exp...
Sql Server Management Studio 2008 is not scripting table permissions even when I select the option to script object level permissions. Is this a bug or is there another way to do this? It is creating permissions for stored procs, but not for tables. I am a sysadmin. If it doesn't work, are there free sql server tools to script the permi...
Hi All, Does anyone have any experience of developing external tools for SSMS 2005. Ideally I would like to be able to interact with the query windows directly, for example, taking the query text from the window to perform some processing on it. Any pointers in the right direction would be great. Thanks in advance ...
I am currently using SQL Server Management Studio (Ver 9.00.3042.00) and click the "New Query" and wrote the following code: Select colA, colB, colC colD From table1 When I click the parse (checkbox) button to validate the SQL statement, it says "Command(s) completed successfully". Isn't the parse button suppose ...
I've notice an issue - it feels like a bug but I suspect a 'feature' - in SSMS in SQL Server 2008. I have various tabs open, for example an alter table script in one table and a SProc that queries that table in another tab, and when I execute my Alter Table script the changes are not reflected in Intellisense in the other tab. I can cr...
I dropped a database from SQL Server, however it turns out that my login was set to use the dropped database as its default. I can connect to SQL Server Management Studio by using the 'options' button in the connection dialog and selecting 'master' as the database to connect to. However when ever I try to do anything in object explorer i...
I have a 64bit Vista laptop. Initally, I tried to Install a 64bit version SQL Server Express 2005 on my computer, but no matter what I tried, only the 32bit version seemed to work...so that is what got installed. The 32bit SQL Server Express 2005 was working fine, but recently I installed a 64bit version of SQL Server Express 2008 - wi...
My microsoft Sql Server Management Studio is slow. And by slow I mean >1minute to render a context menu-slow. All other things work perfectly fine. The connection to the database itself is not slow (my app works just fine and context menus don't need connection to the DB anyway I guess).. Anybody has any idea what I should check to solv...
Hi all, I am trying to write an app that makes use of the external tools functionality of SQL Server Management Studio. To specify an external tool, you can enter a path to the app and specify some arguments to pass to the app via STDIN. Currently I just have a form that displays the arguments. Every time I run the external tool I ge...
Am I the only person annoyed by this? I don't even know what proc I'm clicking on if the file names have the same prefix, or are longer than the context window width. ...
I know Red Gate has such a product, but I'd rather not have to pay for something which, in my opinion, should be built into SSMS. Thanks! ...
Is there a x64 or ia64 version of SQL Server Management Studio (SSMS) 2005? All the information I'm seeing leads me to believe there is only a x86 version. This link is my evidence that a 64-bit version doesn't exist - http://support.microsoft.com/?id=906892 ...
Is it possible to run SQL Server Management Studio Express from CD without installing it on the computer? I need it sometimes to provide support for the client but do not want to install/uninstall it. ...
I'd like to automate the script generation in SQL Server Management Studio 2008. Right now what I do is : Right click on my database, Tasks, "Generate Scripts..." manually select all the export options I need, and hit select all on the "select object" tab Select the export folder Eventually hit the "Finish" button Is there a way to ...
I have been running SQL Server 2005 Express Management Studio ("SSMSE"), and I now have a need to install the full version of Management Studio ("SSMS"). This is a known hassle, but I've not found a comprehensive way to carry it out. At first, I uninstalled SSMSE, and then ran SqlRun_Tools.msi to install the toolset. I got this error me...
I'd like to be able to run an already parameterized query from within the SSMS: select name from aTable where id = @id I know that other IDEs (e.g. TOAD) allow for parameter binding - is this available in SSMS 2008? Thanks! ...
I have a large database of zip / postal codes used in proximity searches. There are about 1 million records. Somehow I didn't add the primary key to the table, and now I have to add it because searches take about 3 seconds because of the full table scan. When I go to generate a script to add it in SSMS, the operation times out because it...
OK I'm not sure if this is valid, however I have a bug bear with SQL Server, and that is that I cannot organise objects in to a group of objects. Imagine I'm working on a new section of work in a large database and I perhaps have 15 objects that I will be regularly using. What I want to do is sort of "Favourite" them in to a folder so t...