I hope that I've an easy question. I've 2 pc's, one with MSDE and one
without. Now I want to use the msde from the pc without msde. But I can't
connect to database. In the configuration I found no option to enable an
external access. How can I enable an external access? Both pcs ...

I can't access to my MSDE instance from external clients if I select the
Instance name.
"this server does not exist or access is restricted"
If I use the IP adress instead everything is OK. (I always use sa account /

i have a server with MSDE installed that a database application uses. I
have just inherited this to look after and i see a few things that look
suspicious. First the database is under 300megs, which is fine. But the
LDF file associated with the database is 16gigs. I want to trim ...

It appears that SQL 2005 Express has removed the SQL Agent.  Is this true?
Or, am I simply missing something obvious?  If not there, does anyone know
the minimum version of SQL 2005 which enables job scheduling?
Thank in advance,

I would like to know if is there any problem if I try to install and MSDE
2000 instance on a server which already have SQL Server 2005.
I have to install a Backup Software that does not support and SQL Server
2005 instance, and it gives me the option to install a MSDE 2000 ...

Looking through the brief on SQL Express/AS the following line is included :
- Run SQL Server Reporting Services reports on local relational data.
Does this mean that if you have an application using this version of SQL,
that only the machine that has the SQL sever installed can ...

As usual i'm having trouble finding my way around in the Microsoft licensing
jungle.
I think that the easiest thing is to describe my setup and then hope someone
is able to help me.

I am running a Bulk Insert and getting the error that the PRIMARY file group
is full.  All the databases in the server have the Autogrow check box
selected and there is over a 100 GB space available on the hard drive.  The
transaction log is set to autogrow as well.

I just reinstalled my copy of VS 2002 after a hard system crash. Now, I
can't seem to open the SQL Server that the installation created under the
Server Explorer, "DESKTOP\VSDOTNET"
First: this SQL Server has a "Red x" on it.

I have vista and I upgraded MSDE to Express and now SQL Studio won't let me
connect to MMSSD with windows authentication.
What are my options?
Thank You

I need to determine if MSDE or SQL 2005 Express is installed versus the
full version of SQL 2000 or SQL 2005.  I only want my installation to
run if the full versions of SQL is installed.  Where can I find this
information?  Is it in the registry, can I do a SQL query that tells me

I've been reading up on SQL 2005 Compact Edition. I take it this is the death
of Microsoft Access? Comments?

I'm having a little trouble with a Bulk Insert. This is my first time
working with this, so I'm not sure what I'm missing here. I've read
everything I can find about Bulk Insert in BOL and from querying the
archive, but I'm not finding the answer.

i'm not much familier to the SQL Database so that i need your expert
advice on one problem.
the problem is,
i've 50 databases and i need to truncate one perticular table from all

I am having to move a database from one pc to another and would like to know
the best way to do so making sure that users and logins come across as well.
I am using MSDE 2000 Rel A and am moving it from a Windows 2000 pc to a
Windows XP Prof 2002 SP2 machine.