it worked the first time when I used it...i deleted the user, recreated the user again, when I execute the command it says "Command Completed Successfully" but it does not...

Thanks...just one problem....The script below doesn't work:

EXEC sp_addrolemember N'db_owner', N'TestUser'

I will keep looking.

Thank you very much!!!

yes, thats what I meant.

Sorry about mispelling.

SQL Server Standard does not allow Online indexing. DBCC DBREINDEX is one them I can't use.

thanx Suresh

Thanx Deepak

Yes

I tried that numerous times before...still does not work.

Thank you so much. It works.

Thanks alot for you help

See code below. When executing this below I get no resluts back, juts command executed successfully.

/* declare local variables used for fetch */

declare @email varchar(100)

declare @recno int

Set nocount on

/*declare the...

Hi Gail,

Thanks for the info. One more question though, I created the variables that goes into the fetch next.

declare @email varchar(100)

declare @recno int

After this was inserted, I'm only getting back...

Develop a SQLServer stored_procedure that runs everyday.

The Code must email a user if the request count is greater than 0.

Do you perhaps have a script that will update all the tables at once and not one by one

Thanks so much!!!