Hi,

I came across undocumented system stored procedure sp_MSForEachTable.

Try this to delete all data from all tables in a given database.

Please Test it.

EXEC sp_MSForEachTable ‘ALTER TABLE ? NOCHECK CONSTRAINT ALL’

EXEC...

Hi,

Along with the permissions, please check if you have any filter settings and remove them.

Right Click Tables -> Filter -> Remove Filter.

Thanks

Prem

Hi ,

Please check if you are opening an explicit transaction (i.e Begin Tran ) from the application.

If for some reason before committing the transaction if there are errors encountered, how...

Hi

Please try this for scripting out the object permissions in a database.

SELECT

CASE WHEN perm.state != 'W' THEN perm.state_desc ELSE 'GRANT' END + SPACE(1) +

perm.permission_name + SPACE(1) + 'ON...

Hi,

You can change the execution context of Stored Procedure using EXECUTE AS clause while creating Stored Procedures.

Different options available are { CALLER | SELF | OWNER | 'user_name'...

Mike,

Thanks for your Wonderful article on SQL Server Encryption.

Please give me your inputs for the following scenario.

We have log shipping set up between server A and Server B. Server...

Check this out.

--Role Memberships'

SELECT --rm.role_principal_id,

'EXEC sp_addrolemember @rolename ='

+ SPACE(1) + QUOTENAME(USER_NAME(rm.role_principal_id), '''')

+ ', @membername =' + SPACE(1) + QUOTENAME(USER_NAME(rm.member_principal_id), '''') AS '--Role Memberships'

FROMsys.database_role_members AS rm

ORDER BY rm.role_principal_id

--Object...