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

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

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

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

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

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

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

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

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

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

Hi, I'm new to SQL server. I have a question btw MS SQL server and Microsoft SQL Server2000 Desktop Engine. What is different btw MS SQL server and Microsoft SQL Server2000 Desktop Engine ? As knowledge, MSDE can choose be as an database engine for application (like: MS excess). Can i...more >>

I know the max row size in SQL Server is 8060, but what happens if I go over the max row size. Will some of the data be lost? Will I have problems with backing up the database or importing or exporting data? Also, does the 8060 size apply to rows in Views also, or is it just for tables? ...more >>

Hi all, I have inherited a custom build application that is being nominated to get replaced by something else (which is not known for know). The company who created the application is gone and while the application was reasonable good it won't run with XP SP2. The application uses a dat...more >>

Can someone pls let me know the location from where i can download SQL 2005 latest beta release. Regards, bobby...more >>

I'm doing a MSDE install on a Windows 2000 server. The client has Office (including MS Access) installed on the server. When I try and install the SQL Tools, it runs through the process, but there is no SQL Server folder under Program Files, nothing is added to the Programs menu. Is ther...more >>

I have a log file that is pretty large, but I cannot see it inside Enterprise manager. It just shows an hourglass when I click on the log. I would like to see even part of it if possible. Where do I look for the file and what do I use to possibly copy 10% of the file? Thanks, Roger ...more >>

Hello I want to find who and when the changes wasdone to a particular database or table into the database of SQL 2000 server. Is there any way to monitor it ? With regards Ashutosh...more >>

Hello. I am responsible for backing up two Windows 2003 servers, one of which contains a non-simple SQL database. The tapedrive is a DLT1 without any automated loading (I must load a new tape each day by hand). I am using Microsoft's built in backup software, to backup all the important...more >>

I am having trouble finding my SQL server from a remote SQL server running 2000. Please help....more >>

I have two tables with the same layout, and I need to join them in a way that all the records from each table will be "on top" of each other (not sure how else to word that). For example: Table 1 records: A B C Table 2 records: 1 2 3 I need my output to look like this: A B ...more >>

I currently have 2 tables. Both have ssn's of an employee. I'm trying to pull 2 fields, de_code and amount, from one of the tables based on the ssn and the de_code like EIC (which is just a value in de_code). I'm having trouble merging those 2 fields into the other table. Should I instead ...more >>

I am looking into pulling Exchange Mailbox data directly in SQL. Currently, we export the data from Outlook manually and then import into the data into SQL. We would like to bypass the import/export to a text file piece. Could someone point me in the right direction? I had heard this could ...more >>

Hi all, 1- Which better data types for money fields, float or decimal? Which i use? (... my money type requires 6 decimal point ...x.123456) 2- I m using User Defined Data Types. Is the UDDT supported Alter with data? When i think change in future. 3-How do i reject new records in...more >>

I currently restored a databae from another agency with a 4.5 G .bak file. After restoring I was questioned why the databaes was so huge. I used the sp_spaceused stored procedure and it reported 3.7 G used. There are approximately 700 tables but many of them have no rows. From the small ...more >>

Hi all, I'm wanting to change all of these Update queries into a single view. Pretty new at this and would appreciated the help. Cheers, Job Update Tbl_Txn_Line_CHS Set LP_AdjandPay_Not_0 = CASE WHEN (LnPstAdj = 0 and LnPstPymnt = 0) THEN 0 Else 1 END Update Tbl_Txn_Line_CHS Set wP...more >>

I have to create a database application (multiuser) for about 15 users using SQLExpress and C#. I am very new to SQLExpress so I need some basic direction. Do I put the data file on the network drive and install SQLExpress on each machine or do I install the data file and SQL on the network,...more >>

