alzdba, I have full recovery model. can I somehow get those transactions back?

thanks

thanks, but doesn' Log Explorer need to be installed before the deletion occured. I'm douwnloading the demo right now

All logins are in the syslogins system table in the master database. Make sure you get the SID's as well.

Might wanna try http://www.TestKing.com.

They have a good study guide.

Good luck. I'm preparing to take mi exams in August.

nope, that wasn't it either.

still searching though

there is no Access involved, from SQL 2000 strasight to Excell. I dropped the excell files and re-ran the package, and it worked.

I'm still puzzled though. Oh well.

Thanks for your...

Steve, I just sent an email with the error I got from the package. Would you please reply?

Here you go Steve, and thanks

Dim iToday As String

iToday = Format(Now, "mmddyyyy")

Name "\\strategic\APPS-SRV1\Output\daily_extract.xls" As "\\strategic\APPS-SRV1\Output\daily" & Left(iToday, 2) & "_" &...

I have never used an ActiveX Script Task, and I'm not familiar with VBScript functions.

Do you have a sample code that I can modify and use to rename my file...

I ran it under the account that SQL Server is running on, and still no luck.

Can you be a little more specific as to what I'm doing wrong?

Thanks

Thank you very much. I will try it and let you know.

How can I change the file name every day that I run these packages?

Thanks

I still get the same errors. Device offline.

I must not have the right administrative rights on that share.

here are the errors that I encounter...

Server: Msg 3201, Level 16, State 1, Line 1

Cannot open backup device '\\gary\d$\report.bak'. Device error or device off-line. See the SQL Server error log...

I mapped a share to the drive on the network that I want to back up the database, and ran it. I still get a device error. I tried both...