I have mirroring set up from server PRD to DR, working fine.
Doing failover test right now, all is going well.  Took PRD offline,
changed IP, now DR box is responding as if it were the PRD box.  Have
left PRD box down for now.

First be patient - I'm an Informix DBA who is tasked to manage a 2005
install.  I have a db that's been restoring for 24 hrs and is only 12
MB.  Normally it would only take a minutes and it would be done.  I've
gone through the logs and found a few errors but nothing to do with

The installation prompts for user to run the engine service account, the
default (and recommended) user is a domain user, not a local user. I'm
interested to know why the service account runs with access to network
resources? Is it to do with being able to browse/link to other ...

I've moving some databases from SQL 2000 to SQL 2005 (new master and
model). All our Windows servers are set to either English US or English
UK. When installing SQL 2005 on a Windows server set to English UK, it
asks for the collation order, and the default is Latin1_General.

I am doing a performance analysis for one of my customer. After
analysis of the perfmon logs I foundout average _Total %DiskTime is
around 140, when I did a details analysis I found the data drive
%DiskTime is 90% of the _Total %DiskTime.

A client is going to run these two scripts in SQL 2000, in order to shrink
the transaction log of the database to a reasonable size:
BACKUP LOG %DBNAME% with TRUNCATE_ONLY
DBCC SHRINKFILE (2, 20)

Is anybody having t-sql or vbscript that can display the SQL Server instances
installed on the machine?
Please share it if you have any such script.
Thanks,

I have a SQL Server that was earlier a part of the domain and had a domain
account for the MSSQLSERVER service and SQLSERVERAGENT service. Now it has
been taken of the domain and given a different name. The SQL Server service
refuses to start. I took out the domain account from ...

When I double click on the work from arrow which is connected between the
server, it show me this error:-
Error Source : Microsoft OLE DB Provider for SQL Server
Error Description : [DBNETLIB][ConnectionRead (WrapperRead()).]General

We're a shop that is required to keep our clients at n-1. So I'm wondering,
and I can't find conclusive evidence, if SQL Server 2008 has been officially
released.

What would peoples preference/opinions be on using the following drive RAID
combinations for a SQL 2005 install:
6 x 73G SAS 15K drives (RAID5 or RAID10)
or

One of our applications came bundled with a MSDE 2000 that got installed
along with the application. The default passwords were changed and the person
who knew the passwords left the organization. Upon rebooting the server the
application is not able to connect to the MSDE since ...

I have a problem with a stored procedure.   The stored procedure is
called as follows:
exec InterfacePatientUpdate
@HospNo=N'D509929',@NHSNo=N'',@SName=N'MOHAMOUD',@FName=N'Ahmed',@Sex=N'M',@DOB='1989-10-19

I would like to be able to change the physical name of the transaction
log in my SQL 2000 database. For instance, I would like to be able to
change D:\Program Files\Microsoft SQL Server\MSSQL\Data\filename1.ldf
TO D:\Program Files\Microsoft SQL Server\MSSQL\Data\filename2.ldf . Is

I found out that I can only send mail under my own profile. How can I make my
profile public so that anyone that access to the sql server can send the
email?
Besides, I want to make it scheduled on batch job purposes.