all groups > sql server msde > july 2005 > threads for july 29 - 31, 2005
Filter by week: 1 2 3 4 5
Installation question
Posted by ZRexRider at 7/31/2005 8:22:52 AM
Hi,
I have MSDE (SQL server) running various workstations within my home
network. I have no problem connecting to the SQL server instance on
each local machine but when I try to connect to a SQL server on one of
the other workstations I get errors indicating that the Server cannot
be found. ... more >>
Command Prompt problems when installing MSDE
Posted by Billy at 7/29/2005 7:47:01 PM
Hi,
I cannot seem to create a server instance when installing the MSDE.
step 1. I launch my cmd. It pops up with (C:\Documents and Settings\Billy
I type setup instancename="netsdk" sapwd="sa"
I immediately get a status message saying go to the control planel and
install and configure sy... more >>
MSDE & SQL 7 running, backups fail
Posted by Swaffs at 7/29/2005 8:08:12 AM
I have a W2K Server with SQL Server 7 and an instance of MSDE 2000 installed.
SQL Server 7 and MSDE 2000 both run OK together (I can make ODBC connections
to their databases from other clients, Enterprise Manager and dbamgr2k work)
and the MSDE 2000 backup jobs run successfully.
However, th... more >>
Upsizing to Standard Edition
Posted by gina_dauer NO[at]SPAM deaconess-dot-com.no-spam.invalid at 7/29/2005 1:11:01 AM
Can I simply backup a database currently on desktop edition an
restore it to a different server running Standard Edition (sam
service pack)? Or do I need to use DTS to move the database? Ar
there any gotchas that I need to watch out for
Thanks
... more >>
Restricting Rows to be returned on Select
Posted by Arjang at 7/29/2005 12:00:00 AM
Lets say Select * from Table returns 100 rows.
How can I get only get the
First 10 records , 2nd 10 records, etc ...
I now select Top n selects the top n rows from a query, but is there a
supported way of asking for next 20 rows after the row 50?
Thanks
Arjang
... more >>
|