mrichardson 57577 (5/28/2012)

---

yes, same name, (just not NIGEL obviously for security reasons)

but it worked ok before as the same name on sql2000.

I realise now, it might not be good...

Symbol assignment statements like this:

select @uweid = id from #temp1

will not work the way that you think they do when there is more than one row returned. Try putting...

Is...

Yes indeed! Nothing forestalls a good spanking from us...

Did you check that your DNN connection strings have been changed to the new server correctly? IIRC, there is more than one place in the .CONFIG file for DNN...

You really should consider SQL Server Replication for this. It is tailor-made for just this situation.

One thing I'd recommend is not to exclude the system databases from these stats. I guess you could exclude [model], but the other three all have configurations/cases where they...

Here's a simple non-Cursor, non-loop way to do it, to save your eyes:

DECLARE @tab TABLE (Reference NVARCHAR(10), ObjectName SYSNAME)

INSERT INTO @tab

SELECT 'Direct',

...

MadTester (5/28/2012)

---

Been trying to solve this with a cursor on the initial query but I seem to be stuck in a loop adding the same record.

I am appealing since...

Stewart:

Actually, the site at your link has another link to this site: (http://sqlblog.com/blogs/adam_machanic/archive/2006/07/12/validate-a-url-from-sql-server.aspx) which does demonstrate a way to do it entirely from within SQL using OA Automation objects.

Oops, I just noticed a mistake in my code. Try it like this instead:

CREATE TRIGGER InventLow on PurchaseOrder

For update

AS

BEGIN

-- SET NOCOUNT ON...

This will only INSERT a new row for rows that were just inserted...

Sorry, just add an "END" statement on to the end. That should get rid of the dreaded "red leggy".

Jakub.Janda (5/28/2012)

---

I am aware of that article and even acknowledge that the optimalization in QN is good - it's just that the old way was more useful for a caching...

Rock from VbCity (5/27/2012)

---

Thanks Jeff

I tried my code with Barry's function getting a result 1 versus 6 seconds in favour of Barry's 🙂 I am in the process of fine-tuning...