Hello All, What is the best way to build an application that uses an SQL server data base. I am trying to get something that is similar to a ACCESS wizard application.. with a switchboard or menus to add and view records and reports. Thanks ...more >>

I'm thinking about installing MDAC 2.8 (RTM) on client machine (Win2000Pro SP3 ou SP4) and servers (Win2KSP3 + SQL Server 2000 SP3) (cause some programs run on). Is this version of MDAC stable ? Or, migth I prefer 2.7 SP1a and wait for 2.8 SP1 ? What is your experience ? Thanks. Jacques...more >>

Hi! I have table with [EntryDate] field in it. I have problem creating where clause with selection for last 30 days starting from today's day. Any help appreciated. Thanks ...more >>

I have a SQL server that is hosting 5 databases, when I try and use Enterprise Manager running it from the server its self and connect to one specific database I get A runtime Error has occurred Do you wish to debug? Line 306 Error: Unspecified error it only does it for one specific da...more >>

Hi, Recently, my manager has mentioned that there was a software called "Leeco" or "Lecco", which is used for SQL administration. I was wondering has anyone heard of this software? Thanks. Peter ...more >>

Hello, I am developing a program using VS.NET 2002 and SQL Server 2000 to access the database. However, every time I write code to access the database using the command "ExecuteNonQuery()" I get the following error message: "unhandled exception of type "System.Data.SqlClient.SqlExceptio...more >>

How do I interpret the results of the sp_spaceused proc? I've got: database_size: 51 MB unallocated space: 7.70 MB reserved: 35128 KB data: 29504 KB index_size: 5114 KB unused: 480KB How much total space do I have in this database? How much is currently taken up? What do reserved and...more >>

Hi, all. I have a SQL2000 Stored Procedure that accepts 2 input parameters (works as designed, returns a small set of records). I have an Access 2002 .adp with a simple form (2 textboxes, 1 command button) for users to enter the 2 parameters and run a report. I've created a report a...more >>

Hello, Howto convert existing text in several columns to upper case? In other words, I would like to convert to upper case the entire table. TIA Sergi ...more >>

Hi, I have a column (CustOrderNo) which is set to datatype int and IX_tbl. We need to change the format of our Customer Order Number from 123456 (6 digit #) to T123456 (alphanumeric) format. 1. Can the data type be changed w/o affecting the data? 2. If so which datatype would be more appropria...more >>

Dear Professional I just wanna know the last access record like I have three records in one table like 1 ABC Active 2 EFG NotActive 3 EDS Active I just wanna know when the 1 record(ABC) last access date, in...more >>

Hello, I am using CRViewer to Dispaly the Reports. I am using ADO & Access as Database. The reports run Fine on the code machine. But when Packaged and installed on th another machine without Crstal reports, The CRViewer is Shown but no Report display. I get the Message Physical Database not F...more >>

I work for an organisation that uses a bespoke document imaging system, the database of which is an MS sql server. We have MS Access and already use it for some querying of the database. The database comprises a large number of distinct cases, which are differentiated by case reference numbers, ...more >>

We are trying to access a SQL server 7 database using an application called "Saleslogix". We are connecting from Windows 2000, and XP clients running the SQL Server 2000 client. On all but one of the systems, we can access the database great. On the last one, we keep getting the error ...more >>

We are running custom apps written in VB for SQL when you close a program sometimes it remains open in the background.You can go into task manager and the app is still running,I am talking app not process but the app is closed on the desktop.We use XP but had this happen with both NT and W2k....more >>

I have multiple clients connected to my training SQL Server 2000. All the machines are configured the same they all have the same RAM, hard drive space and programs installed. One machine is very slow responding when the SQL (Windows NT) Icon, I am talking from 25 minutes to an hour or lo...more >>

I need to how to convert julian date to date...more >>

I have a question. For example I have a table called Customer, it has the following structure. >CustID PK - Clustered Index >Last Name - NonClustered Index >First Name >Zip Code Is the following Select query use indexes to retrieve data or table scan as Zip Code is not part of non-clustere...more >>

I am storing the request and response from a webservice on a "log" table. The data is in as LogText Column varchar (3000). The character data has all the XML tags and such. We now want to display portions of the log table such as the XML request and XML Response as character data to incl...more >>

i can connect to my sql 2k using names pipe but is not connecting using tcp/ip getting error 17...more >>

Hi there. U have table structure shown here: category (Int - AutoIncrement) parent_category(Int) Title(string) 1 0 HOME PAGE 2 1 FIRST DEPTH 1 3 ...more >>

We are due to go into a meeting with a company who use Oracle instead of SQL 2000. We have been playing with SQL 2000 for around a couple of months now, and the whole point of this meeting is to find out how effective/reliable SQL 2000 is over Oracle when it comes to extracting data out o...more >>

I have sql server running an enterprise software with several clients. After running for about a week sql server increasingly uses all the available memory until performace becomes unacceptable. Is this normal or is there a configuration or patch that I need to apply? thanks...more >>

We have two machines on a peer-to-peer: MachineA: Office 2000 MachineB: SQL2000 Server, with 2 test tables called cust and inv with 7m and 168m records respectively. What I want to do on MachineA, is use an ODBC link to extract data from SQL2000 on machine B. Can someone give me some...more >>