Actually,

I take it back. I myself didn't read carefully Paul's response impressed with the amount of code provided by you guys. Sorry about that.

I'll definitely try Paul's 2nd solution: turn...

Thank you guys for all your help,

But you probably didn't read carefully about what I was talking about.

I don't have any problem with shrinking files from the Query Analyzer using...

Thanks Angela,

I think your idea would work.

I have a remote access to my database. I'm checking it's size every Sunday.

If it didn't shrink, I'm shrinking it manually using...

Thank you guys for all your replies. I'll try to answer your questions.

The database is not read only. I don't know the minimum size of the files (I'm not sure...

I beleive, it used to be 4-5 GB

13GB; 3GB of which is unused space.

Thanks Cathan,

This should work but will need to add couple more tasks in the package and comes out little complicated.

Does anybody have other suggestions?

Thanks in advance.

Alex

Unsavory,

You are right about active connections. I realized that in few cases before when I took my database offline there was no connections present at that time. Sorry about that.

And...

Did you try my suggestion?

I'm able to take a db Offline when there are users connected to it the way I told you before.

I'm using SQL Server 2000 though.

You...

I don't know which SQL Server you are using.

If it's 2000 then you can right click on database, go to 'All Tasks', 'Take Offline'.

Then go to Query Analyzer and...

Brian,

Thank you so much for your time and all your help.

Now I realized what kind of person a real author should be. The way you explain the things I...

Brian,

Thank you so much for your script. I think, we will use your advise.

The problem is, I never used a PerlScript before and not familiar with this program.

Should we buy...

Thank you Brian,

I don't have PerlScript installed on my machine. I will definitely look into it if there will be no other solutions.

But I would still prefer using my DTS...

James,

Thank you for your response.

Job failure was just an example of writing to Windows NT Event Log.

My goal is to get the record of deadlocking on my SQL Server...

Michael,

Thank you for your quick response.

Unfortunately we are using an IMail SMTP/POP3 e-mail server and are not going to switch to MS Exchange server in a nearest future.

Anywhere, we are...