Just run "File", "Export", "Script Trace Definition", "SQL Server 2005" and you can define the file from there. Attach it to a message (cause posting it would be ugly).

Wild.

That's sure a surprise that you shouldn't run trace in production... Since I've got it running off & on on most production servers and I have yet to see...

We carried straight jackets... That's all I'm going to say about that.

Short answer: it depends.

Slight longer answer: When looking at a system like this, you have to decide, is it a single integrated system or a series of apps that have...

OK.

Then without details... I think the insert & update is better.

I agree. You should minimize what is maintained there to only what is needed to run the processes that move the data in & out. Assuming it's not also used...

Were you answering someone's question?

He's right. With very, very few exceptions, every table should have a clustered index. Further, every table should have a primary key and that constraint can be clustered (since it...

Kevin Durham (4/29/2008)

---

I have demographic data in several tables in production with IDKey being the unique identifier. Daily data loads include new records and updates. Basically what I need to...

codevault33 (4/29/2008)

---

Hi, I'm in a similiar situation, you asked about the quantity of data that the other systems may generate to warrant having their own database, well in my database...

No, it's an implicit commit. I just got the same results. I ran this query against Adventureworks:

SELECT soh.[SalesOrderID]

,sod.[SalesOrderDetailID]

FROM Sales.[SalesOrderHeader]...

It is a small world. I was on SSN606, Tinosa (a pile of glowing razor blades now). I was nuclear power machinist mate. In other words I used a slightly...

It sure beats working on a nuclear powered submarine in terms of pay, benefits, hours, cleanliness... Yeah, I'd say it's still a good career.

I'd have to see the procedure to understand why you're getting a difference. But I think, and I could be wrong about this, the batch includes the commit, but the...

To give you a specific answer you need to post specific information, the two tables & some sample data. See here: http://www.sqlservercentral.com/articles/Best+Practices/61537/

In general, you shouldn't have to do cursors or...