Viewing 15 posts - 4,246 through 4,260 (of 7,168 total)
capn.hector (4/30/2012)
GSquared (4/30/2012)
Standard Edition can use 64GB of RAM in 2008 R2. Ref: http://download.microsoft.com/download/F/F/C/FFC6D450-A0A2-4916-80EA-B83F7BCDF250/SQLServer2008R2EditionsDatasheet_Aug10%5B1%5D.pdf
The OP was talking about Windows Server not SQL Server being the limiting factor the...
April 30, 2012 at 2:09 pm
I do not see EXEC(@MyString) in your proc.
Also, to clarify, make sure you have a GO after your proc definition when compiling to make sure you do not include anything...
April 30, 2012 at 2:07 pm
You would need to upgrade Windows to Enterprise Edition, at which time SQL Server would immediately gain access to the additional RAM.
April 30, 2012 at 1:42 pm
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...
April 30, 2012 at 12:28 pm
mohan.bndr (4/29/2012)
Hi,Can i know what are the prerequisites for Cluster Environment please....
Thanks,
Seriously, mohan.bndr, is Google broken again? If so, try Bing.
http://www.lmgtfy.com/?q=prerequisites+for+sql+server+2008+Cluster+Environment
April 30, 2012 at 12:08 pm
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...
April 30, 2012 at 11:57 am
Excellent work! Happy you got it working 🙂 Thanks for posting back too, hopefully it may help someone else down the line.
April 30, 2012 at 10:18 am
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....
April 30, 2012 at 10:15 am
"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...
April 30, 2012 at 10:09 am
kirkm 55368 (4/28/2012)
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...
April 30, 2012 at 8:51 am
durai nagarajan (4/30/2012)
another question if i atleast want to block their select and update access is it possible.
SELECT is not an actionable event in SQL Server, so if you want...
April 30, 2012 at 8:46 am
poornipmca (4/28/2012)
yes.But wat type of design u suggest.
We already gave you options
- move to a multi-tenant database and have the application pass in the correct "customer id" to the database...
April 28, 2012 at 8:17 pm
Alan Kwan (4/27/2012)
4) How do I do this?5) How do I do this?
Use portqry (link in my last post). Let me know if you have trouble figuring the cmd line....
April 27, 2012 at 5:31 pm
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...
April 27, 2012 at 5:06 pm
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...
April 27, 2012 at 4:05 pm
Viewing 15 posts - 4,246 through 4,260 (of 7,168 total)