More RAM = More Performace.   That is what I hope to see as we transition ~6 Servers running ~ 20 databases in 2000  to a singl 64bit SQL2005 box, and a...

Temp tables are the way to go when you need to step through data.

And, in-fact when every possible, I like to create real tables that are dbo. or user owned...

I recently wrote a slick SP that shells out and grabs the Directory information for a directory and loads all the details into a table.  I could post that for...

I would suggest importing as a VarChar(##), then you can add a date column and do something like this:

UPDATE tblImportData SET DateValueCol = Cast(Replace (Replace (DateTextCol,'a.m.','am') ,'p.m.','pm') AS DATETIME) 

A week ago, we just cut over from SQL7 to SQL8 from WINNT to WIN2003.

We feel your pain!

The key to getting these steps to work was shutting down EVERYTHING that...

From command line use BCP.  For help, just type bcp /?

It is by far the fastest and easiest way to get data in and out of SQL.

I think the answer is missing a key word... (is)

Question: What's the difference between a server login and a database user?

Correct Answer: A server login connects an account...

To make an exact duplicate of a table use SELECT * INTO...

--Copy all rows and column

USE PUBS

SELECT * INTO

dbo.COPYOF_authors

FROM dbo.authors

-- If you want no data in table...

SELECT * INTO

dbo.COPY2OF_authors

FROM dbo.authors

WHERE...

You can get the file name from the SYSdatabases table in master...

USE MASTER

SELECT filename FROM sysdatabases

WHERE name = 'pubs'

returns....

filename

---------------------------------

c:\sql\data\MSSQL\data\pubs.mdf