This behavior is by design. This excerpt from "SQL Server Replication: Providing High Availability using Database Mirroring" written by Paul Randal and Gopal Ashok, explains it well

"It is possible for...

I have experienced this same behavior with SQL 2008R2. I have databases mirrored in high performance mode, in "disconnected" state due to some firewall changes that were applied over the...

i would use Excel to generate insert scripts like so: Copy your (1,1,1)

(2,2,2)

(3,2,1)

(1,2,3)

from your query window, open excel highlight cell A1 and paste, highlight cell B2

and input the following...

Do you get any results (or an error) if you query the linked server using the 4 part syntax like so

select

*

from [test-linked server].master.dbo.sysobjects;

Try this instead:

select

'EXEC [dbo].[usp_DropPKFKConstraints] N''' + TABLE_CATALOG + ''',N''' + TABLE_SCHEMA + ''',N''' + TABLE_NAME + ''';'

from information_schema.tables

I'm sharing the answer that i found in the hopes it helps someone else.

I too had a stubborn filegroup that could not be removed. All the files had been...

Thank you Henrik. It works now!

The following 2 excerpts are from BOL. Under SQL 2000 it was required to run sp_altermessage on an error number for it to get logged to the Windows Application log...

Thankyou all for your assistance with this vexing cascading.

I agree that have cascading references setup adds a lot of overhead that can be avoided if you're willing to do the...

Well I've been trying a few changes with little success.

A performance gain happened when I deleted the index:

CREATE INDEX [nci_va] ON [dbo].[vts_tbVoterAnswers]([AnswerID])...

Got a simple little stored proc here that does a nice job of grabbing the proc name and the snippet of code containing the search term.

I also created one that...

Thanks for everyone's input. By the way I have experienced problems using /* */ for commenting (in stored procedures) when there is an embedded GO in the comments. Changing each...

Having a developer background as a DBA has many benefits. I'd say the biggest benefit is it allows you to keep the big picture in perspective.

But coming from a...