regardless of whether you use CTE or not, it's the INTO clause that is the problem.

i'm 99% positive that SELECT INTO does not allow 4 part naming

you have to Use...

this is what varchar(max) was designed for.

varchar(max) will be stored out of row (if i'm correct on that) therefore not counted towards your 8060 bytes and operates effectively...

delete from mytable where vendor_num in (select vendor_num from mytable group by vendor_num having count (*) >1 ) and o_objid is null

i'm pretty sure you can't use select into on linked servers.

same as create proc/table etc -

you have to create the table with a direct connection on the target...

I agree - all of the apps i downloaded seemed to be pretty shoddy. especially periscope which i still havent managed to get to work correctly.

RAAS seems to be fairly...

I've followed the instructions and replied to the trial liscence email with the correct phrase in the subject line, but so far have not received a full liscence key......

but if you're using linked servers how are you running commands like

dbcc sqlperf(logspace)

which would tell you if a log were large or not required intervention (i.e a developer...

This is something i've been looking at for a long time and it's intersting to see how other people approach the problem.

unfortunatly I came across a stumbling block in using...

Japie,

I'm jealous. my colleagues seem to think that a single man like myself would have it easy, no ties or binds. but by the time i finish my working...

redgate's "sql dependency"

http://www.red-gate.com/products/SQL_Dependency_Tracker/index.htm

It's great, but for large databases (i.e thousands of tables) it chews up graphics memory and slows your system. - best used with about 50 tables max

it will...

you have to drop any subscriptions to it firts - but enterprise manager won't let you do that through the gui -

here is the script

sp_dropsubscription @publication = 'publication'

...

sp_addserver 'msyserver','local' also requires you to stop and re-start the service before it takes effect

i have come across this on several occasions.

i tried dropping the article and adding back in before creating a new snapshot, but the problem re-appeared.

the only method i've found of...

I hate the way articles on this site have started to become "adverts"

if it's a balanced article about the merits of refactoring and intellisense then mention the competition.

what could have...

look at sysdatabase.category

select * from sysdatabases where category&&1=1 or category&&4=4

this will tell you if it is published via transactional or merge replication - see books online sydatabases for...