How can I setup SQLServer 2000 to automatically disconnect clients that have been inactive for 2 hours? There was an option to do this in Sybase SQLAnywhere, but I haven't found it SQLServer. Thanks....more >>

Dear all, When calling SP from VB client,It seems like can't pass null as parameter value, Did anybody happen same issue? Cheers, Robert Song *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it!...more >>

I have SQL Server 2000 Enterprise Manager installed on XP box. I want to connect to SQL Server 2000, using trusted connection. I have required permisiions, but I receive this error message: Connection failed: SQLState: '28000' SQL Server Error: 18452 [Microsoft][ODBC SQL Server Driver][SQL S...more >>

Evenyone, I am using VB6 ADO command object to call Stored procedure. the SP have lots of paramters, some of parameters have already been given default values. To that parameters that have defalut values, I don't want to create these parameter objects when calling SP from VB side. But it seem...more >>

I have 3 tables tab1 with columns sname, fpath tab2 with cloumns pname, fpath tab3 with column pname I like to join tab1 and tab2 on fpath and get all rows that do NOT have tab2.pname = tab3.pname A query for that? -- Folke...more >>

Hi, Every time a run a query where dates are included, I get an 'Arithmetic overflow error converting expression to data type datetime'. The dates are stored as yyyymmdd (nvarchar 8) and usually the 'month(DATE_X) AS Month' syntax is used. I think that somehow, some of the dates are cor...more >>

I read text files in ASP on server side, then try to enter data into a database in SQL Server. The files are in ibm852 (1250) coding - at least that's the code page with which they are shown properly when putting the lines read on the output. However, when I enter them into the SQL Server (cur...more >>

How can I join two tables with many to many relationship? Any idea? ...more >>

Hi all, I've narrowed down my problem to a key issue. If I don't create a key, then ADO is happy. If I do, then I know get a complaint. I've whipped up the code fragment below to illustrate my problem. I'm using ADO v2.8, although v2.7 has the same problem. Dim dbtblSQL as New ADOX.Table ...more >>

Hi, We have a third-party software that uses Borland Database Engine (BDE), which depends on SQL Client Network Utility. I have a few dozens machines to setup and I'd like to deploy SQL Server Network Utility using Group Policies. Can it be done? Where do I find the deployment package? T...more >>

How do I find out how many Client Licenses I have available on my server?...more >>

I have Access XP and SQL 2000. I'm doing tests for my upsizing to SQL. I've read that I should have tables in my Access FE for data that don't change much. Like tblCity, tblEmployee and such. However, I do have a question on tables that don't get changed much, but are linked to other t...more >>

I would highly appreciate if any one give me the answer of the following questions Q1. Can anybody tell me an optimum hardware setup for performance as well as another model which compensates performance over cost. Q2. How would we tune Windows for SQL server? Q3. Can any one tell solid p...more >>

All, I found this script in one FIDONET conference and decided to test my servers available around. The result is more than strange. -- TSQL DECLARE @i INT,@j INT SET @j=0 SET @i=0 WHILE @i <= 3000000 BEGIN IF @i > 100 SET @j = @j+100 IF @i < 300 SET @j = @j-...more >>

Can any one give me the URL of licensing amount of Sql Server as well as Oracle Database. Thanks NOOR ...more >>

Today I had to repair my XP. Now I can't connect from my VB program to SQL Server 2000 The Union database cannot be found Connection String: Provider=SQLOLEDB.1;User ID=sa;Persist Security Info=True;Initial Catalog=Union;DataSource=HPA230N; The error is -214702479:Method 'Open' of object '_...more >>

I am trying to make a query from two tables in my database. The database will be an action item tracker.... Table 1 has the following: ACTION_ITEM ActionItemNum, Task, AssignedTo, AssignedBy, DateForReview, DateForApproval, DateForDelivery, Description, Etc..... ActionItemNum is the pri...more >>

Hi, i want to know if there's any particular reason why a temporal table can be dropped before closing the session. I'm having the following problem: i create the temp table when a form of my application is created, work with it and then drop it on the form's close event. It works fine most o...more >>

What is the proper way to upgrade SQL Server Client tools ? We are using an old version of SQL Server - v7. Query Analyzer says it is version 7.00.623. I installed SQL Server v7 SP4 and then patch MS03-031. However, Query Analyzer still shows as version 7.00.623. Thanks in advance.......more >>

We have a server running SQL2000 which I am trying to get access to via the internet. I have used the port forwarding setup on our router/firewall to transfer all traffic on port 1433 to the server 192.168.0.99. I cannot get a connection as it states the server was not found or it was denied a...more >>

Dear guys.. After completing the 070-228,070-229,070-215 which exam would be easy for getting MCDBA Certificate and have to clear in 20 days, Can anybody guide me regarding this. Thanks NOOR ...more >>

hi I try to open enterprise manager it cannot open it becouse of mmc.exe problem i upgrade my windows and reinstal sql but I still have that problem,is there any way I can open enterprise manager whitout format my windows? cheers -- mahsa...more >>

I ahve created a DTS package & was able to execute it from backend but while trying to execute DTS Package created in local Packages in sql client gets error. Error Number 2147287038T Error Description :The system cannot find the file specified. package Name :FSPETLISASUpload_DevSer...more >>

I ahve created a DTS package & was able to execute it from backend but while trying to execute DTS Package created in local Packages in sql client gets error. Error Number 2147287038T Error Description :The system cannot find the file specified. package Name :FSPETLISASUpload_DevSer...more >>

It's very strange!! When i am querying SQL database via SQL Query Analyzer, the query window sometimes close itself automatically without any notice. There is no infomation in system event log. Meanwhile, my other colleague can use the tool to query database without any problem. I am using ...more >>

Dear Colleagues: This is such an SQL newbie question its not even funny. To begin with, please forgive my informality as well as my lack of any specific error messages, etc.. . I think the questions are academic (the specific error messages and notes are strewn about my desk at work). Ok...more >>

Hi all, I am having a major problem with a simple application that queries a database. Firstly we have SQL2000 SP3a running on a Windows 2003 Server with all the latest patches and updates. Windows 2003 is running the shipped MDAC 2.8 and I've run the component checker to make sure there is...more >>

Hello, I have an Access client that has a subform based on a VIEW. I wrote the view with an instead of insert trigger. I also included the WITH VIEW_METADATA option. The problem is this. If I have the VIEW_METADATA option in my VIEW, the forms recordset is not updatable, but if it ALTER the...more >>

hi, can u help me in configuring a remote server using client-network = utility I got the username, password and the IP address of the server. regards...more >>

con Sqlserver 2000, puedo ejecutar trabajos con ActiveX, con VBScript y Javascript, ¿puedo hacer lo mismo con C#, es decir ejecutar scripts hechos en C#, con trabajos de Sqlserver 2000? ¿Se puede ejecutar scripts con C# al igual que podía con VBScript? Con VBScript escribo codigo en un archivo...more >>

Hi, I would like to create a comand which would detach a DB, zip the .mbf file into a directory and than, attach it. Can it be done and if so, how? TIA Elen ...more >>

Which newsgroup is available for Windows 2000 server. Thanks NOOR ...more >>

I want to give Data warehousing or Data Minning sort of exams for MCDBA so can any body tell me like is there any examination available for that in MCDBA? Thanks NOOR ...more >>

Hello all, I need solid clarification on the differences between the connection limit, performance governor and CAL's in regards to MSDE. 1. Do we need to tell our clients to purchase CAL's for a basic MSDE server? 2. What is the true number of simultaneous connections? I have heard 5,...more >>

There is a scanario like there are two tables name department and other is Employee. Each department manager has been added to the managers database role. You need to allow members of this database role to view all of the data in the department table. Members of this role should be able to insert...more >>

I wanna update one text file or we can say that write into text file through sql server, is it possible ? Thanks NOOR ...more >>

Hi, I have made a custom web application using .asp and an Access 2000 backend database. This application allows users to enter reference numbers. Once reference numbers are entered, a list is generated to be run on an external database to get account information for the account refer...more >>