Your insert statements don't run...

Msg 109, Level 15, State 1, Line 54

There are more columns in the INSERT statement than values specified in the VALUES clause. The number of...

Jeff Moden (8/8/2010)

---

Thanks, Drew. Rumor has it that it's also pretty touchy about special characters like...

I believe that the document is pretty clear... an in place update of a Windows Server 2003 cluster / sql 2005 cluster to Windows Server 2008 cluster / SQL 2008...

I don't see an issue with it. Why do you think there is one?

If you want help, you need to put your data into INSERT statements. I've already pointed you to the article for how to do this, so why don't you help...

gmamata7 (8/7/2010)

---

Hi,

We have 2 node active/passive cluster set up for SQL Server 2005 x64 with SP3 on Windows 2003 x64 with SP2.

Now we want to first perform in-place upgrade for...

Sounds like you need a table of tasks, and email address of person assigned to each task. Then the package just utilizes this table to send emails out. All you...

Try this link

Tara-1044200 (8/8/2010)

---

I am using the following code to run the update in batched so that it wont take full log space,please verify if this is really doing transactions in batches...

IF OBJECT_ID('tempdb..#TestTable') IS NOT NULL DROP TABLE #TestTable;

CREATE TABLE #TestTable (TableName sysname, Qty int);

execute sp_msforeachtable 'insert into #TestTable select ''?'', count(*) from ? where date_modified >= DATEADD(DAY, DATEDIFF(DAY, 0, CURRENT_TIMESTAMP)-2,...

Ron has already asked you this...

You know, the people that help out here are all un-paid volunteers, so please HELP US HELP YOU. Providing the DDL scripts (CREATE TABLE, CREATE...

Okay, this time I'm going to insist.

You know, the people that help out here are all un-paid volunteers, so please HELP US HELP YOU. Providing the DDL scripts (CREATE TABLE,...

That being said, I think that this will work. Since there is no test data to test against, all the testing of this code is up to you.

UPDATE ME

...

You know, the people that help out here are all un-paid volunteers, so please HELP US HELP YOU. Providing the DDL scripts (CREATE TABLE, CREATE INDEX, etc.) for the tables...

CirquedeSQLeil (8/6/2010)

---

I think project rotation or task rotation maybe even responsibility rotation is a good way to keep fresh in the business. It helps to be able to do...