Can you shed some light on what you did or what fixed it?

Administrator shouldn't matter, it's the accounts that are set up in SQL Server. Likely the local administrator's group is set up as a login in SQL.

Ouch, do you at least buy the donuts?

Are the tools installed? Which edition of SQL Server 2005 did you install? There is no "full". There's Enterprise, Standard, Workgroup, Express, Developer.

I'm also not familiar with user provisioning. Are...

If someone has administrative control of the instance, there's nothing you can do. People will be able to access the data and stored procs. There's no way to stop them.

So...

I don't think I met Mangal up there.

Note that the MVP award is for community contribution, not technical knowledge. You are expected to answer questions, and give good answers, but...

A fix for this to make it more visible in the newsletter and front page should be in next week.

I bet there are plenty of 2000 instances in 3-5 years.

do you mean MDF?

You can give it a new name in RSETORE as well.

I'll give you a few hints here. The explanation above is correct.

Look at charindex/patindex to find the "marla" in your string. http://www.sqlservercentral.com/articles/Advanced+Querying/tamestrings2.asp/97/

Then use substring to grab the part before that...

I'm slightly amazed that you would compare TSQL to C and the IDL. I suppose it's possible, but SQL is a query language, designed for working with data, and sets...

Tom Sawyer, he he he :hehe:

http://www.sqlskills.com/BLOGS/PAUL/post/Conference-corruption-demo-scripts-and-example-corrupt-databases.aspx

http://www.sqlskills.com/BLOGS/PAUL/post/TechEd-Demo-Creating-detaching-re-attaching-and-fixing-a-suspect-database.aspx

Not sure you can do anything about the system adminstrator outside encryption, and you'll take a performance hit here.

If you setup DDL triggers, you can look for the application name,...

Delete one row.

SET ROWCOUNT 1

DELETE FROM Users

WHERE Username like 'KO%'

SET ROWCOUNT 0

Or you can select from the data and find a specific row to delete.

Trace what happens, get...