Kyle,

if the stored procedures are in the database the database level permission EXECUTE should do the trick.

DENY EXECUTE TO PUBLIC

In case it has permissions to execute any stored procedures that...

You may be able to achieve a single row result with a case statement too. If you post your problem with a bit more details it will make it easier...

This is for the crash reporting utility of Microsoft. It is called "Watson" if I remember it right.

Regards,

Andras

Hi Kyle,

Cross-Database Ownership chaining is relevant to SQL Server 2000.

I'm not sure how you could query it in your scripts on 2000 though. You can find out if it is...

on http://vyaskn.tripod.com/passing_arrays_to_stored_procedures.htm there is a comprehensive article that describes the various ways to pass lists to stored procedures.

Regards,

Andras

DECLARE @managerIDs TABLE ( managerID INT )

DECLARE @managerEmps TABLE

( managerID INT

, empID INT

)

INSERT INTO @managerIDs

VALUES (...

Do you have a newline after the last line of your datafile? If so, remove it.

Regards,

Andras

Hi Kyle,

you can get this from

SELECT value_in_use FROM sys.configurations
WHERE name='cross db ownership chaining' 

Regards,

Andras

You can create a stored procedure with "execute as 'dbo'" like:

CREATE PROCEDURE foo2
    WITH EXECUTE AS 'dbo'
AS 
    SELECT  *
   ...

Have you installed the Debugging Components on the remote server.?

http://msdn2.microsoft.com/en-us/library/s0fk6z6e(VS.80).aspx

Regards,

Andras

On SQL Server 2000 use:

select * from syslogins

select * from sysusers

Note that the password policy is not relevant to 2000.

Regards,

Andras

for the SQL Server you need:

sp_dropserver 'OldServerName'

GO

sp_addserver 'NewServerName','local'

GO

Andras

I do not think that you can create four database users in the same database for the same login.

Regards,

Andras

select * from sys.database_principals

select * from sys.sql_logins

Regards,

Andras

You can publish your SQL Server and its databases in an active directory. This is not required, and is useful primarily if you write applications that pick a database dynamically...