Well, the title explains the pain! We had the same issue recently in one of the machines, which was avoided upgrading just because of this issue for the last 4 months. every time we upgrade it and SQL stops working so we roll...
Read More
After long enough , I found something interesting .. Decrypting existing encrypted objects of SQL...
Read More
If you are searching for the solution regarding SQL CLR Send an email, you came to the right...
Read MoreLast week was quite simple and went without trouble , and just before I start enjoying my weekends – stuck in to in issue of getting ROW_NUMBER() (as we are doing in sandard SQL Query ! Finally come-up with sort and sweet...
Read MoreRecently on my shared hosting server I need to delete all the tables and starts from scratch , I got a ready-made script on Internet page. declare @n char(1) set @n = char(10) declare @stmt nvarchar(max) — procedures...
Read More
Just a day before, come across new issue of database. For some reason database found in suspect...
Read More
Recently Needs to find ‘/’ character in Sql store procedure body and replace with...
Read More
Recently I was asked to find out way to reduce the log file of SQL , after few search over google...
Read More
Recent database backup restore come-up with new error while tried to create database diagram...
Read More
Recent Comments