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)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy