We installed sql 2k sp4 name instance over sql 2005 default. When I
resigister the sql2000 server, It give me error says that I need sql2005 to
register.
I did in sql2005 for the sql2000 name instance. It shows sql2005 dbs... any

I'm testing a query which in a certain circumstance performs poorly, on
a 1.5GB SQL Server 2000 db. It takes about 28 seconds to retrieve zero
rows from a join of 5 tables. In task manager I can see it causes SQL
Server to read 330MB of data.

I really need this question answered so I edited my post.
I have this complicated CREATE VIEW query at the end of my post, but
to make it
simpler I  lifted out the one LEFT JOIN  I'm looking at.

I have a very large database with about 20 filegroups. We want to consolidate
down to 3 or 4 file groups. My question is how can we do that in TSQL? I am
trying to do it during a restore but have not found a good solution. I can
create the filegroups and new files but have not ...

We have a sharepoint server which runs our website (sql server 2005 SP2).
Can I use use it to generate reports (Using sql server reporting services
2005) from other databases and also to collect performance stats from few
other sql servers using SQLH2. Should I use a seperate ...

Is there a guide to troubleshooting SQL 2005 performance or "Best Practice
for?".
We are running into issues in a clustered environment, and I want to perfmon
it, but want to make sure I'm catching the right thing.  It's slow with 2

I *just* added a SSMS Project to Source Safe. It was one of many in the SSMS
Solution. I close the solution then re-open it and get the following error:
The project file C:\<...>\My Documents\SQL Server Management
Studio\Projects\xxx.Db\xxx\xxx.ssmssqlproj is not bound to source ...

This counter is the % of log reads that were satisfied from the log cache.
The log cache is used to hold information that will be written to the
transaction log and also used when the log information that has recently been
written inot the log cache is read.

Eample:
CREATE Table AssociateTbl
(
   ClientA BIGINT NULL REFERENCES ClientTbl(Id),

Over the course of the past 6 months, I have experienced an issue where an
executing job fails reporting the error message:
"Step 1 of job '<job name>' (0x559E576215752743B5F8789EEF8CC185) has caused
an exception in the TSQL subsystem and has been terminated."

I am having a very difficult time trying to figure out how to write a script
for a SQL backup. I will try and explain what I am trying to do.
The majority of our computers out at customer sites are running access
databases, however a few other computers are running on a SQL ...

I am trying to create a stored proc to get the last modified date of
a .BAK file stored on the server.
Can anyone give me some pointers...

Hi!  I'm using C# on VS2008 to build an app and sending the query in a
C# string.  I'm using SQL Server 2005.  I'm actually new to both C#
and databases in general.  Most of the examples I've seen (and there
are a LOT!) are inserting a row from one table to another by checking

I want to be able to select the first child record from a bunch of
parent records, e.g.
I have order header records, each order header has a number of order
lines, each line in an order will be for a different amount of money.

I backed up two DBs on Server1.  Created two new DBs (same name) on Server2.
Restored (overwrite) over the two new databases on Server2 with the .BAK
files I created on Server1.
This is the way I always move DBs and I have never had any problems before.