OK I think I understand, if your execution string isn't encrypted you can possibly tell but if it is you will not be able to my knowledge. Can you post...

OK I understand, when you scheduled your job did you have both or are you saying you are trying to schedule now?

How are/did you scheduling also? Can you post the...

Or try this so you are not convert between varchar and datetime at all.

SET @dtStopTime = dateadd(s,-1,dateadd(d,datediff(d,0,GETDATE()) + 1,0))

Not sure why it would be an issue thou. Might dig later.

Where did you save it to. Use Enterprise Manager and see. Usally is just local.

No no problem doing so as long as you have the hardware to support. I don't see any performane issues and would be aware of the security concerns as mentioned...

Yes, if you created Froeign Keys they have to have the CASCADE ON DELETE option turned on for you to get this to happen. If you don't have Foreign Keys...

Simply put there is no difference between interdb and intradb queries, the only issue is administration to assure a query with a join across databases will work without error.

We asked a guy once how the GRATER function works in SQL Server during an interview over the phone. He asked us what we meant and we said the cheese...

What is the goal of this SP fout of curiosity?

I don't have a copy here to check but I think it says 64-bit in the Help About screen of QA and EM (About Enterprise Manager in MMC).

Do all say Hello? If so why not just drop Hello? as you will now need to repeat the same thing for all 5 million rows unnessarily if that is...

I would do a technical design of the system and develope it out on paper first, cannot tell you which although there are bennefits of going straight to SQL 2005...

Place A textbox on the page with the visibility properties set to

=iif( Count(Fields!FieldName.Value, "DataSet") = 0,False,True)

When there are no records it will be visible, when there are it is hidden.

Not sure I can answer that without a lot more information about your application. If I had an option of 2005 over 2000 I would go 2005 for sure and...

You only need to tell it when not to use all (MAX DOP) if you find a query being affected negatively by parallel processing. Otherwise the Server will try to...