In SQL Server Management Studio 2008, if I log into a shared hosting provider with many databases on one server, I cannot use the Object Explorer. This worked fine in 2005. Anyway to change this behavior? It throws this exception: The server principal "myusername" is not able to access the database "first-database-alphabetically-on-sh...
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'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! ...
A while back, I installed SQL Server 2008 Express with Advanced Services, which installed SQL Server 2008 Management Studio (SSMS) Express as well. Now that we have SQL 2008 Standard on the network some months later, I want to confirm that I don't have to reinstall SSMS 2008 on my desktop. This blog post I found seems to suggest that I'm...
I am using SQL server management studio (2008) quite a lot these days. If it had a "Select top 1000" command in the toolbar,(or a shortcut key) it would make my life a lot easier. Is there any way i can do it. I tried looking in the customize dialog, but cant find that command there. ...
When scripting a DB using SQL Server Management Studio (SSMS) it generates line like: /****** Object: ForeignKey [FK_NoteLinkAssociation_Link] Script Date: 04/24/2009 10:04:46 ******/ Is there a way to stop it from generating that line or the date part of that line? Reason: The DB is being scripted and stored in source control an...
Hello, here is my setup: Sql server 2008 standard running on Vista - VMware running a XP machine with VS2008 inside it. If I open a SQL database in my host computer in sql server management studio and make structure changes to the database and then go back to visual studio, my visual studio has lost connectin to the database (says a n...
In SQL Server Management Studio 2008 there is a Task List very much like the one in Visual Studio, I can't seem to figure out how to put it to use nor can I find any documentation on it other than the documentation for Visual Studio which does not apply as the comment syntax is unique to TSQL... The Task List in SSMS 2008 is accessible ...
Hi I installed VS 2010 on a plain Vista x64 OS, now I need to install SSMS as well. Based on your experience, what version do I have to install? Thanks in advance! ...
I have a database that I need to edit a lot of fields on, but SSMS doesn't quite seem to be up to the task. First problem is that I can't seem to insert multiple lines of text into a field. Second is that any time I happen to have the Shift key held down when I press the space bar, SSMS immediately enters the data. Is there a better ...
Im getting this when running a query like this WITHOUT inserting in any table. in SSMS 2008. select iav.* from ITEM_ATTRIBUTE_VALUE iav where iav.attribute_value != '' and ISNUMERIC(iav.attribute_value) = 0 Why would it do this ? ...
Is there a keyboard shortcut to close a tab in SQL Server Managament Studio 2008? like Alt-W in Firefox. ...
I am looking for some reference code implementing a SSMS 2008 plugin. Can somebody point me to the right direction? ...
How to save query result using T-SQL in a csv file in SSMS 2008? Needs to be done programmatically. ...
We're having some intermittant connection problems connecting to our few SQL 2000 servers, but only seemingly from our SSMS 2008 workstations - there don't appear to be any actual business applications that aren't able to connect. Most of the time, SSMS connects just fine, but sometimes, I'll need to manually set the connection protocol ...
Either the autocomplete in SQL Server Management Studio 2008 is buggy, or I am. Either way, when I try to type this and hit the spacebar: SELECT TOP Autocomplete immediately changes it to this (Topics is a table in one of our databases, btw): SELECT Topics Is there a way to fix, or at least gracefully work around this? ...
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 ...
Hello Everyone, I have a sql script with insert statements to insert 1000s of rows (12000 approx.). When i try running the script in SSMS, it throws 'Out of memory' exception after a while. "An error occurred while executing batch. Error message is: Exception of type 'System.OutOfMemoryException' was thrown." I have SQL Server 2008 o...
A SQL table has 100s of tables, SPs and functions. I am trying to put together a sql query that will return all the dependencies of a given set of tables. Is there a way to accomplish this using SSMS without writing queries? Updated: Simplified the question to the point. ...
Using the SSMS (Sql server management studio) 2008 ide, I frequently get timeouts asking it to script a trigger (or table) to a new query editor window. This particular time, the error message is Script failed for Trigger 'spbldrom_update'. Additional information: - An exception occurred while executing a Trasact-SQL statement or batch...