How do I enable mirroring on sql server 2005 sp1?
Do I still need the -T1400 trace flag like I used to in the RTM version?
Tnx

I have two software need SQL database. I have about 100 users need to use
those two software. How many license should I get for SQL 2005 Standard
edition? Please advice.
Your help is very appreciated!

How do I enable mirror on SQL Server 2005 SP1?
Do I still need the -T1400 trace flag as in the RTM?
Thanks

I have Microsoft SQL Server 2005 Development ed and wish to install
it
on a computer with Vista Home Premium edition *with* -- and this is
important! -- SQL Server Integration Services (SSIS) so that I can

Not sure if this is the correct group, aplogies if it isn't. Here is the
problem, a colleague is trying to install sqlExpress on to a new Acer lap
top running only fully patched XP & office, whe he tries to install he is
told " the system administrator has set policies to stop the ...

SQL 2005
Is it possible to run commands such as these automatically on a regular basis:
BACKUP LOG YourDBName WITH TRUNCATE_ONLY
GO

Curious if this requires enterprise edition of sql server or if it
will work with the standard edition (2 node clustering)..
Cheers

I've configured a min. of two drives.. C and D.. we typically install
the database files on d.. ie:  d:\data\sql databases\instancenameshere
When i run setup.. i let it pick the defaults.. then afterwards i
change the default database path to D:

I downloaded SQL Server 2005 Express and ASP.NET Express. When I try to
create and connect to a database file... I get the error message:
Generating user instances in SQL Server is disabled. Use sp_configure 'user
instances endabled' to generate user instances.

I have gotten mixed comments on this topic. I have a 64 bit machine running
64 windows 2003 standard and 64 SQL 2005 standard with 8 GB of RAM. We want
to upgrade it to 32 GB. What is the best approach to do this? Dynamic or
Stattic giving min and max server memory a value ? and ...

I'm trying to install MS SQL 2005 Standard x64 to a two node Windows Server
2003 R2 SP2 cluster.
I've setup the cluster as per MS requirements and tested failover, The
cluster seems to be working well.

I am running SQL 2005 Standard under Windows 2003 Standard with 8 GB of RAM
in one of our 64 bit servers; I noticed min server memory was set for some
reason to 128 MB and max server memory to 6114 MB by the previous DBA. We
plan to upgrade it to 32 GB. What is the best approach ...

i have already posted this in other forums but so far nobody could tell me
how to solve this.
i log in to Sql server with Studio Management with Windows Authentification.
My account ("myaccount") is local 'administrator' on this computer. There

I want to set up SQL Server to run as a non-administrator domain user to
prevent security leaks... whats the best way to do this? What files /
folders does the user need permission to? thanks!

I have been using Team Foundation Server 2005 in a 180 days trial version.
Finally I am going to upgrade to a full version and I have successfully
entered a license key in the FTS part.
But the SQL-server is not that simple as I see. The license key is hard