Move those 5 to a different group, copy the permissions from one to the other, and then add the new permissions to the new group.

Anything else will be more difficult...

Take an exclusive lock on the table, disable the trigger, import the data, enable the trigger, unlock the table. Or will that take too long and block too many...

Can you modify the triggers?

If so, you could probably use User_ID to detect who the transaction is coming from, and ignore inserts that are originated from your login. Or...

I wouldn't build this in this pattern.

Automated restores almost always work better if they query the backupset data from msdb. If you do that, you don't need all this...

Do you have a question about this?

Roy Ernest (1/13/2011)

---

This place rocks... I ask for help and I get tons of help. This is the second time I asked for help here and both the times I...

Jeff Moden (1/12/2011)

---

I don't care about...

Steve Jones - SSC Editor (1/12/2011)

---

I can't afford Benjamins. We're in a recession, so you have to make do with Jacksons.

If you want to work for a half hour, I...

Makes sense. Glad you got it resolved.

You're welcome.

Yes, if the update includes multiple rows, the trigger will have a problem. I've never yet seen a login process that allowed for a multi-row log entry, since every...

Can you post the whole script/procedure? Might help if we can see what this is doing.

john.richter (1/13/2011)

---

Steve Jones - SSC Editor (1/12/2011)

---

You are right and wrong here. Similar arguments were made against web servers being off-premises. Today tons of companies do this and it works.

Not...

Are you just creating a clustered index, or are you creating a clustered-unique index? Or by "clustered index" do you mean "primary key"? The clustered index can have...

Reji PR (1/11/2011)

---

I am not understanding, why you are using dynamic sql string?

If My understanding is correct, you need to set the arguments in the where clause based on the...