Hi, I have FormA used to input data into TableA located in a SQL2K Server having one of the fields as check box (bit, not allow null). FormB is used to edit data stored in TableA. When checking/unchecking the box using FormB, Access shutsdown and restarts (It doesn't do it when insert...more >>

Server = NT 4.0 sp 6 and SQL Server 7.0 sp 4 with hotfix 031. Background: Our company is very large and is going through a domain shift to AD. A = new ID B = old ID X = old domain Y = new domain ( BX )Old id, old domain was original setup and worked fine. User then was switched ...more >>

I have 3 tables AUTHORS BOOKS SW_BOOK_AUTHOR_JUNCTION this is a junction table joining authors to books and this is a many to many relationship what i want to do is list my authors and a count of how many books they have each authored. author ! count of books --------!--------------...more >>

I'm getting the error above when ever I try to register a sql server in enterprise manager. This just started occuring today and I haven't been able to find anyone who has successfully dealt with this error. If anyone has had any luck....please let me know. I started by reinstalling MDA...more >>

One of our developers accidentally added a 'rowguid' column to all of our tables (mssql 2000). I'm trying to write a script that will drop this column from all the tables; however, I've run into a problem where I can't drop them because there are dependant contraints/indexes. The following cod...more >>

Has anyone an idea what this type of error means? Event-ID: 17052 Error: 17882, Severity: 18, State: 1 Error accepting connection request via Net-Library 'SSNETLIB'. Execution continuing. ...more >>

Hi all, Can any one tell me if you can update a ntext field from a stored procedure? My insert works but the update method using set does not work. Thanks Nishan...more >>

Hi, I posted this mensage on the access.form NG but I got no help. I thought to post it here and see if I have better luck in getting help. I have a dialog Form with a combo box used to select a record in a table and via a command, I bring up a Report. I would like to add two Date fields in...more >>

Dear Expert Does anyone advise me why I cannot use SQL Query Analyzer to connect SQL 2000 Server (SP2 - 8.00.608) installed on Windows 2003 Standard Server from another PC at the same LAN? (I've used SQL Server authentication "sa" account for direct connection and set IIS to 5.0 as isolat...more >>

Hi , Our company decided to convert all char columns to varchar in our next software release. We have lot (40+) of client databases which is more than 75GB . Below the query I wrote for this ,but it's taking long long hours to complete the upgrade. Is there any better way to write this ?? Th...more >>

My enterprise manager runs very slow. How can I install client network library and configure to windows XP? What are the Network protocol setting and other setting required??? Thanx at advanced Bhavin...more >>

Hi I have installed SQL Server Enterprise Manager on Windows XP. I register my server under SQL Server Group. When I click on my server name it shows me five folders Database, Database Transformatin Server, Management, Replication, Security and Support Service. But when I click on database...more >>

Hi, When I try to install the sqlsetup.exe (CD: SQL2000 \X86\SETUP\SQLSETUOP.EXE)on the W95 PC it starts to install but then says: "Setup Initialisation error, The system cannot find the file specified Source:'E:sql2000 \x86\setup\setup.ins Target: C\windows\temp\setup\bin\setup.ins. Also me...more >>