Database admin makes sure the data is accessible.
Database programmer accesses the data and provides it to others.

-SQLBill

To answer the question you asked....I have found that if I stop the DBCC SHRINKFILE before it ends, it doesn't do anything....I still have the same amount of free space...

One big issue with SA isn't just that they can access other databases and do things with them, they can also access/alter the 'externals'. Things like changing MAXDOP, granting xp_cmdshell,...

One rule of thumb I follow is:
If you want the user to be able to enter a value, include it as a required parameter, but supply a default in...

When you do CHECK CONSTRAINT, it means what it says....it has to check the constraint against all values.  So your entry violates the FK constraint and you need to check...

My understanding, and I'm sure someone will correct me if I'm wrong, is that the issue is you set the table back to CHECK CONSTRAINT. That causes the tables to...

Are you positive your query window is connected to the correct server/database?

I've had issues where I have connected to two or more different servers and when I open...

It's hard to help with so little information.  We don't know where your database is or how you are trying to connect.  So, based on what you did provide, I'd...

The only way I know of to run SSMS as a different user is:
Start>All Programs
Find the version of SSMS you want
Shift&Right Click on the SSMS option
That...