I recently took responsibility for a sharepoint 2003 server & corresponding
SQL 2000 server.  The backups are working through a maintenance plan, but
I'd like to implement a richer plan and am having difficulties developing
the best approach.  understand I've not done much care & ...

I have tons of short SPs being called all the time.  The # of milliseconds
on each matters and I'm at a point where pulling data from the hard drive
slows down the operation more than anything.   I've done tuning, etc.    So
if I get more RAM on a SQL Server 2005 than the size of ...

Using SQL2k EE SP3
There's a spid in the activity monitor that has a Last Batch date of
1/1/1900 12:00AM however, the logged In date is recent.  What could cause
this to happen?

A system that houses an app and it's database was restored.
The database called testdb has a user called testdbuser.  When I check
the users for this db - it shows testdbuser - the properties show the
Login Name as <none> after the restore.

We are using SQL Server 2000 (latest SP) on Windows Server 2003.
Recently we made database changes where we deleted a number of columns from
the highest level table in our database hierarchy (every other table is
either a child or grandchild of this table).

I am trying to figure out how disk space is used when overwriting backup
files.  Here is a description of our situation...
We have a 700+GB reporting database (SQL 2000) that we backup weekly to a 1
TB drive.  This has worked fine for quite a while but we have seen the

I have: One server with Win2003 Sp1 and SQL 2000 Sp4.
Are there any known problems with applying Windows Server Servicepack 2?
I currently have problems and needs to If this can be a problem based on
known issues that IM NOT aware of.

I hope I am giving the right information here to get help with this.
I am trying to get information from two tables that are in an access
database over to sql 2005.  I did this via DTS and saved the import options
as a file, but when I run this as a job I get the following error: ...

We have an OLEDB provider written using C++ and the OLEDB templates. It
works fine under SQL2000 and SQL2005 SP1 but in SP2 we get the following
error
OLE DB provider 'CAMEOProv2.CAMEOProv' cannot be used for distributed

I've just received a new machine to add to my 3-node SQL Cluster on
which 2 instances were installed.
I've only installed one of the two instances on the new server because
the second instance will surely dissappear.

I'm using two cursors in the same proc.
Do I need to reset @@FETCH_STATUS before using it to check the status of the
second cursor? If so, how can this be done.
Many thanks for your answers in advance

Morning everybody,
I'd appreciate if anybody could give any help with problems getting
databases back online when i just have the .mdf file
I lost the TLOG virtual drive yesterday (had a fatal problem with the

We just started using DPM 2007 to backup our 2005 DB's so I am deleting the
backups in the maintenance plans. Should I go back in and have any regular
maintenance on DB's like Shrink or Reorganize or is just backing up using DPM
ok?

Let me correct that. The data part of the database is also corrupt. Is there
a way to delete the corrupted part of the data base and try a partial
recovery?

I'm a developer using SQL Server Express to a vb.net application.  On regular
occasions I get a query that normally returns in less than a second, timeout
(90secs).  Searching forums I noticed a lot of other people of the same
issue, but without resolve.  People mentioned the ...