Are there any post snapshot scripts associated with the snapshot for that publication?

Scripting replication is a very simple process. Just drill down to the publication in EM, then right click and select "Generate SQL Script", this will then allow you to create...

I wouldn't recommend using a defrag on datafiles. You won't be able to without stopping SQL anyhow.

An option to resolve the fragmentation level disk wise on the files would be...

We run it on all non db related drives. Whether it makes a difference or not I am dubious about, I've not seen any definitive stats to show me that. Bearing...

You'll have to drop the subscription and the publication, make the change to the table, recreate the publication and subscription and resnapshot.

Best way to do this is script out the...

You could change the IUSR account to a normal account.

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_NULLS ON

GO

CREATE procedure bcc_sp_inspection_result_codes

as

select...

Check out sp_helprotect in BOL.  I use this within a dts to pull all permissions on a nightly basis into a table along with the current date. I have another...

You would change USER ID =  and PASSWORD = to Intergrated Security = SSPI

create table #test (tablename varchar(100), count int)

insert into #test exec SP_MSFOREACHTABLE "select '?', count(*) from ?"

select * from #test

--drop table #test

Less of the "old" thankyou...

How about creating a temp table, insert into the temp table a count of the number of rows on the DB2 db and if that count is more than 0...

This would do it. It runs a select for those contactids in the clientcontacts table that are not in the select of the contactids that have a matching contactid in...

2 ways I know of (there may be more).....

Use a Dynamic Properties task to set the value (you can use a query, ini file etc)

or

Use a stored proc and pass...

Make the first step a datapump into a #temp table on SQL.

Second Step:

DECLARE @THECOUNT INT

SELECT @THECOUNT = COUNT(*) FROM #TEMPTABLE

IF @THECOUNT = 0

BEGIN

RAISERROR ('NO DB2 DATA', 16, 1)

END

Then run...