management-studio

Using cached credentials to connect to SQL 2005 across a domain boundary

Ever since moving to Vista some time ago on my development machine, connecting to SQL Servers in our DMZ active directory domain from client tools like SSMS has not worked like it used to. In XP, as long as I had authenticated in some way on the server (for example directing Explorer to \server.dmzdomain\c$ and entering valid creds into...

What is the best development environment for TSQL / SQL Server

Just curious if there are better tools out there for sql server development. We currently use the standard MS stack . . . SSMS with the addition of Redgate's SQL Prompt (which rocks...most of the time). Are there others? Are there better tools? ...

How to tell the data types after executing a stored procedure?

Is there a way when executing a stored procedure in Management Studio to get the data types of the result sets coming back? I'm looking for something like functionality of when you pass a table name to sp_help ...

What's the best way to work with SQL Server data non-programmatically?

We have a SQL server database. To manipulate the data non-programmatically, I can use SQL Server Management Studio by right-clicking a table and selecting "Open Table". However this is slow for very large tables and sorting and filtering is cumbersome. Typically what we have done until now is to create an Access database containing link...

Can I use SQL Server Management Studio 2005 for 2008 DB?

I am looking to manage a SQL Server 2008 DB using Management Studio 2005. The reason for this is because our server is a 64-bit machine and we only have the 64-bit version of the software. Is this possible? How about managing a SQL Server 2005 DB using Management Studio 2008? ...

Free SQL Server development tools

I usually use Management Studio and SQLCMD to work with SQL Server. For the most part, they work for me. I'm just kind of curious what else is out there. I just want to find out if there are any needs I have that are unfulfilled. So what are some helpful SQL Server tools? There's no particular functionality I'm looking to replace or...

SQL Server Management Studio 2005 - Change Default Directory for Backup Location

Using MS SQL Server Management Studio 2005 - To Restore a Database: Restore Database (*) From Device: Click "..." Button Backup media: File Click "Add" Button Popup Window: "Locate Backup File" That window Defaults to C:\Program Files\Microsoft SQL Server\MSSQL.1\Backup How do I configure MS SQL Server Management Studio to look i...

What is the T-SQL syntax to connect to another SQL Server?

If I need to copy a stored procedure (SP) from one SQL Server to another I right click on the SP in SSMS and select Script Stored Procedure as > CREATE to > New Query Editor Window. I then change the connection by right clicking on that window and selecting Connection > Change Connection... and then selecting the new server and F5 to run...

In SQL Server Management Studio can I search for assets across multiple databases?

My everyday IDE is Eclipse which has a wonderful Open Resource feature (CTRL+SHIFT+R or Navigate > Open Resource) which allows the user to search for files/resources across multiple projects. I can't find a similar feature in SQL Server Management Studio, is there one? ...

SQL Server Management Studio 2005 "Remember Password" doesn't work

Folks, I connect to a large number of SQL Server 2005 databases through SQL Server Management Studio 2005. I frequently check off "Remember password", yet the next time I try to connect it doesn't actually remember it. Have you had this experience? Any workarounds? ...

Sql 05 express management studio versus standard

What are the differences between the free sql express 05 management studio and the licensed version? ...

SSAS Cube Browsing not working after SQL 2008 CTP uninstall

I've had SQL 2005 & 2008 CTP installed side-by-side with no problems. Recently uninstalled the CTP after it expired and now whenever I try to browse an analysis services cube in SSMS 2005 or VS 2005, I get the follwoing error: Retrieving the COM class factory for component with CLSID {C4F9B80B-89F7-4800-9C26-504D6E692B2C} failed due to...

SQL Server Management Studio, getting title bar to show more detail.

I use SQL Server Management Studio 2005(SSMS) for most of my T-SQL and general SQL DB maintenance, but one thing that I would love to change is the level of detail the title bar gives you about each instance of SSMS you have open. I would love to be able to see the connected server from the active tab at the very least. e.g. Any i...

Script all stored procedures in Management Studio 2005

In Enterprise Manager you could script all SPs in a database through the right click menu, is there a way to do it in Management Studio? ...

"Favorites" or "macros" in SQL Server Management studio?

I have a few databases that I always use SQL Server Management Studio with. I'd like to be able to create a toolbar button or keyboard shortcut that automatically opens a new query window (in the current SSMS instance) and connects to a given (registered, perhaps) database. That's it. That's all I need. And this ashtray, and the paddl...

How can I add SQL Server database objects to TFS?

We don't currently have our SQL Server objects in any form of source control. We recently installed TFS 2008 and I'd like to get our SQL server code added. I think I could script all of the database and create script files for each object, but I'm hoping there is a way to point to a database in SSMS and create a project that can be added...

Limit Database List to Ones With Permission SQL Server

By default if you connect to a remote SQL Server via an account that has access to say 1 of the 10 databases. You will still see in the Object Explorer all other databases, obviously due to permissions you cannot actually query them, but you can see their names. I have heard that there is a method that disable this behavior, but I've b...

Why does SQL Management Studio output null separated characters when saving as csv?

and can it be configured not to happen? I'm usually finding myself saving a result of a query as a .csv and processing it later on my Unix machine. The characters being null separated makes me have to filter those chars and is a bit of a pain. So, these are the questions: Why is this so? EDIT: Because it outputs in UTF-16 by defau...

Way to preview (retroview) SQL queries of SQL Server Management Studio Express

Could you tell me, please, if it's possible to preview (or at least retroview, for example, in a kind of a log file) SQL commands which SQL Server Management Studio Express is about to execute (or has just executed)? In the past I used Embarcadero DBArtisan which shows SQL queries to be executed before actually running them on the serve...

Generating sql scripts for SQL Server using SQL Management studio

Is it possible to not have the: /**Script Date: 10/27/2008 09:05:41 ****/ in the output? I want to use Diff's so I can see what's changed, having a timestamp makes it difficult! ...