Ok, Dom I got my problem resolved but I don't have a great explanation of how I fixed it. Send me some particulars of your problem and I'll try to...

Dom, I'm still working on this with my new friends at Microsoft. I will post back when I have an update.

As a FYI, before you go and try aspnet_regiis on anything other than a test server the postings at the link below. The command looks benin, but as usual, there...

Dom thanks for replying. After a little reading here

http://msdn.microsoft.com/en-us/library/ms143736.aspx

I still did not have success, so I decided to use one of my MS partner tickets. I was...

I'm working on this same problem too and I will try to update this post as I work this out. If you have found a solution since your last post,...

Dom, I too am getting the 401 unauthorized error. This is a permissions issue with IIS and I'm still working on the fix. Is your machine working now?

Joel, there is a lot of stuff to read in books online about locking. You should also read about transactions and transaction isolation levels. Once you do your homework you...

Vijay, another way to check dependencies is to script the database and use the find in files feature of Visual Studio. This also works with code that creates dynamic...

Thank you both for posting. Brandie, you confirmed what I was seeing. And Karl you showed me what I suspected all along, that there's some problem with aliasing my...

Brandie, this basically get me the result, that shows the member in the database role. I'll be darned why the IS_MEMBER() does not work.

SELECT DPR.NAME, DPR.Principal_id, Member.*, DPU.Name

FROM sys.database_principals...

It's a database role.

I've this does not work I'll write my own proc. Have you ever used sys.database_role_members? or any of the related tables.

Thanks again Brandie.

Thanks Brandie, but it just does not seem to work with my own roles. It works fine with db_owner, but my roles always show FALSE.

Try this with your...

you can always create a SQL agent job to count the actual rows the night before and store them in your own tables. Then you can have multiple rows in...

Thanks Phil that was very helpful. I've also found the site below is helpful too. It has an easy to understand guide for using performance monitor.

Derkin, I've been in...

To find out more about CRCs and corrupted databases this is a good place to start

http://www.sqlskills.com/blogs/paul/default,month,2008-07.aspx

Best of luck

D