Hello, when I run following query select convert(datetime, '10/01/03', 101) I'm getting Error: Server: Msg 241, Level 16, State 1, Line 1 Syntax error converting datetime from character string. the same code was working fine on win98 client system, but the same query giving error on Win...more >>

Hi, Is there any known issue about the situation when the same query runs way much slower via ADO than via isqlw? Sometimes when I have a comlicated query (with joined subqueries etc) the query runs very slow via ADO. When I spy in Profiler it tells me, say 3000000 reads, 29 sec. When I co...more >>

I got 2 computers in here that displays "No items" under=20 the database tree in SQL Enterprise Manager.=20 When I hit refresh... it takes a loooong looong time (I am=20 talking minutes here), but sometimes the databases are=20 appearing afterwards. I read on other site that other people ha...more >>

how to tell whether a server is running msde or mssql?? ...more >>

I need help verifying how many access licenses I have on my SQL server. Nothing shows up in the normal licesneing area in windows 2000. When I purchased the server it was with the understanding that I bought a per processor licesense so that I would deal with issue with access licenses...more >>

What is the perferred method of locking records in a Client-Server based application? Here is the situation, I have a list of records that I use to populate a form. On selecting a record (list box based), I query the Database via an ADO Recordset (basic SELECT * WHERE ID = #####), and then I populat...more >>

I'm trying to find a way to set the decimal places returned in an expression through a view, I've listed the SQL statement below. The two expressions I am looking at are the PagesHr and the BatchesHr, they are showing 12 decimal places and I would like the to show only 2. I've used the LEFT and...more >>

Dear Professional I read about Locking from BOL but still I have some confusion can any body give me any URL from where I can get the detail locking concept step by step. Thanks in advance Noor ...more >>

Hi there, I am new to SQL Server, we are running SQL Server 7 I am having some trouble with creating a delete query. Basically, i have developed a Access database that exports data to a .csv file, to be imported to SQL server via a scheduled DTS package. Most of the .csv files will only hav...more >>

hello, Suppose i have a transaction which updates multiple tables on multiple servers,how do I get the confirmation that the update on a specific server is complete? I can use @@error , but even if it is zero it is not necessary that the update has happened. is there any other way? thanks, r...more >>

Hi all, I m trying to use BCP utility to upload a huge text file. As per microsoft documentation, -R is used to specify the regional settings. My computer (client) and the sql server (running in a network machine) has dd/mm/yyyy as the regional settings. The incomming text file also has d...more >>

Dear Experts, I would like to insert a result set from the SQL server 2000 Stored procedure to Oracle 9i database. I am thinking to create txt file out of result set, but I am not sure How can I create a txt file directly from stored procedure? Anybody has a better Idea? TIA .. ...more >>

Hello: I need to be able to determine the name of the client machine running the session. The value in sysprocesses.hostname is client-supplied, so it may be not the real name of the client machine. The client can explicitly specify any host name in the ADO connection string. Is there a way to...more >>

How can I execute a select with OPENROWSET and extract only the record that I request with the WHERE clause? For example: SELECT a.* FROM OPENROWSET('MSDAORA','DBORACLE'; 'USER'; 'PWD', 'select * from TABELLA' ) AS a WHERE a.Cognome like @Cognome With this SQL statement, SQLServer ...more >>

I have been trying various scenarios all afternoon trying to get XP Pro and SQL Server 7.0 to play well together. SQL Server (client version, of course) seemed to install well and no problems there. However, when I go to register my server and connect to it, I get the following error: [Begin e...more >>

I have been trying various scenarios all afternoon trying to get XP Pro and SQL Server 7.0 to play well together. SQL Server (client version, of course) seemed to install well and no problems there. However, when I go to register my server and connect to it, I get the following error: [Begin e...more >>

Hello I have a VB6 app which connects to SQL Server. The application is installed and runs correctly in all workstations, but one. The error message I receive when I try to connect is: "Unable to load communication module. Driver has not been correctly installed." The PC in question is a...more >>

Hi all, is there anyone in area that have experience about snapshot replicate from server ---> client? My trouble is that in the client (subscripter) i don't succeed to start the sqlserver-agent. log return this error: [LOG] Exception 5 caught at line 191 of file ..\src\refreshr.c. SQ...more >>

Hi, I am new to triggers and would like your help I am trying to write an insert trigger on a table, so that when a record is inserted in table1 a dummy record is inserted in table2 eg: table "master" has a record with fields "1', "Honda", "1998" When this record is inserted into the "mas...more >>

I asked the question on the connectivity side. CAn I connect to a SQL 2K DB from a widows 95 PC. IF yes, what is required? It was reported that the correct version of MDAC might allow connectivity. Please advise. ...more >>

*apologies for multipost Hey we have an SQL7 box (soon to be upgraded to SQL2k) we have in-house client software that connects to a db hosted on the box via ADO + SQLOLEDB. Our client software always specifies an "Application Name=" parameter in the OLEDB connection string. The applicatio...more >>

Is there a service pack for the SQL client for SQL2k??...more >>

Is there a service pack for the client of SQL2k? Thanks ...more >>

Dear Professional I have created the replication b/w two servers and when I do alter the table then it gave me an error that to can't drop the table b/c it 's being used for replication, I am altering the table on Publication Server. Regards Waiting for your reply ! ...more >>

We are running SQL 2000 Server Eval on a Windows 2000 Pro box. When we run an SQL query against a table, we get (after around 40 seconds or a minute) a Timeout error. How do we change or ommit the Timeout? Thanks, skc ...more >>

How many Licenses does one need to connect 12 PC's to an SQL database. Does one need the same amount of Server CAL as SQL CALS? Can there be 1 Server Cal and 15 SQL cals?...more >>

Hi my application is a client-server database appication which is developped in vb to work on the local area network. backend which is used is sql server when i am assigned connection string to make connection through ado, server was not found and time of the connection is expired. ...more >>

Subject: Windows Server 2003 + SQL Server Yukon Scenario We're going to deploy a solution in two years time, where WinForm clients are accessing a SQL Server Yukon directly. The server OS will be some version of Windows Server 2003. The database will be used by 32 clients during normal offic...more >>

Hi there, we are having an application running on sql server. on client side there is an a setting for the internet (to run internet on each machine) in which they have assigned the ip address in the gateways. this setting creating problem in which application not going on local server it goes...more >>

Dear Professional Is there any possiblity that I can save the result of any query into file automatically. Like I want to save the result of the following query into the mention file name. Select * from Emp. I want to save that result into c:\emp.sql Note: I just execute...more >>

Dear Professional ! How can I create dynamic stored procedure in which it will take table name and field name as a input critaria and Insert into the table but one thing is very important that before inserting it should check that specific record is exist or not. Can any body let me know how I...more >>

We have an application that requires SQL server. We want to set up a pc to show a 'run time' version of the application. We wanted to install SQL server 7 on the pc and run the application locally. Can i insall SQL server on any OS or only NT Server? thanks ...more >>

Hi, Recently upgraded an application from access to msde...install and ran sql client on 5 XP and 1 win2k pro machines...only the win2k box cannot access the database... When I try to point to the data base it says it installed them but will not connect to them...checking the sql server DS...more >>

Hello I have reported this bug previosly, but Microsoft has so far not responded yet, so I am reporting it again. Basicly, SET FMTONLY is NOT working correctly with SQL Server 2000. Because of this bug I still have to use SQL Server 7.0 for my campuswide student information system application, alt...more >>

All, I have a MDI application with 15 or so different forms. Each form connects to the same SQL database via adodb. My question is, is it better to: 1. Just open the connection upon startup, then just reference the connection throughout each form opening 2. Open and close each connection ...more >>

Dear Professional I just wanna know about all procedures name with their parameter via single query !, how ? Waiting for your reply NOOR ...more >>

dear sir recently we have purchsed standard edition of sql server 2000, at the time of installation clent access to sql server was ok, bacause of the virus problem system in clients were corrupted, we have reloaded the system and sql server 2000 for client (client option) only . throu...more >>

Hi Is there any way that I can connect to a SQL Server from one of my PC without having SQL Client tools. I can install some minimal dll or any exe so that I need to connect to the SQL Server. If any solution please let me know. Thanks in advance. Anand...more >>

I am trying to export data out of a table that contains text field types. Here is the SQL: SELECT 1, 2, First(3) as First_Date, Last(4) as Last_date, SUM(val([5])) as Sum_Qty FROM Results Group By 1, 2 Field 3 and 4 contain dates in the format date/time but are in a text datatype....more >>

how can I insert a 'tab' character into a string data type? I tried char(9) in the help and it replaced by a single space when displayed. thanks....more >>

The SQL database / application that I am using does not have any functionallity to change the users password. It also does not use Windows security (I have to set up the users in SQL.) Is there a simple utility that would allow users to change their own SQL password? Could I create a script? ...more >>

All, I am inserting a new record into SQL and need to return the assigned IDNumber (autonumber) to my app or be able to get the ID. Dim sqlUpdate As String = "INSERT INTO tblCompanyInformation(CompanyCode, CompanyName, CompanyAddress1, CompanyAddress2, ProjectDetails, CompanyCity, CompanySt...more >>

Hi, I'm running into an annoyance that I can't figure out how to fix. For SQL Server 2000, in both Enterprise Manager and MS Visual Studio .NET Enterprise Architect Edition, if I display rowsets for a table and the results are more than a page long, I eventually (~5 mins) get a popup message ...more >>

Hi, i would like to list all database from a server using ado. Does anyone know how to do this. Thanks Sylvain ...more >>

The workstations in our office take approx 3 minutes to connect to the sql server program we use. Any suggestions where to begin searching for the problem?...more >>

Can somebody tell me whats the best way to connect to SQL server from Linux using C/C++. Has this ever been done in commercial projects? ...more >>

hi i can't join sql server from client why ??? thank's ...more >>

I know char uses more space than varchar since it right pad all data. But below example suprises me . Any ideas ?? ------------------------------------------------------------------------ create table TEST_TABLE( recno int, F_1 char(55), F_2 char(55), F_3 char(55), F_4 char(55)) go declar...more >>

can anubod tell me some online guide for this exam...more >>

I'm running Small Business Server 2000 (upgrade from NT4). I have a new XP Pro client that needs the SQL Query Analyzer and Enterprise Manager. How can I install these tools and where do I get them??? Thanks, Tod...more >>