Is I:\ your mapped drive?

If so, did you map it under YOUR NT Logonid?

If so, SQL Agent wouldn't know that the drive mapping exists.  Determine what Logonid SQL Agent is...

Its most likely a permissions issue.  The account that SQL is running under doesn't have rights to your mapped drive.  If at all possible, backup your databases to a local...

You know, it sounds like you're dealing with a primary key.  Try this, replacing 'table_name' with the name of your table -

select s1.name from sysobjects s1

 join sysobjects s2

 on s1.parent_obj =...

Tested on my test server which was running MDAC 2.7, and received the SQLState messages.  Upgraded MDAC on that server to 2.8, tested again, still got 'em.

Steve

I've experienced this on many of my "utility" stored procedures.  It always shows up on output produced by print statements in a stored procedure, not in scripts. 

I've not tried...

A database can be backed up while in use.  no problem.

Steve

The sysindexes table will tell you which index # 1 is.

Steve

Put it into a stored procedure and give exec rights to the procedure.

Steve

I'm not sure about sysindexes, possibly the status column, but you'd have to decipher it.

You could load the output from sp_helpindex into a temporary table, and check the description column...

Go into Control Panel, Administrative Tools, Services, find the MSSQLSERVER service, right click, select properties, then you should be able to modify the startup parameters.

Steve

Have you tried changing it back?

Steve (not Jones)

This is what I use...

   if (select databaseproperty(@DB, 'istrunclog')) = '1'

    begin

    print '   * recovery model is SIMPLE. *'

    set @flag = @flag + 1

    end

    if (select databaseproperty(@DB, 'isbulkcopy')) = '1'

     begin

     print '   * recovery...

Sounds like permissions.  Verify that the security in your MSDE 2000 is set up identically to your 7.0 .  Is the 2000 on a separate machine from the 7.0? If so,...

SQL Server Agent is a service (SQLSERVERAGENT), so it can be changed within the services applet in Control Panel / Administrative Tools.  I'm not aware of a SQL command to...

Hey Doug,

Maybe breaking it out will make it easier to see...

(select min(foperno) from #temp t where t.fjobno = t1.fjobno and t.foperno > t1.foperno)

Steve