Viewing 4 posts - 1 through 4 (of 4 total)
NO, but it did not give the results from the second file.
November 4, 2015 at 9:53 am
Yep, just an FYI. All the other fixes I saw use cursors and mine does not.
November 11, 2011 at 9:00 am
I hate cursors!
Tested on MS SQL 2008 R2
SET NOCOUNT ON
declare @GetListOfOrphanUser table
(
rowid smallint IDENTITY(1,1),
UserName sysname,
UserSID varbinary(85)
)
declare @UserName sysname
, @NoOfUsers smallint
-- To generate...
November 11, 2011 at 7:34 am
I hate cursors! Tested for MS SQL Server 2008 R2
SET NOCOUNT ON
declare @GetListOfOrphanUser table
(
rowid smallint IDENTITY(1,1),
UserName sysname,
UserSID varbinary(85)
)
declare @UserName sysname
, @NoOfUsers...
November 11, 2011 at 7:31 am
Viewing 4 posts - 1 through 4 (of 4 total)