You would need to upgrade Windows to Enterprise Edition, at which time SQL Server would immediately gain access to the additional RAM.

Here is a video demoing the For Loop in SSIS. Using it would be a slightly different approach than the path Elliott provided, although I am confident that what Elliott...

Seriously, mohan.bndr, is Google broken again? If so, try Bing.

http://www.lmgtfy.com/?q=prerequisites+for+sql+server+2008+Cluster+Environment

That looks like the gist of it, but I am not sure you need to grant anyone VIEW SERVER STATE...all members of public are able to view their own sessions...

Excellent work! Happy you got it working 🙂 Thanks for posting back too, hopefully it may help someone else down the line.

It would be a lot of custom coding, but you may be able to achieve it using a Server Logon Trigger, depending on exactly what behavior you're trying to restrict....

"my firewall" meaning the firewall on your machine?

What port is your SQL Server running on? Did you use portqry? Is your firewall preventing access on the SQL Server TCP port...

kirkm 55368 (4/28/2012)

---

Hello,

I apologise if off topic, I do not have SQL Server 2008, but my question is where would it be best to ask for general SQL help and...

SELECT is not an actionable event in SQL Server, so if you want...

We already gave you options

- move to a multi-tenant database and have the application pass in the correct "customer id" to the database...

Use portqry (link in my last post). Let me know if you have trouble figuring the cmd line....

it could be a lot of things...but it sounds like your SQL connection attempt is not even making it to the SQL instance.

For starters, verify:

1. You are providing the correct...

Bummer...the operating system requirements for SQL 2012 are the following:

> Windows Vista SP2 or above

> Windows 7 SP1 or above

> Windows Server 2008 SP2 or above

> Windows Server 2008R2 SP1...

Happy to hear things are improving...please help us help you...

opc.three (4/26/2012)

---

It looks like you could benefit from an index on Users.ID that INCLUDEs email but I need to see the...

I see you mentioned the Native Client 10.0, not SSMS...you may be able to use the SQL 2008 Native Client to create an ODBC DSN that will connect to 2012,...