Glad I could help.

Uh, no. Just change the Nvarchar to Varchar.

glad I could help.

Only with dynamic SQL.

No I don't mean Nouveau "Old School", I mean real Old School. I was already a professional programmer when IBM's Sequel was developed. I programmed for many years...

Generally speaking, direct manipultation of the System Tables is no longer possible in SQL 2005.

Also, I believe that Visual Studio Team Systems is integrated with SQL Server.

I am old school: I always say "Sequel", though am I so comfortable with hearing it either way that I can rarely remember which way a specific person says it.

Well, Brian provided a better explanation of the Agent approach than I could have.

As for Service Broker, I just want to add, not only can do the same...

Michael Valentine Jones (4/4/2008)

---

The issue of scaling out was solved years ago by DEC with VMS clusters and the RDB database (RDB is now owned by Oracle and VMS is...

rbarryyoung (4/3/2008)

---

OK, corrected version:

Select A.*, B.*

From TableA A

Left Outer join TableB B

ON B.CompanyID = Left(A.CompanyID

, (Select MAX(len(B2.CompanyID)) From TableB B2

Where B2.CompanyID = Left(A.CompanyID, Len(B2.companyID))

And ( B2.CompanyID...

Note that the Agent will only retain so much history (based on your settings) and so you may not have 30 days of history to query.

I have seen Cursor-based queries and procs do this also.

Yes, it does require that there are no other users of the database and will wait for them to leave.

Alternatively, you can use:

ALTER DATABASE msdb SET ENABLE_BROKER with rollback...

Compare the query plans.