I was a professional photographer and now I'm a DBA. Went back to school in the 80's and changed professions.

I, too, ride a bike, but mine is the kind you...

I don't think we'd skip a version. I just don't see how we can upgrade every 3 years with our current level of staffing. We would always wait several months...

There's no way that a shop such as ours with several dozen different dbs and apps and only 3 DBAs can perform upgrades every 3 years. We still have a...

dob = date of birth

date of birth does not have any relationship to join date unless the table is in the Almighty's db.

😀

You can create a new Operator that consists of multiple email addresses seperated by semi-colons, and then use that for notifications.

Or you can use:

sp_send_dbmail

...

Thanks, Paul. You're right. My document must be old.

Paul Randal (1/28/2008)

DBREINDEX is also deprecated and doesn't run the indexdefrag algorithm - it does offline...

Errors...

Msg 156, Level 15, State 1, Line 36

Incorrect syntax near the keyword 'FETCH'.

Msg 156, Level 15, State 1, Line 43

Incorrect syntax near the keyword 'DEALLOCATE'.

Msg 156, Level 15, State 1,...

Please remember that INDEXDEFRAG will be deprecated. Try using DBREINDEX or ALTER INDEX REORGANIZE.

We did this exact thing in September. I would advise you to rebuild your indexes and update your statistics after you move your dbs to the new SQL2005/64bit instance.

Also, we...

You may be able to use something like the the following, too.

BULK INSERT  NorthWind.dbo.[table_name]

   FROM 'C:\InputFile.csv'

    WITH (FieldTerminator = ',',

   FirstRow = 2)  -- Use if csv file has...

I have used NW to do some testing in our prod environments. For example, I wanted to test latency across replicated servers, so I first set up my scripts and jobs, and debugged it using NW....

We have pub and northwind. That's why I used "dbid>6".

You could try replacing the "sid>1" with "dbid>6". I think that works, too.

Thanks to you all. This worked exactly as needed.