Should this be an issue? My system was working fine before I renamed my system (host), but since I have renamed it, my application is working from a remote system. From the local system (the machine where the MSDE is running) the app is working fine. Any ideas? - manzoorWith MSDE 2000, if you rename the host then the name of the SQL Server will follow the name of the host. Make sure your remote client is connection to the new name. JimYeap, it's working fine now. Even though I am not doing anything different. I had expected teh new name to be required and was trying to use it initially. Maybe it has something to do with using DHCP, but I'm not sure. Anyway, I realy do appreciate your reposnse. - manzoor
Hi All. How does file locking work in MSDE? Coarse grained, fine grained? ChrisHi Chris, Exactly the same as in SQL Server. Locks are applied at the row level but can be escalated up to larger objects if needed. So, yes, fine grained. HTH,
( action_id int NOT NULL default '0', database_name varchar(20) NOT NULL default '', username varchar(15) NOT NULL default '', password varchar(15) NOT NULL default '', PRIMARY KEY (action_id) ); Field 'database_name' stands for the DB name used by ODBC (In my Java application I'm using ODBC, to connect to particular DB). So when I'm adding a record to this table, for instance: 1, "MySQL", "root", "password" ODBC || MSDE || JDBC changes the values by adding free space to fill all the field's spaces (Instead of "MySQL" it adds "MySQL "). It seems like some component doesn't understand that I'm using varchar(20), not char. For instance, when I'm
I can't install MSDE release A in Windows XP SP2. I verified if Server Service is started and it is ok. I also verified if File and Printer sharing is checked on network properties and it is ok. The windows firewall also is disabled but the instalation doesn't work. I run the follow comand setup.exe sapwd="suportebsb." /L*v C:/MSDELog.log. Anyone can help me? Cicero Galdino ******** This is the lastest lines in log instalation files ******************* created. skipped. request from Service Control Manager.hi Cicero, please inspect your C:/MSDELog.log for RETURN VALUE 3 entrie(s), that reports exeptions duting the install process about 10/15 lines before each entry some (sometime cryptic) descritpion of the problem will be available
Hi, I'm using SQL Server MSDE RelA (BackEnd) Access Project (FrontEnd). I need to Duplicate a record from a form and the linked records in its subform. Parent form duplicate goes to table "Jobs" where JobID is the key, records from subform with (Link JobID) go to table "Samples". I've created an update query in order to do this and I'm getting the following error-message: Cannot insert explicit value for identity column in table "Jobs" when IDENTITY_INSERT is set to OFF Do I need SP4 Service Pack SP4 or am I doing something wrong? Is there any other way to duplicate these records?Sorry, I've meant "append query" not update
would have to check table2 and 3 for the existence of that id. I searched the net and didn't have any luck?? I think a trigger would work to kick off the process but not sure how to create the procedure to search for the existence of a record id. Any help would be appreciated. - robhi Rob, SET NOCOUNT ON USE tempdb GO CREATE TABLE tableA ( ID INT NOT NULL PRIMARY KEY , Name VARCHAR(10) NOT NULL , Country VARCHAR(10) NOT NULL ) CREATE TABLE tableB ( ID INT NOT NULL PRIMARY KEY , Name VARCHAR(10) NOT NULL , Country VARCHAR(10) NOT NULL ) CREATE TABLE tableC ( ID INT NOT NULL PRIMARY KEY , Name VARCHAR(10) NOT NULL , Country VARCHAR(10) NOT NULL ) GO CREATE TRIGGER tr_I_tableA ON tableA FOR INSERT
I using MSDE and it works fine in winXP and Win2000. Now im trying to work with Win98 and it gives me this message "Login Fail for user Null - Not associated with trusted SQL" Can somebody help me? :)Sounds like you have only enabled windows authentication, but are trying to connect with a non-authenticated user.How do you authenticate the user? but are trying to
;#39;20040103') INSERT INTO dbo.ColNames VALUES ( 1 , 'dbo.TableX' , 'Name') INSERT INTO dbo.ColNames VALUES ( 2 , 'dbo.TableX' , 'Id') GO --------------- PRINT 'SELECT (SELECT ColName FROM dbo.ColNames WHERE ID = 1)FROM dbo.TableX' PRINT 'this only return a single row but the SELECT list must be a constant indeed' SELECT (SELECT ColName FROM dbo.ColNames WHERE ID = 1) FROM dbo.TableX -------------- DECLARE @Columns VARCHAR(20) SET @Columns = '' SELECT @Columns = @Columns + ColName FROM dbo.ColNames WHERE Tbl = 'dbo.TableX' SELECT @Columns DECLARE @cmd VARCHAR(100) SELECT @Cmd = 'SELECT ' + @Columns + ' FROM dbo.TableX WHERE
How replicate a db in msde? RV
advice. Can anyone tell be if the following is feasible. I have a record in a database that a user updates over a web interface. The updated record is sent back to the MSDE database. I would like to use a trigger event to prevent the original record from being changed and instead create a new record with the updated information. The 'inuse' flag of the original record would be set to false, and set to true for the new record. What I would like to do is in the Trigger call a stored procedure which creates the new record and then cancels the original update. Can this be done? Also can I pass the contents of the virtual table 'inserted' to a stored procedure? If I can, can I pass them 'as one' into a custom type in my stored procedure or will I have to pass
Hello, Several consecutive records have been deleted out of an MSDE database and the program that uses the database doesn't like it. I'm curious if it's possible to say reset the primary key count so that the records all shift to fill the "dead space" left by the deleted records. I have the feeling that this may be humorous to some of you, but any input (including "you can't do this. that's the point of a primary key") is appreciated. Thanks! Matthi Matt, you can "reset" the identity value using a DBCC CHECKIDENT with the RESEED option specified.. http://msdn2.microsoft.com/en-us/library/ms176057.aspx
hi well I am working on a project that our database has 2, 8000 record table that they have triggers on the update of their feilds our application must update these tables but it takes a long time to do this I know there is something named bulk insert but I couldn't find sth similar to this command for update so would you please help me to find a faster way to update these tables? thanks for your attention EggHeadCafe.com - .NET Developer Portal of Choice http://www.eggheadcafe.comhi, nope.. update syntax is not overloaded with bulk operators.. if the cause of your delay is dependent on the trigger fired by the update statement, you should perhaps check it's code or if you are sure the updates you are performing do not involve the trigger check, you can
I am fairly new to SQL development and have a question about task I am trying to do. I have a database where by users submit entries into a table on my SQL server. Is there a way I can setup a Trigger on the table so that when a record is added that I can have a process that then email me that this event has occurred? Stevehi Steve, MSDE does not support SQLMail but you can have a look at an SMTP alternative at http://www.sqldev.net/xp/xpsmtp.htm, a free extended stored procedure you can use in your INSERT trigger, you can fire a call to it I do not "support" this design, but you can do it remember that trigger action should be as fast as possible
be about the same as VBScript) First, I create an ADO Connection and create my table. Server;UID=myID;Trusted_Connection=Yes;Network=DBMSSOCN;APP=Microsoft Data Access Components;SERVER=SERVER\INSTANCE;"' This works fine. Then, I attempt to allow insertion into the ID_Field. This seems to work in that it does not throw an error and gives a return of -1. Then I open a Recordset Last, I am attempt to add a record to the recordset with an explicit ID, but this fails with the error of "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done." Even worse, if I now try to set the identity field to allow inserts again, Updating() causes an error that I must use an explicit
Here's the screnario using an MSDE install of SQL Server to run a stored procedure the first inserts a record to a table and then executes the master.dbo.xpcmdshell stored procedure (call from within the insert procedure). This is executed from an ASP.Net web site and it assume a SQL Server login user to run the procedure. That login has Execute rights on the procedure as well as the xp_cmdshell procedure. Any ideas on how to get rid of this error? FYI - I run this procedure in Query analyzer as this user with the same results. However, if i run it logged in as a System Administrator user, it execute fine.hi, you have to check your account running SQL Server Agent permissions http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_xp_aa-sz_8sdm
I have two databases, old database ‘db1’ with data and the new database ‘db2’ empty How can I update the structure of database ‘db1’ to be equal the structure of database ‘db2’ Tankshi Carlos, you can have a look at commercial syncronizations tools like http://www.red-gate.com/sql/summary.htm (and http://www.red-gate.com/sql/sql_packager.htm) or the like, and/or to free tools like http://www.davidemauri.it/dabcos/ , http://www.absistemi.it/sqlCompare.aspx
Hello, I'm trying to add MSDE to my installation program, and so far have been unsuccessful. Right now, I'm shelling out the setup.exe program with the parameters I want, and the install seems to go successfully. However, then I cannot get that instance of MSDE to start, whether by "net start instancename" or running sqlservr.exe from the instance's directory, or running scm.exe from the Tools\Binn directory. Can someone show me the code very much in advance for your help.hi Jason, I install MSDE the very same way you do, but actually I never tried to start the service my self as I always require a reboot, in order to properly register all COM components and services registration after rebooting, the services are available for all my needs..
that contains an auto incrementing integer into Access 2002 via ODBC. Access identifies this field correctly as an "autonumber" field. However, when I add a record to the table, I get an ODBC error that mentions a "Cast" error. In other words, the ODBC driver is translating the field from SQL server (via Cast type function?) but Access thinks that the number can exceed the limit of an autonumber and we get the error. The only work around I have found so far is to link access to a table with the same name and ODBC connection, but where the SQL Server field is just an integer. Access then translates the field as a long integer. Then I replace the SQL table with the one that has the incrementing integer field, but don't refresh the link to Access. Records
the files in between. I have remote access to the server where the Database is, so this morning I've detached the database, replace it with a newer version and re-attached I forgot to change the attribute and I re-attached as "read only". First big mistake. Somebody tried to update a record and the project was "hanging" so they press Ctr+Alt+Del and stop the Access project. The database shows there is still one user connected Trying to fix this, I've stopped the server thinking this will disconnect the user nope. Please help me to fix this mess and learn few big lessons (like never attach a read only db) How can I connect the Instance again? The service manager is not letting me re-connect, everything is "disabled" How can I disconnect
made many tasks far eaiser. But we seemed to have shot outselves in the foot. Because to the significant performance gains, we added additional features that involved complex queries. Our application, which supports the automation of chicken processing, is very DB intensive. We write a record to the database every 80 ms or so. Lately some of our bigger clients have complained of application freeze-ups. Upon further investigation, it turns out to be due to the consumption of available memory by sqlsevr.exe. The executable goes consistantly and not at a slow rate. We have wittnessed it growing from 8 mb to over 700 mb in six hours. I found some info via google and have tried setting the memory throttle but I don't think it is working. The sqlsevr seems to blow right by
hi Roy, never tried [still not own a 64bit processor =:-( ], but I think yes, as you can install SQL Server 2000 too hi Roy, on actually may be what kind of error do you get as installation result in the verbose log file?BTW, the error msg is "Setup failed to configure the server. Refer to the server error logs ans setup error logs for more information" when installation stops.hi Roy, http://support.microsoft.com/default.aspx?scid=kb;en-us;816499&Product=sql
i need get update record log in my database. Then i can find what data is wrong updated.http://www.lumigent.com/products/le_sql/le_sql.htm SQL has no real built in tools for recovering information from the log (none documented anyway). There is a DBCC LOG command but the output is pretty cryptic and I doubt it would be any use. If this is important and you don't have backups then get Log Explorer. HTH, Jens Suessmeyer.
to SBS 2003 Premium with 5 licenses as the only solution. Personally I think MSDE would do the job… There are few things I’m not so sure: - How many users can access the server at the same time with MSDE? - Is there a way to let the user know if a record is being used? Like displaying a message before any changes are made? - I’ve created a table for users with username, password and group they belong to. Is there a way to integrate this with the MSDE Groups and Permissions or Transact-SQL? So Users, passwords and Groups can be setup from a form in the front-end. I’m doing some research on Veritas and see if it would backup the Instance of MSDE. Any help on this matter would be greatly appreciatedAndrea, Thanks so much for your answer. I see I need to change directions in few
Hey everyone, I have a system that is running MSDE 2000 and we run the following script to back it up: osql -Usa -P -n -Q "Backup Database MyDB To Disk = 'E:\mssql7\backup\mydb.bak'" The problem is that it appends and fills up my HD. Anyone know what I would need to do to change it to "overwrite"? TIA, ClaytonChange your script as the following: osql -Usa -P -n -Q "Backup Database MyDB To Disk = 'E:\mssql7\backup\mydb.bak' WITH INIT" It uses WITH NOINIT by default, so using WITH INIT will overwrite the older backup file.
Server Instance from the shortcut menu if you know there are SQL Server Instances on this machine". I work in education and would like to be able to set MSDE up for use in the classroom. I have spoken to Computer Services and they are not sure what they need to do to get it working. Help! Any suggestions or ideas would be greatly appreciated?Are you perhaps running XP SP2? If so then you will need to put a rule in your Windows Firewall to allow discovery of SQL Servers Jim
+ convert(varchar,292) + ';' --generate the plan EXECUTE sp_executesql @strSQL END INSERT logQuestions (thedate,qUniqueIDbefore,changecode,affecttable,userid,qUniqueIDafter) SELECT getdate(), qUniqueid,wrkChangeCode,'QQuestions',wrkUserID,wrkqUniqueIDbefore FROM deleted 1) The above code does not change the 'inuse' field to 0 for the record with the qUniqueID of 292 but it does insert a record in the logQuestion table. The 'inuse' field is a bit type. Can anyone see why it does not work? 2) I want to replace the convert(varchar,292) with the qUniqueID from the Deleted table - what would the correct syntax for that be? 3) Is there any way to interrogate the value of @strSQL? I tried using PRINT @strSQL but nothing
Hi, we are installing our app at different sites. Normally it is a easy job, but today we got problems. The user had MSDE from before with Win NT authenticaton only. We changed this to mixed mode. Then we used OSQL and sp_addlogin. Yesterday at another customer this was enough to get access from the whole local network. But here we could not access the database from even the server! We then used OSQL and sp_addsrvrolemember on the login. This enabled us to access the database from the server, but still not the
Can MSDE 2000A still be used to distribute in an application for sale? jzYes. You need to have a license though (see http://www.microsoft.com/sql/msde/howtobuy/msderights.asp) or you can register: http://www.microsoft.com/sql/msde/howtobuy/redistregister.asp
with Microsoft SQL Server 2005 Express Edition. After the reboot if I connect to the server via odbc (configured with localhost as hostname) using a tool odbc based I've no problem with all the classic operation (select, insert, update, etc.) but in a particular software (written in Visual Basic 6) if I try to add or update a record in all the tables of a database I obtain this error: "37000:[Microsoft][ODBC SQL Server Driver][SQL Server]Could not find '' in sysservers. Execute sp_addlinkedserver to add the server to sysservers" Maybe the VB6 software does a different operation even if it uses the odbc driver but however the problem is that I don't manage to update or execute the linking of the server using the Management Studio Express because
's GetDefaultConnect(), return _T("ODBC;DSN=themsde"). Both DSN's are ODBC, the original uses Microsoft dBase driver (dbf), the msde is of course SQL Server. Using the SAME data and the SAME code I add a record (AddNew()) the Recordset.Open() takes about 4 or 5 times longer with the msde dsn the Recordset.Update() takes about 10 times longer (eg. 10 seconds with the msde dsn, less than 1 with dbase odbc dsn) Are there changes that have to be made in the code or in the data?Hi Charles, Rather than focusing on the change in DSNs I think you should focus on a much more fundamental change namely the fact that you have changed the RDBMS. I would start by adding a few relevant indexes to your tables and if they already exist try updating your statistics. Jonathan
new to using it, but you can install SQL 2000 on SBS 2003. SBS2003 Premium comes with SQL Server anyway. JohnHi, John! I've managed to get some info on this issue (by MS themselves, actually). You have to manually (by command-prompt), create an "instance" in MSDE. You run MSDE setup with parameters (examples included in a htm-file in installation folder). Check out MSDE 2000 release A on: http://www.microsoft.com/sql/msde/downloads/default.asp I spoke to a swedish ms-consultant and he told me that installation of SQL version 2000, 2003 or whatever is not possible on sbs 2k3 . MSDE 2000 is tested by MS for one (1) default instance and fifteen (15) named instances. So he and I and some programmers who developed the dental-application are going to give it
is programmed to "speak" at 10 second intervals, so there's a fair amount of traffic. Now what I've been asked to do is write a record to a database for each of these meters at ONE MINUTE intervals. At first I simply set up a one minute timer and pointed my software to the directory where the XML files live and said "write a record for every file in there." But, alas, occasionally one (or several) of the meters' files were being overwritten at that particular time and thus weren't available. So, I changed things so that each time a meter speaks, I check the database to see if it has been a minute or more since the last database update for that meter, and if it has I write a record out. Now this works fine, but it uses an enormous amount of CPU time
not understand the but if the registry key is inspected to run oSql, of course it will fail just to test, I fixed the registry entry and installed MSDE from the MSDE Release A package, http://www.microsoft.com/sql/msde/downloads/download.asp, with the very same result as additional side note, unistalling the MSDE sp3 instance (that from http://www.microsoft.com/sql/downloads/2000 version and then (manually) install the desired service pack level (sp3 is the supported SQL Server 2000 version on Win2003 platform) as regard MSDE, the currently available packages do not (for sure) grant you a way to decide at run time the service pack level to be installed.. if you choose sp4 there you are, the same for sp3 actually it should be safe, but consider that installing sp4 updates
I have many problems with the stored procedural used at web service (and this´s used by aspx page) because i get a timeout expired or this stored procedural is very very very slowly (more than 30 minutes). Although if i use the console and osql this stored procedural runs very very quickly (some seconds). Can i do somethings? Regards, and thank very much,hi, SET FORCEPLAN will instuct the query optimizer to execute the join condition(s) in the (manual) order they are presented by the developer, and I'd be very carefull in it's use as
When trying to connect with the "sa" user I get the following error: Login failed for user "sa" Reason: Not associated with a trusted SQL Server connection.Hi The installation of MSDE is setup to only accept NT Integrated Security logins. Login with an NT account that has permissions to access the MSDE instance.
I installed MSDE 2000 Release A, but can't find the Query Analyzer. Is it included, or only available with other SQL Server versions. If it is included, then how do I install it? If not, can I download it from somewhere else?Hi MSDE 2000 does not come with any of the tools like Query Analyzer or Enterprise Manager. You could download the evaluation edition of SQL Server 2000 and use those tools for 120 days.