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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
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 >>
|