ZMira

Disable/Enable all trigger in a database

How to identify when a SQL Server database was restored

Windows could not start the SQL Server (MSSQLSERVER) service on Local Computer.Error 1069: The service did not start due to a logon failure.

Execution of user code in the .NET Framework is disabled. Enable "clr enabled" configuration option.

The database owner SID recorded in the master database differs from the database owner SID recorded in database 'AdventureWorks2008R2'. You should correct this situation by resetting the owner of database 'AdventureWorks2008R2' using the ALTER AUTHORIZATION statement.

Find Column Name in Database

How to know any table/function is used any query

How to find the Procedure Created and Modified date

Import/Export data with SQL Server 2005 Express

Delete duplicate rows

Non Clustered indexes per tabel

Merge Statement – One Statement for INSERT, UPDATE, DELETE

Store XML data into database using stored procedure :

SQL Server Function to Split Comma in Text