Performance Issues - Access 2000 Frontend SQL Server 2000 Backend
Hi, Simple question: A customer has an application using Access 2000 frontend and SQL Server 2000 backend. Data connection is over ODBC. There are almost 250 concurrent users and is growing. Have they squeezed everything out of Access? Should the move to a VB.Net frontend taken place ages ago? Cheers Mike
michael.vandeweg
comp.databases.ms-sqlserver
14567 articles. 
1 followers.
janinepelletier (108) is leader.
Post
Follow
4 Replies
621 Views
Similar Articles[PageSpeed] 47
Hi Mike, I just completed a similar conversion if that's what you're thinking of doing. We converted 100 forms, 60 access reports and 15,000 lines of code "TO" 100 forms, 60 crystal reports, and 75,000 lines of VB.net code. It was a nightmare. We spent a good 50 percent of our time chasing down bugs in databinding itself, work arounds for tab controls that don't work, combo boxes that don't have incremental search like in access, radio and checkboxes that don't bind to database column nicely as in Access...let me see, what else sucks about .net,,,Oh, it takes freakin' forever to load a dropdown compared to access. Crystal is a pig (eg, 30 seconds of 100 percent cpu to gen one page of output). But on the bright side, mgmt is buying everyone new Pcs with a gig of main memory. I guess that's good for someone.
John7394Michael wrote: > Hi, > > Simple question: A customer has an application using Access 2000 > frontend and SQL Server 2000 backend. Data connection is over ODBC. > There are almost 250 concurrent users and is growing. Have they > squeezed everything out of Access? Should the move to a VB.Net frontend > taken place ages ago? > > Cheers > Mike Converting to dotnet could well be a lot of work for little benefit. If the system is of significant size then you might well want to take a look at techniques used in Access to ensure they're IO efficient. There again, if the system is working fine, why fix what ain't broke.
aon14You should also post this on comp.databases.ms-access. "Michael" <michael.vandeweg@za.didata.com> wrote in message news:1120467838.034104.295910@f14g2000cwb.googlegroups.com... > Hi, > > Simple question: A customer has an application using Access 2000 > frontend and SQL Server 2000 backend. Data connection is over ODBC. > There are almost 250 concurrent users and is growing. Have they > squeezed everything out of Access? Should the move to a VB.Net frontend > taken place ages ago? > > Cheers > Mike >
sergeaYou should also post this on comp.databases.ms-access. "Michael" <michael.vandeweg@za.didata.com> wrote in message news:1120467838.034104.295910@f14g2000cwb.googlegroups.com... > Hi, > > Simple question: A customer has an application using Access 2000 > frontend and SQL Server 2000 backend. Data connection is over ODBC. > There are almost 250 concurrent users and is growing. Have they > squeezed everything out of Access? Should the move to a VB.Net frontend > taken place ages ago? > > Cheers > Mike >
Similar Artilces:
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 Ser
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 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 2000
Hi 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 Issue
Hi, 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 databases
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. 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 2000
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 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 server
How 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 2000
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 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 2000
Hello 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 issues
hi 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 Database
Yesterday 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 2000
I 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 2003
Hi, 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 Server
Hi 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 DTS
I 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 2000
Hi 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 Java
Hi 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 2000
There 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 Problem
Hello 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 2000
This 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 2000
Hi, 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 Professional
Hello, 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 ...
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 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 2000
Hi 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 Issue
Hi, 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 databases
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. 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 2000
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 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 server
How 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 2000
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 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 2000
Hello 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 issues
hi 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 Database
Yesterday 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 2000
I 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 2003
Hi, 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 Server
Hi 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 DTS
I 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 2000
Hi 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 Java
Hi 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 2000
There 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 Problem
Hello 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 2000
This 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 2000
Hi, 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 Professional
Hello, 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 ...
Web resources about - Performance Issues - Access 2000 Frontend SQL Server 2000 Backend - comp.databases.ms-sqlserver
Performance - Wikipedia, the free encyclopediaA performance , in performing arts , generally comprises an event in which a performer or group of performers behave in a particular way for ...
Julie Stevanja of Stylerunner is speaking at PERFORMANCE INSIGHTS in Sydney this weekData will be what gives businesses the edge in the 21st century. No aspect of business will be untouched, from decision-making and corporate ...
Finnish Startup Beats Google, Microsoft and Amazon In Cloud Hosting Performance
... performer in a new study of top European Cloud Service Providers by industry consulting agency Cloud Spectator. “We have long identified performance ...
... performer in a new study of top European Cloud Service Providers by industry consulting agency Cloud Spectator. “We have long identified performance ...
IT teams choose between performance and securityAlthough security breach stories regularly make the headlines, a new survey shows that the biggest worry IT teams have with current security ...
Utility-Scale PV Projects: First US Statistical Performance Analysis... photovoltaic operating projects whose empirical AC capacity factors differ by more than a factor of two, however. Understanding the performance ...
cleveland.com Man catches fire during performance at school pep rally in Florida (video) cleveland.com DELRAY BEACH, Florida — Eight people ...
Meet the iPhone SE, which packs iPhone 6S performance in a 4-inch body... it, has an A9 chip and M9 coprocessor, which means it has double the speed of a 5S and is three times faster when it comes to graphics performance. ...
Gun Test: Performance Center Shield
Smith & Wesson has shipped 1,000,000 Shields - This little gem from the Performance Center just might be the King of Concealed Carry
Smith & Wesson has shipped 1,000,000 Shields - This little gem from the Performance Center just might be the King of Concealed Carry
New York Times The Passion Live's Best, Worst, and Most Confusing Performances E! Online "Hey Jesus, can I get a selfie?" We're genuinely ...
EXCLUSIVE: Justin Bieber Goes on 'Drunk' Rant During Impromptu Performance in Los Angeles: 'I'm Just ...
EXCLUSIVE: Justin Bieber Goes on 'Drunk' Rant During Impromptu Performance in Los Angeles: 'I'm Just Speaking Real S**t'
EXCLUSIVE: Justin Bieber Goes on 'Drunk' Rant During Impromptu Performance in Los Angeles: 'I'm Just Speaking Real S**t'
Resources last updated: 3/22/2016 5:45:06 AM