Worker great - thanks again.

Scott

This sounds good - I will try it tonight, Thanks!

Greg - thanks!

I am not sure this will work in this case, but look at this link.

http://www.mssqltips.com/tip.asp?tip=1145

thanks Francis.

I am concerned about the massages I got. I saw that you get them with auto_close on. In my case since it is off, not sure why I got...

I like using the size rather than percent. Using percent can cause problems as it gets bigger. But as Steve says... monitor your database, as the free space gets smaller,...

if I understand your question correctly - in ent mgr, right mouse click on database, then properties, then datafiles. You can control how your datafile grow here. You can also...

So in effect - your work on making space was correct - you did in fact make your database smaller. Only the datafile still at 32GB. New data will use...

I think I would leave my database as 32 GB, so it will not have to regrow as you fill it up again.

Thanks Sanjay.

works - thank you both

i might be missing the question here,

do you mean if start date = 11/28 and end_date = 12/01

and you have data for 11/28, 11/29, 11/30 and 12/31, then TRUE 

We use it here quite a bit. But as for database replication, we only use it for one sql server for DR purposes. As I understand it , it works at...