Microsoft SQL Server Forum

I am having problems with long timeouts when connecting to or executing commands in SQL Server 2000 SP3. I am writing an application that will be used on laptops within an environment that is wireless. The application is written in VB.NET using the SQL Server managed provider. I have set the "Connect Timeout" parameter on the connection...

I have a Visual Basic 6 application that uses MDB or SQL Server databases. I was wondering if it was possible via Automation or ADO or some method, where I could programmicatlly upsize an MDB database to SQL Server. I can run the upsizing wizard from within Access to do the upsizing, and the database converts fine.

I will be deploying an application on an AIX server. Is there an SQL Server client software that I need to install on the AIX box to enable it to communicate with SQL Server?

INSERT INTO AD_Account (AcctName, AcctAddress, AcctCity, AcctState, AcctZIP, AcctStart, ListID) VALUES (, , , , , , ) INSERT INTO AD_AcctContact (ContactFName, ContactLName, ContactTitle, ContactTel, ContactEmail, ContactStart, AcctID) VALUES (, , , , , , @@IDENTITY)

I have a query which is quite complex. It's based on a set of data in a complex view which takes the data from several tables. In this complex query, if I allow the various parts of the query to work on the results of the view (MISView), it can take 15 minutes to run (eek !), however, if I create a temporary table with the data from the...

Hi, is there any way that I can automate granting user permissions to tables/ stored procedures in SQL server 2000? I have a whole bunch of tables and rather than having to right click each table/ then permissions in Enterprise manager I would like to be able to iterate through each table object in a database and grant the relevant...

I am trying to set up my machine for replication and have recieved the following message "SQL Server replication does not support nicknames, such as "." or "(local)" as server names. Delete the SQL Server registration for this server and register it using the actual server name" Well, I am not sure how to do that, I can't seem to find...

I will be deploying a Java application on AIX server. Is there a SQL Server Client Software that I need to install on the AIX server to enable the communication between the AIX box and SQL Server? -- Posted via http://dbforums.com

This may be a basic question, but defining anything other than a cursor is preffered. I have, as an example, 2 tables. One with customer data (addresses, phones, etc), the other is a listing of all 50 states (a cross reference for short state alias to long state name, i.e. FL - Florida, etc...). I want to sort the out put by state long...

We just installed SQL Server version 800.194 on a dual processor server equipped with a gigabyte of RAM, running Windows 2000 Server operating system. We set up a few databases with (so far) very tiny tables. When I am working locally (i.e. on the server itself) with Query Analyzer, even the simplest operation is incredibly slow. If I bring...

Hi, can someone help me out here. We have a database system for our distribution department to ship out orders everyday. We code with Clarion 5.5 of Windows are implementing some SQL. The current code implemented is working great. We want to add some more but our boss is having major reservations about it. He thinks that it will tax...

Hello All, We have outsourced much or our IT department to a large service provider who is managing our NT/Netware environment and our network infrastructure (routers, switches, etc.). They are using an enterprise management system to gather snmp traps and alerts and other info in order to identify problems before we do. Unfortunately,...

Hi. i am facing a problem. How do i save a java.util.Date in a SQLServer column declared as a 'datetime' . and please tell me how to retrieve it too.

I have two related tables in my SQL database that I wish to join as follows: ------------------------------------ tblCustomers ID (pk) Name etc. tblCustomerManagers

Hi, I have a few things on my databases which seem to be neither true system objects or user objects - notably a table called 'dtproperties' (created by Enterprise manager as I understand, relating to relationship graphing or something) and some stored procs begining with "dt_" (some kind of source control stuff, possible visual studio...

I'm having problems creating a linked server from SQL Server 2000 to DB2. I have an System DSN using Client Access ODBC Driver. I am trying to create the linked server using Enterprise Manager as below, Linked Server: MYLINKSERVER Provider:Microsoft OLEDB Provider for ODBC

Hi there, I am converting a large PL/SQL project into Transact-SQL and have hit an issue as follows: I have a PL/SQL procedure that converts a string to a date. The procedure does not know the format of the date in the string so it tries loads of formats in converting the string to a date until it succeeds.

I need to export certain fields of a table from sql 2000 into a dbf file, but can't find the proper query command to make it work. I also want to set this up to run each night automatically. Any help will be greatly appreciated. Randy

Is there a command to store a stored procedure to a script in stead of doing it manual one by one with the generate script option. I would like to make a script which copies a bunch of stored procedures each in a different file. A.M. de Jong The Netherlands.

I was experiencing odd behaviour from SQL Server within Vis Studio this morning and had to uninstall SQL. Trouble is I can't seem to get it set up the way it was before. I installed the developer edition, client and server tools. Can't recall if I did this last time,but now I get the error: "A connection could not be established on...

I'd like to use log shipping to provide warm backup to some production MSFT SQL 2000 servers. I know that I can write something to ship logs but I'm looking for a complete solution that would take a while to write. Prefer not to upgrade to SQL enterprise (too costly). Is there a tool that provides a robust solution? ... deletes old log...

Hi, I am getting "Row cannot be located for updating. Some values may have been changed" error when I try to update from visual basic with ado. This happens only when set as default locale on the pc other language than English. Anybody can help on this¿ Thanks

Hallo I have a DTS Package which reads data from a Access Database and imports it to SQL Server. This package runs without error when it is executed trough Enterprise Manager. When I create a job with "Schedule Package" and then try to run the job, it gives errors like this: Ausführt als Benutzer: SQL-S002MUR\SQL_Admin. ...db Das...

I've tried several different possibilities but don't have enough basic understanding of the ownerships and permissions that are involved so I'm looking for someone to explain what is required: I created a DTS package that includes a drop table, create table, and data transformation task. Originally, my owner was local to the pc workstation...

The University of Washington, Seattle, is offering two certificate programs, beginning in October, for those with significant background in relational databases such as SQL Server that would like to add an additional database to their skill set. If you are interested in also learning Oracle to enhance your ability to get a job, or to keep...