The best way is not to do it.

The couse of this trouble is "resolving views" or "opening derived tables" behaviour which was once fixed in SQL2000 SP3 and sadly reintroduced in SQL2000 SP4.

It stays with us since...

You probably do not need all that excessive "in code" checking.

The whole point of those checks is to make sure there would not be any error.

Which is good (as for...

I made up a quick test to verify Gila's suggestion.

Very interesting outcome.

Whoever is curios try to run this:

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

create proc [dbo].

as

begin

declare @i table (id int, NAME nvarchar(150))

select...

What dynamic SQL is for?

CREATE PROCEDURE [dbo].[ProSearchStudent]

@search varchar(50) = ''

AS

IF (DATALENGTH(RTRIM(LTRIM((@Search))))) = 0

...

Which means - can afford to lose data.

Which is not the case by default.

yes, I would recommend changing...

Are you in some kind of competition for a stupidiest advice ever?

Is it what you suggest your poor customers: switch recovery mode on all databases to SIMPLE???

So they do not...

You might be surprised - but SQL Server has it too.

And cowboy developers may (most certainly will) ignore that scaffolding in PowerShell as well...

opc.three (4/24/2013)

---

I would also like to mention again that Microsoft has initialized the xp_cmdshell option as "disabled" since SQL 2005 and just about every "Security Best Practices" document, book...

opc.three (4/26/2013)

---

A stand-alone PowerShell prompt on Homer's machine does not offer much over a stand-alone CmdShell prompt on Homer's machine in the way of added security, only in functionality. Both...

FULL backup takes care only about data pages from data files.

It does not touch TRN log file at all.

You need to release some sppace in log file by doing BACKUP...

VBS is out of fashion.

There is a new kid on the block with huge marketing budget attached to it.

Everybody must immediately forget about the old and proven tool.

Yep, first thing to look.

Faced the same problem...

geoff5 (4/23/2013)

---

After reading through the thread, I see that none of the solutions offered thus far have recognized the necessity of treating the rows with a known IDNo differently than...

INSTEAD OF trigger would be useful for the task.

Look up BOL for details.

But I support Andrew in his suggestions - regular job is more preferrable for such tasks.

Or call deletion...