Microsoft SQL Server Forum

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...

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...

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 want to use the Identity field (increment 1,1) as a primary key and have a unique constraint on my other field which is of type char. I am worried that related data in other tables may lose referntial integrity if records in the ID table get messed up and need to be re-entered. Can you please advice on best way to do this. I definitely need...

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...

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 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.

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

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

Hi, In case of a remastering of a client, I need to backup the Enterprise Manager configuration (the groups, the declared servers in the groups), instead of registering all servers manually once again. Does anyone know how it could be done ? TYA rjp

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

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...

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 was wondering if the CPU is the bottleneck. Hence I used the Performance Monitor to look up some values. Here are the results. Counter Scale Average Maximum Minimum %Disk Time 1 2.74 24.932 0 Current Disk Queue Length 10 0.090 6 ...

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...

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...

Hello all, I have been trying to find some information about exporting data from postgresql on linux to ms-sqlserver 2000 on windows but have not been able to get hold of any information. I would really appreciate if someone can point me to some source of information. Thanks in advance, Nishy

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

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...

Hi, I would like to add a unique index that consists of two fields in a table. e.g. tbl_A (field1,field2) -- field1 & field2 Indexed and combination must be Unique. Can anyone tell me the actual sql syntax to create this index? Thanks, June.

Greetings all, This should be an easy task, and Im sure it is, but as many times as I have tried, I cant seem to get this to work properly. We changed ISPs recently from a shared host to a co-located server, and our former host was nice enough to send us a backup of our old SQL2000 database (about 5MB). I went into Enterprise Manager,...

Hi all This is a super simple problem I am sure. I was playing with the DTS Import/Export tool to see if I could transfer and entire database between two computers. It seemed to work ok until the very end, when it gave a message saying it could not find