i keep getting a syntax error trying to make and run a cursor to kill
processes. Is it even possible to run a kill in cursor? In the docs it
says cursors can run exec and selects. I tried running it with and without
an exec in front.
DECLARE replicationdb_users CURSOR
FOR SELECT spid
WHERE dbid = 8
Any ideas would be welcome.