I am part of an AD group. The group does not have permissions to create or alter logins.

My question is, How do I deny Alter Login permission? Or rather what permission is allowing me to create my own login?

I added some more information. Please take a look.

i get a syntax error when i run this. "Incorrect syntax near '@num'."

Lynn Pettis (3/3/2010)

---

preetshari (3/3/2010)

---

Yes but i need to return the updated LastUsedIndex.

Does this accomplish what you require?

DECLARE @num...

Yes but i need to return the updated LastUsedIndex.

Does this accomplish what you require?

DECLARE @num int -- or what ever type it is

BEGIN TRAN

UPDATE SeqNumbers

@num =...