Archived Months
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007


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 >>



DevelopmentNow Blog