There have been some major changes here at work, and in order to keep up we
need to change some of the Group names in Active directory.  Will the
changes that are made in Active Directory cascade down into SQL Server?
What is the protocol for this type of change?

Hey, all!
There is a lot of useful info in the various windows within SSMS. However, I
don't personally want to see all the columns and/or data in, say, the Job
Activity Monitor. Is there any way to customize the view by removing columns?

Running 2005, I have backups with multiple datasets on them.
But when I open the restore backup windows, it only shows me the last set.
How do I see the all the sets so I can choose which set to restore?
Thanks,

I am currently doing a project on MS SQL Server 2005 where I am in
need of  table level backup/restore. I know about FILEGROUP. But in
our project using FILEGROUP is not feasible. As far as I know MS SQL
Server 2005 does not support Table level restore directly.

I'm looking for some information regarding the 3 GB switch for SQL Express
2005.  I have Windows Storage Server 2003 R2 SP2 and SQL Express 2005.  The
server has 4 GB in it.  I have a database that is running slow.  It takes
about 1.4 GB of RAM and another 1.5 GB in virtual RAM ...

Is there a way to change the Database Engine Default Isolation level?
The default is: Read committed (Database Engine default level)
I would like to move it to: Read uncommitted (the lowest level where
transactions are isolated only enough to ensure that physically corrupt data

I have an UPDATE query that sets a "quantity" field in a table based
on the sum of events in another table. Those events are "basketed"
into different accounts through a four-way tupple,  (acctId, portcode,
mgrgpcode, invpgm).

I setup a two node SQL 2005 SP2 failever clustering.  Shared drives
are set up on NetApps SAN.   I can see all drives throught the
Windows.  However,  my SQL Server can only see shared drive from SATA
and not the other ones that were setup on Fiber Drives.  I can see

Is there any way to tell the date and time a database was brought
online.  I'm using Performance Dashboard and trying to determine IOPS
without restarting the server, so I'm looking to calculate IOPS using
the database's time currently online.

I am working with a client whose primary software for their firm uses
MS SQL.  They have been experiencing frequent issues with data missing
from query windows, or old data that has been deleted or archived
reappearing; the client closes the program and things are back to

I've noticed the following error message in the event viewer being reported
by SQL Server for a site that we've had online for several months without
incident.  However, every so often now, SQL server is locking up and it seems
to be occurring after this error message:

I think there is an option that will allow you to write a stored procedure
that loads data on a server that is not yet created (server created but not
the database).   This would be for used for transfering data from one
existing object to another not yet created.

I have build a trigger for insert, update and delete that works with
all the fields of a table, it doesn't matter the names and the number
of fields.
As triggers can't manage text, ntext or image fields I get the list of

I have now SBS 2003 with SQL. I had a SBS2000 with SQL.
I want to do some migrations and tried to migrate Data Transformations.
In Legacy I choose " Data Transformation Services" and rightclick on
"migration wizard"

Gurus,
Running SQL Server 2005 SP2 on Windows Server 2003 SP2 as a guest OS inside
a VMWare session.  Due to hardware constraints, I typically run this SQL
server at either 512 or 768MB RAM.  It works OK, but I cannot give it any