I am having an issue lately where users are unable to add to any table in
one of the databases on the SQL 2000 server for a while, but then out of the
blue everything starts working again.  They are just doing a simple insert
of a record at the time.

Hello to all,
I have SQL Server 2005 SP2 9.0.3054.
I have KILLED a SPID 93 7 days ago, but this spid has the Status:
KILLED/ROLLBACK, WaitType: OLEDB.

I'm trying to migrate some date from MSDE to SQL Express 2005. Its a very
large transacation and its failed because of this error message. I've set the
database recovery model to Simple.
The transaction log for database 'XXXX' is full. To find out why space in

Is it possible to move a database from SQL Server 2000 Standard to SQL
Server 2005 Express?
We have a 3 GB database with some historical information that we need to
access from time to time.

I am trying to write a cursor that can look at the specific column in
a table and replace a portion of test with something else.
I am getting two error messages:
Server: Msg 170, Level 15, State 1, Line 12

Here is the sample of the data from one column(ClassDID) in my table
(CLASS):
DB1-A07\CASCLASS_DATA
DB1-A07\CASCLASS_SUB

Does anyone have recommendations for books that have good coverage of SQL
2005(8) Database Mail?

I have a failover cluster based on win 2000 AS machines and SQL 2000 just
upgraded to SP4 a couple of days ago.
Under normal conditions things seems to be good but when many jobs (dts,
stored procedures and so on) are running together much more time is needed

I am very new to MSSQL Server. Recently, I've found some problems with
my Rebuild/Reorganize Index Task.
I can find the following in the error log. Can anyone tell me how may
I solve the problem?

Can Anybody tell me What are the defualt permission Public Database role has?
Thanks

Guys
I have a 120 user network (which may well grow) and am wondering what the
reccomendations are for SQL Server in relation to Microsoft Office
SharePoint Server 2007.

We have set up a test server that has SQL 2005 on it.  If we restore backups
of our SQL 2000 databases from our SQL 2000 server into SQL 2005 on our test
server, will this upgrade the databases to 2005?  Or, do we need to go
through an upgrade "process"?

Can anyone shed more light on this error, or do I need to supply more
information:
 [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionCheckForData  
 (CheckforData()).

I'm using a server side trace with roll-over to log the activities on a
SQL 2005 server.
This generated huge traces.
When I try to load the report files with ::fn_trace_gettable onto

I have an IP-Location database with columns
FirstIP bigint
LastIP bigint
Country char(2)