Skip to content

Category: SQL

Restoring a DB to a different directory

http://www.codeproject.com/Articles/708720/Solution-The-WITH-MOVE-clause-can-be-used-to-reloc

 

Find all tables containing column with a certain name

 

SQL – This will search any procedure, view, or function for a string.

 

SQL Changing Schema Name

Changing it one by one use the following.

Changing all stored procedures.

 

Simple Linq to SQL Insert and Update