the stored proc can...

that would be the default action for dynamic sql within a cursor, then. just don't wrap the cursor in a transaction.

i would not use a cursor for this, but pending...

so, if your cursor were going to loop through 50 tables,

and you get an error on table #30, do you want to rollback just table30, or the 29 previous...

this is effectively recreating the wheel, isn't it(youtube.com?)

Like Sean said, i doubt you'll have an API to push around a DVR; i've never seeen or heard of one.

if you have...

convert has an optional 3rd parameter:

--2015-04-06 16:13:21.187

SELECT CONVERT(VARCHAR,getdate(),121)

also, use quotename around your db variable; sharepoint databases often get created with hyphens, and hyphens or spaces int he naem will break your script

SET @sql = 'USE ' +...

deleting and inserting again where the your Id already exists is exactly what an update actually does...

it sounds like if you cannot fix the applciation/datastream to know it has an...

as i remember it, pragmatic works is around 1500 bux, which would save you weeks of self development anyway.

certainly a good option, in my opinion.

there's an older 2008 version here, which can be compiled:

SSIS SFTP Task v1.5 for SQL Server 2008

you did see that that project contains the complete source code, so you can compile it yourself, right?

ok, i see what the others were saying now.

https://ola.hallengren.com/sql-server-index-and-statistics-maintenance.html

i've used this open source project several times:

https://ssissftp.codeplex.com/

no sense reinventing the wheel, if it's open source, you can rename it, taking care to leave credit where credit is due, and...

for the specific database you exclude, is it a database snapshot, or offline or read only ?

easy fix.

@temp variables go out of scope when you call it in the msdb.dbo.sp_send_dbmail call , so you'll have to change it to a #temp table instead.

in a general sense yes,it's probably good for 90% of what you need, but depending on your settings for your scripting options things can NOT be scripted. that's why a...