I'm having problems working on a DNN Site. I'm doing all the dev work local
on my machine. I've got SQL 2005 Developer Edition. I'm running a DNN site on
the local IIS. I've enabled both tcp and named pipe connections and I've
started the browser service. The web config is ...

I hope this is the right ng for sql serer 2005 express
I looked for guideline for optimal table design with regard to attribute
word boundary and other best practise, I failed to din any.
can anyone point me some quick guideline?

I have two servers with the following detail:
Server #1
Server Name: SQL2005WIN2003SERVER
Windows: Win 2003 Server

I'm getting the below error when I try and run a simple OSQL command to backup the database "TotalSpeech".
---------------------------------------------
C:\>OSQL -Usa -P -n -Q "BACKUP DATABASE TotalSpeech TO DISK = 'C:\Program Files\
Microsoft SQL Server\MSSQL ...

i log into my msdn and i cant find sql server 2000 to download. is it still
available? i see sp3 and 4 but i do not think they are full verison right?
thanks,
sd

I am a newbie trying to attach an MSDE dbf from a whatever.mdf and
whatever.ldf files. I keep getting an error that I can't attach the database
to the same name as an existing database.
Any help would be appreciated?

may i know is there anyway for me to find out from any system table in
MSDE what are the triggers that have been created ?
I wish to delete all and log in a new set of triggers, just in case
some old triggers cause some problems to the new ones.

OK so I've downloaded and installed this 1.7MB wonder, but now what?
I just wanted a nice easy to deploy db to use with my VB 6 app and although
the size is now great it doesn't seem to be doing much else.
Nothing in the start menu, sys tray, desktop, etc.  Just a folder in my

I've installed a program called Winfinance who saves it's data to
MSDE.
When i log on to the database with my credentials as a server
administrator i get access, however, when i try to log on as the "sa"

Hi, I am running SQL Server Personal Edition on a Win2k Pro box, and I need
the server name in Enterprise Mgr toi be something other than (LOCAL), which
is default, can I rename it or do I have any option to reinstall it and give
it a name?

I jave a PC with BlackBerry 4.1 installed. So, I have a MSDE installed with
default instance.
Now I want to install a named instance of MSDE SP4, but it seems to be
impossible. I have add the option to create the log file of the

We are starting a new developmement of our supervisiob system that will run
uner vista and we will use VS 2005 as a development platform ..
Based on that we need to select proper local database for our local data
archiving.

I wonder how the 4 GB limit is found.
Is it the size of the datafile only, or does the size also inlcude the
transaction log?
Regards

I am planning to develop a asp.net 2 project running on Windows 2003 Web
Edition.  I am aware of OS and SQL 2005 Express hardware limitation.  The
followings are my plan, and I appreciate if someone could tell me any issues
that I sould be aware of and could arise in a production ...

I have a table simular to the following:
ID = int (Key)
Name= VarChar
Department = nChar