I created a SDF (SQL CE) database with Visual Studio 2008 (Add / New Item / Local Database). Is it possible to edit this database with SQL Server Management Studio? I tried to attach it but it only offered .mdf and attaching a .sdf file results in "failed to retrieve data for this request". If so, is it possible to create SDF files wit...
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...
I have about had it with this tool, I check the save password box at the login dialogue but it just doesn't work. Sometimes it will for a few days, and then the password will just be gone. Nearly every time I load this thing up I have to track down the password again and type it in. Is there some password rule in the database that would ...
I connect to a lot of different servers in SQL Management Studio, but I find that not only is there no way to delete the old connections (dbnames, usernames, etc.), they also start to show up as duplicates. Is there any way to clear them/reorder the history? I can't seem to find any easy way. Thanks! Chris ...
I have SQL Managment Studio Express, but notice it doesnt have the add on for solution and project creation. Is there a download to add that functionality so I can group my queries and connections? Or is this funcationality not available for express? ...
I used the SQL Server management studio on a table with Create Script to New and did minor changes. Give me an error "Incorrect syntax near '('" for the "(" after "WITH" /* EventType Table Creation */ CREATE TABLE [EventType] ( [pkEventID] [int] IDENTITY(1,1) NOT NULL, [Description] [nvarchar](50) NOT NULL, [BeginDate] [datetime]...
I have a SQL database that has a table with a field set to "Read Only" when I look at it through Microsoft SQL Server Management Studio Express. I need to change some data within that field manually but I can't see any properties that I can change that will let me override this. Will I need to write a sql script on the table to do thi...
Is there a keyboard shortcut for the "Connect to Server" modal window in Microsoft SQL Server Server Management Studio? The modal window that is displayed when you first opened up SQL Server Management Studio from the Start Menu or shortcut. ...
I'd like to remove the dbo prefix from the Object Explorer so I can press the 'S' key and go to the tables that begin with 'S', having dbo there is irritating (to me). I have searched on the net and there was an answer at that other site that said I should use F7 in the summary tab, but I couldn't find a summary tab, and pressing F7 in ...
In Management Studio, you can right click on the tables group to create a filter for the table list. Has anyone figured out a way to include multiple tables in the filter? For example, I'd like all tables with "br_*" and "tbl_*" to show up. Anyone know how to do this? Thanks ...
In SQL Server Management Studio (SSMS) running against SQL Server 2005, I have a solution which contains a number of views. These views are not sorted alphabetically. Can anyone provide either an explanation of why, or a solution to order them alphabetically ? ...
In my TSQL table I added a constraint with the following sQL statement alter table disabledqualities add constraint uc_uIdQualCode unique (userId, qualitycode) I did it by hand because I just can't work out how the GUI is supposed to work. You add a constraint and then you get a window where you should "define" your constraint. It's b...
I created a constraint on my tsql table like this: alter table disabledqualities add constraint uc_uIdQualCode unique (userId, qualitycode) In MSSMStudio the constraint shows up under indexes rather then under constraints. Why? --EDIT-- I understand that it creates an index to enforce the constraint, but then why is there a node cal...
In the "datagrid" view of an open table of data, how can I type a new line character into an nvarchar field directly in SSMS? Is there an alt code? ...
I'm trying to create a SSMS add-in. One of the things I want to do is to create a new query window and programatically connect it to a server instance (in the context of a SQL Login). I can create the new query script window just fine but I can't find how to connect it without first manually connecting to something else (like the Objec...
When I have a file open in visual studio/sql server management studio and have it split in to two panes, I'd like to be able to switch between the panes without having to reach for the mouse. Does anyone know if a shortcut key exists for this? ...
In SQL Server Management Studio, the VIEW menu's TOOLBOX item is not visible. Can any one help me make it visible? ...
When trying to connect to a server in Management Studio (specifically 2008), there is a field where you enter the Server name. That field also has a drop-down list where it shows a history of servers that you have attempted to connect to. I would like to know: How to remove an individual item from that history. How to remove an item f...
I can use the PRINT statement in a stored procedure to debug my code. I see the output in the Messages tab of SQL Server Management Studio. How can I dump one or more entire SELECT statement outputs to that Messages tab? My stored procedure returns several output variables so returning a single dataset isn't an option here. I am strug...
I am trying out some cascade options with nhibernate mapping and have a unit test where I'd like to use a tool to inspect the state of the database. I was hoping I could use linqpad to do this, but the connection seems hung while in the debugger. I'd seen a demo not to long ago where SSMS was being used to inspect the db during a debug, ...