You may have installed the "default" version of SQL Server Express Edition...which doesn't include SQL Server Management Studio (the new combined Ent. Mgr/Query Analyzer).

You probably want to grab the SQL...

Mike: Take a look as this article from Any Warren. It's a fairly decent step-by-step to a method for how to do exeactly this:

Anatomy of an Incremental Load[/url]

And...

You need to create a report model, with the columns you want to make available, the relations between tables, etc.... and then give you end-users access to the Report Designer...

Grant Fritchey (5/27/2008)

---

Do you mean delete data from the column? You don't mean the end-users of the app have DDL privileges?

Assuming you want to protect the column... Only allow the...

Steve Jones - Editor (5/27/2008)

---

If you're really concerned, give it a long, one-time password that you don't write down. Randomly bang on 20 keys to get it.

Don't rename it or...

I don't think you have access to the SQLContext.pipe from within a UDF. That's one of those ugly limitations the UDF's seem to have.

Since you have a function, your...

just out of curiousity - what's the clustered index on Table1? Is is unique? A WHILE loop might help, but running the deletes based on the clustered index of...

Like...

James Stover (5/23/2008)

---

If I had a dollar for every time I've heard the phrase "skills shortage"....

This is what they say: "We can't find any qualified applicants."

This is what I hear:...

nagarajanmm (5/27/2008)

---

Thanks for your replies. I understand Trigger has more benefits than the Output Clause. Only thing I am worried about is the Performance of the Trigger. Is there any...

Keep in mind that you need to track the SQL:stmtCompleted event (not one of the default options) to catch the trigger firing.

within SSMS: Tools, Options, Scripting. Set the extended properties to FALSE, and enable scripting the permissions. These set the default scripting options.

J. Cote (5/27/2008)

---

You know, I knew it had to be something simple. One of my umpteen million test iterations had something close.

But of course, close only counts in hand-shoes...

The big question in my mind would be - what is it you see using this for? do you have a specific example in mind?

Understanding the background could be...

Paul - You're not giving us a lot to go on. I think you're looking a pivoting or cross-tabulating data, but without some specifics (like what does the source...