use master;
go
create database db1;
create database db2;

Using SQL Server 2005 Standard Ed. SP2.
I created a sql auth login and gave it the server scope permission 'view any
definition'.  I log on as that user and try accessing the sys.objects
cataloged view for each of the DBs on the server.  Some databases it works

I have a small app that is sometimes deployed in small offices that just use
workgroup networking ie no domain.  The SQL Server Express runs on a 'main
pc' - XP or Vista, so there is not a lot of external security. The backups
are done to a folder and then backed up to tape or cd ...

I need to be able to disable a trigger in an SP whilst I perform an update
and then re-enable it, but the trigger is on a table on a Linked Server.
What permissions will need to be on the remote database to allow DISABLE
TRIGGER?

I have a x64 SQL Instance and i suddenly started getting proxy account job
failures letting me know that the account is denied access.  Upon researching
and reviewing  i was able to access the directory where the ETL data is
stored with the proxy account however SQL Agent jobs ...

We use sql2005. We have a script auditing tool that needs access to view the
definition of sys.syscomments. To enable the permission, I ran the statements
listed below but it still got denied.
use master

Can anyone advise me on what to do here. We have Great Plains resellers on
site at the moment who are installing Great Plains who are insisting that
they use the SA user and password in the client ODBC connections for staff
(it's even in their setup documentation). I'm pretty ...

Hello, currently our SQL Server 2005 has only Windows Authentication mode
configured (not Mixed mode) in Management Studio.  When running Profiler how
come the 'sa' account gets displayed listing activity?...isn't this account
disabled when Mixed mode is disabled?  Thanks in ...

I'm hitting the following error when my web service API tries to call
a SS PROC.  It's working fine from another web service (production
service set up on another box) but i cannot get this web service set
up properly somehow.  It's to serve as development / staging web

I'm looking for a T-SQL script that allows me loop through all members of
an existing database role and copy each member into another database  role
of the same database.
Can anyone help with a sample code?

Our client has asked us a good question:
We need to add security to our sql server management tools in our cliente
servers. All of them share the same password for the user 'sa'. Also, all the
applications in production use 'sa' in their connection strings. The password

Production - QA - Development
If the linked servers are setup and there is an sa account located in DEV,
then the sa of dev should  ???? not ???? have rights on Production except
those listed under the "be made using this security context".