-
-
10000 rows at a time.
DECLARE @i INT
SET @i = 1
SET ROWCOUNT 10000
WHILE @i <> 0
BEGIN
DELETE FROM dbo.table
SELECT @i = @@ROWCOUNT
END
SET ROWCOUNT 0
-f.
-
-
- Go to Start - Programs - Administrative Tools - Terminal Services Configuration.
- Right Click on the RDP Connection and go to the sessions tab.
- That will create server wide settings and you can choose to over ride individual user settings.
Yesss, and it works even on a standalone server.
-f.