Do you have any UPDATE triggers between the two tables?

Hi,

I have solved one part of my problem   There IS a timeout setting when executing remote stored procedures. On the Properties dialog of the...

Hi

I have a similar problem. Since I have standard edition I have written my own log shipping routines which work fine all week. Every night there is a full backup...

The Matrix. I first watched the Matrix on a flight from London to Atlanta, and at the end of it I was left with a distinct feeling of 'what if...

Thanks for a great article which clearly explains the balance between isolation and concurrency. I have had to make extensive use of (NOLOCK) in reports to obtain good conurrency because the...

I thought standby could be used with either, certainly it doesn't cause any problems when I include it in the restore command run from query analyzer. I tried the command...

No doubt we will soon have books being written on-line, a page or chapter at a time, 'open source' style, with contributions from the readers.

David

If I understand you correctly, you are storing your SQL statements in Table10, and retrieving them to the variable @s-2 before executing them with exec sp_executesql.

Is it that...

Me too,

I usually either end up concatenating columns to get the required condition, or using WHERE EXISTS.

Didn't know that the correct name for these was 'row constructors'

Hi

I was wondering if you could build a SQL statement that used a JOIN and a searched CASE to generate the different columns instead of all the inline SELECTs. It might make...

Logins assigned the system administrators (sysadmin) server role will automatically create objects belonging to dbo (look under dbo in BoL).

David

Also worth checking the instance name on your old computer. If you have ever upgraded or re-installed SQL Server on the old machine you may need to specify the instance...

For a warning about taking this approach to extremes, see Don Peterson's article on Lookup Table Madness...

http://www.sqlservercentral.com/columnists/dpeterson/lookuptablemadness.asp

Hi,

if you are trying to backup the file to a folder on another server then I suggest you create a shared folder on that other server, and give the account...

Hi,

there are two forms of CASE statement described in BoL,

Simple CASE, which yields a single column with different values depending on the results of the expression.

SELECT

CASE <expression>

  WHEN <condition1> THEN...