Decrypt an Encrypted Object in SQL Server
After long enough , I found something interesting .. Decrypting existing encrypted objects of SQL...
Read More
Tag: SQL SERVER
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