John,

Can you give me an example what you just described here.

Let see one of my requirements, I need to call the same DTS by multiple users at the same time...

Thanks,

Cheers!

Sandy.

Gail,

Can you just guide me...Before shrinking what are the necessary steps I have to check, I mean to say I will be sure after shrink my database will be consistence...

Yes, I got it...

But I need know how its work..Is it reducing the Log File Size or doing some internal removing space from the page level.

Cheers!

Sandy.

As the error message indicates, there's no file named TestDB_log in that database. Check sysfiles for the names of the files. It's looking for the logical name of the file,...

Gail,

Can you please make it little more clear..

Cheers!

Sandy.

See, I can give you hint how to make it, Just take a counter and increase by 1 inside the loop, I can say some times it may reach upto...

Hi,

You can check with another loop inside the main loop.

Cheers!

Sandy.

Lipina..:),

Just check this link...

This is SQL Server 2005 Training...

http://www.exforsys.com/tutorials/sql-server-2005.html

This is Sql Server 2005 Commands...

http://www.ss64.com/sql/index.html

Cheers!

Sandy.

Milu.:), Finally you accepted truth.

Hope you now clear your...

Yes Gail,

Thats true. I do agree but do you have any alternative for this?

Cheers!

Sandy.

Thanks..........:),

Cheers!

Sandy.

Andras,

If in Sql Server 2000, then...

Cheers!

Sandy.

Andras,

Thanks, but my question was who drop my table instead of delete the data, Is DDL command logged in transaction table?

we can also achieve this by another command too like...

Milu,

Addition to gail's post, check this too..

http://pratchev.blogspot.com/2007/08/parameter-sniffing.html

Cheers!

Sandy.