Peter's response was just on my time conversion. So in my solution you can use style 108 instead of 114.

eg:

select convert(varchar(8), dateadd(second,@sec,0), 108) as WithHour

select right(convert(varchar(8), dateadd(second,@sec,0), 108), 5) as...

Actually to be precise { and } are braces, [ and ] are brackets and ( and ) are parentheses.

Ah yes forgot about style 108, thanks Peter.

Chuck

Here are a few DTS articles that will hopefully bring you up to speed.

http://en.wikipedia.org/wiki/Data_Transformation_Services

http://www.sqlservercentral.com/columnists/rNageshwara/overviewofdtspackages.asp

http://www.devguru.com/features/tutorials/DTS/DTS1.html

Try this

declare @sec smallint

set @sec = 133

select convert(varchar(8), dateadd(second,@sec,0), 114) as WithHour

select right(convert(varchar(8), dateadd(second,@sec,0), 114), 5) as WithoutHour

The LoadFromSQLServer method loads a DTS packages that resides in SQL Server into memory.

You will need the address of the SQL Server. I'd check that the package exists on the...

As you're loading from SQL Server, shouldn't the ip address be for your SQL Server not...

Try the INFORMATION_SCHEMA views.

Have you tried using pull subscriptions?

Terrence,

Outlook / SQL integration works well until a) the permissions for the account changes and SQL can no longer access the mailbox, b) Exchange admins reboot their server and...

Check the queries that are at the head of the blocking chain. As I mentioned in my other post, without effective indexes the queries will read, and therefore place a...

So how does this IO compare against your databases?

Markus, I recall something along those lines as well. From memory, it was something like allocating specific threads to a cpu, but I think this was after the thread had...

Have you thought about/tried a non-clustered index covering all of the fields in the where clause?

Since you say the stored procedures use temp tables a lot, I'd also look at putting the tempdb data and tempdb log on seperate physical drives (that's two drives).

I'd also...