If this does not work then have her step thru and debug her code to see if it fails at the same place each time. If so then she may...

You can detach and attach thru EM by right click the database and do task, detach then when moved right click database folder and do task attach, there you can...

There are a lot of applications out there and I have tried a few but I generally stick to QA. However is there any specific functionality you are looking for?

Also...

You are not using dynamic SQL are you? That will always be the issue if you do.

Otherwise can you post the ddl of the table and SP to see if...

It is a bad idea to have the test and dev DB on the same box. SQL prioritizes the memory of objects based on usage which you canot change.

"Don't roll...

Without the entire message I can only look at the error number. Check out http://search.support.microsoft.com/search/default.aspx?Catalog=LCID%3D1033%26CDID%3DEN-US-KB%26PRODLISTSRC%3DON&Product=sql&Query=80004005&Queryc=80004005&withinResults=false&srchstep=0&KeywordType=ALL&Titles=false&numDays=&maxResults=25 and see if any of these fit your problem. Otherwise please post the entire error...

DCOM causes us some strange problems as well so I really cannot tell you for sure. We have even had objects we removed processes from still run those processes until...

Well, the solution is all that matters.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

You cannot do this with SELECT TOP x but try you can use SET ROWCOUNT to get the same result. See BOL for more details.

Ex.

DECLARE @ret int

SET @ret = 10

SET...

Like I said in previous postings we generally only move the data into filegroups for specific reasons. 1 is that the data is static in some tables and not in...

This should be the same as what you are doing now.

SELECT

user_id

FROM

my_intersect

WHERE

thing_id IN (1, 2, 3)

GROUP BY user_id

Not sure you need the group by unless you have...

When you say the regional settings are identical do you mean for Windows or SQL? SQL Has a language setting as well that handles the format internal. Try ths follwoing...

I know of no way to restrict the size of the import as there is no governor for that ability.

"Don't roll your eyes at me. I will tape them in...

In regards to what?

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Great article Brian pointed out there and may help you prove/disporve your fears.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)