Thanks all! The code using textcopy and xp_cmdshell to create a DTS backup is working nicely. 😀 I am storing them is Visual Source Safe and I hope to be...

This question baffled me for the same reasons already mentioned.

10^24 <> 1 024^8

This is the second time this week the "poorly worded" QOD caused numerous comical replies....

I was able to successfuly execute the select statement

select HireDate, * from employees order by HireDate desc

on Northwind employees tables in SQL 2005 and SQL 2000 (using both management...

Thanks, I will look into System Monitor.:)

In addition to the question changing, it seems one of the answers (C) was correct for SQL 7.0 (as described in 224071 - Moving the MSDB database - SQL Server...

From what I've read here on the subject, Henk Schreij got it right with:

SELECT (0+CONVERT(CHAR(8),GETDATE(), 112) - CONVERT(CHAR(8), @d, 112))/10000

I also ran the information and found an error with the third choice. :hehe:

Try this in query anaylzer....

declare @dateofbirth datetime

select @dateofbirth = '02/24/1964'

print convert(varchar(20), @dateofbirth)

print convert(varchar(20), DATEDIFF(yy, @DateOfBirth,...