have you set a proxy up on the job that is going to do the work?
that's pretty essential for anything that touches stuff outside of SQL server, like command...

the restore headeronly command can do what you are asking

the results has a column named "SoftwareVersionMajor", and "SoftwareVersionMinor", where you can get things like 13,0 for SQL2016, for...

where are you displaying this, in SSMS or in some SSRS report?
you can convert the values to varchar with a case statement, but is that what you want?

I've seen this as a cross check that the big file is not still currently being written to; ie the file exists, and would be open but potentially if read would...

it is not possible that a database restore skips a table.
that means the table was empty at the time of the backup.
you most likely need to go to a...

nope, you have to drop the foreign keys that reference the PK, then drop the PK, then recreate a new PK and -the foreign keys so they now feature the...

I have to use this kind of logic to maintain a suite of tables that are consistent as a group, ie all data s of 8am, and I can hot...

how about swapping objects in and out of a schema? doing a bunch of transfers is extremely fast, but like  Chris said, you are consuming resources on production to do the...

SSDT can connect to FTP but not SecureFTP/SFTP.. FileZilla or many other executables handle both FTP and SFTP.

if that is what you are connecting to, you'll need to...

so do you want to arrange your data as columns, or one column that is comma delimted?

yopu did not provide an example query or expected output, but here's...

you have to be patient. it finishes rolling back when it finishes. maybe 15 to 30 hours from now; it's common that a rollback can take twice as long as...

I think you should have fixed the one query that was the issue, since you already identified it as a problem.
instead you changed the entire server behavior to account...

i do something exactly like this in PowerShell; with that, i can capture the output of the script, whether it was an info message, a  data set or an error...

here's a quick and dirty version of powershell, detailing what Grant was referencing

$FileNames = Invoke-SQLCMD -Query "SELECT top 5 'C:\Data\' + name + '.sql'...

I don't know that ConenctionProperty is actually database functionality . function. it's server functionality related to the connection, right?

this works in SQL2008 and above, and  I just checked, and...