Viewing 15 posts - 1 through 15 (of 44 total)
March 16, 2018 at 9:32 am
March 14, 2018 at 4:35 pm
March 6, 2018 at 11:13 am
For my personal version of this I have removed the first 3 columns as they were taking up visual space for information I did not need. I have added the...
February 8, 2017 at 1:34 pm
Your script is a military grade flashlight in what was a black box for me! Added to favorites, thank you.
January 30, 2017 at 4:30 pm
If you are going for fewest number of characters in the exercise you can save one more with:
WHERE n < 101
December 28, 2016 at 9:56 am
No results from both of my production replication servers, one SQL 2005 one SQL 2012.
June 6, 2016 at 1:00 pm
cyp901 (6/2/2016)
Velveeta22 (6/2/2016)
fregatepllada (6/2/2016)
It's amazing that usage of CLR is no-no in SQL Server , but old-fashion OLE/COM integration is acceptable 😉
cyp901 (6/2/2016)
In general, my preference is not...
June 2, 2016 at 2:02 pm
fregatepllada (6/2/2016)
It's amazing that usage of CLR is no-no in SQL Server , but old-fashion OLE/COM integration is acceptable 😉
cyp901 (6/2/2016)
In general, my preference is not to have...
June 2, 2016 at 9:47 am
Bosko Vukov (6/2/2016)
Hi, the problem is not in the nvarchar type but in the limitation of sp_OAGetProperty in the line:EXEC @hr = sp_OAGetProperty @Obj, 'ResponseText', @json OUTPUT
I believe this is...
June 2, 2016 at 9:21 am
fregatepllada (6/2/2016)
How to build a HELL in each SQL Server :angry:
Angry face is confusing. Please expand on the issue.
June 2, 2016 at 8:41 am
Checking on sp_OA limits, probably the character limit issue.
June 2, 2016 at 8:35 am
The purpose is to pull the user out of the text string in a friendly readable format. If you are getting an error here, then you have an oddball...
February 8, 2016 at 4:04 pm
Although submitted as an ad hoc script with no permanent tables, I actually use it in my own environment to send previous months aggregated login data into permanent tables on...
January 6, 2016 at 8:40 am
No worries. This is actually my favorite script I have implemented. The business used to have a lot of problems with re-syncronizing the mirrors after they were disconnected...
January 5, 2016 at 8:45 am
Viewing 15 posts - 1 through 15 (of 44 total)