Thank you so much for the time you spent.

I just heard before is to avoid using Cursor, so now I understand in some way cursor is good for admin use.

The group is not in the AD though, now I think they use individual users instead of group is because each person in the group has different access to the...

Just to show how to filter... and how overly complicated it can be in ForEachDB >>

So do you mean Cursor in this case is easier?

Thanks

I missed a point, even I use windows group, when I add the group to the users to the Read_only databases, I still have to make it to not readonly,...

Yes, I think a windows group is a smart way.

But it seems these users have been already setup like that in the existing databases and they are passed by from...

Thanks!

I see we have a template in our repository, called something like storedproc.cst

We still need the tool even if we have already had the template, is that correct?

Thanks

Yes, thanks, I have never seen before using Case to compare table values, learn something new.

Sorry, I further look at the query I should make it exactly as it is:

It looks like it compares different tables

Select Cast(CASE bcd.BusCalItemID

WHEN bci.BusCalItemID THEN 0

ELSE 1

END as...

Move to adminstration forum.

http://www.sqlservercentral.com/Forums/Topic1152018-1550-1.aspx

Thanks

Have you ever done this successfully?

I'm interested to do that too? But Reporting service is really picky, so a lot of conerns

We found SQL server standard doesn't have two features we may need:

One is table partition, the other is backup compression.

I still need to evaluate the necessisty of doing this to...

So the best option may be do a side by side upgrade to a new server.

Even so I'm still interested if there is a documenation of upgrade in both cases.

Any...

SQL server 2008 standard

Can you explain a little in detail how I can be alerted by using default trace or using policy management when there is a new database created?

Thanks