More specifically you have to do this to the variable on the VB side.

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

Here is all I did.

CREATE TABLE [PO] (

[UID] [int] IDENTITY (1, 1) NOT NULL ,

[PO] [int] NULL ,

[Vender_ID] [nvarchar] (30) NULL ,

CONSTRAINT [PK_PO] PRIMARY KEY CLUSTERED

(

[UID]

) ON [PRIMARY]...

First do you know which line is failing? Try this change

var = CStr(DTSSource("DZK8DT") + 20000000)

yearvar = Left(var, 4)

monthvar = Mid(var, 5, 2)

dayvar = Right(var, 2)

"Don't roll your eyes at me....

I woul have to test it to say whether or not I would use. I tend not to use third party products unless I can find a good business case....

Sorry your first big problem is you cannot do this.

quote:

---

Set Temp_amount1 = (Select sum(AuthAttr_Amount*( select @value= exec PR_num_business_days '2002-03-17', '2002-03-31', @return_days...

I do so love these.

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

No, as far as I know you have to stop replication and rebuild the table, then redo replication.

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

My experience is it should fail. But I haven't done log backups in a while since I have transactional replication and do differential backups each night (full on saturday). I...

I'll try it on my server tomorrow at work both 7 and 2k see what happens. There may be a setting but I have never seen it.

"Don't roll your eyes...

If you break this down SQl is trying to do this implicitly.

quote:

---

Syntax error converting the nvarchar value '000053-1' to a column...

I agree with tmorton, your objective in SQL queries and functions is to call the least number possible, this genrally has a total effect on the server in CPU utilization...

BULK Insert, truncate table, BCP, anything that is not logged in the Transaction log see BOL for other possibilities. A flag is flip in the Transcation Log when an unlogged...

Note: SQL Server loves memory and will negotiate with the OS to give it the most it possible can (usually around 90%). This is to give it the ability to...

Can you tell me a bit about the file structure of the production instance. Do you have multiple files for the filegroup(s) and or the Log File? I assume based...

I do agree there, it is far better to ask for the space of another drive than to do all this, primamrily since you cannot make modifications without following some...