王中王 · 2005-08-17 11:42:41 · 阅读: 323 temp use DBNAME go DECLARE @sid BINARY(16) SELECT @sid=sid FROM sysusers WHERE name='USERNAME' and islogin=1 exec sp_addlogin @loginame = 'USERNAME',@sid = @sid