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 / sql server authentication). - Both MSDE server and clients are on XP SP2...more >>

Hi there, 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 a...more >>

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 this file si...more >>

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, Gary Johnson ...more >>

Hello! 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 instance,...more >>

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. Second: When I double click on this SQL Server, I get a "SQL Ser...more >>

Hello, 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. Is there a max...more >>

Greetings 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 have 5 devices running a application on top of Windows CE. Can i use the free version of SQL-S...more >>

Hello 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 ...more >>

Hi all, 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 th...more >>

Hi, 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 run...more >>

Hi 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. I have sucessfully install...more >>

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. This is the error I'm getting when attempti...more >>

Hi guys, 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 database. all i know is there is one undocumented SP for "for each table". can anyone tell if there i...more >>

Hi I have a bunch on tables and data in my local SQL Server 2005 Express master DB and I want to export it to a database.mdf within my wwwroot (visual studio) file - how can i do this? Thanks for you help leonaisse ...more >>

I have MSDE 2000 installed as part of a Backup Exec installation and a port scan reveals it's advertising itself on 1434/UDP. Is it possible to obscure/obfusticate this information in the same way that you can change an SMTP banner on a mail server? MarkDemon ...more >>

I've got MSDE 2000A running on a computer as part of an existing application. The database is eating the hard drive at a prodigious rate, and I can't repartition it (for other reasons), so I need to move the database to a different, larger partition that is available. I'd like to do so with ...more >>

Hi What can cause "Timeout expired" on deleting only one row? delete from tmarcid where id=3423 this happens not every time, same problem with update. SQL 2000,Windows XP, all SP's installed. DB size is only 4MB Computer: 1GB RAM,2.66GHz Pentium, 20GB Free Disk space. Regards; ...more >>

hi, how to access sql 2005, is it something like enterprise manager and view, create, attached database? Thanks. ...more >>

Our software installs a copy of MSDE 2000 on the clients computer during install. On several of the computers I can not log in to the server via osql (or my software). The problem seems to be referencing the instance. The instance is {computer name}\RR, so for example the guy I currently ...more >>