Archived Months
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
all groups > sql server msde > august 2006 > threads for august 8 - 14, 2006

Filter by week: 1 2 3 4 5

How to import odbc data into msde 2000?
Posted by CharlesC at 8/14/2006 5:38:25 PM
Hello, I have a database which uses the odbc microsoft dbase driver, how do I import this into msde 2000? Thanks, CharlesC. ...more >>


indexed views & jobs
Posted by Keith G Hicks at 8/14/2006 1:36:17 PM
One of the charts on the MS site that compares SQL editions indicates that SQL Express supports the creation of indexed views but not something with "query matching" that I don't understand. I've spent the last couple of years workign on a project that should be able to use MSDE 2k. We're ...more >>

msde installing problem without a number problem...
Posted by Baruch Ortiz at 8/14/2006 10:06:21 AM
Hello: I'm trying to install the MSDE in a server that only needs the engine of SQL that it works properly, furtunelly, I have a preproduction environment, in the preproduction evironment the MSDE is installed without problems but in the production environment doesn't finish the instal...more >>

issue of backup database on upgraded SQL2005 Express
Posted by William at 8/14/2006 9:06:02 AM
Hi there, After upgrading the MSDE2000 to MSDE2005, I ran the sql "backup database mydb to disk = 'c:\temp\mydb.dmp'". However, I got some error message like "Msg 207, Level 16, State 1, server ..., Line 1" "Invalid colum name 'mirror_count'" I checked the msdb, there is no system...more >>

MSDE Localization
Posted by RitaK at 8/13/2006 11:26:01 PM
Hi All, I have searched the newsgroup for localizing the MSDE Setup.ini by country code, eg. 1033 for the US. My question is, if I want to deploy my application to many different countries, how would I go about supporting 20 plus countries. Surely there has to be a more elegant way than l...more >>

Performing query 10 times faster over internet
Posted by Ronald at 8/12/2006 8:45:30 PM
Hi there! I have a Sql Server 7 running on a webserver. Now I have a quite complicated query that I run on 4 ways. 1: Using ODBC-driver directly on the Sql Server. time to execute: 12 seconds (done this about 10 times) 2. Using OLEDB-driver directly on the Sql Server. time to execute: 12 ...more >>

Concurrent connections MSDE in XP
Posted by jmeykos at 8/11/2006 8:18:41 AM
I need to increase the number of Concurrent connections in Windows Xp because give a error if a run my application en with MSDE. I think that in the Registry exist the option Somebody help me Please...more >>

Msg 3270,An internal consistency error occurred
Posted by Randy Fraser at 8/10/2006 10:45:32 AM
Please help I am unable to find a resolution to the following: Server: Msg 3270, Level 16, State 1, Line 1 An internal consistency error occurred. Contact Technical Support for assistance. Server: Msg 3013, Level 16, State 1, Line 1 RESTORE DATABASE is terminating abnormally. I have a M...more >>



Serializable Isolation Level
Posted by Sapnil at 8/10/2006 1:48:01 AM
Hi, I have one question regarding Serializable Isolation level. Consder the following scenario Two concurrent transactions T1 and T2 read the same row Row1 - T1 reads Row1 at X sec and - T2 reads Row1 at X+0.1 sec Now T1 modifies Row1 and tries to save the row also T2 modifies Row1 and tri...more >>

SQL 2000 & 2005 on the same server
Posted by Dave at 8/9/2006 10:07:26 AM
I have a client which is using SQL 2005 Express (for WSUS) and is now looking at a package which uses MSDE 2000. Can I put it on the same server? Any help is greatly appreciated! Dave ...more >>

How do I find out SQL Server instance name and username?
Posted by achen at 8/9/2006 8:53:12 AM
I have an application that uses MSDE 2000, I just obtained a free 3rd party tool trying to manage the database a little bit toward what I wish it to be. However I do not remember the "SQL Server instance name" and "username" when MSDE was installed with this application, is there any way to fi...more >>

Administrator Access
Posted by andrewmaksyd NO[at]SPAM hotmail.com at 8/8/2006 8:59:59 AM
Hi, I have installed SQL 2000 MSDE and the Web Data Administrator tool. I was able to create a new database and added new column etc. However when I come to create a new user I cannot see any of the security options under server tool. Can anayone assist please??? ...more >>


DevelopmentNow Blog