I am having troubles attaching a database that was previously attached using
sql server 2000. We have two databases xxx and xxxTest but when i try to
attach the xxxTest database the file names resolve to the xxx database.
What options have i got in regards to getting the xxxTest ...

Are there any known issues in having IIS and SQL Server on the same computer?
If so, could you please give me specifics (or links to specifics)?
Thanks.

Since morning I have observed the following errors in sql 2005 error logs
Error: 18456, Severity: 14, State: 16.
Login failed for user 'sa'. [CLIENT: XXX.XXX.XX.XXX]
(where XXX represents Ip address of client machine)

I'm building a backup server with a fresh install of sql2005.  The server
this will be a backup for is sql2000 upgraded to 2005.  The database path on
the upgraded machine is "Program Files\Microsoft SQL Server\MSSQL\data".  On
the fresh installed 2005 machine it's "Program ...

I'm looking to move indexes for my databases into a different filegroup and
spindles on my SQL Server implementation to improve disk performance.   I've
been doing a little reading and have seen where people have said not to keep
the clustered index in a different filegroup, can ...

We need to free up space in the C drive of our server and we don't use the
SQL server. Can it be manually removed, and if so, once removed will it
cause an issue when we update the server software with SP2? Thanks for your
interest.

I've got a client that needs to purchase MS SQL 2005 - will be having a dozen
local users and then many web-users as we roll out.
So processor lic made the most sense.
The actual MS SQL need is lightweight - so they were thinking of putting the

I have a database on a sql server 2005. A maintenance plan performs a
full backup every night, while a backup of the transaction log is done
every 15 minutes. last night all log backup failed from the early
morning onwards. the error is "BACKUP LOG cannot be performed because

We are running SQL Server 2005 Enterprise Edition, SP2, 64 bit, with 32GB RAM.
This is a server dedicated to SQL Server, single instance, OLTP based.
Is there a link that gives some guidelines as to how much memory (Max Server
Memory) should be allotted to SQL Server given the above ...

I have a deadlock situation on a Sql 2000 sever. Unfortunately, I did
not have trace active or profiler running at the time.
My goal is to copy out of the Log table the entire row of any
Application Error into a Problem table on another server running

I have the following installation on a Windows 2000 server (This is needed
because of an application version upgrade).
SQL Server 7.0 Default.
SQL Server 2000 Named Instance.

Does anyone have handy documentation on what Microsoft recommends for
naming conventions?
Our current naming convention is using the '_' however I have a
customer who's databases we will house, who wants to use '-' (dash).

I want to use 3 raid 1 for existing db. if i was creating this db new, I
would be able to use 3 different files for the same filegroup and that way my
db would use them all.
But I have an existing db which uses 1 data file and I want to migrate it so

Where is the "Auto Create Statistics" disabled option , how can i disable
stats ?
I think statistic tables are slowing my server.
UPDATE STATISTICS <table>...with NORECOMPUTE ??

We use SQL 2000.
We want to create a stored proc that builds a parameterised query and
executes it using sp_executesql. We have an index on the date column
of a table. For small date ranges, using the index is very useful. For