sunny.tjk (10/15/2012)

---

Gail,

I still have a question :-).

If I create a single index on Col A, Col B and Col C , but will this index be useful if I've...

Gail,

I still have a question :-).

If I create a single index on Col A, Col B and Col C , but will this index be useful if I've something...

Thanks Gail.

If space isn't the issue, can I create separate NC indexes than creating a composite index?

Any suggestions, please?

Suresh B. (10/10/2012)

---

No. Single composite index is better.

also can I create a composite index on [LKUP_ID]...

Other than the space needed by these indexes, I'm not assuming there will be any bad repercussions by adding them because there are no updates/deletes/inserts into this database.

I'd really...

Hi everyone,

Could someone please help me with this? I can provide more info if needed.

Lowell (9/6/2012)

---

Try this stack of queries; they all give you some various information about what permissions your current login belongs to:

select * from fn_my_permissions(null,'SERVER')

select * from fn_my_permissions(null,'DATABASE')

--some inferred roles I...

Lynn Pettis (9/6/2012)

---

sunny.tjk (9/6/2012)

---

I'll be sending the execution plan in a bit.

I've a question, I ran the following query and when I looked at the execution plan it's just doing...

I'll be sending the execution plan in a bit.

I've a question, I ran the following query and when I looked at the execution plan it's just doing a table scan...

Same error.

'Domain\New_ad_group' is not a valid name because it contains invalid characters.

SQLRNNR (6/27/2012)

---

Here's the Syntax

sp_addlogin [ @loginame = ] 'login'

[ , [ @passwd = ] 'password' ]

[ , [ @defdb =...

I wish I could but our dev machine is SQL 2000(with Enterprise Manager) and when I run create...

Lowell (6/25/2012)

---

two minor syntax issues;

the first is missing the single quote after "SSN_GRANTED"

EXEC sp_addrolemember N'SSN_GRANTED', N '[T001371\ViewSSN]'

and for both commands, there cannot be a space between the N and the...