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 ...

I am woking in a database that is new to me. There is a table with 1.5  
million rows. There is no primary key or unique index. There is an index with
the first column an integer and the second a varchar(60). There are only
eight possibilities for the integer and the value 2 ...

dear sir/madam
  When I open enterprse manager and wants to change some record and
try to save then it gives a messaage
Transaction can not start while in firehose mode.

We have some performance issues on our db server memory on the box is 32GB. I
am looking out for perfmon counters what is the value should for both memory
grants pending/memory grants outstanding?
Memory grants pending the value seems to be 0 for this counter