I installed SQL Server 2005 Express in a computer to replace MSDE. Now I cannot connect it on my SQL Server Group with Server Enterprise Manager. Thanks ...more >>

After upgradeing an existing MSDE instance to SQL Server express a backup won't work. When using the following statement: "Backup Database APPDBTo Disk='C:\Data\Archives\APPDB.bak' With Init" we get the error "Invalid column name 'mirror_count'". If we rebuild the MSDB by running instmsdb.s...more >>

Hi there Is there a specific newsgroup for SQL Server 2005 Express? Or is the newsgroup to use? Thanks Stephen ...more >>

Hi , I have this distribution database (created via replication setup). I have set aside 200 MB for data file in E:\ drive & 20 MB in C:\ drive for log file using simple mode recovery on the properties --> General tab of distribition it shows Size : 220.00 MB (from the data + log file) ...more >>

Hi, I am running SQL Server 2000 sp3a , standard edtition. I have ran a dbcc showcontig that shows the following : DBCC SHOWCONTIG scanning 'tb_Options' table... Table: 'tb_Options' (1079674894); index ID: 1, database ID: 6 TABLE level scan performed. - Pages Scanned......................more >>

In SQL Server 2005 Express the follwoing query produces the wrong result: SELECT CHANNEL, DURATION, STARTTIME FROM Recordings WHERE (STARTTIME > '12/27/05 00:00:00') AND (DURATION > '5') ORDER BY STARTTIME DESC If I replace it with: SELECT CHANNEL, DURATION, STARTTIME ...more >>

Hi, I wrote an application in vb6 to install sql service pack 3a. I am running this application from a cd. When I execute the setup from the application, I get prompted to close the application that called the setup exe. Then, the setup continues after I close the application, but the service...more >>

Hi, I used the DBCC SHOWCONTIG on a database and it shows : DBCC SHOWCONTIG scanning 'sysobjects' table... Table: 'sysobjects' (1); index ID: 1, database ID: 8 TABLE level scan performed. - Pages Scanned................................: 4 - Extents Scanned..............................: 4...more >>

Hello all I write a program that use sqlclient to connect to SQL Server 2005 Database so how can i run this program on a computer that SQL Server 2005 is not installed on it cause it's too much for the customers to install SQL Server 2005 express edition it takes too much time and space i t...more >>

Hello all, I connect to SQL server using SQLDMO to update the database and make many Other tasks. I installed SqlServer2005 on a test server and I got an error using the connect method of SQLDMO. Is SQL Server 2005 is 100% compatible with old SQLDMO? How to make it working with the SQLDMO, re...more >>

Administer SQL Server express? I installed it and now what? How to view/browse/create databases? Any visual tools? ...more >>

Hi All I have a statement table which stores customers latest statement details and I retrieve them with the code below I am using MSDE 2000 maxmonth, maxfn, maxweek are calculated dates sql = "Select * from [stheader] inner join [customer] on customer.[cust_code] = stheader.[cust_code...more >>

Hi All I have a statement table which stores customers latest statement details and I retrieve them with the code below maxmonth, maxfn, maxweek are calculated dates sql = "Select * from [stheader] inner join [customer] on customer.[cust_code] = stheader.[cust_code]" & _ " wher...more >>

I installed MS SQL Server 2005 Express edition. But couldnt find SQLServerAgnet Service.... Dhiren ...more >>

Hello. How can I receive the ISO 8601 week format retrevied from a Date object of SQL? I now use : DATEADD(d, -1, DATEADD(ww, DATEDIFF(ww,0,stamptime), 0)) wo get the week of the year, by this returns the first week of the year as where 1 of the month is, also each week starts with sunday ...more >>

C:\osql -E [SQL Native Client]Named Pipes Provider: Could not open a connection to = SQL Server [2]. [SQL Native Client]Login timeout expired [SQL Native Client]An error has occurred while establishing a connection = to the server. When connecting to SQL Server 2005, this failure may be = caus...more >>

