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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
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 >>
|