Error :- The description for Event ID ( 17055 ) in Source ( MSSQLSERVER ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. The following information is part of the event: 17113, initconfig: Erro...more >>

Sqlstate '01000' Sql server error : 53 Connection failed Sql state '08001' Sql server error : 17 server does not exist or access denied Now the situation is this that our sql server is accessible from all other machines except one, suggest why. we restarted the machine and tried al...more >>

Can someone tell me what this is: MS Tabular Data Stream (TDS)? I looked in the manuals, but I still don't quite get it. On one hand, it looks like an engine level API that puts data into packets on the wire, but on another diagram it looked like it was part of the Client/Server comm flows and just ...more >>

I've configured SQL2000 with both security sql + windows (sql propierties) and I can't access to the corporative administrator on the clients. It appears a validation error message. I can't use the sql superaccount 'sa' to open the sql server. This didn't happen with Win2000 Server. Must I recon...more >>

I need a query to get non exisits id Example TABLE B (contains column name ID) ID A B C D E 1 2 3 Table A (contains TOW columns name ID,ORGID) ID ORGID 1 A 2 B 3 C 4 D 5 E Table A id...more >>

Hi there, I need to connect and insert data to mssql from unix system. unix : sun sparc solaris 8 gcc (GCC) 3.3.2 database : mssql Thacks in advance, Jaguk Ku ...more >>

I need to evaluate SQL Server 2000 for a new application. This new application must be the primary instance. Can I install SQL Server 2000 Evaluation Version onto a machine that is already an SQL Client for another application without adversely affecting the Client Operation? Thanks i...more >>

We are running SQL 7 Standard edition and we are getting an error message that it has reached its limit of 50 connections. Is this a default # of connections? ...more >>

Hi, trying to access a MSSQL database from Access, as a quick way of editing and deleting records. But cant get the access to work. Anyone can point me in the correct direction greatly appreciated. Thanks Neil ...more >>

Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable...more >>

Dear Professional, I have use textcopy command as Hari told me but it's saving the only one image columns data, as I have five image columns in one table and I wanna save it into file. Waiting for your reply Noor ...more >>

Hi, Does anyone know how to pass trough parameters to a sql script (which will be run with osql: osql -i"....") thanks...more >>

Hi Is there anyway I can restrict the number of connections to a SQL Server database ? How can we do that.? Also what is the best way to find out number of current connections to the database using a query ? Thanks ...more >>

I have 2 sql server 2000, both with win2k advanced server, in the in the Enterprise manager of server 1, I could connect to server 2 and see it is database, but if I try to do that from server 2, it gives me unable to connect, access is denied or server is not exist, after many trial, I put in t...more >>

I have a table that store MS/Word and Excel files via Image and nText data type. How can I select these fields using SQL/Analyzer tool to write these files back to the hard disk in their original Word/Excel formats ? Thanks for your help, John ...more >>

I have sql server 2000 installed on windows 2000 server. I just replaced new workstation (win2K) and installed SQL Client Tools. Now I am trying to register my SQL server but it says login failed. I use same login and password to log on SQL 2000 server directly from windows 2000 server and it wo...more >>

Sorry I couldn't see the answer I would like to add Identity property to exitinng column which has a unique data and would like to start it from 100. Could anybody please give me the syntax TIA ... .. ...more >>

I would like to add Identity property to exitinng column which has a unique data and would like to start it from 100. Could anybody please give me the syntax TIA .. ...more >>

Does anyone know of a reason that an ODBC logon would work fine on a WinXP Pro station for about an hour after reboot but then fail with Connection failed SQLState 'HY00 SQL Server Error: [Microsoft][ODBC SQL Server Driver] Cannot generate SSPI contex Logout and back in has no effect, only r...more >>

hi there, i have some problem regarding the OSQL display on txt.... why if i select more than 3 fields... the sum will left so far away from the last record? such as the following: Monthly Bonus Listing [By Bank] ID Member_Name Bonus -----------...more >>

There are 50 images in one table and now I wanna generate the script of that table, how can I do this !!! Can you please let me know how I do this... Waiting for your reply Noor ...more >>

Please Help We keep getting the following error in our server logs. Unfortunately, this is also causing ole db errors in our vb client apps. 1. Using 'dbghelp.dll' version '4.0.5' *Dump thread - spid = 98, PSS = 0x5bafb1a8, EC = 0x62d12098 2. Stack Signature for the dump is 0x5CAE52...more >>

I have created a new Instance on my machine, how can I add it, I can't see this on Enterprised Manager, can you help me in this regard ...more >>

Hi all, Apologies for the cross-post. Just wasn't sure where to put this one: I'm getting this error sporadically on an ADO connection. When it happens I also cannot connect through the Enterprise Manager (or anything else!). The environment is SQL Server 2000 running on Windows 2000 Ad...more >>

hi there, Yesterday i tried to run this SQL queries whic is as the following.... "Print 'Monthly Bonus Listing' Use PerfectID Select M.MemCode AS ID, M.MemName As Member_Name, M.MemChair As Rank, M.MemBank As Bank, M.MemBkbch as Branch, M.MemBankAC as Account, O.T_Money As Bonus f...more >>

My 'SQL Server 2000 Books Online' gives me the following message: "Cannot open the file: C:\Program Files\Microsoft SQL Server\80\Tools\SQL80.col." I've searched but did not find this problem anywhere. Has anyone seen or solved this problem? Jerry ...more >>

A client application accessing sql200 is getting this error:An error occurred while validating the user login. SQL Error Msg:DBPROCESS is dead or not enabled Please Help....more >>

already have backup scheduled for 4 different times of the day, I was looking for transfering this backup to multiple machines automatically, so that in case the main server crashes, i still have copies of backup on different machines. *** Sent via Developersdex http://www.developersdex...more >>

Dear Andrew, Thanks for the suggestion, however could you please give me some example on it?? for example my SQL queries id "Select MemName, MemCode from memreg where memgender='male'" Thanks Regards Sharon...more >>

Does SQL Enterprise Mgr have a "Query By Example" feature like Access? In Access I could do very complicated queries (with JOINs of multiple tables, etc...) just by draggin and dropping. Thanks! ...more >>

My boss created three identical tables, future, present, past and data lives in any one of these tables depending on the date. For reporting I created a view as follows SELECT * FROM Future UNION SELECT * FROM present UNION SELECT * FROM past When I query this View via the Query Analyzer...more >>

When an specific client tries to connect our application, the following error appears: The page cannot be displayed There is a problem with the page you are trying to reach and it cannot be displayed. Please try the following: Click the Refresh button, or try again later. Open the...more >>

I use a sql :select xx from table1 where column like '%model town%' and anonther sql is :select xx from table1 where column like '%10_g model town%',I think the later will be faster than the first,but actually it is not like that,the first is faster than the later,why?I can't understand that.a...more >>

Hi there, I really need somebody to help me out about how can i develop a templete which is just like an icon that occupie the SQL quries(which i have created at the querie analyzer)and write the result to a file when i double click the entire icon? Thanks sharon...more >>

Can any body tell me what the problem is ... [DBNETLIB][ConnectionRead (recv()).]General network error. Check your network documentation. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the ...more >>

Receiving the following error from the website: [DBNETLIB][ConnectionRead (recv()).]General network error. Check your network documentation. What I have do ? Thanks ...more >>

Dear Professional I wanna ask one question, I have one table name 'VIcon' in which there is one field VI_LiteIcon and the datatype is 'Image', through application we have inserted four images in this table and now I am making one script and through that script I wanna save this image, for exam...more >>

I have used the following command but it gave me the error : use master Go sp_helpdb Go Server: Msg 515, Level 16, State 2, Procedure sp_helpdb, Line 53 Cannot insert the value NULL into column '', table ''; column does not allow nulls. INSERT fails. The statement has been terminated. ...more >>

Hi guys, I just wanted to check one thing please. XP_SENDMAIL should be visible from any database on the server, right? Regards, Graham ...more >>

Hi all, What statment will do the job I want to accomplish. I will appreciate who can help me write a script that will do following job, If table T2.cust_id is on T1.cust_id, update rest of columns (address,phone,last_cont_data, so on) to T1 table from T2. T1 has all the columns (compare t...more >>

Is there any query through which I can find out the sa password. like through @@servername I can get the server name, how can I catch the server name on run time. thanks Noor ...more >>

I run this following query sp_who 13 0 background sa 0 master TASK MANAGER 14 0 background sa 0 master TASK MANAGER 51 0 sleeping NGSOL\Administrator WEBSERVER 0 SugarAsp AWAITING COMMAND 52 0 runnable ...more >>

I have executed one sql script from command prompt and it gave me messages like this 3> 4> 5> 6> 7> 1> 2> 3> 4> 5> 6> 7> 1> 2> 3> 4> 5> 6> 7> 1> 2> 3> 4> 5> 6> 7> 1> 2> 3> 4> 5> 6> 7> 1> 2> 3> 4> 5> 6> 7> > 1> 2> 3> 4> 5> 6> 7> 1> 2> 3> 4> 5> 6> 7> 1> 2> 3> 4> 5> 6 6> 7> 1> 2> 3> 4> 5> 6> 7>...more >>

Dear Professional I have 10 tables in my database now I wanna know that in which tables there are records. Through which query I can get the table names ? Waiting for your reply Noor ...more >>

hi guys, m having a problem with the stored procedure copied below. when i try to execute this stored procedure from query analyzer then i get the following error: Error: ---------------------------- Server: Msg 203, Level 16, State 2, Procedure EJ_GetEvents, Line 24 The name 'select sEve...more >>

Is it possible to direct a Terminal Server sql server 2000 client to see a SQL server 2000 database using this cliconfig or other file? Also if so where do you find it? -- The information contained in this email is privileged and confidential and intended for the addressee only. If you are n...more >>

How can I export a database schema to a script that can be run on another server that will recreate the database schema? -- James ...more >>

Hi, I posted a message a few days ago that was unanswered... We are running SBS2000 with around 30 Windows 2000 clients. One particular client is running dBase for DOS 5.0. When he installed SQL Client Tools for SQL 2000 on his machine, this instantly killed dBase for DOS 5.0 as he ...more >>

Can any guy let me know about the Disaster Recovery Planning. Thanks in advance. Noor ...more >>

Can any body let me know about the disaster recovery, like let's assume I took the last backup yesterday and today in the night my sql server has been died and I want to recover my whole information till today, how can I get this ? can any one guide me or give any information how can I do this ? ...more >>