i don't think you'll find an existing product that does EXACTLY what you are after, but it's a trivial request to do via TSQL.

there's a zillion examples of random strings...

can you use a script task to grab a COPY of the file to stick in %temp%, and toggle it's attributes to not be readonly? i had to do something...

In that case, if both iis and sql are blocked, its probably te wi dows firewall. Add two differen exceptio s, one for port 1433 and another for port 80...

SQL express, by default, does not allow remote connections, you very likely need to change that, and also go to SQL configuration and enable TCP-IP

empty string converts to an int without an error, and it's value is zero. it has to do with the precidence of implicit conversions

you could use the NULLIF function to...

ok technically it's possible, but not practical to consume later.

you can use a sql_variant, which allows individual values to hold their datatype...one field can be an int, and another...

in my snippets, where i have some mySQL linked server example,s the database and schema are left blank for a typical user.

Once you have the Linked Server in place I...

i would custom cursor for specific databases, sicne you wouldn't deploy to model/master/ReportServer etc.

it's actually a specific list, or some sort of pattern right?(all databases with 'APP_' or something like...

Jason running this specific example on my local machine, as well as on another server, this worked correctly for me:

http://webcache.googleusercontent.com/search?q=cache:GQgjJjIxFmsJ:codetempest.blogspot.com/2009/08/powershell-reporting-services-rskey.html+&cd=8&hl=en&ct=clnk&gl=us

it has to run locally, since it's effectively calling a command...

https://www.google.com/search?q=ssis+pop3&oq=ssis+pop3&aqs=chrome..69i57.6850j0j7&sourceid=chrome&es_sm=93&ie=UTF-8

from...

wow neat question.

i head to search this, and this link seems to say if you create an extended event session watching rpc_completed, it';s all available:

http://dba.stackexchange.com/questions/50122/collecting-parameter-values-from-extended-event-session

https://www.google.com/search?sourceid=navclient&aq=&oq=extended+events+paramter+values&ie=UTF-8&q=extended+events+paramter+values&gs_l=hp....0.0.0.4715...........0.

dynamic sql and and a serverprooperty might help, but how do you KNOW the user test already exists ont he local machine? why cna't you just add a domain\test instead...

jason i only did this once, and it was a two or more years ago, for a 2005 instance.

there's away to backup the key via powershell, and avoid the gui...

if your email server supports a standard POP3/SMTP interface, it's possible, but complicated code, since it would involve c#/vb.net code in a script task, and of course requires a lot...

well that's a design issue you have to think about.

in my case, our app user doesn't have access to the certificate.

the sql user we created has db_datareader, db_datawriter, and...