Has anyone used a source control system for database backups ?  ( databases
which potentially could be quite large )
If so which system ?   Pros ?  Cons ?

I have a customer who is running SQL Server 6.5 whose database has grown out
of space.  I can't find any documentation on the Microsoft website about
version 6.5.  What is the easiest way to shrink a SQL Server 6.5 db?  Does
SQL Server 6.5 support the DBCC SHRINKDATABASE command?

On Query Analyzer I could toggle the results pane by clicking the
'Show Results' button on the toolbar. On Studio Express I can't find
this function. I'd like to easily get rid of the Message panel after
running a query - is there an similar function?

I'm trying to connect across a LAN to a SQL 2005 server, but it fails with
error 233, suggesting that the remote server may not allow remote
connections. (Named Pipes Provider). I've checked the settings on the other
database server (server properties, Connections page) and

I'm in a quandry. I have two machines each with SQL Server 2005 installed. On
one of my machines the version of Managment Studio is 9.00.2047.00. On the
other maching the version is 9.00.3042.00. The context menu when right
clicking an object (i.e., view) in 3042 version has an ...

Just wondering if anyone ever came across this before.  I had a large table
I needed to export in SQL Server 2005, about 8 * 10^9 rows.  See below for
what happened when the export got to MAX_INT.
Workaround is just to export the table in chunks of less than MAX_INT.  No

when i am executing my long running calculation depending of a lot of
tables and procedures (needs about 15 minutes), i can see heavy harddisk
led activity all the time. Because i have only one disk in my pc i am sure
it is the sql server producing this activity. But when i check ...

I've got SQL Server 2000 running on my PC, and I want to continue
doing so.
But now I also need to manage a remote SQL Server 2005 database.  I
think that I need to install SQL Server Management Studio to do so.

Ref: SQL Server 2000 - bcp utility.
I am planning on exporting some records from a view in a database to a
datafile and importing it back to a table in the same database. I would be
storing the datafile on the local drive of sql 2000 server. However, I will

Can anyone tell me how to get Sql Server Management Studio to stop asking me
if I want to save changes every time I shut it down?  There was an option to
stop that in Query Analyzer:  "Do not prompt for unsaved files on closure."  
If they knew enough to put that in QA, why on ...

My company has recently let me start using the Data Dude product for
2008, and like most niche products, there seems to be limited help on
the web for users.  I was wondering if there are any Visual Studio for
Team Systems Database Professional users out there who would be

I often write SQL scripts in SMSS, using tabs and return keys to format the
script, but then copy and paste the script into VB for use in a SQL command
CommandText string.  To have VB recognize the script as a string, I need to
remove the tab and return keys from the SMSS script. ...

If I do " restore headeronly from disk "<trans log file name>" , I get the
Fisrt LSN and Last LSN,
is there any way to get the time stamp of LSN got generated.

Does anyone have any reccomendations on audit software?
Currently we are using Idera SQLCompliance Manager, but are finding it a bit
lacking in reliablity and are beginning to look at other options.
Just curious what others are using.

You guys know if Microsoft have released a Data Modeling Tool for SQL Server?
I tried the Visual Studio Database Edition, but, at first glance, it doesn´t
have a high level design view of the Database Schema. It just help to code
the sql scripts, right?