100 roles! Yikes. I've never had that many, but I suspect it's some type of bug.

I'd learn the T-SQL and just script it.

Did you set the test server to allow SQL logins? Server | Properties | security tab

The best way is to monitor the services. There are lots of app out there (NetIQ, BMC, ServerAlive).

not sure what is needed in EM. Perhaps sysjobhistory has the status while it is running. You could try select access on that.

We have chosen not to show them after you have answered them. It costs us to produce the questions and display them on the site and our intention is to...

You see the answer right after you complete it. We have compiled 100 of our questions into the Two Minute SQL Server Stumpers - Vol. 1 with some editing and...

We started work on this, it didn't work as well as we liked, and so far haven't finished. We'll talk about it and see.

The forumid was never in the newsletters until Tuesday of this week. We made a change on Thur that somehow broke the shwmessage page even though we didn't touch that...

Roles prevent this whole issue. You might find a script here on the site to help with this.

It shouldn't be a danger, although I'm not sure it will stop before it finishes the task it's on. It might rollback it's changes if you stop it, but it...

Not an Access guy here, but it's a related question to SQL Server. Lots of people use Access out there and swear by it. I'm not in that camp, but...

There are other ways outside of SQL Server, but Phil's method is the best (IMHO)

Read the outline from MS and then search on those topics (hopefully here ) and study each area. We have a book for sale,...

If you were already running profiler, you could sort through the transactions, btu you'd have to know if implicit transactions were on for any connections, group up connection traces, etc.

Lumigent,...

Actually, that was the point that I got when I ran it. Because an answer said "error and date" I remembered to check both tabs. It's worth you knowing this...