Often we need a fresh copy of the production database in another environment (eg DEV/TEST/UAT). Previously this was a tedious task involving getting a backup…
This means your SQL Master DB is in a bad state. To fix: Error- Invalid object name ‘master.dbo.spt_values’. CD “C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Install” run u_tables.sql…
Using Integrated Security in connection strings should be either of the following: Integrated Security=SSPI or Integrated Security=false It should not be Integrated Security=true
declare @vcFK varchar(250), @vcTable varchar(250), @vcSP varchar(250), @vcView varchar(250), @vcFn varchar(250) — …drop all foreign key constraints select @vcFK = min(name) from sysobjects where type=’F’…
CREATE PROCEDURE <procName> /*^ * Procedure: usp_TryCatchSkeleton ^*/ AS BEGIN SET NOCOUNT ON BEGIN TRY –Do work END TRY BEGIN CATCH /* Note that catching…
Delete all tables EXEC sp_MSforeachtable @command1 = “DROP TABLE ?” Grant execute permissions to all stored procedures to a specific user CREATE PROC grantexecutepermission( @UserName NVARCHAR(250)) AS DECLARE curse CURSOR …