| SQL Server (view all ...) | Last Post | Replies |
|
| Re-attaching database | 01 Dec 2008 19:57 GMT | - |
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>
|
| Best practices for error handling in SQL Server procs | 01 Dec 2008 19:56 GMT | 24 |
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---------------
|
| check sql mail log | 01 Dec 2008 19:44 GMT | 2 |
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?
|
| SQL Server to Microsoft Exchange | 01 Dec 2008 19:23 GMT | 5 |
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...
|
| Database Mirroring not synching till I open Mirroring Monitor | 01 Dec 2008 19:19 GMT | 5 |
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
|
| Adding memory has degraded performance | 01 Dec 2008 19:14 GMT | 3 |
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
|
| Odd Identity Behavior in Enterprise Manager | 01 Dec 2008 19:06 GMT | 1 |
I have noticed a weird issue with a very simple table in Enterprise Manager, The Table structure is, CREATE TABLE [dbo].[Departments] (
|
| Query File Growth Properties | 01 Dec 2008 16:56 GMT | 1 |
Is the a stored procedure or SQL statements to query to the file growth properties for a database? Mark Atlanta GA
|
|
| MSDE (view all ...) | Last Post | Replies |
|
| SQLEXPRESS: Login failed for user 'sa'. Reason: The account is disabled. | 27 Nov 2008 19:56 GMT | 2 |
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
|
| SQL Server 2005 Express slow comapared to MSDE? | 21 Nov 2008 09:37 GMT | 3 |
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 ...
|
| Strange sorting | 20 Nov 2008 21:03 GMT | 2 |
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.
|
| MSDE 2000 and SQL Server Express 2005 on the same PC | 19 Nov 2008 18:55 GMT | 6 |
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 ...
|
| Schedule to backup MSDE 2000 to overwrite the previous file | 07 Nov 2008 21:08 GMT | 4 |
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,
|
| MSDE upgrade to SQL Server 2005 | 28 Oct 2008 12:28 GMT | 1 |
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 ...
|
| MSDE and Windows 2003 | 11 Oct 2008 10:43 GMT | 1 |
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 ...
|
| Delete Query SQL? | 10 Oct 2008 17:10 GMT | 1 |
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,
|
|
| SQL Server CE (view all ...) | Last Post | Replies |
|
| How to Direct connect with ActiveSync | 01 Dec 2008 19:37 GMT | 6 |
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
|
| Corrupted databases | 01 Dec 2008 15:12 GMT | 6 |
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.
|
| Sql Compact 3.1 desktop and Sql Compact 3.5 desktop on the same PC | 01 Dec 2008 15:08 GMT | 5 |
Can Sql Compact 3.1 desktop and Sql Compact 3.5 desktop live side by side the same PC? Thore Berntsen
|
| Support for compression? | 01 Dec 2008 09:59 GMT | 3 |
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
|
| Connections usage in a multi-thread environment | 27 Nov 2008 14:53 GMT | 2 |
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
|
| SQL SERVER CE Could not load database compaction library <4a33b595-97d8-4f82-b0bd-fe30ae17aca1@t54g2000hsg.googlegroups.com> | 26 Nov 2008 19:24 GMT | - |
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 ...
|
| rda.Pull ACCESS DENIED | 25 Nov 2008 23:54 GMT | 2 |
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
|
| Errors using DEFAULT constraints | 23 Nov 2008 18:53 GMT | 1 |
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
|