Hi, In SQL 2005/2008 management studio, how to I get the 'summary' tab to be visible? I close it by mistake and want to open it again...any way without restarting it? ...
So for the second day in a row, someone has wiped out an entire table of data as opposed to the one row they were trying to delete because they didn't have the qualified where clause. I've been all up and down the mgmt studio options, but can't find a confirm option. I know other tools for other databases have it. ...
I am currently working with a developer who is experinced at MsSQL, but not much at MySQL. He has been cursing MySQL for having Bugs, and also being far harder to use. Is is becuase his experince has been so good with Managment studio. It seems to me that his problems are with using phpMyAdmin. For example, he cites not being able to c...
In SQL Server Mgt Studio 2005, when I open the Object Explorer to script an object to a new Query Editor window, the tab for that new script window is titled something like 'MyServerName.MyDatabaseName - sqlquery37.sql' Not very descriptive. So when I get a bunch of windows open at the same time, I have no idea which one is which. Th...
I dictate SQL using speech recognition, and lining things up is a pain. If I could see where the tab stops are it would save me a lot of time. ...
I have a ridiculously long xml row, it has > 800000 characters. The 'client' is also the 'server'. The OS is windows 2k8 x64. The database has plenty of memory as does the client. The problem is that once i hit some magic number of characters - exactly 43679 xml chars - the row returns what APPEARS to be ''. i call them 'xml chars' b...
Just to preface: I work in a small company that does ASP.NET development and uses SQL Server 2005 for all of our database needs. I was curious as to what were the pros and cons of using Visual Studio or SQL Server Management Studio for our development on the database side (i.e. table creation, stored procedure writing, etc.). Right n...
I exported a table to a server but I can't find the table. Maybe I didn't put the right destination database. How can I find this table if my server has multiple databases, without opening each one of them? I use MS Sql Server Management Studio 2008. ...
I frequently get the following error when attempting to execute simple statements against a remote instance of SQL Server 2005. I click execute, the window hangs for several seconds, then I get the error. I click OK, click Execute again, and it runs fine. This happens frequently enough to be very annoying. Last week I worked exclus...
I'm running Sql Server Management Studio 2008 on a decent machine. Even if it is the only thing open with no other connections to the database, anything that has to do with the Database Diagram or simple schema changes in a designer take up to 10 minutes to complete and SQL Management Studio is unresponsive during that time. The same S...
Open a new query window. Write some SQL. Save the script, the Save File As dialog box opens - but always to the same default location in the Profiles directory. Is there any way to set my default file location? ...Like I used to do with apps from the 1980s? Under Tools|Options a default location can be specified for query results. I...
Is there a snippets feature in MSSQLServer 2008 Management Studio? ...
In SQL Server Management Studio Express 2008 options, under source control the only available options "out of the box" are Microsoft Visual SourceSafe, and... (wait for it) ...Microsoft Visual SourceSafe (internet). Since I do have VSTS 2008 installed, with the TFS client of course, I find it odd that SSMS Express doesn't include suppor...
I need to restore a DB from a .BAK-file that is not located on the server, but on my local machine. Normally I remote desktop to the SQL server, copy the .BAK-file, and do the restore that way with Management Studio. This feels a bit awkward though, especially on days like this, when I get thrown out because the number of allowed connec...
I'm using SQL Management Studio 2008 Express as a graphic interface to my local SQL Server 2008 Express instance, both of which I have locally only as a test and developement interface for my web projects. I have recently grown more confident in SQL coding, and started to use some more complicated sql stuff - my latest field of explorat...
I was just about to buy redgate.com's compare package when I came to realize it seems highly unlikely a task like this isn't something that can be performed from the Management Studio. I have a development database and I have a live database. I develop my application adding stored procedures, correcting small things in the data structur...
I have a script in T-SQL that goes like this: create table TableName (...) SET IDENTITY INSERT TableName ON And on second line I get error: Cannot find the object "TableName" because it does not exist or you do not have permissions. I execute it from Management Studio 2005. When I put "GO" between these two lines, it's working. But ...
I am able to view the Estimated Execution Plan (Management Studio 9.0) for a query without a problem but when it comes to stored procedures I do not see an easy way to do this without copying the code from the ALTER screen and pasting it into a query window, otherwise it will show the plan for the ALTER and not the procedure. Even after ...
is there any way to connect to ms sql server 2008 using management studio 2005? ...
Argh! I created an SSIS package via an Import Wizard and I can't find the SSIS packages on the server using Management Studio. Execute an SSIS package doesn't appear as an option when I go into job scheduler, either. ...