Cube,

Greg is right. Managing transactions can become a pain via clientside, unless you have already built a data layer to do so.

For a stored procedure to use transaction, it will...

Derek,

From looking at your stored procedure, I would have to agree with Jonathon Prosper. I do not think you would really need a temp table or a table variable; this...

crprajan,

Both Jeff and nigelrivett, have valid approaches. There is also a last option of using DTS/SSIS to transform the data from the flat file to the destination table. Even for...

halifaxdal,

Try searching the web, for Codesmith. There should be some generic stored procedures generation templates which you can use. Codesmith should be able to help you generate CRUD statements/procedures. (C...

ishaan99,

Do the two table have the same table structure? If so, you can use a tool like DBGhost or SQLCompare to script out the data for you, and once you...

Gary,

More frequent than not, when running a stored procedure call from Query Analyzer with the same inputs as a Web Page, the execution time is usually relatively smaller. This is...

Simon,

I agree with Jeff. Except for the security reasons, combining stored procedures depend on the requirements. However, why not return all columns? I would assume this will require Application changes;...

Gopal,

*** Check this old forum post:http://www.sqlservercentral.com/Forums/Topic200830-8-1.aspx

Regarding your comments:

If that's the case, temporary tables will not work. I have tried it for a couple cases. However if you rewrite the logic...

noeld,

It looks like there may have been an issue in the "HTML/TEXT" editor. For links, bold, underline functionality... etc., you actually have to write it using HTML. Previously, about two...

Gopal,

Note: After re-evaluating your posting, I am assuming that your original code was something like this.

Possible Problem:[/u]

INSERT DestDB.dbo.Table

select from SourceServer.SourceDB.dbo.Table

--NOTE:** Something like this will require Distributed Transactions to be fully...

Greg,

Glad to be of assistance....

Regards,

Wameng Vang

Gopal ,

Have you rebooted the servers? MSDTC should be enabled on both servers.

You may want to give this a try. If this does not work, let me know, there is...

jehen joshi,

Please provide the DDL for the table structure. Please define "What is a duplicate customer."

Example of what I mean:[/u]

Customer 1 matches Customer 2, because the Name and Address are...

Greg Snidow (9/26/2007)

---

Greetings folks. I am trying to find where the value for system_user comes from. I use enterprize manager to create logins for my users. When...

A late response to the original post,

Assigning a Primary Key to a table variable can be beneficial and harmful. How it is use, the results may vary.

I have previous...