To reinsert the rows that were copied from table1 into table1_save, and subsequently deleted from table1, keeping the original identity value:

SET IDENTITY_INSERT table1 ON

INSERT INTO table1 (list of all columns...

Dan,

These links might also be helpful:

How to: Migrate a Reporting Services Installation

Moving the Report Server Databases to Another Computer

Seems like you can just restore your databases on the new server.

I have a script (at home - can get it tonight if you want it) that will script out all of the reports/data sources / data models / folders off...

Dan,

The SQL 2008 Upgrade Technical Reference Guide covers this in section 14.3.2.

I was going to comment about the readability of error messages, but I see that Michael has beat me to it. This can be especially helpful if the error is...

Wow. I've seen some pretty long ones, but I don't think it was quite that long. Then again, I usually dump mine to NotePad++, which (depending on the font used...

sqlgreenhand (8/29/2010)

---

I would like to create a dynamic sql with sp_executesql as followed, but with errors. Please help

Do all the varchar become nvarchar ?

Thanks.

DECLARE @DatabaseName nvarchar(500)

DECLARE @TableName nvarchar(500)

DECLARE @ColumnName nvarchar(500)

DECLARE...

STUFF removes the leading comma.

CROSS APPLY runs the query against each record.

Using the 116,000 rows of data from my previous post, this generates these results:

Table '#Test___00000000001A'....

This filters the result set to just those records that do have a period.

If you didn't...

Jeff Moden (8/29/2010)

---

Wayne,

I was looking at your previous row calculation on the 3 part update thinking to myself "Cool... he even thought of the forced RN change when EMID...

Triplicate post. Please post all responses at http://www.sqlservercentral.com/Forums/Topic977057-1292-1.aspx.

Triplicate post. Please post all responses at http://www.sqlservercentral.com/Forums/Topic977057-1292-1.aspx.

Make a job. Make each sp a separate step.

Jeff Moden (8/27/2010)

---

David in .AU (8/27/2010)

---

Jeff, that's such a cop out 🙂

Come on, show the color of your spandex...

As for me, Atomic Robo, has a lot more fun with technology...