How about something like this:

-- change to Text Results (press Ctrl+T) before running

-- change this to whichever database your selecting from

USE [YourSourceDatabase];

-- change this to the destination database name

DECLARE @targetDatabase...

Nice offering MM. The technique is one I have seen outlined before but not necessarily applied to SSIS. While no one step is difficult there are quite a few of...

timscronin (1/9/2013)

---

I have an OLTP system which has a monitor job which needs to be run during the day. WHen the closing is run by 2 different sites the...

michaelkinlb (1/9/2013)

---

opc.three. Would you be so kind as to implement your statement, ' In SQL 2012 we have the ability to define a default schema for a Database User...

David Webb-200187 (1/9/2013)

---

As far as I know, there is no way to do a backward restore, even if the database was in a compatibility mode that matched the lower version....

manibad (1/9/2013)

---

I mean if i choose special format under that home phone number means the data will be like this (XXX) YYY-TTTT...or if i am going to choose social security...

Import/Export wizard runs in 32-bit mode if you launch it using SSMS while your server is probably a 64-bit process per the bitness of the SQL Server.

IIRC you can only...

DFS is another added layer that can complicate matters when manipulating files on the file system, or it could be a red herring. It could be tons of things unique...

When I am talking about formatting I am talking about bolding the text in a column header, or setting the background color or a column of cells. What kind of...

Cup of soup

By all means, absolutely. If the use of NOLOCK is that pervasive then consider this your...

You would enable READ_COMMITTED_SNAPSHOT on the database and remove all NOLOCK hints from your queries. See the article I linked to in my initial post on how to enable the...

GilaMonster (1/9/2013)

---

opc.three (1/9/2013)

---

GilaMonster (1/9/2013)

---

opc.three (1/9/2013)

---

The nice thing is that no queries need to change, not even the ones with the NOLOCK hint applied, and you'll automatically get transactionally consistent reads....

GilaMonster (1/9/2013)

---

Queries with...

I doubt they fully understand what dirty read really means otherwise they would not be alright with it. It means...