SQLRNNR (7/9/2014)

---

Eirikur Eiriksson (7/9/2014)

---

...and now the Backups are coming for...

KGJ-Dev (7/9/2014)

---

Hi Eric,

Thakns for your reply and when i execute am getting sysntax error

declare @IdEmployee int = 11,@Name varchar(20) = 'Peter';

EXEC('SELECT *

...

...and now the Backups are coming for a visit this...

Grant Fritchey (7/9/2014)

---

I'll come right out and say it. No, it's impossible to just migrate your database over using any straight method.

I agree with the steps Hanshi laid out...

Quick thought, place the function in a cte and use the output in the insert.

😎

This isn't too much of a challenge and definitely NOT a question of transferring 7TB in 30 min. Here is a quick suggestion:

a. Do a full backup of the 2K...

Without more information, it is impossible to say. Any kind...

2K doesn't like the db_id...

Few things to improve, firstly you must cast the @IdEmployee to a varchar

cast(@IdEmployee as varchar(12))

Next is the @Name, has to enclosed with apostrophe/single quote

char(39) + char(39) + @Name + char(39)...

This is most likely because the compatibility level for the database is less than 2005(90), nothing wrong with this code.

😎

No need to complicate things, the only thing needed here is correct window specification for the row_number function.

😎

;WITH HISTORY_BASE AS

(

SELECT

...

The Dixie Flatline (7/8/2014)

---

Wolfkill needs to know if there are tanks in EVE Online, as well as bombers.

Tanks are very important. ...

Simple things like snapshot isolation could do wonders in this kind of situation:-D

😎

Francis S. Mazeika (7/8/2014)

---

I ran the query, the attachement data is truncated at 65k, no attachement size is larger than that.

I run the same query\jobs using sp_send_dbmail in 2008 and...

jarid.lawson (7/8/2014)

---

I should have already posted my "solution". The issue was another job was running that used many of the same packages stored in the SSIS Catalog. They hit the...