The print result will appear in message window. I know it is not perfect.

Check http://www.sqldts.com and you will find the answer to your question.

You may try to add a 'print' statement.

USE mydatabase

SET NOCOUNT ON

GO

DECLARE @a INT, @b-2 INT

declare @eventdate varchar(6), @amount int

SET @a = 1

SET @b-2 = 0

WHILE @a < 3

BEGIN

SELECT @eventdate...

'Select' should be sufficient enough. You will see message that indicats you need 'create table' permission, just click next and go forward.

Edited by - allen_cui on 07/31/2003 11:43:19 AM

Have you tried to add one of developer's NT login to your SQL Server and grant proper permissions to see whether it works?

quote:

---

The sp_start_job is working correctly on both servers, because the jobs all start.

---

Does...

quote:

---

These logins are users in the db_datareader and db_backupoperator roles in databases that have nightly differential backups scheduled. We created these...

quote:

---

. A minor issue: Because I did not restore the databases in the same order that they were originally defined on...

The correct server name should be your machine name (SQLBOX) from sp_helpserver.

First, run sp_helpserver to see whether you still have server name 'SQLBOX_NEW'. After you rename machine name, you have to run following commands.

sp_dropserver 'SQLBOX_NEW'

go

sp_addserver 'SQLBOX', Local

go

quote:

---

I have a machine at work that has an instance of sql server named after the former developer, namely machinename\rrodriguez