Hello I have a user who is attempting to connect to SQL Server Enterprise 2000 SP3a running on Windows 2000 Server. The client has WIndows NT 4.0 with MDAC 2.8. The problem is that when I attempt to create the ODBC link , I receive the following error "connection failed sqlstate '01000' sql ...more >>

I am executing the following query but it gave me the following error : ---------------------------------------------------------------------------- -------------------- use sugarv4asp GO if exists (select * from sysusers where name = 'sugarv4role' and (issqlrole = 1 or isapprole = 1)) beg...more >>

Is it possible to search an entire database for a string or number? If so How? - Hamilton ...more >>

I have a user and I want to to give persmission of that user to execute only this XP_CMDSHELL procedure nothing else. Any idea ? Thanks NOOR ...more >>

I have a created in one role in the NoorDb database and now I want delete that role throug if Exists command so can you tell me how I check through if Exists command. Second question is that I want to know the privileges of any user defined role, how can I ? Thanks in advance NOOR ...more >>

I have created one package and now I want to generate the scipt, how can I ? there is no option for this. Thanks NOOR ...more >>

I have the query below: select *=20 from=20 CDO_RXLINK T_CDO_RXLINK=20 where '03/29/2004' BETWEEN T_CDO_RXLINK.Created AND T_CDO_RXLINK.Deleted = AND=20 T_CDO_RXLINK.CID IN (100041, 100043) and=20 ( T_CDO_RXLINK.RxSource =3D 23921 or T_CDO_RXLINK.RxTarget =3D = 23921) The fiel...more >>

Is there any way that I can copy the database from MS Sql to MySql ? Thanks NOOR ...more >>

I used the following commands but it gave me following error: EXEC sp_addlinkedserver dbf ,'Jet 4.0' , 'Microsoft.Jet.OLEDB.4.0' , 'D:\' , NULL , 'dBASE III' GO EXEC sp_addlinkedsrvlogin 'dbf', 'false', NULL, 'sa', 'mypassword' SELECT TOP 10 * FROM dbf...doctor ****...more >>

Dear Prfessional Right now I have 190 tables and there are millions of data in the database but now I want to physically delete the Personnel from the database and when I started delete from master table so it gave me the constraint error and in 100 of tables there are reference that personnel...more >>

I have a foxpro dbf file and I want to copy the data from mdf to sql server, how can I ? I have tried through the sql server Import wizard but failed to do this. Waiting for your reply Noor ...more >>

Hi experts I am new in java programming. I am wana to write an application program to access MSSQL2000 from UNIX. But unfortunately, I am faile. (The program can access to MSSQL2000 from microsoft platform.). Anyone can help me to solve this program ? Thank you David Hunag F.Y.I OS : HPU...more >>

I use the following command in command prompt to output the query result into a text file ISQL /Usa /Pxx /Sserver /iscript.sql /oupdate.Log /n Because the ouput result has many fields in one line, I found that the update.Log has auto Word Wrap ( one line break into many lines ) and it canno...more >>

Hi All On one of our server (02 CPU, 2GIG of Memory) i've installed the database data on one disk (E:) and log on another disk (G:), some of update query took more than 1 seconde, I have monitored my server and noticed that the Avg. Disk write Queue Length is between 0 and 1 for the Disk E and...more >>

I have tried to installed Sql Server Service Pack 3 on my windows 2003 o/s but failed to installed. Any idea regarding this ? Thanks Noor ...more >>

Is there a separate installation or download that can be used to install the Microsoft SQL Client Utilities on a machine to provide the ability for a client application to communicate with the Microsoft SQL Server Database. I know the Tools and Utilities are included on the SQL Server CD but we ...more >>

This sounds stupid, but I cannot find a way to just get today's date without the time to pull a date range... I have tried convert (datetime, GetDate(), 112) and some others, all to no avail... isn't there just a date function that doesn't include the time? ...more >>

