Groups | Blog | Home


Archived Months
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
November 2007
all groups > sql server new users > august 2005 > threads for august 29 - 31, 2005

Filter by week: 1 2 3 4 5

installation problem
Posted by bosterrier72 at 8/31/2005 12:48:03 PM
I am trying to install SQL Server 2000 Desktop edition on my home computer. I have XP home edition for an operating system. I keep getting the following error: "An error occurred while creating one or more registry entries. Please see C:\WINDOWS\\\sqlstp.log for details. The problem could b...more >>


Problem set up connection string to SQL server (Using ADO in VB)
Posted by Chris at 8/31/2005 3:19:02 AM
Hi, i'm VB/SQL server beginner. Lately i try out using the ADO to retrieve data frm SQL server, but encouter the connection problem when i run it. SQL server 7 is locally installed type (local) as server name, & use Window NT Integreted security as log on to the server. (no username/passw...more >>

list of user tables and their fields
Posted by Diane at 8/30/2005 3:38:01 PM
Hello. Thank you for taking the time to read my question. Does anyone know how to pull a list of user tables and their associated fields? To give you a better idea, I imagine the statement to look something like this - Select userTableName, userTableField From ...more >>

SQL Server 2005 and SQL Express
Posted by Don Tucker at 8/30/2005 2:55:03 PM
I have recently installed SQL Server 2005 on a server running Windows Server 2003. I subsequently installed Visual Studio, which installed SQL Server 2005 Express Edition CTP. I am concerned that the Express Edition might interfere with the regular SQL Server. Are there application notes to...more >>

export settings and security
Posted by Marc at 8/30/2005 6:41:02 AM
hello, i m new to sql and i need to export all the settings of a base in sql 2000, security users ..., is it possible? do i just need to backup the database and all the settings will be saved? THX...more >>

calculating percentile
Posted by Loane Sharp at 8/30/2005 12:00:00 AM
Hi there I picked up Ken Henderson's book on T-SQL which has been really enlightening about what is possible, but a bit over my head in terms of operationalization. However he doesn't seem to cover calculating percentiles. Is there another useful reference, or can you point me essentially i...more >>

select date >= today?
Posted by _adrian at 8/29/2005 4:44:36 PM
Lets try this again, this time with the content... So I need to write a select statement in my VBScript/ASP that will return all records where the date field is = or > 'today'.. whatever that day happens to be. I suppose if I could do it in a View, I can build from that too.. in either cas...more >>

Loop thru each column of a table
Posted by rocky20 at 8/29/2005 2:22:19 PM
Is there a way to loop thru each column of a specific table? What I'm trying to do is get the datalength of each row of a specific table. I was using the method of SELECT DATALENGTH(col1) + DATALENGTH(col1) FROM table but I ran into the problem of nulls being in the table, so the output wa...more >>



change the name of sql server with the change of computer name
Posted by Micheal at 8/29/2005 1:36:35 PM
Hi, just suppose I have computer with the name "MICHEAL" and I have installed sql server . after some time I need to change the computer name from "MICHEAL" to "JOHN" Now I need to change the sql server instance from "MICHEAL" to "JOHN" . How I change the name of sql server instance . be...more >>

How do I fix "Could not load the DLL xpstar90.dll"
Posted by Dan Rhea at 8/29/2005 12:19:02 AM
I'm not sure how to correct this... This is the June CTP on and Intel Dual Core, Win XP Pro, 2GB Mem and a virtually empty 160GB raid 0 drive... The link in the error message below didn't offer any suggestions. Was installed today and had been running perfectly. Any help would be appreciated. ...more >>


DevelopmentNow Blog