OK folks -- I give up.  I have a default instance installed under XP and
it is working just fine.  I try to upgrade it to SP4 and consistently
get a message that says the product is not installed.
The syntax I am using is as follows:

I wonder if someone could explain to me why the script below runs fine
against an SQL2000 server but fails with:
invalid object name 'People'. against an SQL2005 server.
The connection to the database works fine. If I supply the wrong password I

I keep getting Error 10061 upon connecting to the remote server through LAN
and local IP
I use SQL authentication and TCP/IP.
Can someone sugest any soutions ?   please

I get the error 206 not autorized to create db in Master ???
I tried to find the error in the msdn but nothing, any one have a suggestion
?
Thanks

Is there a way to get a limited number of rows  results from a select query
?
like  select top 50 * from mytable  returns only the first 50 records, but
what if a want to get records 50 to 100.

I've migrated a desktop VB6 application from MSDE 2000 to SQL Server 2005
Express. Data access functions work correctly, but terribly slow. Beyond all
adjustements that can be made to the server, I've noticed that all the
queries and commands launched by my app run magically fast ...

I've migrated a desktop VB6 application from MSDE 2000 to SQL Server 2005
Express. Data access functions work correctly, but terribly slow. Beyond all
adjustements that can be made to the server, I've noticed that all the
queries and commands launched by my app run magically fast ...

I have two Osql scripting questions for windows?
1. How can I get my OSQL script to output to a CVS file. Such as  "select *
from itemtable"
2. How can I create a osql backup script to will name the backup filename

the SQL Express 2005 database liti is 4GB, right?
Does this apply for each database separately or for all DBs registered?
Also which file size is monitored (mdf only or mdf+ldf)
Thank you

I have the below script:
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id =
OBJECT_ID(N'[dbo].[aspnet_Applications_CreateApplication]') AND type in
(N'P', N'PC'))

How to duplicate a database from one PC to another (remote computer) over
the internet ?
Arthur

How can I check the size of a SQL express 2005 database ?
Thanks
Dag

Howdy All,
I hope Express Edition posts go here, if not can someone direct me to the
correct newsgroup?
I have used Microsoft Update to obtain the latest updates for (obviously)

I have installed MSDE2000 on my pc and am trying to set it up so I can
connect remotely.  
I'm trying to run svrnetcn.exe, so that I can configure TCP/IP  and Named
Pipes.  Instead of opening the program, I get a message: "The operation

One of my costumers have a program that connects to a servers MSDE
database.
The name of the program is Winfinance.
Trough DbaMGR2k i have granted a Windows 2003 security group full