Hi All I am trying to install MDSE SP 4 for BCM V2 and get the message setup failed to configure server.This is what the confsgvr.out states An error occurred while attempting to start the service (1460) SQL Server configuration failed. I have already tried renaming the SQL folder and...more >>

I was looking at the install requirements for SQL Express. It says that the 1.2 runtime must be uninstalled to use it. Is that true that the 1.2 and 2.0 frameworks can't co-exist? Can Express be used from a 1.2 app, or must we switch to 2.0? I need to update a single user with our curr...more >>

Hi, I have subscribed to SQL Mag and in it it says any ques i can post to savvy@sqlmag.com but the problem is i have tried email my ques to them before but so far nobody has ever replied my queries(and it has been several months.) Have anyone faced this before or the above email addr i...more >>

Hi, Is there any security updates/patches for SQL Server 2000 or if there's it's actually part of the windows updates as well ? kindly advise if there's such website where i can get these updates for SQL Server 2000 tks & rdgs -- Message posted via SQLMonster.com http://www.sql...more >>

Are there ways to tell if MSDE 2000 is current and patched on a Windows 2000 SP4 server? We have scanned it with MBSA 2.0 and it doesn't say that SQL 2000 SP4 is needed (or that it's the latest SP available), and we are pretty sure it's NOT at SP4 yet. Thank for any help. ...more >>

Hi, I'm using a Recordset with UseServer and Keyset cursor. It works fine except when I ask about record count. Then my application raises this message "sp_cursorfetch: Value of parameter 'nrows2 is invalid" What can I do to solve this? ...more >>

I successfully installed MSDE, but I cannot open the application. All my files and folder are installed under: C:\Program Files\Microsoft SQL Server\MSSQL$NETSDK. My operating system is Windows XP Professional and my Internet Explorer is version 6.0. What do I need to do? Please advice. ...more >>

Hi, I would like to know the following : 1. During replication , is the data being transmitted in binary format 2. where do i get to check the size of the whole replication(in bytes/KB) ? 3. where do i get to check the size of a single table being replicated (in bytes/KB) appreci...more >>

When I try to install MSDE 2000A, using "setup /L*v error.log SAPWD="password" SECURITYMODE=SQL DISABLENETWORKPROTOCOLS=0" I not only get a log file for the msde setup, but I also get a log file in C:/Windows, setupapi.log, that starts with Executing "C:\WINDOWS\system32\setup.exe" with com...more >>

Hi! I know that the default instance of MSDE is the computer name. If the computer's name is subsequently changed, will the default instance’s name change to the new computer name as well. Thanks for your thoughts....more >>

