... and this includes the location for the Shared Features, such as Management Studio and Integrated Services.

One reason beyond this practices is that you are not installing any files on...

This is a weird one.

Do you see also the users from your SQL_Express instance?

What happens if you stop the SQL_Express instance?

Or what happens if you go to your "supposedly" new...

I always keep a copy of my own work elsewhere... specially since I've witness many times the HR lady coming down the aisle with a box to empty your desk.

Many...

Hello,

Two things:

1- Restarting SQL in single mode (using the -m flag) will allow any person that is a member o the Windows Local Admin group to be automatically a SYSADMIN...

Wow.. some simple, and somehow I missed that.

Thank you for your input. This shows you that there are many ways to skin a cat, and some of us choose the...

While this is not exactly what you need, it is a start and you maybe able to modify the script to fit your needs

http://www.sqlservercentral.com/scripts/Security/66129/

Miguel

About SQL injection... it is really difficult to explain to people that are not well verse on SQL.

I found this article, which explains it and gives a few examples illustrating...

I'm on my droid so I can't look it up, but a few months ago I faced the same problem and requirements. Look inside the setup bootstrap, one of...

Hello,

Did you find your answer?

I'm still trying to find a solution that does not involve powershell.

Here is an article with powershell,

http://www.sqlservercentral.com/blogs/adventuresinsql/archive/2010/11/15/get-drive-space-including-mount-points.aspx

but in my case, not all servers allow me to...

Hello,

About getting the node where the instance is running, you can use the following query:

select Nodename from sys.dm_os_cluster_nodes

or this other one:

select Nodename from ::fn_virtualservernodes()

The query above would give you the...

Let's resurrect this thread.

I was looking every everywhere for an answer... and I was surprised that my fav website didn't have it... So here it is for the next poor...

I saw this script using Powershell

http://www.mssqltips.com/tip.asp?tip=2444

I haven't had the chance to use it, but it...

For the Local Policies question... the account is not listed.

Yes, this is MS SQL 2005 SP2 Standard Edition on Windows Cluster 2003 SP2.

That is a good explanation as to why...

Hello,

Interesting stuff the locked page in memory.

I did a search on several log files, and I couldn't find anything in regards to

"Using locked pages for buffer pool", so I guess...

I knew I was forgetting something

64 bit and AWE = 1