Groups | Blog | Home


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 > july 2004 > threads for july 1 - 7, 2004

Filter by week: 1 2 3 4 5

Express version just upgrade of MSDE?
Posted by Robert Blackwell at 7/7/2004 12:51:16 PM
Is the Express 2005 version just an upgrade of MSDE 2000? ...more >>


Doubt with Client Network Utility
Posted by Juan Rodriguez at 7/7/2004 11:18:58 AM
Hi. I've been worling with Ms SQL Server 7 / 2000 and on every installation I've done, after installing the Server I had to Install Connectivity Only on Clients in order to configure Client Network Utility to add the Server Alias. Does MSDE have an option like this ? Does MSDE Needs a Client Ne...more >>

Error removing a view
Posted by Jerbear64 at 7/7/2004 9:54:01 AM
I have developer who created a view on a database in SQL MSDE 2000 and for some reason it was created without an owner. When I try to DROP this view I get the following error message: Cannot drop the view 'V_RATE_CATEGORY', because it does not exist in the system catalog. Any help on how I can...more >>

SQL Client Tools on MSDE - Database Maintenance Plan
Posted by Giuseppe Cibrario at 7/7/2004 9:22:12 AM
Hy anyone use 'Database Maintenance Plan' for setting database backup? I try many times but the backup's log mangement don't work. Giuseppe ...more >>

MSDE 2000 INSTALLATION PROBLEM URGENT HELP
Posted by Andy at 7/6/2004 4:16:19 PM
I am trying to Install MSDE 2000 A latest version and I am getting error product:microsoft sql server desktop engine--installation of the microsoft distributed transaction coroordinator package failed and this fails. I am installing on NT 4.0 Server Sp6a version. Please help as I need this ...more >>

"Best Practices" way to distribute MSDE
Posted by Ian Boyd at 7/6/2004 1:21:25 PM
i have decided that when distributing MSDE2000 i want to use the Microsoft MSI file (rather than using Merge Modules). What is the (THE, the one) best way to: 1. Install MSDE? - checking existing named instances - use CreateProcess and wait? Launch msiexec directly? 2. Start MSDE...more >>

Posible bugs in MSDE 2000 Service packs
Posted by Abraham at 7/6/2004 3:33:38 AM
Currently, i am conducting some assessment to upgrade from MSDE 1.0 to MSDE 2000. I have discover a posible bugs when i install MSDE 2000 SP 1. When i run the below store procedure (i execute it from custom application), it has different result. In MSDE 2000 without SP, the result is 40 row...more >>

SQL Server 2005 Express - no scheduler
Posted by Baudewijn Vermeire at 7/5/2004 11:00:53 PM
Why did they drop the sql server agent in the follow on of MSDE and task scheduler? How do you need to migrate job steps to what ? regards bav ...more >>



SQL-DMO OR OSQL.EXE in Attaching database??
Posted by Robert at 7/4/2004 11:33:01 AM
I am totally lost which is a better way to attach database use dmo or osql.exe also where can i get some basic scripts to get me started, I produced some dmo scripts but when I run them in my setup program I am getting errors. Can someone provide me some basic sript for example how to connect to e...more >>

indexed view blocks insert into table
Posted by Carl Karsten at 7/4/2004 11:08:16 AM
Pretty sure this is a bug in msde. 3 reasons: 1. not getting an error on the insert, just (0 row(s) affected) 2. insert succeeds if the index doesn't exist, and the index can be built on the resulting data. 3. insert succeeds on Standard Edition RTM with the index in place, same data. restored...more >>

HOW CAN I ATTACH DATABASE TO MSDE ??
Posted by Robert at 7/3/2004 10:58:01 AM
I am having little problem with it , I am using installshield for setup program and at the end when I finish with msde installation I try to attach a database, I would like to use SQL-DMO , but I dont have much clue how can I do it I need some examples scripts Thanks a lot ...more >>

Activating MSDE for remote Access
Posted by Joseph Geretz at 7/2/2004 10:17:07 AM
I'm finding that when I install MSDE, by default no protocols are enabled for remote access. I've found that I can use the SQL Server Network Utility to enable the TCP/IP protocol and then the MSDE instance is accessible from remote workstations. But how can I do this without having the SQL Se...more >>

MSDE install common sense issues?
Posted by Jeff at 7/1/2004 8:35:09 PM
MSDE installs via a batch file using Microsoft's setup. Once installed does it really make sense to uninstall it? What if Visio is already installed before my install, or some other product that uses MSDE, what happens to that install when my install runs? Would I need the sa password of t...more >>

how do i get started
Posted by steven davis at 7/1/2004 7:23:23 PM
I hope some one can help with this most basic of questions. I am working on a project that requires a mediium size data base and so MSDE look like a good fit. Problem is that in all my VB 6.0 work i never did any data base work and i cant find any good way to get started. I am lookign for ...more >>

MSDE and Installshield
Posted by Drizzt at 7/1/2004 4:18:40 PM
I need a better installation procedure for my software, so I wanted to merge the MSDE install into the main one. At the moment the Setup has been built by a third part developer, who use Installshiled. Problem is, he doesn't know which version of Installshield he needs. Someone can give me a hin...more >>

dt_ stored procedures
Posted by Eric Brasher at 7/1/2004 12:17:01 PM
I am trying to use microsoft access project file to access msde databases on local workstations. I have to set the users security to db_owner due to the application requirements. The problem users are having is since they are owners they see the dt_????? stored procedures in the queries list whi...more >>


DevelopmentNow Blog