Please don't post polls for questions. Use Add Topic.

This is covered in books online. For general questions, please do some research.

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

Please don't write in all caps.

The above solution is how I'd do it as well

I'm curious why you need to do this? If you remove Bob from SalesAdmin in AD, then he's gone from access to SQL? Or are you adding Bob to SQL...

Drop them and rebuild them on the primary filegroup. ALTER INDEX and CREATE INDEX have options for specifying the filegroup.

You can use Profiler, probably the easiest way for large scale tracking of things. It will record all SQL run against the database (you can limit it by user/login).

Rather confusing, but I'd think the join process would either work, and use the new virtual name, or it will fail, and you'll need to rebuild the server.

Personally I'd probably...

Are you an admin? It sounds like a rights issue.

I have never seen SQL Server, in 17 years, delete objects. Someone did it.

If you have logs or log backups, download Log Rescue from Red gate and view them.

Did this fix things?

It's security related. You are not running the command, the SQL Server service is.

I would agree that not every table needs a Primary Key. Paul has given a great example, and if you do not need to enforce one, then you might not...

Thanks for the clarification and I'm with Barry. Do not do this as it is asking for issues.

If this were an extremely busy system and the were performance problems from...

Was the service account changed? I've seen that cause the issue.

Also check the system time on the server and other machines, including the DC. Differences can cause this.

I'd listen to Chris, but I might look to add multiple indexes on these tables. Look at the queries and see what they're using for their WHERE clauses.

Right click the server in SSMS and select Generate Script.