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...

rather than looking at recompiles and statistics, how about looking at your joins themselves.

would it be possible to have 2 versions of the proc - each with distinct join...

you can also try using SET FMTONLY on/off

will execute the query, but not affect any rows or return rows (only metadata)

this would show up errors better than parseonly for missig...