atricapilla's questions

I have virtual machine (VMware vCenter 4.0) using Windows Server 2003. I would like to extend C:-drive. I can see the unallocated space in C:-drive (disk management). How to do that in Windows Server 2003?

Why it is not recommended to shrink transaction log?

Do I need to be sysadmin to run DBCC commands on SQL Server? Or is db_owner rights enough?

I have a .ssmssqlproj file in a Sharepoint folder, but I cannot delete it. It says that some application may currently use it. That is not true, because I don't have SSMS open. How to delete this SQL Server Management Studio project file?

When giving permissions to certain Schema in SQL Server, I want to deny some operations from certain users. Do I have to explicitly deny these, or is it so that when user gets a permission to this schema, rights for this schema is automagically denied for other users?

We have Apache Tomcat running on Windows Server 2008. Is there a problem to install IIS on the same machine?

How can I find all groups for a specific user (groups for which the user is assigned) using dsquery?

In SQL Server 2008 EE, how can I create a local server group? And also, what is the benefit of using local server groups?

What is the basic difference between local, global and universal groups in Active Directory? What is the best practice when assigning users and groups to these groups?

I have read, e.g from here

http://wiki.lessthandot.com/index.php/Find_Out_Server_Roles_For_a_SQL_Server_Login

that SecurityAdmin role can read Error logs. I'm on SecurityAdmin role and when I try to execute xp_readerrorlog I get a following error:

Msg 229, Level 14, State 5, Procedure xp_readerrorlog, Line 1
The EXECUTE permission was denied on the object 'xp_readerrorlog', database 'mssqlsystemresource', schema 'sys'.

What I'm missing? Can this role read error logs or not?

(migrated from stackoverflow)

The application I'm using tries to connect SQL Server named instance running on a dedicated database server. Here's the error I'm getting:

The TCP/IP connection to the host <instance_name>, port 1433 has failed. Error: Connection refused: connect. 

Is the firewall blocking my access or what? Should I dedicate a different port for this application?

I'm dbowner on certain database (my account is on public role on server login but dbowner role on certain databases). Now when I try to add logins from server logins, I can only see sa account and my account. How can I add user to my databases from server logins?

How can list environmental variables on Windwos Server 2008 R2 using command promt?

What is the difference between native SQL Server connection and ODBC? What are the benefits when using native SQL Server connection?

I would like to make a t-sql query to check which logins have 'view server state' permission in server type securables. How to achieve this?

This query from mssqltips don't show this:

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

SELECT prin.[name] [User], sec.state_desc + ' ' + sec.permission_name [Permission]
FROM [sys].[database_permissions] sec
  JOIN [sys].[database_principals] prin
    ON sec.[grantee_principal_id] = prin.[principal_id]
WHERE sec.class = 0
ORDER BY [User], [Permission]; 

Is there a possibility to create DSN (ODBC to SQL Server) using different Windows account than current coputer login account? I’m trying to create System DSN to SQL Server and I would like to create this connection using Windows authentication using my admin account. I’m creating this DSN using my normal windows account.