Why are you trying to restrict another DBA, just out of curiosity?

What you see in Object Explorer, is actually a connection to the server using your local machine credentials, not any SA credentials. When you click on the server in...

http://www.microsoft.com/sqlserver/2008/en/us/trial-software.aspx?info=EXLINK

What account is SQL Agent running under? Is it the same domain account as the SQL Server?

Have you had a look here? http://support.microsoft.com/kb/315886

or here? http://support.microsoft.com/?id=263556

Keep in mind that...

This may help:

http://support.microsoft.com/kb/327489

You can not backup TempDB, and you should try to steer clear from auto-shrink. It is much better to size your databases accordingly from the start to allow you...

If the account you are using in Object Explorer (this is your local Windows account) is a local administrator on the server in question (either explicitly, or through an group),...

Changing the password in the connection string not an option then? A new app password never hurt anyone 😉

Please elaborate on what connection problems...

Just a guess, since I don't have an app ready to test this with, but sounds like the SQL login has "Enforce Password Policy" and "User must change password at...

Recommend you read up on this in Books Online (take note of the warning that this feature will be removed in future versions):

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

Have you tried the trusty "Script action to new query window"?

If you could post more of the code, it will help.

This is not mine, but here ya go anyway.

SET QUOTED_IDENTIFIER OFF

GO

SET ANSI_NULLS OFF

GO

ALTER PROCEDURE sp_diskspace

/*** Borrowed from SQL Stripes Disk Size Stored Procedure ***/

AS

SET NOCOUNT...

You can see if these tips help:

1. Enable ad hoc distributed queries, by running:

EXEC sp_configure 'show advanced options', 1

EXEC sp_configure 'ad hoc distributed queries', 1

RECONFIGURE

2. Allow ad-hoc access to the...