you should only have to cast the comparison with a collate statement;
this worked for me, does this help?

i used 128 for the length, since a object name...

I am always so afraid of using a shot gun approach without definitive testing and eyeballing for correctness, because a find/replace could nail partial words /strings.
I would use either SSMS...

I would also suggest the SET NOCOUNT ON,  that used to be a staple of my old classic ASP pages; I would bet that is what is affecting you.
you...

i would think getting rid of the trigger, and creating a simple TSQL job that runs every hour would be better and easier.

a script like this would do...

gotcha, i think the issue is the cross database query call.

then normal individual who enters the data is not in the [msdb] SQLAgentOperatorRole or SQLAgentUserRole, which arethe roles...

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...