MicroSoft SQL Server 2000, Service Pack 2, AppDev SQL Server 2000 Accelerated Training [3 CDs], TransTrainer for Designing Microsoft SQL Server 2000 Databases v1.1, SQL Server 2000 Reporting SerMicroSoft SQL Server 2000, Service Pack 2, AppDev SQL Server 2000
Accelerated Training [3 CDs], TransTrainer for Designing Microsoft SQL
Server 2000 Databases v1.1, SQL Server 2000 Reporting Services,
(Enterprise), Developer Edition 64 Bit, other 16,000 more CDs, [ no
dongles, no activations, etc ... needed ! ] (free donge)! No time
limitation!
CD NR 4203 MicroSoft SQL Server 2000 4in1
CD NR 9452 Microsoft SQL Server 2000 Service Pack 2
CD NR 11 298 AppDev SQL Server 2000 Accelerated Training [3 CDs]
CD NR 12 000 Microsoft SQL Server 2000 Developer Edition 64 Bit
CD NR 13 424 TransTrainer for Designing Microsoft SQL Server 2000
Databases v1.1
CD NR 14 688 SQL Server 2000 Reporting Services (c) Microsoft
CD NR 15 412 SQL Server 2000 Reporting Services Enterprise (c)
Microsoft
please send e-mail, to ola2@mail.gr, zorba@mail.gr
...
Using MS SQL Server 2005 Enterprise Manager with MS SQL Server 2000Hi Everyone,
Most of our MS SQL Servers are still running on SQL 2000, but being I
will soon be upgrading my workstation to Vista Business I'd like to
install MS SQL 2005 Enterprise Manager to manage them all. When I
tried to install MS SQL 2000 Enterprise Manager on Vista, it gave me a
message saying it's not compatible, so I'll have to use 2005 I guess.
We have LOTS of DTS scripts on our SQL 2000 server, and will 2005 EM
work with these okay? Also I want to make sure SQL 2005 Enterprise
Manager won't be adding to, changing, or 'upgrading' the DTS scripts or
anything on the SQL 2000 servers as we still have folks using SQL 2000
Enterprise Manager.
Thanks for any suggestions. I'm always leery when using cross-versions
of Microsoft applications because they are often incompatible or they
do squirly things that often break stuff.
Thanks --
Alex
Alex (samalex@gmail.com) writes:
> We have LOTS of DTS scripts on our SQL 2000 server, and will 2005 EM
> work with these okay? Also I want to make sure SQL 2005 Enterprise
> Manager won't be adding to, changing, or 'upgrading' the DTS scripts or
> anything on the SQL 2000 servers as we still have folks using SQL 2000
> Enterprise Manager.
>
> Thanks for any suggestions. I'm always leery when using cross-versions
> of Microsoft applications because they are often incompatible or they
> do squirly things that often break stuff.
There isn't any Enterpr...
SQL Server 2000 Performance IssueHi,
I've got a problem in that a stored procedure of mine always times out
within my application. Realistically there's no need to increase the
timeout because the individual sections of the SQL execute fast, yet
when I bring them together the execution time increases dramatically.
Firstly, here's the entire SQL statement
select
rate_id,price_id,date_from,date_to,daysofweek,product_id,time_from,duration,sell_price,min_price,sub_rate
from rate_sheet_dates rsd, product_prices pp
where rsd.date_id = pp.date_id
and date_from <= '2007-08-07' and date_to >= '2007-08-07'
and rsd.rate_id in
(select mo.rate_id
from timesheet_detail ts, main_order mo
where ts.order_id = mo.order_id
and ((ts.status & 2) <> 0)
and actual_datetime_from between '2007-08-07' and '2007-08-07'
and not exists (select * from invoice_detail where job_no =
ts.job_no)
union
select mo.rate_id
from timesheet_detail ts left outer join timesheet_group_clients tgc
on (ts.job_no = tgc.job_no), main_order mo
where tgc.order_id = mo.order_id
and ((ts.status & 2) <> 0)
and actual_datetime_from between '2007-08-07' and '2007-08-07'
and not exists (select * from invoice_detail where job_no =
ts.job_no))
order by rate_id,daysofweek,time_from
This is taking 12 seconds to execute.
If I take the unions;
(select mo.rate_id
from timesheet_detail ts, main_order mo
where ts.order_id = mo.order_id
and ((ts.status & 2) &...
MS SQL Server 2000 and MS JDBC SQL Server driver problems. (Connection timed out, followed by Error establishing socket)
I have downloaded the MS SQL Server 2000 Enterprise Evaluation edition, and
the MS SQL 2000 Server JDBC driver.
I have installed and configured the MS SQL Server 2000 onto two computers,
which reside on the same network. (In fact, these two computers comprise
the entire network).
The network server (computer name=SUNCDS1), and the lone node (SUNCDS2),
each have their own SQL Server 2000 instance.
The SQL Server 2000 Enterprise Manager console on SUNCDS1 shows both SQL
Server instances, the (local) instance, which is SUNCDS1, and also SUNCDS2.
It may be worthwhile to mention that the SUNCDS2 instance on the Enterprise
console does not show the SQL Server Agent as being started, but I can
navigate to the SUNCDS2 databases, and display the table information. If I
try to start the SQL Server Agent for SUNCDS2, I receive the message "Access
is Denied". The enterprise console on the SUNCDS2 machine indeed shows the
SQL Server Agent as being started.
I have written a sample Java application that uses both the MS SQL Server
ODBC driver and a JDBC type 4 driver (MS SQL Server 2000 JDBC) to establish
a connection to the SUNCDS2 instance. This application resides on the
SUNCDS1 network server. The ODBC driver will connect to SUNCDS2 instance
wihout a problem.
The JDBC driver does not connect to SUNCDS2. The JDBC driver will, however,
connect to the local SQL Server instance that resides on SUNCDS1.
Following are the code snippet to est...
SQL Server 2000 SQL Agent Error [393] Waiting for SQL Server to recover databasesWhile I was out of the office the Lan Team moved one of my SQL Server
2000 servers to a new network domain. Since then the maintenance job
has not ran.
The error log for the SQL Agents has the message listed in the subject
line. I have not found any useful articles on the MS SQL Server
site. Anyone know what might be wrong and how to fix it.
HTH -- Mark D Powell --
Mark D Powell (Mark.Powell@eds.com) writes:
> While I was out of the office the Lan Team moved one of my SQL Server
> 2000 servers to a new network domain. Since then the maintenance job
> has not ran.
>
> The error log for the SQL Agents has the message listed in the subject
> line. I have not found any useful articles on the MS SQL Server
> site. Anyone know what might be wrong and how to fix it.
I would try
select * from master..sysdatabases
where databaseproperty(name, 'IsInRecovery') = 1
and see if that finds something. There are a couple of more properties
for Databaseproperty that you should search for.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
On Jan 30, 5:30 pm, Erland Sommarskog <esq...@sommarskog.se> wrote:
> Mark D Powell (Mark.Pow...@eds.com) writes:
>
> > While I was out of the office the Lan Team ...
Database link to a MS SQL Server 2000Hi NG,
we have to replikate some data between an oracle DB and an application with MS SQL Server.
There is no possibility to load and push the data on the client mashine. We have to replicate the data on the server mashines
directly.
Is there a possibility to create a DB link from oracle to MS SQL Server or otherwise?
thanx
abbas
On Thu, 9 Jun 2005 00:13:02 +0200, "Abbas" <ar.newsgroup@web.de>
wrote:
>Hi NG,
>
>we have to replikate some data between an oracle DB and an application with MS SQL Server.
>
>There is no possibility to load and push the data on the client mashine. We have to replicate the data on the server mashines
>directly.
>
>Is there a possibility to create a DB link from oracle to MS SQL Server or otherwise?
>
>thanx
>abbas
>
Look into using Heterogeneous Services in your Net administrators
manual.
--
Sybrand Bakker, Senior Oracle DBA
Are you willing to install a bridge program to create this "link"? If
so, then try www.examinstudio.com
Do as Sybrand told you, look at the Heterogenous services of Oracle.
Oracle even supports natively DRDA towards a DB2 z/OS mainframe,
and they also support SQL Server. They all end-up like a database link
with a totally quallified names in the "from" clause.
Be aware of that distributed joins between different DBMS systems
might cause huge performance problems, keep the functionality
when dealing with multiple DBMS systems simple, no dist...
migrate Progress database to MS SQL Server 2000 #2
I am afraid that our customer has already made up his mind about movin
to MS SQL server and there is nothing that we can do about it
Is there a migration tool
--
panagiotis@mel
-----------------------------------------------------------------------
panagiotis@melo's Profile: http://www.progresstalk.com/member.php?action=getinfo&userid=817
View this thread: http://www.progresstalk.com/showthread.php?threadid=7937
Yes ther is. You'll find it between your ears.
Regards...Dan.
"panagiotis@melo" <panagiotismelo.1gvuzm@progresstalk.com> wrote in message
news:panagiotismelo.1gvuzm@progresstalk.com...
>
> I am afraid that our customer has already made up his mind about moving
> to MS SQL server and there is nothing that we can do about it.
>
> Is there a migration tool?
>
>
> --
> panagiotis@melo
> ------------------------------------------------------------------------
> panagiotis@melo's Profile:
> http://www.progresstalk.com/member.php?action=getinfo&userid=8173
> View this thread:
> http://www.progresstalk.com/showthread.php?threadid=79374
>
crossmerge.com ?
Regards...Dan.
"panagiotis@melo" <panagiotismelo.1gvuzm@progresstalk.com> wrote in message
news:panagiotismelo.1gvuzm@progresstalk.com...
>
> I am afraid that our customer has already made up his mind about moving
> to MS SQL server and there is nothing that we can do...
Import XML file to database (MS Server 2000) using procedure (transact sql) ???I must import some exemplary file to database (MS Srrver 2000) ofcourse
using procedure Transact SQL.
This file must:
1.Read the xml file
2. Create table
3. Import this date from xml file to my database
Ps. I create procedure who File xml imports to base, but unfortunately she
only schedule when earlier create a table or table is created.So I need (I
think) create such mini parser in language transact SQL.
Does someone have some ideas?
For every help Thanks
==== example file xml ===========================================
<root>
<Cust>
<IDosoby>1</IDosoby>
<Imie>Lukasz</Imie>
<Nazwisko>Przypadek</Nazwisko>
</Cust>
<Cust>
<IDosoby>2</IDosoby>
<Imie>Dariusz </Imie>
<Nazwisko>Mroz</Nazwisko>
</Cust>
<Cust>
<IDosoby>3</IDosoby>
<Imie>Tomasz</Imie>
<Nazwisko>Kolo</Nazwisko>
</Cust>
</root>
===========================================================
--
Luk
Not sure of the exact requirement. But if you can parse the XML and then
using OPENXML shred it into a new table.
SELECT * INTO <MyNewTable>
FROM OPENXML (@idoc, '/root/')
Where @idoc is the document handle of the internal representation of an XML
document.
--
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
...
Installing MS sql server 2000 on win 2003 serverHow do I do this when my instalation cd is an old veriosn with no SP�s? Win
2003 requires MS SQL 2000 SP3 sp what do I do???
Regards
Anders
> When you get the prompt saying that it must be SP3 you can continue to the
> end of the installation as per normal. You should then install SP3
> immediately before you do anything else. SP3a can be download from the
> microsoft web site.
Actually not. It says:
Ms SQL Server 2000 Enterprise Ediditon server componenet is not supportet on
this operating system. Only client componentes will be avaible for
instalation.
I juts read that bef...
Transferring databases from MSDE 2000 to SQL 2000Trying to transfer databases from MSDE to SQL. When I use SQL
Enterprise Manager - DTS - import or export, it works for the first
database, but then fails for the others. I select the to and from
databases using DTS - Import - 'MS OLE DB Provider for SQL Server',
then select 'Copy objects and data between SQL Servers'. It fails
with the generic error message: 'Copy objects failed', nothing
further. I tried to just copy data, and it doesn't work totally. On
two databases, it said that it copied everything, but when I go in
under Enterprise manager, some of the tables are incomplete, i.e. no
data, table shows up in the list, but if you try to look at it, it
says that it is missing or empty. Also, one table was not even
copied. In the other two cases, I get errors, does not copy all
tables. I get errors, like insert fails, but the column it references
for the table does not even exist in that table. Any suggestions
would be appreciated.
Bob (bobk7@earthlink.net) writes:
> Trying to transfer databases from MSDE to SQL. When I use SQL
> Enterprise Manager - DTS - import or export, it works for the first
> database, but then fails for the others. I select the to and from
> databases using DTS - Import - 'MS OLE DB Provider for SQL Server',
> then select 'Copy objects and data between SQL Servers'. It fails
> with the generic error message: 'Copy objects failed', nothing
> furth...
MS-SQL-Server 2000Hello NG,
we have created a database for our schedules on the SQL server 2000.
As we have many satellite stations, we created a merge publication.
The aim of this merge publication is to provide the satellite stations
with their "own" databases, in which they can alter their data and are
able to synchronise with the main server thereafter. At the same time
it is possible to enter data into the main server (in our main
office). The subscribers (?) (the satellite stations) have been
prioritised. The main database, of course, has 100%, and the
subscribers are put into hierarchical orde...
MS SQL Server 2000 -MS SQL Server 2000
Location: Raleigh, NC | Duration: 6+ Months | Start Date: ASAP | Rate:
Open
We are willing to pay salary of 60K to 70K/year or depending on
experience
Need contractor to assist the agency in migrating it's ArcIMS 9.1
site, MS SQL Server database to the latest version. The contractor
will perform the following tasks:
Update user interface
Migrate data to accommodate new database fields
Skills Required:
Must have experience with ArcIMS 9+.
Preferred:
Experience with MS SQL Server 2000, ASP .NET
Join INDUSA and get your IT career on fast track. Apart from providing
a tremendous growth opportunity and the right learning curve, INDUSA
offers several tangible benefits to its employees such as 401k Plan,
Health Insurance through Employer's Health Insurance Plan including
dental insurance for employee, Performance Bonuses and training
reimbursements once a year. Indusa has a dedicated staff that will
help you through the Green Card process. INDUSA offers friendly HR
policies including a great focus on continuous training and value
addition and it makes INDUSA the right place to be in for an IT
professional.
Nipun Joshi
email: nipun.joshi@indusa.com
Phone : 630 424 1800 # 320
Indusa Technical Corp.
1 TransAm Plaza Drive
Suite 350, Oakbrook Terrace, IL 60181
Fax : 630 424 0505
web: www.indusa.com
...
SQL 2000 performance issueshi there,
Just wondering if anyone can offer any advice on an a SQL performance
issue i have repeatedly come up against in work. I am a sys admin for
an internet company and we are having problems with SQL eating up too
much of the CPU on a brand new server. I am new to SQL so apologies
is my questions sound a bit simple. I have recently migrated one of
our databases to a new server (2 x CPU, 4gb RAM) and things were
running sweet. Recently we have launched a few new websites running
off the back of the database. The average CPU utilisation is now
hovering at about 50%. The problem is that we have a number of other
sites ready to launch off the database. We are running SQL 2000 on
windows 2003 standard x64 R2.
Obviously the first port of call would be to look at the database/
websites and try and optimise the code in order to improve the
performance but it is proving really difficult to squeeze any
resources out of the company. The directors of the company think that
because they have spent =A322k on a new SQL server they do not have to
put any more effort in. Whilst things have been pretty easy for a few
months as usual everyone has taken their eye off the ball. I can
quite easily see a situation arising in a couple of months were we
have a database that requires more power that the server it is running
on.
Can anyone offer any advice on the way forward with this one? I know
I need to looking into putting in a solution that will scale but it is
going to go down...
Restore of Case Insensitive Database to a Case Sensitive DatabaseYesterday I received a response to my CI/CS Collation problem and the
recommendation was to try and restore a CI Collation database to a CS
Collation database. After creating a blank CS database a full restore
(Force restore over existing database) does change the Collation to
CI. I'm unsure as to how I can restore without changing the
Collation. Any suggestions?
Hi. Check out this article:
http://www.sql-server-performance.com/vg_database_comparison_sp.asp
If appears that if you can put the CI db on another box and create a
linked server to it you should be able to bring over every...
Importing data from Pervasive 2000 to SQL Server 2000I am working on bringing data into our SQL Server from a btreive
database through Pervasive.
It seems to work, mostly, but I am having problems with dates.
At first, all date conversions from btreive field type Date to SQL
Server SmallDateTime would produce nothing but errors of this sort:
ActiveX Scripting Transform 'DTSTransformation_1' encountered and
invalid data value for 'HomesteadDate' source column.
Looking into the data on the pervasive side, many of the the date
fields had no data in them.
I tried to get around this by changing all lines that brought over
dates ...
Multiples Instance of SQL server 2000/SQL server 7.0 on Windows server 2003Hi,
Is it possible to install on a Windows server 2003,
SQL SERVER 2000 in the folowing configuration :
SQL server 7.0 as a default Instance
and
SQL server 2000 as a named instance.
Thanks for your answer.
riless (g.carali@voila.fr) writes:
> Is it possible to install on a Windows server 2003,
> SQL SERVER 2000 in the folowing configuration :
>
> SQL server 7.0 as a default Instance
>
> and
>
> SQL server 2000 as a named instance.
If SQL 7 can be installed on Win2003, yes. But I would not really
expect SQL 7 to be welcome on Windows 2003, although I don't...
Hanging or lockup issue with SQL Server and Terminal Services 2000 on NT 4 Domain ServerHi all,
Have a situation that my company has never run across before. Client
is running NT4 for the domain server, using terminal services 2000 and
running an application with a SQL Server backend and they are
experiencing locking problems. Once one person gets locked out then
everyone trying to access that tables is also locked out as a result.
It is not specific to a certain User, or module within the
application. It's not a specific time of the day (like when a backup
would be running) and sometimes it's in the middle of the night when
there are actually less Users on the syst...
DBF file export issues onWindows 2000 SQL server w/ DTS/ SQL 2005 with DTSI need to export data from SQL server 2000 (or SQL server 2005 with a
db connection to the SQL 2000 server) to a DB4 file via DTS.
When I use Windows 2000 server to attempt the export, I keep getting an
error message saying that one of my columns does not exist from the
Server 2000 DTS, and don't even see an option for 2005 DTS export to
DB4 in the SQL Server Import and Export Wizard for SQL 2005.
I've been exporting the information to Excel and then saving as DB4,
but this introduces a whole 'nother set of issues.
Please let me know what can cause the error message on Windows 2000 DTS
export that can say a column does not exist; additionally, please let
me know if DB4 export is available at all on SQL server 2005, as I
don't see it as an option.
Thank you,
Christopher Feyrer
...
Connection to MS SQL Server 2000Hi There,
I'm going to create a desktop application which will connect to a MS
SQL Server 2000 and do some SELECT queries. The problem is that I
can't decide which driver to use.. I'm trying to decide between
Microsoft's JDBC driver and jTDS.. The main problem is, they both
doesn't have "Connection Pooling" which is really essential for me..
By the way, I really can't decide whether I should open and close a
connection each time I need information on the database, or just open
a connection and close it whenever I want like quitting the
application or with a ...
MS SQL Server 2000 and JavaHi all,
I have a problem that deals with long time of creation java.sql.Statement
object:
Statement stmt
=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPD
ATABLE);
Time of call of such line is sometimes 4500 milisec.
Database: Microsoft SQL Server 2000,
JRE: JVM 1.4.1
JDBC Drivers: Microsoft w. SP 1
I do not use JDBC - ODBC bridge.
Does anybody know why it takes so much time? When application and DB server
is on the same machine everythink works fine. When I connect form other
machine times of creation Statement object are too big.
Gregory
...
MS-DTC / SQL Server 2000There is apparently a new worm called "Dasher" that
is making the rounds:
http://www.computerworld.com/securitytopics/security/virus/story/0,10801,107144,00.html?source=NLT_AM&nid=107144
It apparently exploits a "recently patched" flaw in MS Distributed
Transaction Coordinator.
Does MS SQL Server 2000 require MS DTC for anything besides
distributed update transactions, where "distributed" means
two or more database servers? If a server doesn't participate
in such transactions, can I safely disable MS DTC on that box?
...
MS-SQL-Server 2000 ProblemHello NG,
we have created a database for our schedules on the SQL server 2000.
As we have many satellite stations, we created a merge publication.
The aim of this merge publication is to provide the satellite stations
with their "own" databases, in which they can alter their data and are
able to synchronise with the main server thereafter. At the same time
it is possible to enter data into the main server (in our main
office). The subscribers (?) (the satellite stations) have been
prioritised. The main database, of course, has 100%, and the
subscribers are put into hierarchical orde...
PostgreSQL and MS SQL Server 2000This is a multi-part message in MIME format.
------=_NextPart_000_0000_01C41974.2A244FA0
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit
Hi !
My name is Mariusz Wojtkiewicz, im from Poland.
In my company we using base "MS SQL Server 2000".
In next time we will need new base in next office.
Our deliverer suggest as to use free base "PostgreSQL" put on free Linux.
All is fine and beautiful but is one problem:
We will need transfer all tables and record and changes from "PostgreSQL" to
"MS SQL S...
DROP Database sql server 2000Hi,
i have two servers. database A on server A . database A on server B
(both sql server 2000 - both same d/b - server B being the standy
by).if i delete databse A on server Ai have to deleted the standyby
copy on server B.
can anybody please guide me as to how to do this.
Thanks,
Shark.
shark (xavier.sharon@gmail.com) writes:
> i have two servers. database A on server A . database A on server B
> (both sql server 2000 - both same d/b - server B being the standy
> by).if i delete databse A on server Ai have to deleted the standyby
> copy on server B.
>
> can anybody please guide me as to how to do this.
On SQL 2000 the only way is to explicitly drop both databases.
On SQL 2005, you could set up a DDL trigger, although I'm not sure
that it would be worth the effort.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
...
SQL server 2000 installation problem on Windows 2000 ProfessionalHello,
I received the error message below when i'm trying to install SQL
Server 2000 standard edition into a Windows 2000 Professionale
workstation.
Error :
Microsoft SQL server 2000 Standard Edition server components is not
supported on this operating system. Only client components will be
available for installation.
Any request modification ?
Best regards,
Thanks
Thomas (tdethomas@yahoo.fr) writes:
> I received the error message below when i'm trying to install SQL
> Server 2000 standard edition into a Windows 2000 Professionale
> workstation.
>
> Error :
>
> Microsoft SQL server 2000 Standard Edition server components is not
> supported on this operating system. Only client components will be
> available for installation.
To supplement Lyle's answer, you can also opt to install Developer
Edition or Personal Edition on Win2000 Pro.
--
Erland Sommarskog, SQL Server MVP, sommar@algonet.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
...