Hi I've got a sql server 2000 database that when running is runnign fine. About 9 months ago I altered one of the stored procedures and ever since then when the machine is rebooted the stored procedure is "reverted" back to the old sproc... ???
is there any way I can recrete a sproc in a job that runs every day?? why would it be doing this?
Our NT person thinks that rebooting the SQL 2000 (on WIn 2000) server every month is a good idea (this is a client production box). I am strongly against it. For starters any trends I am trying to capture with performance monitor become useless every time we do this. I am willing to listen to every one's opinion, but I hope by now that SQL 2000 is stable enough not to have to do this.
View 1 Replies View RelatedHi,
here goes the question:
i have 1 sqlserver 2k5 machine (machine A) and sqlserver 2k (machine b)
how do i build a query to select data from 2k machine in a query of 2k5?
i mean something like
select *
from login:passw@machineb.dabatase.dbo.customers
thanks!
Hi,
here goes the question:
i have 1 sqlserver 2k5 machine (machine A) and sqlserver 2k (machine b)
how do i build a query to select data from 2k machine in a query of 2k5?
i mean something like
select *
from loginassw@machineb.dabatase.dbo.customers
thanks!
Hi I've got a sql server 2000 database that when running is runnign fine. About 9 months ago I altered one of the stored procedures and ever since then when the machine is rebooted the stored procedure is "reverted" back to the old sproc... ???
is there any way I can recrete a sproc in a job that runs every day?? why would it be doing this?
Hi,I'm having a hard time figuring this out. Let me start by explaining my setup. I have a database that will hold high school football statistics. The two tables to focus on are the games table and the schools table---schema below: schools----------school_id (varchar, 4, unique)school_name (varchar, 32)school_city (varchar, 32)school_district (varchar, 32)games----------game_id (int, identity, unique)game_datetime (smalldatetime)game_stadium (varchar, 32)team_home (varchar, 4)team_away (varchar, 4) I didn't bother creating a separate stadiums table, because games will take place in only two stadiums. But here's what the row(s) I want to look like: game_datetime, game_stadium, school_name (for team_home), school_name (for team_away)The trouble is with pulling the school names for both teams from the schools table. I tried this query: SELECT * FROM games
INNER JOIN schools
ON team_home = school_id
OR team_away = school_id That pulls two rows for each game (one with the home_team's info and another with the away team's info).The way the tables are constructed makes sense to me, but I'm not opposed to changing the schema. Perhaps you can point me in a different direction. Thanks
Hi,anyone could explain this : I have installed the same asp.net application on 2 distinct hosts, each with its own SQL Server 2000 database.However, in some SQL queries in Stored Procedures, the results do not come out the same.For example, on one server the query "select @value = (select ....)-(select ...)" works and on the other one it returns a null valueAny hint ?Thanks for your helpJohann
View 2 Replies View RelatedI was able to successfully create a database maintenance plan for SQL Server 2000 Transaction Log Shipping for a few databases a few weeks ago. Yesterday, I created a few more but to my surprise, I can no longer do it. I can create a maintenance plan but the job it creates does not start even if I force the job to start. I did exactly the same thing as what I did (as I document everything I do) before but no luck.
Has anybody had this experience before?
Hi there,
We are in the process of upgrading from SQL Server 2000 to 2005. During testing we came across the following situation.
To reproduce the issue you can do the following
Create this structure in a 2000 and 2005 server instances
CREATE TABLE test
(a int,
b varchar(30))
INSERT INTO test
(a, b)
VALUES (1, '2')
INSERT INTO test
(a, b)
VALUES (3, '3a')
INSERT INTO test
(a, b)
VALUES (4, '4')
Then run the following statement in both servers:
UPDATE test
SET a = ltrim(rtrim(b))
WHERE b NOT LIKE '%a%'
AND ltrim(rtrim(b)) <> a
In 2000 this last statement will execute with no problem and it will update one row, whereas in 2005 the following error message is given:
Msg 245, Level 16, State 1, Line 20
Conversion failed when converting the varchar value '3a' to data type int.
By looking at the execution plan it seems that 2005 first tries to evaluate ltrim(rtrim(b)) <> a and then excludes those rows containing a whereas 2000 first excludes those rows containing a and then evaluates the different than condition.
I know fixing this instance itself is easy but I€™m more concerned about having to rewrite many more stored procedures where we find this same scenario; is there any setting that can be changed to avoid this?
Any guidance is much appreciated.
Thanks!
A stored procedure takes an IN parameter, an INOUT parameter, and returns an OUT parameter. When this stored procedure is defined in SQL Server 2000, the JDBC DatabaseMetadata method getProcedureColumns() returns three rows in the resultset:
one for the IN parameter (COLUMN_TYPE=1)
one for the INOUT parameter (COLUMN_TYPE=2), and
one for OUT parameter (COLUMN_TYPE=5).However, when the same stored procedure is defined in SQL Server 2005 (SP2), the getProcedureColumns() method returns only two rows in the resultset:
one for the IN parameter (COLUMN_TYPE=1)
one for the INOUT parameter (COLUMN_TYPE=2).No row for the OUT parameter is returned.
jTDS JDBC driver was used for both of the above tests. When the Microsoft JDBC Driver for 2005 was used against SQL Server 2005, the same behavior (only two rows in the resultset) was observed.
Has someone else run into such a problem? Is this a bug in SQL Server 2005 because the same jTDS driver works as expected against SQL Server 2000 but not against SQL Server 2005? Any feedback will be appreciated.
Thanks,
-- Damodar Periwal
Hi,i have SQL 2000 and 2005 on same machine(with different intance names,of course), my laptop - XP with SP2. The 2005 works fine but i can'tconnect on SQL 2000. All the the SQL services are started.Any idea? Have i to reinstall 2000?Tks,Lourival
View 1 Replies View RelatedI need to move a DB that's on a SQL 7.0 box to a SQL 2000 box for consolidation. I cannot upgrade the 7.0 box to 2000 at this time. I tried reattaching it on the 2000 box and it gave me some errors about versions mismatched. Would DTS be the best way to pull it over? If not, what's the recommended operation?
View 1 Replies View RelatedI'm currently running SQL Server 6.5 and 7.0 together on the samemachine (i.e. switchable using the program switcher). Does anyoneknow if i can install SQL Server 2000 to run alongside both of these?Thanks in anticipation.Rob
View 2 Replies View RelatedHi i am new using SQL 2005, i have SQL 2000 Personal Edition SP4 with 2 databases for testing installed in the default instance and i would like to install SQL 2005 standart Edition (i have Windows XP pro sp2) . can i have the same instance for both SQL database engine?. or to create a new instance for the 2005?. what i need is to test SQL 2005 while i keep my database for test in SQL 2000. I was trying to install by typing a named instance, and it gave me an errors. then i try again by choosing the default instance and then it start an upgrade operation and affter a sucess upgrade now i cannot see the sql management studio and neder Enterprice Manager for SQL 2000. i am confuse, some ideas for this issue?
View 5 Replies View RelatedHi all
I have a machine running SQL2000. And I have to share the machine to run another application that runs .NET2.0 and J#2.0.
Will it have any impact on the existing SQL 2000 server? Any experience could share?
Thanks
Can you have a SQL 2000 and 2005 running on the same machine? Can you direct me to resources regarding this?
View 4 Replies View RelatedHi, I am trying to create a connection string that will connect to a SQL Server 2005 Registration on a remote machine. I have a SQL Server 2000 registration (installed) on the same machine and so I think there may be a conflict. The SQL 2005 registration is denoted as HARDYSQL5 and the 2000 registration is merely HARDY (the machine name). I need to connect to a database on the HARDYSQL5 registration but I am not connecting. I have tried various connection strings but none have worked. I get a Login failure. I think this is red herring because I doubt its even finding the database.I can connect to the 2000 db with:"Server=HARDY;Database=Perimeter;UID=use;pwd=example;" But its fails with the following, for example:"Server=HARDYSQL5;Database=Perimeter;UID=use;pwd=example;" "Server=HARDYSQL5;Database=HARDYSQL5Perimeter;UID=use;pwd=example;" "Server=HARDY;Database=SQL5Perimeter;UID=use;pwd=example;" I'm gon go nuts. What am I doing wrong? Thanks.
View 10 Replies View RelatedDear All,I am developing a network application in asp.net. The database is in local machine having sql 2005. But the user database is already existent. So I am accessing that database which is sql2000. does it give any problem while connecting from sql2005 machine to sql2000. If yes it is giving me error as follows:An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.)connection string is :"Data Source=192.168.1.16,1433;Network Library=DBMSSOCN;Initial Catalog=mycatalog;User ID=myuserid;Password=mypwd;" Please correct me if I am wrong. Thanks and Regards.Fazal
View 2 Replies View RelatedHi all,
I started learning ASP .Net using the "Teach yourself ASP.Net in 24 hours". In that book, the applications use MSDE as the database tool.
Now i have started developing some big applications and have installled MS SQL Server 2000 on my machine.
I still have databases on the MSDE.
My question is 'How do i move the old databases from MSDE to SQL Server 2000' ?
Can i uninstall MSDE safely since i already installed SQL Server 2000 ?
Please let me know.
Thank You
:-)
Hi all,
I'm about to download the VWD ASP.NET 2.0 with SQL Express 2005, but i currently have Visual studio.net 1.1 and SQL Server 2000 installed on my PC, XP Pro.
Has anyone had problems with this or are they happy to run along side one another without over writing projects already created in the older versions?
Thanks in advance.
Allen
i am trying to install SQL 6.5 client on 2000 box. but the installation wants to install an SQL 6.5 SERVER on it. Is there something im forgetting?
is there a way and if so how? if not, is there a workaround with out upgrading the sql 6.5 server.
Thank you in advance
I am moving my SQL 2000 Server from a Small Business Server to a full version of Windows 2000 Server and SQL 2000 Server. I have had no experience doing this but have backed up and restored my production databases for practice in case a of disaster situation. Is there anything special I need to do to move everything, including the system databases to a new server and not loose any of the user logons, etc.?
Thanks for any advice,
Chris
Is it possible to install sql server enterprise edition on an xp machine (home or professional)? I tried both (w/sp2) and it said it can only be run as a client.
View 2 Replies View RelatedHi,
i have SQL Server 2000 running on my notebook for learning purposes. Is it possible to run SQL Server 2005 on the same notebook without using virtual machines?
Thank you,
Tobias
Hi Samuel,
I'd like to draw on your expertise on this topic. I've been browsing at many blogs/forums about installing SQL Server 2000 and 2005 on the same machine.
What I'd like to know is how does that work with Reporting Services? Your machine's IIS will need to work with Reporting Services 2000 and Reporting Services 2005. The RS 2005 requires .NET Framework 2.0 and RS 2000 requires .NET Framework 1.1. IIS can only support 1 version of the .NET Framework at a time.
Thanks kindly.
I've got to install sql server 2000 and 2005 on our test computer (sql server 2000 is already installed). I've heard from the grapevine that trying to install 2005 with 2000 already installed can cause problems, and its difficult for sql 2000 and 2005 to co-exist on the same machine.
what are these problems and how can I avoid them?
Thanks in advance.
When you connect to SQL Server using SQLConnection, how to set client machine name(or IP address) so that you can monitor the process on Server side using Enterprise Manager?
View 2 Replies View RelatedCan I install the client utilities for Microsoft SQL versions 6.5 and 2000 in the same machine?
Please, provide me with any information or links in this matter.
Can I install SQL Server 2005 Express Edition on the same server where I already have SQL Server 2000 Enterprise Edition?
Doing this also includes replacing .Net Framework 1.1 with 2.0, could that cause any disturbances to the already existing SQL Server 2000 ?
(None of these two databases are heavy production databases)
How can I get the 2000 and 2005 versions of SQL Server Reporting Servicesboth working on my development laptop ?????I have ASP.NET 1.1 and 2.0 installed on my laptop.I have Visual Studio 2003 and 2005 installed on my laptop.I have my default website configured for ASP.NET 2.0.I have the developer edition of SQL Server 2000 installed on my laptop asinstance RMK006 in the MSSQL folder. I have the developer edition of SQLServer installed on my laptop as instance RMK0062005 in the MSSQL.1 folder.I have the corresponding versions of SQL Server Reporting Services installedon my laptop.I have the Reports web site and the Reports web site and ReportServer website configured to ASP.NET 1.1I have the Report$RMK0062005 web site and the ReportsServer$RMK0052006configured to ASP.NET 2.0Entering http://localhost/reports$rmk0062005 in my web browser works fine.Entering http://localhost/reportserver in my web browser generates thefollowing error:Reporting Services Error--------------------------------------------------------------------------------The report server cannot decrypt the symmetric key used to access sensitiveor encrypted data in a report server database. You must either restore abackup key or delete all encrypted content and then restart the service.Check the documentation for more information. (rsReportServerDisabled) GetOnline HelpBad Data.--------------------------------------------------------------------------------Microsoft Reporting ServicesEntering http://localhost/Reports in my web browser generates the followingerror:The report server cannot decrypt the symmetric key used to access sensitiveor encrypted data in a report server database. You must either restore abackup key or delete all encrypted content and then restart the service.Check the documentation for more information. (rsReportServerDisabled) GetOnline Help Bad Data.The only way I can seem to get 2000 Reporting Services working is to do thefollowing:- run C:WINDOWSMicrosoft.NETFrameworkv2.0.50727aspn et_regiis.exe -u- uninstall 2000 Reporting Services- run C:WINDOWSMicrosoft.NETFrameworkv1.1.4322aspne t_regiis.exe -i- install 2000 Reporting ServicesBut once I've done that Visual Studio 2005 etc no longer work.The utlimate goal is an ASP.NET 2.0 application developed in Visual Studio2005; the application is based on a SQL Server 2000 database and needs toinvoke SQL Server 2000 Reporting Services to run reports.What am I doing wrong?ANY HELP WOULD BE GREATLY APPRECIATED - I'M DIEING HERE AND MY CLIENT ISLOSING PATIENCE !!!!!
View 1 Replies View RelatedHello everybody..Is there a way to fix the SQL Server 2000 installation when the Server afterthe server has been disjoined form its old domain and added to a new domainwith a different computer name too?Sounds like a joke, but stuff happens.TIA-arifi
View 3 Replies View RelatedHi,I am facing one more problem. As soon as i started the sql server firsttime, my windows 2000 machine reboots and i was not able to start sql serveragain. I had to uninstall and install again and this process repeats. Doanyone has idea about what is happening ??Thanks a lot,Dinesh
View 2 Replies View RelatedHi I would like to ask If its possible to have installed MSDE 2000 and SQL 2005 Express on the same machine. My computer uses MSDE 2000 for one application and I would like to install SQL 2005 Express for my own application. I would like to ask it will be a problem before I install it.
thanks a lot
Martin Molnar