SQL

Sometime you may get below error while attaching a database: Attach database failed for Server 'SERVERNAME\SQLEXPRESS'. (Microsof...

Use below query to get details of permissions on Database objects SELECT ulogin.name AS [User Name], CASE princ.type WHEN 'U' TH...

Use below script to restore maintenance plan from log backup: USE [Master] GO DECLARE @BackupExtention nVarChar(4); SET @BackupExtentio...

Sometime when we try to import a SQL Server 2000 DTS package into SQL Server 2008 R2 using SSMS, the following error  appears : Managing ...

You can use below queries to get the list of all the tables with Identity column: SELECT OBJECT_NAME(ID) AS [Table], Name AS [Column] FR...