:::: MENU ::::
Posts tagged with: SQL SERVER

Decrypt an Encrypted Object in SQL Server

After long enough , I found something interesting .. Decrypting existing encrypted objects of SQL Server !! (Ref : Source ) Step 1: Make sure remote admin connections is enable on server if not enable using following EXEC sp_configure ‘remote admin connections’, 1 GO RECONFIGURE GO Step 2 : Connect to  SQL Server using DAC […]



ROW_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 code! var items = context.ItemMasters.AsEnumerable() .Select((u, index) =>  new ItemDetail {    ItemId = […]



Repair SQL Server 2008 R2 Suspected Database

Just a day before , come across new issue of database . for some reason database found in suspect mode ! and that was horrible moment. After some search , we got brief idea that , database can go in suspect mode for many reasons like improper shutdown of the database server, corruption of the […]


Search within Store Procedure Text !

Recently Needs to find  ‘/’ character in Sql store procedure body and replace with ‘\’ Now Having about 100 Procs and its really boring job to open each proc and have check for it ! .. so find out small handy sql query so that it will give me list of procs contains specific string […]



SQL Server Database Diagram Creation Error

Recent database backup restore come-up with new error while tried to create database diagram “Database diagram support objects cannot be installed because this database does not have a valid owner.  To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a […]