any command with a FROM must have a SELECT...

so that's the error you are getting.

To do what you want, I'd probably use EXISTS:

something like htis, maybe?

IF EXISTS(SELECT 1 from inserted...

thamil_md (3/22/2012)

I have a column named 'SQLs' in Table A and the column 'SQLs' has SQL statements as data, like this:

select '21/03/2012' as date_modif_create, 'tblAddressesGP' as table_name, count(*) as total_rows_modified_updated...

take a look at this books online item about using native mode to avoid dataconversions...it's just a -N flag, but it's important to understand, it might be what is affecting...

best practice is to never shrink the databases, unless you know a one time ETL process ro something expanded a database.

the thing to do now, i think is to look...

absolutely no value or logical reason Eugene, you are right, other than it was what I thought the OP was asking for...a model that included try catch and features an...

here's a pretty full fleshed model:

CREATE PROCEDURE EXAMPLEINSERT(

@Value VARCHAR(30))

AS

BEGIN

BEGIN TRY

BEGIN TRANSACTION

...

echoing Henrico and Anthony's responses, there is more support and examples for using SSIS than any other ETL tool out there, and the price for SSIS, being included free for...

if you want to start digging into slow queries, something like this will get you started.

you could then start reviewing the querie plans and see where the perforance issues are...non-SARGABLE...

does your application make hundreds of separate trips to the server? so for example if you have a dataset with 100 table,s it makes 100 separate calls to the server...

all the code inserting the data has to use the same datatype : NVARCHAR or NCHAR.

code as simple looking as

try this code example out and see what happens if...

Seans idea of using a view has a lot of advantages.

if you deny SELECT on a column like my first example,

if you have code in an application they are using...

deny trumps any other grants unless the user is a sysadmin...so deny it

DENY SELECT ON [dbo].[PAYROLL] ([RATEOFPAY]) TO [ClarkKent]

oops my error, i thought this was via TSQL and not in SSIS...sorry folks.

Paul can you add a CLR?

if you can, it is REALLY easy.

here's an example call

select dbo.CLR_WebQuery('http://www.YourDomain.com?f=QueryString')

and the code for the CLR, which i just tested was incredibly simple:

'Imports...

yeah that's working by design;it's considered the normal behavior to throw away the identities that get rolled back in a transaciton or deleted; they are not reused.

the identity() columns...