SET statement is mandatory part of UPDATE statement (check BOL for UPDATE), therefore you can not avoid using it.

This: http://blogs.lessthandot.com/index.php/DataMgmt/DBAdmin/mirroring-sql-server-2005-to-sql-server-2008

can help.

Good luck

It seems that"SET XACT_ABORT OFF" define transaction behavior.

In accordance with BOL: "When SET XACT_ABORT is OFF, in some cases only the Transact-SQL statement that raised the error is rolled back...

"The more I learn, the more I learn how little I know"-

Just now I got that problem was in WHERE clause that refers column name explicitly.

Thanks Gail, my bad 🙂

Sorry guys if I did not get something but this scripts works for me:

EXEC sp_Msforeachdb

'

if left(''?'', 5) = ''MyDB_''

begin

use [?];

if...

There is Hide (?- sorry do not have access to SSRS right now) property for column-

use IIF function and assign 0 or 1 to hide/show column depending on your...

It can be the case (I have this experience) that this is actually not SP or report issue but rather how browser renders this 20K+ records. Try using input parameters...

IMO next statement from the article

It is ignored...

There is good explanation in BOL "Backing Up and Restoring Full-Text Catalogs"- hope this can answer your question

Sql Servers 2005 and 2008 probably have different default settings for linked servers, therefore they behaves differently. I would suggest for 2005 you:

1) check connection/security (from srv2 to srv3);

2) check...

There are 2 suggestions:

1) Use RowNumber function instead

2) Check function scope.

Probably it can help.

Shame on me- completely forgot that there are actually 2 stop lists- system and DB.

Thanks for reminding 🙂

If you do not have 2008 installed yet how can you "'Add features to existing instance' "?

Logically speaking you should choose "Install new instance"

(frankly I would rather try it first...

Colin,

In 2005 "will" is in default noise list therefore FTS just ignores it (certainly it ignores ' "certificate" AND "will" ' also). I do not have right now 2008 in...

This link http://learnsqlwithbru.com/2009/09/24/downgrading-sql-server-enterprise-edition-to-standard-edition/

explains how to do this trick for 2005 versions- probably works for 2008 also