Here's one that is getting me going. Gus has already chimed in, thanks.

No, this is not what you are doing today. This does your update in one statement, not by building a string of sql statements and then executing the string.

If...

This article[/url] might give you some ideas. It does not do what you want, but it shows how to use a script component to do some conditional processing of...

Just to clarify, you do NOT need Outlook installed on your SQL Server to use Database Mail.

What is the SMTP server you are using?

I'd dump the CSV data into a table then do a set-based update. Something like:

UPDATE TABLEA

SET boolean_column = TRUE

WHERE

EXISTS (SELECT 1...

It depends.

What is the clustered index key? How wide is it?

Where are your inserts in the clustered key, beginning, middle, end?

Are your updates, updating the clustered key?

What is the...

Stefano has the right idea. Attached is the sql I got from Profiler.

Darn Roy, I was hoping this would have been a suggestion...

You could save all the queries in 1 .sql file separated by the GO statement and then execute the 1 command.

You could create a batch file (.bat) that executes the...

You can use a conditional to simulate COALESCE. Why not do COALESCE in the source query? That would probably be the most efficient way to do it.

If object names have a normally disallowed character in them you either need to turn on quoted identifiers and use double-quotes (") around the name, "First Name", or you can...

You would select Database:Database File Auto Grow and Database:Log File Auto Grow. Since these are collected by the Default Trace there really is no reason to do another trace...

GilaMonster (5/29/2009)

---

Lurking a fair bit here at the moment, cause there's little better to do. Hence I'm catching this kinda stuff early.

Got no major projects that I'm busy with, just...

Lynn Pettis (5/28/2009)

---

Roy Ernest (5/28/2009)

---

Kit, Iguana is a delicacy in my island.. 🙂 They make soup out of it. Tastes like chicken. They call it the Natural Viagra from Curacao...

Pratibha_Pillai (5/28/2009)

---

Hi Jack,

Thanks for the reply.I need few more guidelines from you.

Generally I got the answer as to how can I track the schema changes.My application is used for synchronization...