Hello, I am having a problem registering a new server in SQL Server Enterprise Manager. I get the error message <SERVERNAME> - SQL Server does not exist or access denied. ConnectionOpen (Connect()). Both machines are running XP Pro SP2 and the machine I am trying to register is running M...more >>

Hi, I am using MSDE as my database system and I need to store large text data in it (in fact the data are serialized objects from a C# application). But the only applicable data type I found is text, which seems to be limited to 8000 characters. So is there another data type available th...more >>

I plan to buy the new system for my company, which will include MS SQL 2000 Enterprise Ed. However, I would like to know is it worth to wait until the new version coming out? Is that any kind of suggestion? BTW, when do we have a chance to get this version? who knows?...more >>

Hello!!=20 I have a Data Base in sql7 and I want to transfer to another PC with a = clean installation of SQL2000. How do I do this? Thanks!!...more >>

Database: SQL Server 2000 Developer Edition SP3a Frontend: MS Access 2000 and Access 2003 A Custm-built Medical Records Database I am having a problem connecting to my SQL server with certain ODBC drivers (sqlsrv32.dll). But it only acts up on certain "forms" in the Database, in particular ...more >>

Hi All I am new to SQL and I am looking for a free SQL Server that I can load on my server and practice with. I downloaded SQL 2005 Bata but I could not figure out how to access it. I loaded it all went well. I saw it running in services but no way to access it. Can someone give me a site...more >>

When I try to install the above by clicking on autoreun.exe, i get the following error: c:windows\system32\autoexec.nt. The system is not suitable for MS DOS and MS Windows applications. Choose Close to terminate the application I'm baffled! Operating System: Windows XP Home edition. I'v...more >>

.... without changing the value? I want to show "3" as "003", and "17" as "017". Thanks for any leads! Jeff ...more >>

Hello Is it possible to have a datatype which stores just a date value and not date and time? TIA ...more >>

From another thread I now I have a suspicion that autogrow is causing timeouts. But I could be all wet since this is a new thing for me. My transaction logs are set to grow 1mb at a time and that fits the scenario but I would like some type of confirmation. How can I monitor the files size and...more >>

Hi, I am new to sql server would like to ask a question. I want a calculated field whose value depends on another cell. For example allowances. One field takes the no of days, and the other field calculates the allowance like this No of days * 100 How do i do this. kesk ...more >>

Hi all, I'm new to the SQL world. Bear with me as I'm not a DB admin, I'm an HTML guy trying to help out in our small in-house IT dept. We're using SQL Server Enterprise Manager 2000. Each day I run a data import wizard to import some new records from an Excel file. The process works fine, ...more >>

I have a Compaq DL-380 with Dual 3.20 GHz Xeon Processors and 12GB of ram and Windows 2003 Enterprise Server OS. In order to use the full 12GB I have the /PAE switch set in the Boot.ini file. I have two instances of SQL-2000 STD running on the server. Both are set to Dynamically configure m...more >>

Hi, FYI! The performance problem is because of having clause and huge number of records. My table has around 4 million records its taking more than 4 days to build the hierarchy. Anybody has suggestion to improve the performance by modifying the query or another workaround. DEtails a...more >>

What will "shrinking" the database actually do? and if it does good things, is there a performance hit if "Auto Shrink" is selected? I know that "Auto Close" will really slow things down on a sporadically hit database and I wondered if this would cause the same problem. ...more >>

Hi, I'm trying to change part of the data in one column of a database table. Our e-mail addresses changed, and I want to be able to update the information in the database. For example: Database = Company Table = Employees Column= EMail Current data = fred@flintstones.com New data =...more >>

My company is migrating from Sybase Anywhere to MS SQL Server. In Sybase there is an aggregate function named "List" which returns either all values or distinct values for the column. ex: Select fielda, list(distinct fieldb) from table a group by fielda will return two columns, one w...more >>