I always click "Remember Password" when connecting to a database server. Sometimes when I come back into SSMS, it has it remembered, sometimes not. More often it does not. I regularly connect to about 4 different servers, it's fairly random when it works for which servers. How can I get this to work all the time? ...
I'm experiencing a weird problem with a SQL login. When I connect to the server in Microsoft SQL Server Management Studio (2008) using this account, I cannot see any of the tables, stored procedures etc. that this account should have access to on a particular database. When I connect to the same server within Visual Studio (2008) with t...
In this live SQL Server 2008 (build 10.0.1600) database, there's an Events table, which contains a text column named Details. (Yes, I realize this should actually be a varchar(MAX) column, but whoever set this database up did not do it that way.) This column contains very large logs of exceptions and associated JSON data that I'm tryin...
I have it enabled in Visual Studio 2008, but I'd really like to enable this feature in SQL Server Management Studio 2005 Express. Does anyone know if its possible? Maybe in a later version? EDIT: Sorry, I meant specifically in the text/query editor. ...
While using SQL Server Management Studio (2008), is it possible to open a table in Edit mode through keyboard shortcut or even some special keyword I type while in "New Query" window? ...
Hello, I want to restore a bak file in SQL server 2008 (the backup was created on a SQL server 2005). I set the recovery to WITH NORECOVERY, as I want to apply further transaction logs later. Meaning: the database should stay in restore mode, but the recovery-dialog in the management studio does not finish ever. It shows 100% for nearly...
Good morning. Is it possible in some way to format the results of a query, like changing for example the background color of a selected row of the result to higlight negative values? Thanks. ...
I'm writing a software application in C#.Net that connects to a SQL Server database. My C# project is under SVN version control, but I'd like to include my database schema in the SVN repository as well. An answer to a previous question of mine suggested storing the scripts to generate the database in version control. Is there a way to au...
I am trying to create a new table by copying an existing table in SQL Server 2008 using Management Studio. The existing table contains no data. I am using the following code but am receiving an error for Incorrect Syntax near AS. I am not sure what is wrong here. I am a SQL newb and any help would be appreciated. Thanks. CREATE TABLE D...
Can anyone suggest a non java replacement for SQL Server Management Studio for OSX? I currently use Parallels in Crystal mode and run SSMS, but it seems like there should be something better. ...
I have a table which has approximately sixty tables, and other tables are added constantly. Each table is a part of a schema. A such quantity of tables makes it difficult to use Microsoft SQL Server Management Studio 2008. For example, I must scroll up in object explorer to access database related functions, or scroll down each time I n...
Here's my configuration: I have a re-runnable batch script that I use to update my database. Inside of that batch script, I have code that says the following: If Table 'A' doesn't exist, then create Table 'A' and insert rows into it. Later on in that batch script, I create an schemabound indexed view on that table. And if you didn't...
Hey, I made several tables and relationships using SQL server manager. I then imported them to visual studio and it all appeared in the correct form, except one of the relationships did not appear. I have checked everything I could think of and it is the exact same as the other relationships. If you know anything I can check, I would app...
This is regarding SQL server 2008 management studio.. I connect to different environment DB and every time I launch the Sql management console, I have to sign up every time to get those connections back in object explorer. Is there a way I could persist the connection so I don't have to login every time to different environments? ...
Sometimes I keep multiple instances of SQL Server Management Studio 2005 open. I might have the dev database open in one, and the production database open in another. These appear in the Windows task bar with the text "Microsoft SQL Serve...", which means it's impossible to differentiate between them unless I open the window and scroll t...
Using SQL Server Management Studio 2008, why can't I see unique index ( not primary key ) when I generate Create Table SQL code? It includes only primary key constraint. Is it by design ? There is a possibility to get SQL code for index creation via right mouse click on an index and "Script index as", but it is another step. ...
In Visual Studio 2k8, I press Ctrl-F and then type some text I want to search for in my project. I can quickly search many files at once. I have a SQL Server with some stored procedures. How can I easily search my stored procedures for arbitrary strings? I know that I can list the text of one stored procedure in SQL Server Studio and...
I have my production SQL Server in a remote data center(and the web servers are located in the same data center). During development we observed that one particular view takes a long time to execute (about 60-80 secs) in our local development SQL Server, and we were OK with it.It was promoted to production and when I run the same query o...
Hi, I have a query that I'm running on two equivalent databases, but hosted on separate MS SQL 2005 servers. I want to measure the time of a query on both servers, and thus tried the following: SET STATISTICS TIME ON GO SELECT TOP 10000 * FROM table GO SET STATISTICS TIME OFF; GO And got the following result: SQL Server parse and...
I install the MS SQL Management Studio 2008, the installation was successfull but when i run the Management Studio and connect to any Server (diffrent Servers in diffrent locations) I got following error ***** Ausnahmetext ******* System.TypeLoadException: Der Typ "Microsoft.SqlServer.Management.Sdk.Sfc.ISfcDomainLite" in der Assem...