Well guys thanks for your help!  This is what I've found out...Because the data is being returned in one list/table, and the recipients only need the data that's pertinent to...

Thanks I'll give the loop a try!

I'll update you guys shortly!

TIA,

Christine

You understood my question exactly right...now my question is:

TSQL wise, how would I store that list so that it can be 'looped' through...is that right?

Currently, I am storing the records/e-mail...

Thanks and you're right so I will look at more characters, perhaps 10...

Now my question is, how within a function, can I return a record where the datetime field is...

Thanks!

Here's the background...I have a dB (3rd party vendor) that has no real constraints...therefore duplicate broker data is constantly being entered...like this

1. Acme Lending

2. Acme Lending Inc.

3. Acme Lending Incorporated 

Since...

I agree Auto Grow is fine as long as you prepare accordingly for expected growth...I however very often turn off the Auto Create Stats.

Duh, I could not remember that for the life of me...

I was stumped after I ran sp_helpuser,

and it was sooooo obvious all along.

Thanks!

Ahhhhh!!!

You are the best!

Thanks!

fhanlon,

I tend to agree with that option and feel a bit more comfortable with that.

Thanks all for your input, you all are awesome!

Edited by - aurora01 on 11/21/2003 10:47:37...

Thanks Stephen, I find the same to be true and that's why I am challenging (so to speak) the standard. One other base to cover though, what's the affect...

Agreed regarding the app! But in this situation we just want to give the security team permission to add/remove logins, and then add/remove users to the datareader role. ...

mforbes,

The problem is "you do" have to be a dbo or sysadmin to add users to roles. They "do not" have to be sysadmins or dbo's to add...

This is the first I've heard of an Admin DBA, as DBA already indicates Database Administrator. At the Senior level, the DBA wears many hats, usually encompassing (but not...

Thanks Allen!

Steven, I connected as the user and was able to run the sproc.

Question though, when a user is added to the securityadmin role should they be able to...