I have now got a new error message that is the cause of SPROCS not transferring:

'The login already has an account under a different user name.'

It maybe because I tried to...

I just tried to recreate the error message and have noticed that it is having a problem copying a table with a table name that begins with a number.  Why...

Is the Import/Export Wizard used or has a DTS package been created?

......  Import / Export Wizard

Is the Copy SQL Server Objects task being used? 

...... Yes

When you say "node" are...

The system was designed for small geographical area statistics.  But my boss wants it to perform the same operation for England and Wales data.  The small area statistics has a...

Is the column name in the #Tally table: PK_tmpTally_N?

Update:

I can see now that it is N

As new data is added to the base table the number of rows required may change. 

The statement used is like:

INSERT INTO Deaths (

 Year_of_death,

 Ageyears,

 Sex,

 Undcause,

 ICD,

 OAcode)

select  Year_ref, 

 Age_start,

 Sex,

 ICD_ref, 

 ICD_number, 

 'XXXXXXXXXX' 

from Eng_Wales_Deaths t

join Number_list n

on n.number...

Can I put that in an UPDATE statement?

Update:  Sorry .... I can .... I need to go to bed I think.

I just want to remove the '.00' from every value in a collumn.  Can that be done with Substring.  The problem is the number of digits before '.00' is varied. ...

I try to minimise code by creating new stored procedures that can be called from more than one other SPROC.  So, sometimes, less code but more SPROCS are the answer. ...

I've had to limit the number of years that I can apply this operation to.  The reason I wanted to perform this operation is so i could maintain the method...

I only allow the front end user interface to submit flat files that are read by Perl programs, and SPROCS are then executed via these Perl programs.  It enables me...

What is an sql injection attack.  And how would the changes above stop that?

Really?  How does it do that?  My database has more than 60 SPROCS and more than 50 tables.  It creates and drops tables on the fly in order to perform...

Is that a problem?

It returns the two numbers:

449291 13591434