Is it possible to move all the users(both windows and sql authnticated) from one database role to another using a script? In my case it would be from db_datareader to...

Thanks Steve.

Thanks Calvo.

Is it possible to rename a custom db role?

Ours is a datawarehousing environment. We always advice the users/teams not to do SELECT * unless needed.

We are going to let all the teams know in advance what we...

I'm little confused here because if I create a custom db role, I'm able to add an object under Securables but for db_datareader and db_datawriter, I'm not seeing Securables.

I...

Please correct me if I'm wrong--

I'll get an AD group created then I'll get the 3 service accounts added to the AD group. I'll give read permissions to this group...

I used the following filter to the trace to exclude the resource database, but it didn't work. Is some wrong with it?

set @intfilter = 32767

exec sp_trace_setfilter @TraceID, 3, 0, 1,...

Here it is:

declare @on bit

set @on = 1

exec sp_trace_setevent @TraceID, 114, 1, @on

exec sp_trace_setevent @TraceID, 114, 3, @on

exec sp_trace_setevent @TraceID, 114, 8, @on

exec sp_trace_setevent @TraceID, 114, 10, @on

exec sp_trace_setevent @TraceID,...

Thanks Gail.

I ran the following query, please look at the results. On Feb 28th, there were 2865738 records for resource database. So, this is the reason I'd like to apply...

No problem Lowell.

One last question:

Which one is correct?

exec sp_trace_setfilter @TraceID, 3, 0, 1, @intfilter

...

Thanks Lowell.

Please correct me if I'm wrong--Isn't 32767 the databaseid of resource database?

I think I found the solution but I'm not 100% sure. Could someone verify if the following filter can be applied to exclude resource db:

set @intfilter = 32767

exec sp_trace_setfilter @TraceID,...

Awesome!Thanks George. That answers my question.

I'll be migrating this database to a 2005 server.

Can I truncate the unused space and then take a backup because I think the backup will take more time since it's...

Thanks Jeffrey.

Looking at the Actual database growth values, this database has grown approximately 24GB in the last 6 months. So, can I predict that it might grow at the same...