I was able to resolve it with a double exec ...

Steve, check where I start the EXEC ... that is what I'm doing. Unfortunately it does not work.

Forgot about this ... back to it. Yeah I could turn it into a proc and cursor through and update a temp table, but I really want to keep this...

Did you mean? ([ROWNUMBER] + 1)/2 AS [Team]

Terri (9/18/2008)

---

Replace the CASE statement with:

([ROWNUMBER]/2 + 1 ) AS [Team]

from BOL

If an integer dividend is divided by an integer divisor, the result is an integer that has any fractional...

If your linked server is going from 2005 (x64) to 2000 (x86), you need to reapply instcat.sql on your SQL2000 server. This is a file included in the SQL2000 SP4...

Michael Earl (9/16/2008)

---

I don't know of any tools that allow you to set an expiration date on MSSQL role membership, but it would seem more logical to do all of...

sp_help_revlogin

Well, I've been talking with ScriptLogic for the past couple weeks and while they have a great tool for this type of thing, they don't have the logic to remove...

Still haven't had much luck on this ... not sure what I'm missing here.

Thanks

haha, point taken ...

So I played with SSIS and got a Fuzzy Lookup working ... wow, just wow! I am simply amazed at how accurate this is and well it...

Trying it now ... ugh, I hate SSIS ... yet this could be really cool and get some much more accurate results.

Thanks John, that definitely makes sense and seems to be about the best bet.

Thanks!

The easiest way to find server up time is checking spid 1 in sysprocesses:

SELECT

[login_time]

,DATEDIFF(mm, [login_time], GETDATE()) AS [Days]

,DATEDIFF(dd, [login_time], GETDATE()) AS [Months]

,DATEDIFF(mi, [login_time], GETDATE()) AS [Minutes]

FROM [master].[dbo].[sysprocesses]

WHERE [spid]...

Yes, or travel directly to the registry ... easiest way is to just use SSMS though.