It uses a Temp table, but temp tables can't be used in functions, right? I am just not SQL savvy enough to know how to repurpose it.

Thanks. Is it possible to put this into a function? Or how would I use that within a select statement?

Sorry, this should be in the SQL Server 2012 - T-SQL forum...

Thanks. I just purchased the book. Hope it helps. I guess I'll have to do some heavy reading. 🙂

Elliott Whitlow (10/19/2011)

---

I would be hesitant to host those pieces cross country. I would expect there be fairly serious performance penalties. While I agree that hosting them on...

Just create a backup on 2005 and restore on 2008. that's what i did.

If the rule for the specific IP is set correctly then it should be blocking ALL connections made on your specified SQL port except for the IP address you specified....

Joie Andrew (9/4/2011)

---

You would setup your SQL instance to listen on a specified port and then configure your firewall to allow traffic only from specific IPs to connect using that...

Thanks

Thanks SSC-Addicted...errr MysteryJimbo

I have a Virtual Private Server with 5 GB...