Google "Parameter Sniffing" - I ran into this issue on a large, custom import process. Straight SQL from QA ran in about 45 minutes; calling the same SQL via...

Thankfully, SP2 (perhaps SP1 as well) has a host of reports that mimic the old TaskPad (which I used extensively).  Just right-click on the database name, select 'Reports' --> Standard Reports. ...

John:

Make sure that your server is in mixed mode.  If it is set up to only go with Windows authentication you'll receive this error.

Optionally, you can just replace the -U...

Not to be contrary, but we keep them on our production servers in the event we'd need emergency space at some point down the road.  Although it's not much it...

Thanks, Martin.  I was thinking along those lines but wasn't able to find anything out there.  Much appreciated sir, I'll try that!

MM

DECLARE

 @NumberToModify NUMERIC(19,5)

SET @NumberToModify = 10

--Use your field name instead of @NumberToModify

SELECT REPLICATE('0',5-(LEN(@NumberToModify)-6))+CONVERT(VARCHAR(24),@NumberToModify)

HTH:

Mark

I think you're going to need to use a function:

CREATE FUNCTION dbo.udf_ReturnEmployeeRecordByID(

 @EmployeeID VARCHAR(12)

&nbsp

RETURNS @EMPLOYEE_ID TABLE(

 EMPLOYEE_ID VARCHAR(12),

 EMPLOYEE_NAME VARCHAR(100)

&nbsp

AS

BEGIN

INSERT INTO...

qbn is definitely correct - it shouldn't make a difference what the id value is.  That being said, if you're refreshing the entire data set (e.g. remove all rows and...