September 26, 2011 at 2:07 am
GilaMonster (9/23/2011)
Gianluca Sartori (9/23/2011)
I always feel safer when I set up a SQL_SERVICE user on my laptop with no special permissions. Maybe I'm paranoid, but that's just how I feel. -)I could, but seriously what's the point?
This is machine on a single-user network (it's not a laptop that could connect to other networks). If someone compromises my network to the point they can get access to the SQL Server, I'm in a world of hurt already and the SQL Server will be the least of my concerns.
When I change it to a domain account it'll be for cross-machine permissions.
Oh, I see. It's a different thing, indeed.
With my laptop I never know what's on the other end of the cable I'm plugging and with all the mess I do in my test databases I could find myself in big trouble.
-- Gianluca Sartori
September 26, 2011 at 2:14 am
vaithi.saran846 (9/25/2011)
Hi,Either through front end or back end query anything is enough.. Please send to me
Regards,
Vaithilingam.K
Based on Gail's suggestion, this should do:
SELECT cntr_value
FROM sys.dm_os_performance_counters
WHERE counter_name = 'Total Server Memory (KB)'
-- Gianluca Sartori
Viewing 2 posts - 16 through 16 (of 16 total)
You must be logged in to reply to this topic. Login to reply