From a command prompt you should be able to execute winzip /? and see the command line switches you can use to suppress the Y|N.  Also you can probably go...

Have you tried attaching the database through EM?

Have you tried relinking the items (Not sure if possible with the sp's)?

RAISEERROR ?  Shouldn't this be RAISERROR??

IMHO...

Option A provides you with the ability to control the data access and avoid rogue processes and runaways that could potentially crash your server

Option B would allow people with no...

In addition to asking questions here I have some handy books that I like to use

MS Press:  Inside SQL Server 2000

Sybex: Mastering SQL Server 2000

Osborne:  SQL Server 2000 The Complete...

I have received this message in the past.  The only thing that I have done is shut down QA and re-open it.  The query then executes fine.  Another thing to...

I think it is non-clustered and then clustered.  I honestly get confused on this one too though.

Why not dynamically change the datapump parameters/settings based on the global variable?  This way you don't have multiple branches but 1 dynamic properties set.

SELECT CAST(123 AS VARCHAR(100)) + CAST(456 AS VARCHAR(100))

We just went through this and the short answer is no.  You have to reboot the server.  We had MS come on-site to help us and they were only able...

another way of ensuring that only the latest version is ever used is to save as a Structure File on the hard drive and when you update the package save...

CONVERT(VARCHAR(5), GETDATE(), 108) = HH:MM  I think this should work for you

WHERE DateField >= CONVERT(VARCHAR(10), GETDATE(), 101)

Have you tried CDbl([Field1]) = CDbl([Field2])?