Hi, We need to have a clarification and a full technical explanation about the folowing issue: A Year ago Microsoft had announced and released MSDE, Microsoft desktop engine, where we can download it from the internet at the Microsoft website, (it comes also free with Microsoft office 20...more >>

I have a field in a table that contains date data in the following format: 20040301 what is the best, low impact method for converting this to a useable date field? ...more >>

I want to export data into one text file which contain image fileds. Noor ...more >>

I have made transaction replication and it's working fine and now I want to drop one procedure from publisher database but its gave me an error that you can't drop the procedure b/c it's beeing used in Replication .. what should I do? can any tell me . Thanks in advance. Noor ...more >>

I've installed a new server as a Windows 2003 Server member of my NT 4 domain and installed SQL Server 2000 on it. Clients who're authenticated to the domain don't seem to be able to see the SQL Server database although they can see shares on the server where it's installed. I've been ...more >>

Windows 2000 Server SP4, Microsoft SQL Server 2000 - 8.00.760 (Intel X86) SQL Server is finished with ---------- Event Type: Error Event Source: Service Control Manager Event Category: None Event ID: 7031 Date: 22.03.2004 Time: 10:14:19 User: N/A Computer: SQL Description: The MSSQLSERVE...more >>

I have some programs (written in vb6 & vb.net) that connect to sql server on a W2k machine. I should change the machine (moving to a new one) but for a few days the two machine will co-exist so I cannot give to the new machine the name of the old one. I would like to have the programs accessi...more >>

Is it normal to see a new TCP connection for every SQL statement executed [via ADODB.Recordset.Open] when connection pooling is switched on? When my ASP application is running there seems to be 1 constant connection open, and 3 or 4 separate and continually opening/closing connections. On ex...more >>

How do I validate how many licesenes I am using in SQL 2000? ...more >>

Good day, [SQL Server 7.0, SP4] I have a table wich contains only one column [varchar (1500)] filled with some texts (different length, ranging from 150 chars up to 1200s). When I execute "Select * from Table1", I only get parts of my texts; the returned strings are truncated, but not ...more >>

When I try to run a local package on a SQL 2000 box from my desktop machine I get the following error: The exception unkown software exception (0xc000001e) occured in the application at location 0x4150de I am running Windows 2000 Professional with SP4. I have also installed SQL Server SP3a and A...more >>

Hi, I use the convert function like this: CONVERT(VARCHAR(10),'2004-05-05 01:01:01',120) But I would like to replace 10 in the VARCHAR definition with a variable, like this: DECLARE @DateSelect int SET @DateSelect = 10 CONVERT(VARCHAR(@DateSelect),'2004-05-05 01:01:01',120) This...more >>

Can any body let me know about the suspect database what is the remedies...more >>

Hello we are migrating an Access Database to SQL Server 2000. We are usin the Access feature Upsizing Wizard. The wizard works all the times fine but one Table missed everytime! The Table contains about 4.000.000 rows If the Table contains less rows such as 3.400.000 rows it would b upsized Is...more >>

Can McAfee antivirus slow down a sql server? If McAfee scans each file that is touched for a virus. Is running antivirus on a SQL server common practice? Why or why not? Thanks, The Borg ...more >>

Dear sir How do i pass the value to the views in sql server 2000. i have monthly table depending upon monthly table i want to extract data from the particular table for e.g. table name tbltrip_2004_1 i want to pass the value _2004_1 to the view i can do this using stored proc but how can...more >>

My name is Cam. I am an SQL Server developer, noticed the following problem and need your help badly. Situation: We have 2 databases in our system; Database FASAT_PROD and FASAT_PROD_ARCHIVE; we also have 2 tables, which have the same structure; AGENT_ACTIVITY, which is in FASAT_PROD and...more >>

amount before 82.758 960.000 331.034 After 82.7 960.0 331.0 hi there i want to trim last 2 digit. how can i accomplish in sql script?? ...more >>

I have an XP desktop connecting to SBS 2003 which intermittently loses its ability to connect to the SQL server residing on the SBS server. Rebooting the XP desktop is the only way to get it to talk again. The client application, from what I can tell, is a VB client with no diagnosti...more >>

Hi All, Can any one tell me how many column can be accomodated inside a Table of SQL Server 2003. In SQL Server 200 we could add 256 columns in a Table. What about SQL Server 2003.?? Hoping to hear frm you Thanks Vikash ...more >>

Hi, I have SQL Server 2000 running on one box and IIS running on another box. I am connecting to the SQL Server via ASP pages on the IIS box. My concern is security -- currently I am using this kind of code to connect: var setListings = Server.CreateObject("ADODB.Recordset")...more >>

Dear Professional I have a question here regarding replication.. I have created the replication and inserted one row in entity table on the publisher site instead of replicating the data into subscriber database it gave me the following error. Error :- Could not drop object 'Entity' ...more >>

Dear Professional I have a question here regarding replication.. I have created the replication and inserted one row in entity table on the publisher site instead of replicating the data into subscriber database it gave me the following error. Error :- Could not drop object 'Entity' beca...more >>

I have an application for scheduling sales appointments. One important requirement is to never have two salesrep on the same appointment. My first stab at it was to deal with in code but soon found out this approach was not as robust as I would like. Perhaps, I thought, I should create a declarat...more >>

Using Query Analyser, how do I create a new table in my database? I keep getting: [Microsoft][ODBC SQL Server Driver]Syntax Error or access violation. Furthermore, in my code: create table DummyTable1 { empid int empname varchar(8000) } ....what do I preceed the DummyTable1 wi...more >>

While trying to install SQL Server 2000, I am getting error 1904. What is the solution ?...more >>

Hi all, I get the above message in a message box after the stored procedure has executed for about 7 seconds and around 2500 records are inserted.This happens only when the results are viewed in the Grid view of query analyer and when the results are in the text view its working without any...more >>

Hi, I am new to SQL 2000. We have bought the full version and we have created some tables with large numbers of records (20m, 60m etc...) but I wish to know more about Indexes and all the different types within SQL 2000 and which one to use and for what. Clustered and Non-clustered ne...more >>

Hi, Is there a way to set the time zone as a parameter in a query? I am working on an ASP.NET application that gets data from a sql server. The sql server uses UTC time but I need be able to select data according to the ASP.NET application local time. I can easily change the query to ...more >>

Hi I'm working in a project which uses JDBC to connect to an SQL Server and execute some stored procedures. It works fine so far, excepting one thing: Some errors from SQL Server do not cause an SQLException to be thrown in the Java program. Most errors work fine, but some don't work For example...more >>

i am passing this query select received_date, received_time, act_closed_date, act_closed_time, assigned_to from ticket where received_date < '3/13/2004' and received_date <> act_closed_date and act_closed_date <> '1/1/1900' order by received_date desc for which i get this result ...more >>

Just getting started with SQL app programming. Writing a business app using odbc. Here is my concern. The app creates nice invoices and other documents for my client. But how can I be certian the data used to create the invoice does not get changed down the road by some autherised user, theref...more >>

Server is Running Windows Server 2003 SQL Server 2003 SP-3 Client is running MDAC 2.8 Windows Server 2000 Service Pack 4 and Critical Updates Access 2002 SP-2 I can create a brand new Access Project using existing Data on the sql server. Specify use Windows NT Integrated Security, Spe...more >>