You might be able to add the wildcard * character at the end of what you have built.. Not sure about that control..

CEWII

What is in the report server log? DDS runs write data there, also you may have to turn the verobsity up on the log to get the information you...

Why don't you post the EXEC SQL task SQL statement and we might be able to help. I can say that it doesn't do what I would call complex...

Although I know "." equals local machine, I have seen weirdness.. You might try actually using the machine name and see if it makes ANY difference..

CEWII

The MS provided tools are not the only tools and blocking them alone not really secure. Basically anything a user can do from SSMS can be done from any...

If it is asking a Y/N question then I have a thought.

Login to the machine as the same user that SQL/Agent login to the machine as, ie: if SQL uses...

Maybe it is my paranoid nature to data protection, but I still like to have 2 copies in this situation, but mileage and comfort levels vary by the individual.

CEWII

You still haven't addressed the fundamental problem.. So we keep SSMS out, that is nice, but "programname" is set at the client, there are no controls on that side....

You are very welcome. SQL, like every other language take a while to get into.

I would say this, my guess is you are coming from a procedural language, like...

Inplace upgrade?

That always scares me.

It looks generally right. I'd copy the DBs off to another place as well, but I'm just paranoid..

CEWII

At first blush you are probably right, I'm curious how you came about this syntax since you did pretty well everywhere else..

Also, I may not fully understand your goal in...

First I think there is an important element to consider, indexes really only have costs on the write cycle. For reads like SELECT statements they can usually only help....

Logon triggers won't help audit WHAT data was changed just that a user logged in and some metadata about the...

Fazalul Haque (2/24/2010)

you can group by a column which is not...

You can use the ISNULL( fieldname, '' ) function around the items that are used to assembly the string. Keep in mind that sometimes things end up NULL when...