I too have found that the MERGE construct works very nicely. Sure beats having an INSERT / UPDATE which was done historically....

Kurt

Well today I'm a happy man... I found the issue that I have been having issues with. It turns out to be a GRANT issue in the MSDB database....

Why are you using a constraint construct here instead of a trigger?

Kurt

I'd check permissions on your views, cuz the import/export wizard should allow you to move data...

jpSQLDude (8/12/2011)

---

It seems like this should be simple, but I must be missing something really basic.

Everything works fine except the part about trying to stuff EXEC sp_databases into a...

kumar1 (8/12/2011)

---

@Ninja's_RGR'us: Thanks very much for this solution. I am working closer with this solution.

@Kurt W. Zimmerman: You are obsoltely right.I have done similarly before but used waitfor delay option.

Thank...

Some time ago I wrote a process that was spawn asynchronous Agent jobs to process a range of data. I don't remember the exact details of the work to...

Often times, when dealing with null values in a column of data...

Sean Lange (8/12/2011)

---

I think the more important question is how can you eliminate your cursor and therefore not really care about some of the subtle details. 😛

Honestly cursors are one...

Brandie Tarvin (8/12/2011)

---

And being totally snarky (forgive the...

Brandie Tarvin (8/12/2011)

---

What changed between the time it was providing results and the time it stopped?

Any OS service packs? Any SQL Server hot fixes / SPs? Any major issues with...

Brandie;

Sorry for the confusion.... What I should have said DTA is no longer providing me any results. Any script I run through DTA comes back with the...

I think the simple answer to this question is it all depends on the employer. I live in a metropolitan area and everyone in the "hood" has broadband. ...

I use a tool from Redgate called SQL Compare that allows me to compare database structures. If you need to get down to the data level there is SQL...

Well folks... I managed to spend some time on this and I got the answer.... along with a job that runs to check the status

I found this:

select objectproperty(object_id('table name'),'TableFullTextBackgroundUpdateIndexOn')

This...