MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.
Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.
declare @lname as nvarchar(128); DECLARE custom_cursor CURSOR fast_forward FOR select name from sys.syslogins; OPEN custom_cursor FETCH NEXT FROM custom_cursor into @lname; SET @lname = @lname WHILE @@FETCH_STATUS = 0 BEGIN ALTER LOGIN @lname ENABLE --PRINT @lname FETCH NEXT FROM custom_cursor into @lname; end close custom_cursor; deallocate custom_cursor;
|Requesting help with creating an SQL query with 2 tables||6||25|
|Compare a numeric value to a varchar w/o getting an error||4||20|
|Is it possible to debug a Store Procedure on MSSMS after a unitTest that calls it from VS ?||4||24|
|Finding gaps or missing dates in a date range using TSQL||3||24|