Thanks for your response . The idea is to generate the XSLX randomly using script and then using database mail I am sharing the file with the users. This process...

The solution explained in the Link cannot be implemented in this case as SQL Standard edition is running and hence no snapshots can be taken .

There is no blocking traced on the back end. Its a Share point instance and around 200 sleeping connections are present as of now.

Thanks for replying !!

The windows server editions are Server 2008 R2 ( where the script is running fine ) and Server 2003 ( where we need to run the script...

@Gail - Will run the CheckDB during the maintenance window, but till now we havn't tried this option..

The entire I/O subsystem has been checked but no problems are reported. Can you advice steps from the DB perspective we can try to dig deep into this problem ..

Thanks Joie .. Only reason being being not to favour replication is bcz of followig doubt

a) If replication breaks bcz of any reason then .. how much impact would be...

I want to find the logins who have enabled the PW policy for the logins or users.

Good luck everyone 🙂

Thanks for such a nice reply. BTW my requirement is to check the database size in Offline mode.

The sp_attach_db stored procedure should only be executed on databases that were previously detached from the database server by using an explicit sp_detach_db operation or on copied databases. If you...

Database Attach operation with sp_attach_db works well with the database having <= 16 datafiles. For more than 16 datafiles , we need to use CREATE DATABASE .. FOR ATTACH...

Thanks for replying. My requirements are following :

a) On few of my Servers Mirroring is configured. I need to remove the login which has created the Mirroring End points ....

Thanks a lot for replying.

In my Environment there is no high availability solution implemented.

In SP3 + CU1 do we get any benefits from Database administraion point of view...

Is it advisable to schedule the DBCC SHRINKFILE before the backup happens. This will help in reducing the log file size and to release some space to OS as Truncating...