This post is very similar to what you are asking and has some useful solutions

http://www.sqlservercentral.com/Forums/Topic950057-149-1.aspx

You aren't checking for @@Transcount in your code. Also, you should use a try catch block and return after the error.

Create Procedure One as

declare @ErrorMessage varchar(300)

...

I guess the answer is it depends. Is this an OLAP or OLTP database? Warehouse? I would try to eliminate duplciation of data where possible, but that's...

you should check @@Transcount to determine if a transaction is opend or not. See this article on MSDN regarding nested transactions.

http://msdn.microsoft.com/en-us/library/ms189336.aspx

why are you trying to increase the initial size? You have the file setup to extend as needed up to 4Gb. I hope you put the second file...

As a developer, I would love to have access to the production box, so I can "do it myself", unfortunately I don't and for good reason, especially now the Sarbannes...

is the sequence just returned in the resultset? You don't want to store it anywhere? What is the significance of it then?

how many records are in the table? The timeout is probably happening because SQL is creating a tmp table and then copying the data from the main table to...

Pretty basic group by expression

select Policy_Number, sum(balance)

from table

group by Policy_Number

You can use a quirky update to populate the sequence field

Table Setup

CREATE TABLE [#abc1](

[I_KEY] [int] NULL,

...

you need to use a format card if the file isn't the same layout as the table

If that's the case, then you can perform 2 separate deletes

delete from wce_linkto

where createtime <= '1980/01/01'

delete h

from wce_history h

...

on an update, the new and old records are placed into tables called INSERTED and DELETED which a trigger has access to. Are all the updates performed through stored...

You can use dynamic sql, although there are issues with this as well. You need to specifically grant select rights to each table.

create table t1 (ID int, Quantity int,...

Is there a foreign key between the 2 tables? Is it possible for a record to be in the history table but not the linkto table?