is it correct ?

SELECT * FROM tablename(nolock) where

startdate >= Getdate() -6

and enddate <= Getdate()

my script is working.

Thanks.

thanks Jeff!!

i need to find out the table names which are modified in last 24hrs.

Hi DB Experts,

Any sugessions here please .

Thanks in advance.

I got for dbo(db_owner).

ALTER AUTHORIZATION ON SCHEMA::[db_owner] TO [Role1]

Any help for below grant permissions.

View Definition

? Execute all Function

?...

Thanks Gila!!

Its fine now.

actual syntax error in below script part.

---Add role to user

DECLARE @command1 nvarchar(max)

SELECT @command1 = 'IF ''?'' NOT IN(''master'', ''model'', ''msdb'', ''tempdb'')

BEGIN USE ? EXEC sp_addrolemember 'SupportRole', 'SupportUser';

END'

EXEC...

yes, i tried removing 'GO' statements, still getting same syantax error.

I am facing some syntax errors.Any suggestions here pls.

Error : "Msg 102, Level 15, State 1, Line 21

Incorrect syntax near 'SupportRole'. ".

Below is the script .

--=================================================================

---Create role in all dbs

DECLARE...

i created below script, but i need to run this script in all dbs at once...

any suggessions here.

CREATE ROLE [SupportRole]

Go

GRANT EXECUTE ON SCHEMA ::dbo TO [SupportRole]

GRANT...

Actually I am struggling for a complete script

Need a script to create a new role in all databases to cover SP creation/execution, any table data manipulation (insert, update,...

thanks.

Sorry Erikur !!!

It is working as expected.

it returns 21 rows.