In SQL 2005, I was using a stored procedure to call sp_rename to rename  
some defaults (default constraints).  Originally, it was failing, I
think because my default schema is dbo and the contraints were on tables
in a different schema.

Over the last little while, we have begun receiving this error in the event
viewer and until the system is rebooted and then the sql server service
restarted (HAS to be done after a reboot) our CRM system and any other sql
related services are unanavailable.

We are running SQL 2005. When we run queries inside of Management Studio
they timeout. If we run the same queries using the old SQL 2000 Query
Analyzer they run just fine. Any ideas why they would timeout with
Management Studio.

We are planning to upgrade SAN for our SQL Server-based/ hosted /OLTP
system.
We are hosting ablut 200 OLTP databases.
•    We are under impression that we should not get RAID-1 for log, since

We are running SQL 2005. Is there a way to view the actual transactions that
are in the Transaction log?

Does the SQL query short circuit evaluating the where conditions like
some procedural languages (C,C#,...)? For example evaluating the
second part of AND condition when the first part of AND is false for a
row, and evaluating second part of OR condition when the first part of

First of all, thank you for posts in this news group, which is being very
helpful in my daily tasks.
Here is a description of the problem I have with Database Mirroring:
I have installed two SQL server 2005 Enterprise edition SP2 instances on two

Since SQL maintenance plans that are properly set up allow for SQL 2005 to
practically maintain itself, are there any other housekeeping tasks that a
DBA should perform on a monthly basis?  If so, what are some of these tasks?
I mean, other than reviewing the job history and log ...

The database has gone into "suspect" mode because the database has reached
the 2 Gb of data, but it's the Enterprise Edition!
That's happening in a server where I have also installed the MSDE. Could it
have something to do with that?

Please help with a syntax error I receive with trying to BCP in a text file.  
Using BULK INSERT from Query Analyzer (SSMS)  the working syntax is:
BULK INSERT [server].[dbo].[tableone] FROM '\\server\share\fileone.pipe
WITH(TABLOCK,CODEPAGE='RAW',DATAFILETYPE='char' ...

   I am running into this issue and the work around describes does work,
but since I am dealing with large databases (300GB+) this is not a quick
process to run and  since these indexes are not part of the normal schema, I
can not keep these clustered indexes on as a long term ...

Ho can I restore 2 databases from an old SQL 2000 server to a SQL 2005
server, on a different hardware server? I guess I do not need to touch
the master database.
Thank you, T

My indexes are rather large, and I do bcp imports daily of 500K to 1M
rows on certain tables.  I've noticed that my applications will run
slow on the newly imported data, and I've also noticed that if I
recreate the indexes, the application will run fast again.

I first tried to upgrade the default instance of our SQL Server 2005 SP2 from
the Standard Edition to Enterprise Edition from the CD and I got the
following message:
“Edition Change Check (Warning): To change an existing instance of Microsoft

I have a table with indexes on multiple columns, Does a UPDATE query
that modifies one of the indexed columns affect the other indexes
(does it cause the other indexes getting updated)?