Create Roles with specific group names and assign schema, tables, views, store procs to those roles as needed access to.

--#### LOGINS,USERS,ROLES (LUR) SCRIPT ####

--#### SCRIPT TESTED IN SQL SERVER 2000,2005,2008 AND 2008R2####

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

-- CREATING A TEMP TABLE TO LOAD WITH DATABASE ROLES

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

That is an excellent post !

Could you attach a sample resume to the article as you described?

Thanks

Ther must be an open transaction that is filling your log, DBCC opentran.

use sp_who2

Sorry, Verified corruption on Litespeed Backups

But learned new thing that Lite speed backups will be shown as corrup[ted when checked with verify native backup.

If you dint fix your error.

Still you can get the activity monitor info

check this: Activity Monitor Script- Head Blocker[/url]

Works like charm !

Give the User

alter trace permissions

LOG

Logs the error in the error log and the application log for the instance of the Microsoft SQL Server Database Engine. Errors logged...

You give this script to them to execute and get the detailed infio they required

http://www.sqlservercentral.com/scripts/Head+Blocker/75366/

sql_novice_2007 (9/29/2011)

---

It shows 150 MB free space out of 3.1 GB. Can I create any free space on it?

In fact I ran into space issue. Thats why I wanted to...

Try executing to find and verify you...

Shrink it to release the unused space........

As views are not physical tables as they are just the query result sets from multiple tables they don't let you to make relationships.

Try making that view to indexed view...

Is you are the db owner ? or Sys admin ?

Another work aroundis here

1.

If you have to delete mdf and ldf , in first it has to...

Status of SPID,

Suspended- Waiting on some resources or thread or on another query to complete.

Use this query to find what it is waiting on along with wait_type.[/url]