help me to resolve in sql 2005

Microsoft SQL Server 2005 - 9.00.4060.00 (X64)

iam working on SQl 2005 enterprise .

@mich

CREATE TABLE #DBROLES

(

DBName SYSNAME NOT NULL ,

UserName SYSNAME NOT NULL ,

...

thanks mich and chris , i tried by amending the variables but got the error

mich i executed the script which u paste but got errot in the

CREATE...

thanks for the replies can pls resend the script by modifing

sorry can you pls modify the script

can you please provide the syntax for this ?

i have sysadmin permissions on the server , incase if it is not worked can you pls provide the script to get the mentioned data as per the above i.e...

its getting error when creating the table

CREATE TABLE [TEMPDB].[DBO].[DB_ROLES]

getting error

Msg 2702, Level 16, State 2, Line 1

Database 'TEMPDB' does not exist.

--#### LOGINS,USERS,ROLES (LUR) SCRIPT #### --#### SCRIPT TESTED IN SQL SERVER 2000,2005,2008 AND 2008R2####

SET ANSI_NULLS ON

GO ...

but the user is not edit or modify the job steps even though he is having permissions in msdb..sqlagent operator role.

what is the reason ? how to solve...

Hi,

its not the db mail i wanted to add\update a value in view

thanks for the reply can u pls provide the link how to do .

Appreciate your help.

thanks pls let me know the details to implement .