Also, take a look at the ASP.NET Enterprise Manager at SourceForge.

http://sourceforge.net/projects/asp-ent-man/

Hope this helps

Phill Carter

--------------------

Colt 45 - the original point and click interface

Thanks for that, I'll check if he has ORDER BY in the view.

Hope this helps

Phill Carter

--------------------

Colt 45 - the original point and click interface

It's only for this one view. There are about 12 other views in the database and none of them have TOP 100 PERCENT.

It's not causing any problems, just wanting to...

I'd love to be able to just shell out the money and go. Every time a conference comes around I just cringe at all the really cool stuff that's being...

I think the global variable passing is only one way.

You'll be able to interrogate the child package and retrieve the values in the global variables if you defined them...

Check the options on the copy tab of the Copy Objects task. If you have 'Include all dependant objects' checked, then the task will drop and re-create the tables that...

The script is attached to the workflow properties. So it executes before the Datapump task. You use the DTSStepScriptResult_ExecuteTask or DTSStepScriptResult_DontExecuteTask constants to execute or skip the task.

Here's an MSDN...

I'd like to see PASS host a conference in the southern hemisphere once in a while. Then it might be more affordable to attend because I'm not shelling out for...

You could capture the output of the last_updated_time in a global variable, then have a short ActiveX Script on the workflow properties of the datapump task to determine if it...

If you're using SQL 2000 and have package logging enabled, you can query the sysdtspackagelog/sysdtssteplog/sysdtstasklog tables in the msdb database.

Hope this helps

Phill Carter

--------------------

Colt 45 - the original point and click...

SQL Server Dataserver is an additional product, which of course you have to purchase

Take a look at

http://www.progress.com/v9/datasheets/dataservers.htm

Hope this helps

Phill Carter

--------------------

Colt 45 - the original point and...

Presuming that you do the "IF last_updated_time < ..." in an ActiveX Script step, then all you need to do is set the appropriate execution status.

Have a look at DTSTaskExecResult...

Unfortunately we've just wasted three months trying to tie down things at the other end. Let's just say that negotiations were not very fruitful

Hope this helps

Phill...

The first, very easy step, is to move the packages themselves. I recommend a tool called DTSBackup 2000, it can be found at

http://www.sqldts.com/default.aspx?272

Also, have read of this short article,

http://www.sqldts.com/default.aspx?204

What...

Check the SQL Server Logs to see what is happening when you are opening the database. If you see a lot of messages saying "Starting up database XYZ" then the...