Our recovery mode is full because we need point in time recovery on our production dBs. Could you show me a sample of you reindexing script?

I just got done installing the Sybase client software and setting up a DTS package and it seems to be working. Thanks everybody for the heads up.

That is the problem. thanks for all the help

This is is a VB.NET & ASP.NET application. I used the code you supplied to copy a stored procedure from one server to another with in a ActiveX Script in...

This is being done within an application and I know I can kick off a DTS package using stored procedures but my problem lies in I don't always want to...

You guys are great. By extending the date out to '8/31/2003 23:59:59' in worked fine.

Thanks a lot.

Arthur Lorenzini

Thanks. Basically, what I hear is…. Don’t use cursors and find another way with set-based SQL.

So… many of my triggers have cursors. Now I know I must rewrite them...

Regarding the second question. What I mean is, if there are different types of multi-row transations, how are they handled differently? Different types imply a table with a key vs....

Why does this not work:

SELECT INTO tblFileStats

EXEC ('sp_spaceused')

I keep geeting a sysntax error in 6.5

Arthur Lorenzini

I need this in a recordset so I can do some reporting. Could you advise me how I can take the commands that you have suggested and create a recordset.

Arthur...

I need this in a recordset so I can do some reporting. Could you advise me how I can take the commands that you have suggested and create a recordset.

Arthur...