View Server Roles and Permissions per Login

obtain server roles and permissions by login

Server Role Membership Validation

Need to know how to verify if a login has server-level access to your SQL Server instance?

User Defined Server Roles

Auditing SQL Server 2012 Server Roles

My organization is looking at SQL Server 2012 and I know that the ability to create roles at the server level is a new feature. Since this is new and impacts security, how do I handle them and how do I audit them?

The User Defined Server Roles in SQL Server 2012

This article describes how to create user defined server roles and use stored procedures and queries related.

Script Server Roles

Script Server Roles in case of migration or documentation

Understanding SQL Server fixed server roles

I know there are fixed server roles that come with SQL Server. How do I best use them within my installations? What should I watch out for?

Moving the Logfile

Hi Guys,I am fairly new to SQL Server but have plenty off background in Oracle, Ingres, and RDB/VMS.A few years ago, contractors put togather a system for my current company using SQL Server, I am now charged with maintaining it.I noticed that the Transaction Logfile is on the same raid set as the Datafiles. I […]

Migrating from Sybase 6

I'm having trouble with the users id's and passwords during my migration process to a 2K instance. Does anyone know of a script that I can use to BCP out?

RE: DBPROCESS is dead or not enabled

This is a pretty generic message and hard to troubleshoot without more information.  When I've seen it in our place it was with a Sybase app and it's always been client installation or configuration issues.  For whatever reason, the client can't talk to the DB which can mean anything from a missing dll to to the […]