p.s. No long-winded lecture on the use of WITH(NOLOCK) or an ordinal column list in the ORDER BY.  You've been around long enough to know the cautions and the...

The simplest method to debug dynamic SQL is PRINT/SELECT it, debug that SQL and then propagate the solution to the SQL that produces the dynamic statement. We can't run your...

If you don't tell us what the content of script.sql is, we really can't do more than guess at what you're trying to do here it.

Is that new ?

So a Domain Admin can't grant SQL Admin access to another Windows Admin account, if the Domain Admin has not specifically been given SQL Admin permission...

• This reply was modified 5 years, 2 months ago by Thom A.

Powershell and a Windows Scheduled Task is one method yes. Some prefer to use a different scheduling tool that is more "user friendly"; there are plenty out there if you...

This is a SQL Server...

All those images show scans, no seeks, which really isn't going to be helping things here. That image, of your SQL, is very difficult to read as well. You'd be...

What is the object um in your code, as it's not defined in the SQL snippet you have given us. Ideally, however, you should be trying to fix the design;...

Without knowing more what you're going, or have changed, I can only guess. I know the above works; it is part of an automated process I have that occurs everyday.

@DesNorton - I don't think sp_ExecuteSQL would actually diminish the danger. If the @WeatherFieldName variable had a semicolon in it, followed by a query - I believe it would...

After connecting to FTP site how do you do a change directory command, and can you just point to a folder to deposit the files from local, not having...

This isn't quite what you are after, but it's not far off, and I am sure you'll be able to modify it for your needs (such as add a for-each...

Hi Solomon,

Yep, I amended everything I could noticed no loss of characters, so it appears that everything does go through that one line that you highlighted for change.

If there is...

All looks good; you can see snippet of the silliness below. 1, 2 and 6 I'd already tested. I didn't, however, test changing the scheduled date to a historical one...

Hi Solomon,

Yep, adding the notation character to that one line appears to do this job. I tested Comments, Posts, and Pages, and all 3 now correctly stored the characters.Well done...