SQL Server Tools

An updated version of SQL Server 2005 Books Online is available from the download center ([link]). Please see the topic "New and Updated Books Online Topics (17 July 2006) " ...

I just installed SQL Server 2005 Development Edition and I really like Management Studio as compared to Enterprise Manager.  Is there any reason why I should NOT use Management Studio to work with my existing SQL Server 2000 databases? ...

Hi: I have SQL Server 2000; a database with three file groups located in three different operating system files; the database size is 200GB; for performance reasons we added an additional storage to the server and we have an additional disk volume, what we want to do is to add a new datafile ...

How to config SSMS05 to remember the "save path" ? So, if I'm scripting a bunch of sprocs and/or jobs, I'd like SSMS to remember the folder I last saved to and open the browse window accordingly. ...

What are the requirements to use Management Studio/Management Studio Express for local instances?  Are the requirements same for both studios and same for all OS? Based on my own testings: Remote connection is required for Management Studio in Windows XP SP2. ...

I have an encrypted 2005 database on my development server that I want to move to a testing server. Both of the servers were set up using the same CREATE MASTER KEY ENCRYPTION Yet, when I use a backup and restore to move the database, I get a ...

Hey, when i try to deploy a Analysis Services Database with Microsoft.analysisServices.Deploment.exe and the Opetion "/s" i always get the error: The 'Name' property cannot contain any of the following characters: . , ; ' ` : / * | ? " & % $ ! + = ( ) [ ] { } < > Deployment of the Database works perfect with the Deployment Utility ...

Hi all, In SQL2000 SQL Mail, I can choose the Operator as a group of operator from Outlook addressbook.  In SQL2005 Database mail, I can add 1 address to a operator for notification.  Any method send notification to a group of ...

I create a new backup device that works every x time and I want to modify this backup and I can't find it anywhere using the Enterprise Manager I also don't really understand what is the difference between backup device ...

Is there a way to set MSDE to send email if the backup failed? Thank you, Samuel ...

Hello everyone, I'm having this problem, I'm trying to run a query that consists of six tables and one view (all joined together) When I run it without anything on the where (or just one criteria in the ...

Hola amigos, alguien de ustedes sabe de algun software gratis (libre) que tenga las potencialidades de un Administrador Corporativo de Sql Server 2000 y que trabaje con la versión liberada MSDE 2000? Tengo que correr un programa hecho en VB6 en el servidor MSDE con base de ...

Hello, we've upgraded to SS2005, and I'm attempting to install the 2005 version of Query Analyzer (Management Studio?)  on my client PC.. The owner of the computer before me had installed many beta versions of .NEt 2.0, SS ...

Hi: We are working with Upgrade Advisor Tool  (for the migration SQL Server 2000 to SQL Server 2005) and we had seen that this tool recomended the use of tracesfiles. What´s usefull to trace? ...