How to make SQL Server Management Studio Express (SSMSE) CTP to start when SQL Server Books Online is also installed? SQL Server Management Studio Express CTP is starting at once when SQL Server Books Online is removed from Control Panel/Add or Remove Programs! :( I'm using the latest, tod...more >>

Hi, Is there a Reporting tools in SQL Server Standard Edition ? or it's actually refering to the Analysis Services ? tks & rdgs -- Message posted via SQLMonster.com http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-msde/200512/1...more >>

Hello - I downloaded everything and installed MSDE (I'm running Windows 2000 Professional). I can see the instance I installed on my local C drive. When I click on the icon for Sql Server Service Manager, and click down on the arrow, there is nothing in there; there also is nothing under...more >>

I haven't installed this yet but does anyone who has have any comments on the pros and cons vs. SQL2005 Express? Also, does it have any graphical management tools (analogous to Mgt. Studio Express)? Many thanks. ...more >>

Hello. Our company is running an application that uses the MSDE 2000 (SP4), to load large amount of data using bulk inserts. The sqlservr.exe process increases from the 4-10MB that it starts with to 80-100MB after all transactions has been completed. When starting a new transaction sessio...more >>

I have created a user in SQL Server Management Studio Express. However, whenever my ASP.NET application tries to connect I get the error Cannot open database "ABC" requested by the login. The login failed. Login failed for user 'Fred'. If I change my login string to Integrated Security=SSPI ...more >>

I built a server that will have three applications that require MSDE 2000. We do not have a SQL server. The apps are SharePoint Services, NAI's ePO and Veritas' Backup Exec. Can all three applications use one copy of MSDE? This is a small shop, so there won't be incredible load on the server. ...more >>

I have a database file which is close to the 2048MB limit, but not there yet. I am trying DELETE FROM TABLE many of the tables so that I can shrink it and get under the 2048 limit. When doing this, I get errors that ALTER (?) would put me over the 2048MB limit..?? I have many full blown...more >>

Hi everyone, We have a requirement to distribute a database with our client-server application. From a database perspective the application is not particularly complex. We have a couple of servers that need to connect to the database using ODBC (none of the clients will connect to the databa...more >>

We currently have SBS 2003 Premium running on a dual processor system. I checked the requirements and SQL Server 2005 Express will load on SBS 2003 Premium, but what are the limitations? Will my dual processors prevent me from running Express? I only want to host my own internal apps, but...more >>

Can we have MSDE and SQL server on the same machine?...more >>

Hello, how can I lock a record? it must be modified only for one user at the same time. Thansk in advance. William GS...more >>

Can one put an MSDE database on a network share that is under the Linux OS (while MSDE is on a Windows TS server). AA ...more >>

MVP on the Outlook 2003/BCM group suggested I bring this question to SQL server msde: I have a partitioned drive with the "C" partition holding only system files and enough room for a manually sized swap file. Therefore, I need to have the BCM database files reside on the "D" partition. H...more >>

I have an MSDE database running on a PC for the Microsoft Retail Management System. In the connection configuration on the local PC where the database is, the only way I can get it to work is to put a period in as the server location. The IP of the PC is 192.168.0.112. If I put that IP in as t...more >>

I have local copy of MSDE 2000 on an XP workstation. My program has already been reconfigured to point to a remote (from the XP viewpoint) SQL 2000 server. As such, it has created the 2 databases that it uses and is already populating those databases with data. The question is, how do I g...more >>

I'd like to produce HTML reports from my MSDE tables. Can I write a Stored Procedure to return HTML code as a file from MSDE? If possible, a short example would be appreciated....more >>

Is there any books or website that will explain in depth about OSQL. Thanks. ...more >>

Hi, I experience a problem after installing "SQL Server 2005 Books On Line" (December 2005) on my notebook, which have also an installation of SQL Server 2005 Express Edition. Management Studio Express Edition (November CTP) don't start... If I try to open it, nothing happens. Anyone can help m...more >>

I have no problem connecting to MSDE using TCP but not nameinstance. Any idea why? ...more >>

Hi, If i have some data on a table that's being deleted by an application and i did not do backup but the recovery mode is "Full Recovery" can i somehow get back the data ? i know there's a deleted/ (created or updated) table but that's wtithin a session isn't it ? appreciate any a...more >>

Hi, I have just installed MSDE 2000a on my XP-Pro system because I need it to install another application. I installed with the options sapwd and instancename. The install completed and I rebooted. Now the SQL Server Service Manager is showing up as "Not Connected - \\". When I click on the...more >>

Pardon me if this is not the group for SQL Express. There wasn't a choice for it so MSDE was the closest. I have a problem where SQL Express stops running and won't start. The only solution I have found so far is to uninstall SQL Express and reinstall it. There has got be a better way or so...more >>

I am using VB6 to install MSDE and here is my syntax. Setup.exe INSTANCENAME=NK SECURITYMODE=SQL SAPWD=NKM It will install and show the progress bar all they way to about 4 second left then freezes up. The log shows this as the last thing it did prior to locking up "Executing "C:\Program...more >>