Check the group membership of any groups that have been added to the Administrators or Users groups on the server. There is probably a group that this person belongs...

Unfortunately, that functionality still exists in SSMS but I caution against using it at all. It is rather buggy and can actually update data incorrectly.

Work on understanding insert, update...

Yes - sort of. The task will generate ALTER INDEX statements for each index selected for rebuild. ALTER INDEX replaces DBREINDEX...

When an index is rebuilt - the statistics...

Yes - it will roll back the transaction that was in process when you cancelled the insert.

Just noticed that the database is read only - so, first thing you need to do is get the database out of read only mode, then you can drop it.

ALTER...

Have you tried setting the database into single user or offline, then dropping it?

ALTER DATABASE {yourdatabasehere} SET SINGLE_USER WITH ROLLBACK IMMEDIATE;

GO

DROP DATABASE {yourdatabasehere};

GO

Or - Offline:

ALTER DATABASE {yourdatabasehere} SET OFFLINE WITH...

When you restore a database from another system, the following things happen:

1) the owner is set to the user that is running the restore

a) this is why your coworker is...

To get it to work that way, you have to install Enterprise version and build a scale-out deployment. You cannot setup multiple web servers accessing and using a single...

Truncate...

Poorly written query performing multiple cross-joins?

Instead of using a view - create a stored procedure and use EXECUTE AS on the procedure.

Tara-1044200 (2/3/2010)

---

I am not looking for any 3rd party tool and i dont have any intention to buy, just want to do this using existing sql tools as this is...

Have you looked at using EXECUTE AS so the procedure runs in the context of a privileged user?

By giving that access, anyone who know the web sites username/password now has access to all of the data in your internal apps database.

If there is any chance that you...

Just note that if you decide to separate out the web portion from the database, you need to purchase additional license for the web portion. It is only free...