When we create a diagram which defines the relationship between two tables, there is no way to specify the exact reltionship type, as there is in Access. We need to create a relationship that is, in SQL, a left outer join. In access, this is easy (gives you three radio buttons and you pick ...more >>

Hi, any help is appreciated. I dont know the best way I can do this fast and easily. What I want to do: Move a MAX value of a column to a variable from my SQL Server and be able to store it as a table or other recommended way, once this is done I want to be able to query this variable from my ...more >>

I am very new to SQL Server 2000. We have SQL Server 2000 SP 3 on Windows 2000 SP4. I have 4 instances running on the server. I am able to register the 4 instances in my copy of Enterprise Manager at my desktop and using Windows authentication with out issue. But, after a day or two or som...more >>

I have a column in a table full of phone numbers, except the user entered them just as "a number" so (206) 555-1212 looks like 2065551212 Is there a way in which I can run something that will format all of these with the appropriate parantheses, etc...? (ie. make them look like phone numbe...more >>

I want to copy the sql server database from the C drive (IDE) to a raid drive E. So I first created a directory and copyed the pair of mdf and ldf file to the E drive and then ranamed them. This didnt work because when I attached the files sql somehow knew they came from the C drive and entered...more >>

I buy a programing book with source code.But the database only can use English to input data.When I input Chinese,I read "??" from the database table. I need help,Thank you! ...more >>

Hi there I've installed SQL Server 2005 Express Edition on my machine (version 9.00.1187, the "June 2005 CTP"). Do you know the precise version number for the .NET Framework that must be installed with it? (.NET Framework v2.0.50215.45, which is the latest version that I can find on MSDN...more >>

Yup i am "newbie" to SQL and i need to rename a database so it will work with a program we have istalled. The last DB administrator left the company unexpectantly and the current database has 5.1 GB log file that I cannot get to shrink and is filling up our harddrive. there is a dabase that ...more >>

Hi there Do you know of a good reference, or alternatively a rough-and-ready rule of thumb, about indexing for purposes of analysing a database? I take a snapshot of a fairly large database and analyse it ... so I'm not concerned with the index performance issues associated with, say, updatin...more >>

Would it be possible to install both sql server express 2005 and sql server 2000 on the same server win2k machine? ...more >>

Hi guys, I have a problemo - basically i have one large SQL2000 DB. This is edited / updated etc by users of the website i am developing. However i also wasnt a SQLCE component as i want certain users to recieve user-specific information from the database to their PPC's (I don't have access to ...more >>

I'm trying to write a script that loads default data into new tables that (will) have an integer identity column. When creating the table I do not specify IDENTITY on any column in the table. Then I use INSERT statements to load in the default data which contains the IDs. Lastly I want to se...more >>

Will someone give me an example of creating a 'Non-Clustered Index on a Clustered Table', so that I can avoid inadvertently creating one? ...more >>

Are there any limitations to the Access Upsizing Wizard?? I cannot seem to upsize a database containing a table of 1.5 million entries to an MSDE2000 database. When I reduce the table size to 800K entries, it works. And the size is no where near the 2 Gig limit. Thanks in advance to anyone...more >>

Can I use asp 3.0 applications with SQL server Express 2005? If yes, how easy is it to upgrade slq server 2000 databases to sql server express 2005? (All the databases are under 4gb) ...more >>

How to export/import database role? How to export/import all user on all database? Thanks...more >>

How would I find out how many bytes are in row in a SQL Server 2000 table? If there is a stored procedure to do this that would be great since I need to figure this out for many tables. Thanks ...more >>

I've put my sql 2K transaction logs on a single drive off the raid 5. I'm curious in what to do if that drive should fail ? -will sql server start? -will it recreate the logs somewhere else? ...more >>

Hello, I have a project with a group of unknown queries (views). I don't recall ever noticing them until a few days ago, but that doesn't mean they weren't there. Here are a couple of the names: dt_addtosourcecontrol (dbo) dt_addtosourcecontrol_u (dbo) dt_adduserobject (dbo) Are these...more >>

Hi all Hope someone can help on this - new to the area so here goes. I've got an SQL stored procedure that checks a company name from an import spreadsheet. If the first 35 characters of the company name are the same on the spreadsheet as already in the database, it leaves the company name...more >>

Does anyone know of a good book to use for a 16-week introductory course to SQL (using SQL server as the platform preferably)? If not, I can use two books: one for a quick "how-to" on SQL server, and then one on SQL itself. Ideally I'd like something with excercises at the end of each chapter...more >>

How can I port, or can I port, a MSDE database from one standalone computer to a second standalone computer? Charles...more >>

Hi Complete newbie to sql server. I have a Companies table from which I would like to create a Clients view as follows; SELECT ID, Company, CompanyType FROM dbo.Companies WHERE (CompanyType = N'Client') Such that when I insert a record into this view it automatically set...more >>

Hi Is it possible to add a field to an sql server 20005 table programmatically by a vb.net app while the vb.net app has the table being viewed on a vb.net form? Thanks Regards ...more >>