A non-admin user's default database should not be master. Set the database that the login uses most frequently as the default.

Other thing to check is the connection string that the...

From object explorer, expand out security and logins, find the login ohk\jeva, right click, select properties, go to User Mapping

Make sure that the login is mapped to the DBs that...

How do those pageIDs link up with the ones you posted in your initial post?

It looks like ''abs_tr'' is the default database for that login. Is that correct? Is it the DB you gave them data reader and data writer in?

Minimum permissions needed to access the server is CONNECT on the server. I think you get that by default on any login, though it can be revoked.

Change the user's default...

Can you give an example of the output you want please?

There's no tool in existance that can rewrite a query in the most optimal way, or list the 'correct' indexes for a table. That's why skilled DBAs are still needed.

Profiler...

You'll have to query every table. There's no place where all data from all columns is stored, or anything like that.

You can use the system tables/information views to build up...

Stats updates get triggered on a read. The updates just set the row mod. When a query is run against a table, the rowmodcnt is checked and, if necessary a...

There's nothing you can really do to protect the server against the admins of that server. They have full control over the servers and possibly even the domain. Stealing your...

Do you want to prevent people from attaching data files, or from copying data files off the machine?

For the first, don't give db_creator rights to anyone. Sysadmins can do in,...

I did a quick check earlier. I couldn't see anything different with profiler, and the times were the same. I just don't know of any way to check system table...

Yup. The indexes won't get fragmented during an upgrade. The stats need updating because SQL 2005 keeps more detailed stats than SQL 2000 did. The 2005 optimiser can use the...

I'm going to reply to your PM here. A private message won't help anyone else, and also means that I'm the only one who can reply. There are lots of...

Easiest way is to use a cursor. For each item found, call sp_helptext.

Set the output in management studio to text, then you can save the whole lot as a file

SET...