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

Do you have any control over the structure of the database? If you do, I would strongly recommend changing your table so it looks something like this:

001 a

001 b

001...

chadlau11 (1/4/2015)

---

John Mitchell-245523 (1/2/2015)

---

There are probably newer-fangled ways to do this, but I would stick to what I know, and import the list of files into a staging table so...

There are probably newer-fangled ways to do this, but I would stick to what I know, and import the list of files into a staging table so that you can...

What results do you get from the following queries? Remember to run them in the same database as you got the sys.database_principals results from.

SELECT name FROM sys.objects WHERE object_id...