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