Yes, this is possible using the runas.exe.

In a command shell window, run the below and replace aausa\carl.federl with the appropriate domain login.

runas /user:aausa\carl.federl isqlw.exe

Regarding "we would like to use a...

In order to drop a table in a database, the login must have one of these privileges

1. Server level System Administrator role.

2. Database db_owner role

3. Database ddl_admin...

Is the vendor app using any of extended stored procedures especially the Object Automation procedures ? These xps begin with sp_OA%.

There are many problem with the Object Automation procedures including:

1....

Doesn't t1.id1 *= t2.id2 translate to a RIGHT OUTER JOIN ?

t2.id2 =* t1.id1 (reversing the condition columns and outer join), should translate to a LEFT OUTER JOIN.

For clarity, I have...

I have eliminated everything that is not relevant to simplify the problem. See the tables and data and the end of this message.

Based on the generated date, the expected...

For working the the trace, below are SQL statements to summarize Stored Procedure Executions and Select statement. You will need to change the trace table name as needed.

I usually look...

The documentation on the EventClass numbers to descriptions is well hidden in Books OnLine and at http://www.microsoft.com. Below is the SQL to create a table with all of the EventClasses...

The permissions to manage DTS Packages should have already been granted to public (i.e. everyone). To confirm, run

exec msdb.dbo.sp_helprotect @username = 'public'

The output should include execute rights for...

No, deadlock information cannot be detected by applying the transactions logs after a restore because only successfull events are written to the log and unsuccesfull events are not written to...

Is the SQL in a stored procedure ?

There are some alternatives:

1. Pass the part numbers as a single string as either fixed positions or delimited. See http://www.sommarskog.se/arrays-in-sql.html for how to...

There are extended stored procedures that allow processing of in-bound emails messages BUT you must be using Exchange and the Exchange Server must be in the same domain as the...

If this is a hierarchy, see oracle's proprietary "connect by".

Since the stored procedure is not being passed the date format, there is no way to determine how to convert.

For example, if being passed '2005/10/12', is this the 10th day...

Please post the update statements.

Without using a case, this is the only alternative that comes to mind:

Create table #C

(StudentID, OldChoice , NewChoice)

insert into #c

(StudentID, OldChoice , NewChoice)

select 1111 , 'Music',...

This is not correct as shown below.

From SQL Server Books OnLine regarding GO:

Your program should behave in the same manner as the utilities. When a GO is found, the...