Do it using pivot option that is available. it sure gives a solution to your req.

try using sp_fkey 'tablename'. this should give u info on foregin key imposed in a table.

check in the error log was was the last status before the service restart.

Thisi ssurely a permission problem. u can see that u can't login to the server. check for the permissions starting the agent service. also check if the account has accesss...

try using database mail instead of sql mail. database mail is easy to use ad configure.

not sure if this can be done. try with fnvirtualstats table.

Check the permission for the account starting the service. check for registry, folder and other windows permissions.

What is the error that you are getting while stating the agent service. did u look at the eventviewer and the log files.

Did u check for any errors in the event viewer. Its hard disk problem only also check for the disk space in the drive. start to monitor the disk i/o.

No. Its for sure to affect that database performance during production times.

check if u can use the script below.

http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=1598

To the max avoid giving permissions for master database to users.

You wanted to install SSMS. first checkif you have .Net framework 2 installed. Also check for MDAC 2.8 as it will be very useful.

Bring the database to single user mode then fire your alter statement that should work....

Lots of reason to say for this message. But did u check for any erros in event vwr or the log file of sql related services to find what exactly...