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...
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? ...
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 ...
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...
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? ...
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...
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...
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...
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? ...
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? ...
What are the differences between the free sql express 05 management studio and the licensed version? ...
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...
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...
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? ...
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...
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...
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...
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...
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...
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! ...