some people just jump on and feed off shit

some people just jump on and feed off shit

Post by Hotdog88376206 » Sat, 26 Jul 2003 20:41:33



they don't play the game they just feed
 
 
 

1. Trying to boot people off a database

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
 FROM sysprocesses
 WHERE dbid = 8
OPEN replicationdb_users


BEGIN

 BEGIN

 END

END
DEALLOCATE replicationdb_users
go

Any ideas would be welcome.
jan

2. ASP with MS SQL Server...

3. Osql replaces line feed with carriage return + line feed

4. Slowness accessing TEXT datatype.

5. Correct UpdateBatch Execution Order?

6. 20% off OCP Exams, 50% off Self Test, 70% off Oracle8i Training, Oracle10G info and more

7. Data: Unloading

8. column disapears (shit happens) on SQL Server 7

9. Reportsmith shit!!

10. sp3 for vb is shit?

11. Actually, the time for shit like this is long gone