Question:

I do not see and declarations or definitions for these three variables?

OK, I have a little time right now, so:

[h4]Technical Books on the Bookshelf I happen to be looking at right now (plus my capsule reviews)[/h4]

Numerical Recipies in C: excellent! teaches...

Florian Reischl (4/2/2009)

---

Hi Timothy

As far as CLR I actually have found another important use for it... though maybe there is a better way. In my development environment I have created...

greg eze (4/2/2009)

---

Thank you RBarry and MJ for your efforts, the problem is that I have these servers in a corperate network, therefore, in different locations round the globe(350 machines),...

jaybouch (4/2/2009)

---

From the result set, looks like 1 vs more than one.

If its 1, there is a physical link in the result set to a page.

If there is more than...

Actually, I think that the best solution would be to re-write it with CTE's and then "de-volve" the CTE's into subqueries and temp tables.

Krushna (4/1/2009)

---

RBarryYoung (4/1/2009)

---

Krushna (4/1/2009)

---

Please note that I'm using Adobe Acrobat 6.0 Professional and PDF Printer is installed in my system and it is set to default printer. The default port...

I agree with Gail. I have seen several situations very similar to this on Replicated SQL servers where a whole bunch of data "just disappeared" and was blamed on...

Hmm, according to this MSDN Blog, table variables are not logged. Of course you have other limitations there also.

This work just fine, as long as you have RPC turned on for your linked server:

exec ServerName.master.dbo.sp_executesql N'Select SERVERPROPERTY(''MachineName'')'

Double post. Please do not cross-post. Please direct all replies to this thread: http://www.sqlservercentral.com/Forums/Topic688473-149-1.aspx

Question: this code from your level 3 loop:

--- Get count of record in #Data

...

Sorry, I do not know the answer to that last question.

I think that you are getting bitten by NULL logic.

This query:

select *

from master.sys.server_principals

where sid NOT in (select sid from [Database_Name].sys.database_principals)

will not work if there are any NULLs in the...

bc (3/31/2009)

---

Professional "SQL Server 2005 Integration Services" is a good book from WROX to start with.

You can do your updates and deletes prior to the Fuzzy Lookup Data...