Type those very words into your favourite search engine. You'll get plenty of results.

John

Baiju

Try enclosing your parameter list in parentheses.

John

"sp_" is the prefix used for system stored procedures, so there are...

If I remember correctly, the job will still run in the context of the SQL Server Agent service account if the job owner is a member of sysadmin. Is...

Yes, that's right, provided there aren't any other connection managers that use a trusted connection.

John

Are you executing the package from a job, and if so do you specify the config file in the job step?

John

Yes, or you could use an OR. Try them both, and see which performs better.

John

If you use third-party backup software (I'm thinking of LiteSpeed, but I wouldn't be surprised if other products are similar) and you need to restore to a server that does...

Unless I've misunderstood...

WHERE ID = something

AND c1 = c2

Edit:

Hold on - I think I know what you're asking. If you want everything where ID = something as well...

For jobs where I am likely to need to know this information, I add a step at the beginning called Initialise. I set the subsystem to CmdExec so that...

I think it's 150ms, isn't it - 6400 waits, 1080 seconds of wait time? But that's only if that's the only query that took that type of lock -...

What is the command line from the job step that runs the package?

John

Are you sure it's not available? Perhaps your server has a case-sensitive collation - I notice you spelled the name with a capital SP? Or maybe you just...

Mohan

I don't know whether that's possible. But I did have an incident last year where a contractor who was working at the weekend got very upset that he wasn't...

Well, you're the expert - that's why your manager hired you. I don't think setting the columns NOT NULL will work, since your requirement is only to have at...