Ok Jeff, with an invitation like that, I have to post.

You can use function F_TABLE_DATE from the link below.  You can use it directly, or use it to load a...

If you want to make sure the database is not in use, just set it offline before running the restore:

use master
alter database MyDatabase set offline with rollback immediate

If you are running SQL Server 2000 Standard Edition, SQL Server can only use 2 GB of memory.

Just put in the date and time you want to start with:

where date1 > '20070308 02:45:00.000' AND date2 <= GETDATE() 

Jay,

I don't understand how you can say radioactive waste is a "manageable problem", unless what you mean is "drop it in a hole in the ground and let someone else...

From your answer, I guess that means that didn't try logging onto the server with the SQL Server Agent service account and running the package.

There are many thing that could...

Wouldn't it be better to post on a forum where they answer questions about PostGreSQL, since that is what you are trying to develop?

With nuclear power there is still the unsolved problem of dealing with waste.

I don’t think the current schemes for storing high level waste for hundreds of thousands of years can...

select MM = right(100+month(getdate()),2)

MM   
---- 
03

(1 row(s) affected)

You will have to remove the UTC offset ('-05:00') before converting to datetime.

select DATE = convert(datetime,substring('2007-01-31T13:47:27.25-05:00',1,22))

DATE                                                   
------------------------------------------------------ 
2007-01-31 13:47:27.250

(1 row(s) affected)

When you say it does not popup any dialog box, does that mean it dosn't do that when you log onto the server with the SQL Server Agent service account...

You can only have one time zone in Windows set as your active time zone, so it will follow the settings for that.

Matt,

I think you should tell the network guys you're sorry for screwing up their machine and promise not to do it again.

What did you find when you tested it to see what happens?

If you have Internet Explorer Enhanced Security installed on the server, it will cause a message box to pop-up when you attempt to run an executable.  Since there is no...