its depends upon what option you are using for @sync_type if you are using repl support only option then 1st option is best. because There is a bug in sql...

first stop the distribution

then remove the subscription

truncate the destination table

run the BCP to transfer the data from source to destination.

add the subscription again using @sync_type parameter set to "replication...

sysdepends does not contains all dependent table informations. best approch is keep trace on and capture the data in a text file import that text file to a table the...

SELECT count(*) nomCount ,convert(varchar(4),year(orderdate))+ '-' + convert(varchar(2),month(orderdate)) 'Descr' FROM #temp

group by year(orderdate),month(orderdate)

having (year(orderdate)=2008 and month(orderdate) = 5) or (year(orderdate)=2009 and month(orderdate) = 5)

union

select count(1) as NomCount, 'Get counts for...

SELECT DISTINCT

o.name , oo.name

FROM sysdepends d,...

surely char(1) because already said that it doesn't contain space or null value.

Surely char(1) because already said that no space or null value is there.

A server may contain different sql server services like 'SSAS','SSRS' etc.other than the database engine.

If Permission to connect to database engine checked deny then user cannot connect to database engine...

You can write union all then write union query order by the primary key. you can see the difference.

select primarykey as Primarykey,* from T1

union

select primarykey as Primarykey,* from...