Posts

Showing posts from June, 2010

Dropping (deleting) a production database…

How to identify if the SQL Server is 64 bit or 32 bit installation?

Changing the login name for database user “dbo” …

.net Application is timing out and everyone is blaming SQL Server

Handling issues related to ASP.net session database during migration…

Unable to open maintenance plan in SQL 2005 after upgrade…

Can not delete or rename a maintenance plan for exception thrown by mscorlib. How to resolve it?

A script to convert seconds into human readable format (HH:MM:SS) / text…

How to start a SQL Server job programmatically/using TSQL/Scrip?

Syncing login between database and server... an essential step to perform in database migration

Capturing Deadlock in details using SQL Server trace and performance monitor…