>>>> I am not seeing this behavior on my test system.

Really! That in itself is good to know.

>>>> What is the default schema for the user in that database?

"dbo". Maybe...

Thanks for the info. Another question: while I can GRANT permissions to a role using t-sql, where can I do the same under SSMS?

TIA,

Barkingdog

Good point!

Barkingdog

By SCOM do you mean Microsoft Systems Center Operations Manager?

Is there a document indicating what SCOM offers to the DBA?

TIA,

barkingdog

Ten Centuries,

You're comment got me thinking. I found that the databases for which the user did not explicitly have access had a database role (authorization "dbo") created for the client...

Our developer's claim they need to run a "ransaction" that updates two databases on two servers. So I think that linked servers are were not enough. We need a...

As TheSQLGuru wrote:

" I note however that configuring DTC properly can be a real b-tch! "

Seems to be the case but are there any alternatives if one needs a distributed...

I will investigate both tools.

Thanks for your help.

barkingdog

Thanks to everyone for you great replies!

Barkingdog

Ed,

That seems like a good idea to me. I'll use it.

Barkingdog

Kudos to everyone for good ideas. I'll try to roll my own, and if I come to my senses, I'll look at Idera.

Barkingdog

I did an experiment once on a modest size database. (Trans log about 500MB). I used the nightly maintenance plans to backup the database, rebuild all indexes, etc. I...

Heyyyyyyyy SSC Journeyman!

I agree with you totally. I am concerned that if all database access if done through a single sql account, the idea of database auditing is out of...

Lynn,

You are brilliant! I never though of adding it to the model database though I am no stranger to that database!. Duhhhhhhhhhhhh.

Thank you,

barkigndog

Very enjoyable video. The image quality and sound is more than good, the thoroughness of the presentation was also appreciated, and I can only hope for further videos on sql...