I would recommend using an ORDER BY clause if you want your query to return the same TOP 1 each time it is run.  The only...

Is this a static query or was this generated by an application?  To answer your original question, yes, all you should need to do is change your dates.  Keep in mind...

Well, its hard to tell you if there is a way to change this in the query if we havn't seen the query.  Can you post your query and an...

This is probably not the answer that you want, but it sounds like you need more disk space.  If users are allowed to create and use temporary tables in a...

Unless you are a domain administrator in both domains, you can't do what you want.  The Domain Admin. must set up a trust relationship between both domains.  Are theses scheduled...

 John,

Try/Catch blocks in SQL Server 2005 are used for error trapping.  I have not seen any information relating them to blocking.  Can you post the link...

Well, where did you copy the .bak to?  The Windows account running your SQL Server service must have read access to the folder where you've placed the .bak file. 

I'm confused now, your latest post says that your SQL Server is using half of the CPU.  Is this correct?  If this is the case, adjusting  your Memory settings isn't...

To use fixed memory in SQL Server 2005, you need to set the minimum and maximum memory setting to be equal to each other.  It is recommended to allow SQL...

Well Will, I think I'm lost anyway.  Can you post your DDL for both tables as well as a bit of sample data for each table and your expected result. ...

When you say 'files', I assume that you are only referring to the backup file correct?  There is no need to 'attach' any files.  Can you clarify your last statement...

No, SQL Server does not have a split function.  That is why I told you to seach this site for it.  I could give you links to it, but there...

Look up RESTORE DATABASE in BOL and refer to the WITH MOVE clause.  This will allow you to use your backup file to create a new database.  Either that or...

Well, it looks like you've tripple posted.  Let's continue this in your Administration post:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=318400

The entire DTS module is also being re-written in SQL Server 2005 into SSIS.  Bulk Insert is part of DTS and will be included in the re-write.  Both Bulk Insert...