No, because the parameter value is the primary key and so only one row can match.  You're deleting one row, changing the parameter value, deleting one row again, and so...

How are you running the query?  The query for which you posted the plan will only delete a single row, since your WHERE clause specifies a single value of the...

Jonathan is right.  To answer your question directly, no it doesn't mean that.  The CATCH block will be invoked because there was an error in the TRY block.  The XACT_ABORT...

I guess that your question is how do you check the space remaining on the drive?  Try using the stored procedure xp_fixeddrives.

John

So you have an instance called CLUSTERNAME\RESOURCENAME and you want to be able to connect to it by typing just RESOURCENAME?  I don't think SQL Browser can help you with...

Not so.  DBCC CHECKDB verifies that the database is free from corruption, as you say.  Verifying the backup performs a check on the backup file.  It's possible to have a...

Merge replication is probably the way to go here.  You could try rolling your own solution with triggers, but I guess it would soon get out of sync.

John

Same principle.  Fail over all AGs to one node, do whatever maintenance you need on the other, then do it again in reverse.  I take it you don't have any...

Fail over so that both/all instances are on Node 1.  Change the service accounts on Node 2.  Fail over both/all instances Node 2.  Change the service accounts on Node 1. ...

There may be a more elegant way, but this works:

DECLARE @CalcField1 smallint;
DECLARE @CalcField2 smallint;
DECLARE @CalcField3 smallint;
DECLARE @CalcField4 smallint;
SET @CalcField1 = RAND(CHECKSUM(NEWID())) * 100;
SET @CalcField2 = RAND(CHECKSUM(NEWID())) *...

Using sysname in this instance, and appropriate data types in general, won't in itself prevent SQL injection - it's just one more line of defence.  It's more difficult for a...

Richard

Your hunch in your original post was correct - you can't parameterise the database name and table name.  I don't understand why you want to change it from how it...

It should work like that.  You've probably got a little syntax error somewhere - that's all.  What is the error message that you get?

John

Keep an eye on the free space in the files, and extend the files when it approaches zero.  Likewise, keep an eye on the free space on disk, and extend...

Matthew

I think I've wondered this myself in the past, but ended up having to reinstall.

Does your application not allow you to specify a connection string?

John