Remembering Thoughts
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 file, copying it to another location, restoring the database. Here […]
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 in master….
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’ while @vcFK is not null begin print ‘Dropping FK constraint […]
CREATE PROCEDURE <procName> /*^ * Procedure: usp_TryCatchSkeleton ^*/ AS BEGIN SET NOCOUNT ON BEGIN TRY –Do work END TRY BEGIN CATCH /* Note that catching and rethrowing an exception is a lossy operation. ERROR_PROCEDURE() etc […]
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 FOR SELECT name FROM sysobjects WHERE TYPE = ‘P’ OPEN curse DECLARE @proc VARCHAR(100) DECLARE […]