SQL Server not starting after upgrade from Windows 10 to Windows 11
Well, the title explains the pain! We had the same issue recently in one of the machines, which...
Read More
Tag: SQL SERVER
Decrypt an Encrypted Object in SQL Server
After long enough , I found something interesting .. Decrypting existing encrypted objects of SQL...
Read More
Sending Emails with CLR SQL Server Express Editions
If you are searching for the solution regarding SQL CLR Send an email, you came to the right...
Read MoreROW_NUMBER() in LINQ 2 SQL
Last 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 MoreDrop all objects of SQL Server Database
Recently 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
Repair SQL Server 2008 R2 Suspected Database
Just a day before, come across new issue of database. For some reason database found in suspect...
Read More
Search within Store Procedure Text !
Recently Needs to find ‘/’ character in Sql store procedure body and replace with...
Read More
Eliminate SQL logfile completely !
Recently I was asked to find out way to reduce the log file of SQL , after few search over google...
Read More
SQL Server Database Diagram Creation Error
Recent database backup restore come-up with new error while tried to create database diagram...
Read More
Recent Comments