You can create a database snapshot to access your mirrored database.

Paul

Adam, like you I have tried those same things but w/o much success.

Normally, what usually happens is that the SP works fine for a while and suddenly it stops working...

Try this little trick to see if it works for you (all changes/additions in bold):

CREATE PROCEDURE dbo.usp_get_untranslated_prompts_for_export

@Label_ID int

AS

DECLARE @LabelID int

SELECT @LabelID = @Label_ID

/* Rest of you code goes here...

Joseph, my earlier post may have confused you a little here. Basically, there are two options with respect to using files and filegroups:

1. Have one filegroup with several files, each appropriately sized....

For sure! You wouldn't be able to deploy a SSIS package on SS2000, but for your purpose you don't need to. All you need is to use the 'SSIS Import...

If you are encountering time-out or memory issues with bcp you can try the -b switch, which will commit the data in smaller batches. Otherwise, write your scripts to import...

Interesting file names! Basically, the 3rd party supplier did not follow the naming convention for database files.

However, when I tried this on SQL Server 2005, it appears to work fine!...

I've not had any issues with SP2, but it really depends on what's in SP2 that is critical in your particular situation. I believe there is an article here in SQLServerCentral.com...

I should qualify my previous post by saying that if you have been performing detach/attach without performing regular database integrity checks and making regular backup of your database, then using detach/attach...

I would try and avoid using detach/attach if at all possible, and especially with a live database. This is because database corruption may prevent you from re-attaching the database, which I...

You may need to reinstall SQL Server on your desktop - possible case of file corruption. If you were to go down this path, you need to think about cleaning...

It depends on the initial size of the log file that was created. Please follow this thread that discuss a similar issue to yours: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=140748

Paul

Not a problem. I have put together this example for you to study at your leisure:

DECLARE @xVar XML

SET @xVar =

  '<book genre="security" publicationdate="2002" ISBN="0-7356-1588-2">

   <title>Writing Secure Code</title>

   <author>

      <first-name>Michael</first-name>

     ...

Can you test with CTE and see whether that works?

You may find this KB article of interest: http://support.microsoft.com/kb/903643

To summarise it states that the NTBACKUP process may break the 'differential backup' chain; however, since you do not perform diff...