If what you want to do is set up a variable workflow where your ActiveX script determines if you execute one leg of the workflow vs. the other then you've...

If the application is VB you can load the package and manipulate the properties of the Copy SQL Objects task. I'd set the task up originally to copy all the...

Why not use the DTS "Copy SQL Objects" function and specify only the Stored Procedures? Saves writing a lot of code.

The current registry information is corrupt or not being recognized. The best thing to do is:

1. Delete all the registrations in EM. Delete all the Server Groups.
2. Delete all the data values...

I can't help you prevent the problem, but one way to easily correct it when it happens is to Export the registry key to a .REG file, and when your...

Thanks. I'll give that a shot.

Did the file come from a non-Windows platform? If it came from Windows the row delimiter should be CRLF, if non-Windows (particularly Unix) it is most likely CR. You can...

Yes, we moved the indexes. The database was moved using backup/restore. All the indexes, etc are in place. I did notice a fair amount of fragmentation so I'm thinking I'll...

Also, "Professional SQL Server 2000 DTS" by Chaffin, Knight and Robinson $34.99 on Amazon.com. This gets into a lot more detail than MSDN.

If you're looking to group them by hour (as it seems based on convert(varchar(8), trandate, 108) BETWEEN '09:00:00' AND '09:59:59' ), why not this:

Select * from transactions where tran_date between...

There's a writeup at Microsoft: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_adda_8gqa.asp on administering Linked Servers. The examples include setup of and querying a File System using the Indexing Service.

Note: I haven't been able to...

How did you delete it and recreate it? The method you used may be important to understanding why it didn't work.

I usually will use the option to script an SP...

Let me start off by saying that I don't have a week or so to read the MS EULA, so I don't know the fine print.

That having been said I...

"OLS" is a named range so I think I specified it correctly. I was wondering how to just specify a worksheet name.

I found the following KB references to my error...

I'd love to, but I don't have SA access to the SQL Server. I'm a SQL developer. The SQL SA's are in a different division.

Besides, what good is the whole...