A database was generating some problems because of disk place, so I detached
it and move the files to another location. However when trying to re-attached
the database, I receive an error message:
Error 3624 : 1450 Transactions rolled forward in Database <xxx>

One of our clients has just developed a set of coding standards for their
.NET and SQL Server application development. For the SQL Server standards,
they say the following regarding error handling:
-----------start of quote---------------

I have a sql2000 server, one of the stored procedure runs every day to send
emails out using sql mail. I want to find out the sent email list or log. In
sql 2005, they are stored in the dmv, where can I find on sql 2000? Is there
a table recording this?

I'm not sure if this is the right group, but I'm looking for information on
how to get our Contacts database (which is in SQLServer) into a Public
Address book on Microsoft Exchange.
I trawled the net and found the following article on SQLServerCentral...

   I'm rather new to mirroring, I had to setup the princible and the
mirror using certificates per the example in BOL. I am using
asychronous mode. Everything looks good till I launch the Database
Mirroring Monitor. In the left hand side it will say Time to Send Log

Hello Experts
We have an active/passive failover cluster running on some decent IBM X
Series servers, quad x64 Xeons with 16 Gb of RAM.
We upgraded each server to 64Gb.  As the server started eating into the new

I have noticed a weird issue with a very simple table in Enterprise
Manager,
The Table structure is,
CREATE TABLE [dbo].[Departments] (

Is the a stored procedure or SQL statements to query to the file
growth properties for a database?
Mark
Atlanta GA

I've installed Visual Studio 2005 professional with SQL Express Edition. A
third party app needs to use it. When installing, it's asking to login as
'sa' user.
I've enabled MIXED MODE in Registry and reset the 'sa' password with

We have an application developed in .NET 1.1 (Visual Studio 2003).
The application has been using MSDE as the database engine until now. Since
MSDE won't be supported on Vista we've tried SQL Server 2005 Express instead.
But the performance of 2005 Express is way slower than when ...

Currently I am using MSDE.
If I want to order some items the output makes no sense to me.
I have a table with 3 records.
Each record has a column (varchar data type), which holds 1, 880 and 2200.

We have Windows XP Sp2 desktops running an application that uses MSDE 2000
(version 8.00.761). If I install another application running MS SQL Server
Express 2005 and it will then the application running MSDE 2000 stops
working. So I install again MSDE 2000 then the application ...

I am try to backup MSDE database with the following command:
OSQL -E -Q "BACKUP DATABASE MYDB TO DISK = 'C:\MYDB.bak'"
It works, however, once I use windows scheduler to schedule to run the
script daily,

I have a Software product that installed the MSDE database engine with its
product.  The database this software product created is a SQL Server 7.0
database. The database is now causing some issues due to size and performance
issues so I trying to upgrade to SQL SERVER 2005 and ...

I am trying to install MSDE on a Windows 2003 server and after I extracted
the file in the default path, C:MSDEReIA, I ran the setup.exe file.
I get the following message: A strong SA password is required for security
reasons. Please, use SAPWD switch to supply the same. Setup ...

Changing some legacy data around to make it compatible to a new system and
need to delete a bunch of duplicate records.
Got the select working here:
SELECT     fc_main1, COUNT(fc_main1) AS No_Recs, cd_complex, cd_plant,

I hope someone can help me on this one it is driving me crazy.
I have Mobile 6 device connected to my desktop computer through a wire ,(NOT
wireless, repeat NOT WIRELESS) useing ActiveSync.
What I need to do is have the device connect to the SQL Server 2000 database

Hi. all.
Using my sqlce based application (based on vs2005 + CF 2.0..) as lot
of users have trouble about sqlce file corruption.
My app is very simple and uses a little database with 5 tables.

Can Sql Compact  3.1 desktop and Sql Compact 3.5 desktop live side by side
the same PC?
Thore Berntsen

planning to use SQL Server CE 3.5 on Windows CE 5.0. I wonder if either
SQL CE or Windows CE supports some kind of compression of the database file?
Thanks,
Thomas

Env.: SQLCE Mobile 3.5 / WM6 / CF 2.0
Hi All,
My app makes extensive use of SQLCE.
User operations (foreground thread) use a connection object that stays alive

I'm getting a very similar problem, has anyone come up with a solution?
I'm using SQL SERVER COMPACT 3.5 in my program but i'm getting the error "Could not load database compaction library" when I try to compact my DB.  All the cabs (repl) are loaded and The DB compacts ok on ...

Folks,
I'll try asking this question again, as my previous post got no response.  
I am trying to do an rda.Pull from a SQL Server 2005 (SP1) database to a
Pocket PC.  This worked just fine from SQL Server 2000.  However, I am now

We have an application (Desktop) that has been using SSCE for quite some
time (Since version 2.1, but we upgraded to 3.5/SP1). Up until yeserday,
I had never encountered this particular problem. I have to say I'm
completely baffled by what this error tells me. I have specified a