Also, when I tried to execute the script, I got:

Server: Msg 173, Level 15, State 1, Line 1

The definition for column 'file_Path_name' must include a data type.

Try something like:

CREATE TABLE...

What is the error? It could be that SQL Server is trying to resolve the temp table in the query evaluation phase (before the create table actually executes) and since...

Personally, I prefer to create a user database (called something like Admin) to hold administrative tables and stored procedures, etc. that I create as a DBA. I don't like creating...

I would try something like the following (sorry, I haven't had a chance to test it):

DELETE FROM t1

FROM         customer t1

INNER JOIN

                          (SELECT     MIN(autoID) AS autoID, Email

                            FROM          customer

                            GROUP BY...

There's a script that someone anonymous posted in the scripts section. Do a search on this site for remove duplicates:

Remove Duplicates from Table - No Cursors

This script deletes all duplicates...

Depending on the size of the database, a somewhat easier method would be:

1) Detach the database in the original instance (default or named).

2) Move the files from the directory for...

There is a series of articles on this site that provide a good overview of transactions (and performing error checking, rollbacks, etc. inside them). See: http://www.sqlservercentral.com/columnists/dpeterson/allabouttransactionspart1.asp

http://www.sqlservercentral.com/columnists/dpeterson/allabouttransactionspart2.asp

http://www.sqlservercentral.com/columnists/dpeterson/allabouttransactionspart3.asp

Do you mean another named instance? That would be the only way to isolate the database from the other databases on the same physical server (having its own tempdb). This...

Profiler does run on the server. If you specify filters, you can narrow the results down to a login, machine, application, etc. It's really easy to do from the Profiler...

If you don't supply a time along with a date, SQL Server automatically assumes midnight (there are no independant Date and Time datatypes up to SQL Server 2000, there are...

Different order, same meaning, Remi.

Look up 'DBCC statements, overview'  in Books Online. It gives you a good overview of the four classes of commands, etc.

My interpretation is that it is a loose grouping...

I always heard DataBase Consistency Checker, but BOL (DBCC statements, overview in the index) says:

The Transact-SQL programming language provides DBCC statements that act as Database Console...

I haven't used it myself, but FogBugz gets a lot of good word of mouth referrals for bug tracking software. Check out http://www.joelonsoftware.com for more info. There are several...

One thing I have noticed with SCPTXFR is that it changes the name of most of my Primary Keys. Example:

Source database PK Index:  PK_tblBox_BoxID

Dest database PK index: PK__tblBox__1A69E950

I'd like to...