I've got installed Win 2003 SBS Premium with the SQL Server 2000 on a server
machine. It works almost fine, except the application which uses the SQL
Server. The main part of the application runs (since the last update) fine,
but other tools of that application (database import and the database
manager for check and rebuild) doesn't. They hang up or kill the database.
Our software developer says that these problems are in correlation with the
server os. But there won't be any problem if we install Win 2000 Server and
add an additional SQL Server 2000.
Finally my question is: Are there any differences between the SQL Server
2000 Versions, which are sold (a) as a single product, (b) as part of the
Win 2003 SBS Premium package and (c) as part of other Server versions?
Hi all... I'm a MySQL user and I want to switch to MS SQL Server, I heared that there is more than one type of MS SQL Server and one or two can be downloaded for free. Can someone tell me the different types of MS SQL Server and where can I download those free versions?
Is it possible to run both SQL200 standard and SQL2005 Express on thesame server? I need to test a database created in 2005 on ourproduction server but don't want to upgrade our "live" databases yet.
Hi If i develop a web application with sql server developement edition, it works fine in my webserver, or my webserver has to have the sql server development too? I'm interested in sql server report services. if i develop a web application with this tool what kind of version of sql server has to be installed in my webserver? Thank you
I know this is a very basic question for all of you but I need help.
I am a CPA working with a client to select an accounting & project management software for a construction client. In the top 5 choices, there are 2 that require MS SQL Server as the DB. This client will have about 10-20 users, including project managers & accounting personnel but by DB standards transaction volumes will be low. The company has a few large projects. There is no inhouse IT staff; network administration is outsourced.
The question on the table is this? How much more difficult is it to use MS SQL server in this environment? If all of the client's requirements can be met using a run-time version of Sybase, Pervasive, or FoxPro, isn't this the simplest solution. I don't want to recommend an elephant if it is not needed. I would appreciate your opinion....Thanks
Hello,We are trying to set up replication between different versions of SQLServer (7 & 2000).This is how the 2 servers are now setup:DB1 - External web-server w/SQL Server 7DB2 - Internal server w/SQL Server 2000REPLICATION SETUPThis is how we need the replication to be set up. They are allTransactional Replications.DISTRIBUTION:This is set up on DB2, which is running on 2000WITH PUBLISHERS ON DB1, AND PULL SUBSCRIPTIONS ON DB2:dbo.Employment_App & dbo.Employ_Jobs (together in one replication)dbo.FeedbackNOTE: This set of replications work some of the time, but make DB1 &DB2 very slow when running. A lot of times, the jobs say "RetryingJob", but they usually will eventually work.WITH PUBLISHERS AND PUSH SUBSCRIPTIONS ON DB2:dbo.Jobsdbo.Releasesdbo.SearchNOTE: This set of replications used to work when DB1 & DB2 both ran onSQL Server 7 with 2000 Enterprise Manager's. But since we moved thedata to an internal server (DB2) that runs on 2000, it doesn't work atall.We've researched the problem, and found an article by MS called"Replication Between Different Versions of SQL Server" athttp://msdn.microsoft.com/library/d...plimpl_4joy.aspthat states that this setup should be possible (on Combination 3 forTransactional Replications).But it's not working at all. Are there some steps that we need tocheck to have replication setup between 2 servers running on differentversions of SQL Server (7 & 2000)? Any & all help & advice isappreciated. Thanks.KWilliams
Do you find that there is a big difference between the different versions of SQL server (6.5, 7, 2000, 2005) as is between Microsoft programming languages (VB.4, VB5, VB6, .Net and now .Net 2) Or is the difference in SQL server minimal and very small compared to the programming languages I mentioned. Thanks a lot
I am having some problems in the process of moving an Access back-endto an SQL Server back-end. Everything works but there are severeproblems of response times when the number of users builds up.At present we are using the Developer version before committing to theEnterprise version. BOL (quoted below) seems to suggest that, apartfrom licensing, they are the same.Can anyone please confirm that this is so. If not, what is thedifference?I may explain in another topic the problems I am facing but I firstwish to be clear on this particular question.---------------------------------------------------------------------------------------------------------------Quote from BOLMicrosoft® SQL Server™ 2000 is available in these editions:SQL Server 2000 Enterprise EditionUsed as a production database server. Supports all features availablein SQL Server 2000, and scales to the performance levels required tosupport the largest Web sites and enterprise online transactionprocessing (OLTP) and data warehousing systems.SQL Server 2000 Developer EditionUsed by programmers developing applications that use SQL Server 2000 astheir data store. Although the Developer Edition supports all thefeatures of the Enterprise Edition that allow developers to write andtest applications that can use the features, the Developer Edition islicensed for use only as a development and test system, not aproduction server.
I am looking at combining / consolidating some of our servers and was wondering if I can install SQL 2000 and SQL 2005 in a clustered Environment on a san. Cheers Angie
I have one publicacion on ms sql 2005 Enterprise w.sp1/MS Windows 2003 Enterprise w.sp2 and one subscriber on MS sql 2005 Enterprise w.sp1/MS Windows 2003 w.sp2, but I have also 3 subscriber on MS SQL 2000 w.sp3/MS Windows 2000 advanced server w.sp4. They replicate the same database with a publication compatible with 80RTM, All works fine with data replication, but I can't replicate DDL to MS sql 2005 suscriber, I don't care that don't replicate DDL, but I want manually alter triggers at MS sql 2005 suscriber, but I get this error at the subscriber on when I run the ALTER TRIGGER statement :
Msg 21531, Level 16, State 1, Procedure sp_MSmerge_altertrigger, Line 67
The DDL statement cannot be performed at the Subscriber or Republisher.
Msg 21530, Level 16, State 1, Procedure sp_MSmerge_ddldispatcher, Line 181
The DDL operation failed inside merge DDL replication manipulation.
Msg 3609, Level 16, State 2, Procedure TU_Centros_Distribucion_Articulos, Line 58
The transaction ended in the trigger. The batch has been aborted.
Any help will be appreciated,
PD. I miss sql2000 replication, where I have full control over the database logic
I just finished an OLEDB interface written in VS2005 C++ that works with Sql Server Compact Edition 3.1. My team now wants me to make my interface compatible with Sql Server 2000, 2005, and 2005 Express. My question is...what header/lib files do I need installed and in my stdafx.h to pull this off? Is there a particular order I need to include these files in?
Right now I'm just including the following for SSCE:
#include <ssceerr30.h>
#include <ssceoledb30.h>
Once I get the right includes figured out, the next step is figuring out what CLSID's I should use in the CoCreateInstance call. I *think* I'm supposed to use CLSID_SQLOLEDB for 2000, CLSID_SQLNCLI for 2005, and I haven't a clue for 2005 Express. I could use some clarification on this as well.
Thanks a ton in advance...I've always been impressed by the MSDN boards...
One of the big problems with the old MDAC was different versions on different client machines. You would test your app with the latest version say, but when you deployed it, it might fail as the client has a different version.
My company develops software for Municipal Government clients. These clients use other SQL Server applications as well as ours, but they can only use one version of the client software (MDAC) on a given desktop. That means if we require a particular MDAC version, but the clients other applications from other vendors don't officially support that MDAC version, the client is in a real jam.
Our software also supports Oracle, which allows our software to specify a particular Oracle Home which points to a directory with a particular version of the Oracle client dlls (along with corresponding registry entries for that Oracle Home), such that we control the exact client version of the Oracle software that the client uses with our applications. This will not interfere with, and is completely seperate, from the default Oracle home installed when you install the Oracle client software.
What I would like to see for the Native Client is the ability to have our applications use the version of the Native Client that we wish to support and deploy without interfering with the Native Client version used by other applications. Have a default Native Client, but allow applications to somehow specify a different Native Client version/set of DLLs.
Is there any such functionality with the Native Client? (I didn't see any mention of such in the documentation, but I thought I'd ask)
If not, are there any future plans to support multiple Native Client versions on the same desktop?
I am confused about the version numbers for SQL Server Compact/Mobile. It _looks_ like the versions went from CE 2.0 to Mobile 2005 to CE 3.0 (or 3.1). Is this correct? In fact, I found one location the specifically said Compact Edition is the next version of Mobile. In another location I saw Compact Edition referred to as 2005 CE.
This has got me going because I am creating a Mobile/CE app and I keep getting a "Initialize SQL Server Reconciler" and the best information I can find indicates a mismatch between the server component and the client component.
So, what are the current versions of Mobile/CE? Is there a location that lists all of the components and what version they should be?
I'm trying to find what are the main differences between SQL Server 2005 64-bits and 32-bits. So far, I've found some articles about TPC-C performance but I would like to know some response time or execution time of a batch or SSIS packages.
Any information about this 2 versions is appreciated.
The i used components checker to check MDAC versions - both 2.8. Also then checked the related MDAC Dlls. All identical.
Only thing i am having real trouble checking is the "Server Network Utility" - which on the server that works (?) is giving me an error of 126 "the specified module could not be found". Any idea what could be causing this?
We have installed 2014 sql server. We have currently 2008r2. We have to run the real time report. So we need to set up transactional replication b/n those two servers. We need to use 2008r2 as publisher and 2014 as subscriber.
Is it ok to have subscriber higher version than the publisher?
I currently have three SQL Server instances installed on my notebook. One is v8, which I believe is used by an accounting application. The other two are as follows:-
SQL Server MSSMLBIZ
SQL Server SQLEXPRESS
The second one (SQLEXPRESS) fails to start generating the following error:-
The SQL Server (SQLEXPRESS) service terminated with service-specific error 17058 (0x42A2).
Other services listed in SQL Server Configuration Manager are:-
SQL Server Integration Services - which runs apparently normally.
SQL Server Analysis Services (MSSQLSERVER)
SQL Server Reporting Services (MSSQLSERVER)
SQL Server Browser
The last thre of these are run under LocalSystem.
I have been trying to install the SQLServer SP2 to the SQLEXPRESS instance for some number of days now, but each time it runs, it fails to install.
I am beginning to wonder if there is a sequence of installation for each of the above instances that should be followed. Can anyone give me any suggestions, or answers to the above problems?
Firslty, my aplogies if this is documented elsewhere - I am a new user to SQL Team and not yet found everything! I hope someone here can help me...
In brief, I am making the foolish mistake of embarking on my third and final year of an MS(c) degree in forensic computing. For my final year project I am intending to study and document (for forensic computing purposes) the forensic capture and investigation of data from a MS SQL Server database.
However, my experience is mostly from MySQL! In other words, I know very little about the internal structure of MS SQL Server 2000 or 2005.
Which leads me to my question....
Can anyone point me in the direction of a technical pagedocumentpdf (whatever) that details what the core fundamental differences are between 2000 and 2005. I'm not talking about an MS publicity paper - no, I need a non-bias technical guide which states the differences as fact.
If the differences in 2005 are mostly just cosemtic (the GUI etc) then I'll study 2000 because lots is already known and documented about it it seems. However, if it's much more than that and the differences are specific to what I'm studying (the forensic capture) then I'll probably have to go with 2005 because that's what we will be encountering more of in the next few years and the differences will effect the investigator.
Your time and responses much appreciated.
Regards
Ted
(BTW - Having looked at the description of 'Inside Microsoft SQL Server 2000', it seems like it might be a good book for my project (if I do 2000). Would you guys agree?)
Hi guyz, I have basic knowledge of Sql Server 2005 and now i wanna move ahead in Oracle 9i ! So, i have 2 questions here -
a)Whats the Difference between Sql Server 2005 and Oracle 9 i ?
Note: Please keep the discussion general so that student like me can understand. I have never seen Oracle but the industry requirements suggest that Oracle is way better than than SQL Server 2005. But thats what i think
b)I am Running Windows XP SP 2 and i would like to practise Oracle 9i. So, Where i can download it for free ? I know i have checked there website but they don't mention the difference between each version. Oracle does't market their products as well as Microsoft.
Please , I am Student .. so i request you to make the discussion general . Thank you for your time.
Hi, I am going to get a new laptop and was wondering in particular which versions of Windows Vista will run SQL Server 2005 Developer Edition. I want to be able to use all the features of SQL Server 2005, so IIS is needed for example ( I will be building end to end BI soutions using SQL Server Management Studio, SSIS, Analysis Services and Reporting Services.
Visual Studio 2005 shows SQL Server 2005 installed product versions differently than the actual. As seen below VS2005 displays 9.00.3042.00 as the version of SQL Server 2005 however it is 9.00.3050.00 in SQL Server Management Studio. [Look at Installed Products section after selecting About MS Visual Studio from Help menu ]
SQL Server Analysis Services Microsoft SQL Server Analysis Services Designer Version 9.00.3042.00
SQL Server Integration Services Microsoft SQL Server Integration Services Designer Version 9.00.3042.00
SQL Server Reporting Services Microsoft SQL Server Reporting Services Designers Version 9.00.3042.00
I have VS2005 SP1 and SQL2005 SP2 installed. Why VS2005 reports versions wrong?
how can I get the time differences between them.Let's say , a person who click on break @ 12:00 PM and he is back and select I am back option @ 12:15 the total break time is 15 minutes. However, can I display this difference of break time.
I'm facing a complicated problem and I don't think that the solution will be an easy one.
I have an SQL statement in Oracle which I need to translate it in Sql Server 2005.
select lpad(' ',5*(orderid)) || to_char(descr) as menui from <table _name> where MENU_ITEM not in ('test1','test2','test3') and item_parent not in ('test4,'test5,'test6') start with <item_parent='item_parent' > connect by prior <menu_item = item_parent and menu_name='ADR_m_adr_frame'; > ?(condition)
Somewhere I have read that SQL server does not support Hierarchical Sql statements. Is this true ? How am I going to do that ?
In our Microsoft Dynamics Nav instance we have a Sales Header Archive table - into which copies of the Sales Header are placed, with 3 items forming the compound key:
Document Number Version Occurrence number
so if doc 1 is archived, then the records would be
Doc# | Version | Occurrence # 1 | 1 | 1
When a second copy is archived a new record is added:
Doc# | Version | Occurrence # 1 | 1 | 1 1 | 1 | 2
and then when maybe a 3rd version is archived a 3rd entry added
This is for EACH document and I now need to retrieve the dataset which is the latest version of each document... but I'm drawing a blank!
If I
select [Doc#], max([Version]) as [V], max([Occurrence #]) from (table) group by [Doc#]
then I get the distinct list of docs, but I now need to use this list to select the records which match this criteria, from this table.
How do I select just these?
I thought (wrongly) that I could simply say:
Select * from Invoice Table where Invoice.[Doc#], Invoice.[V], Invoice.[Occurrence #] in (select [Doc#], max([Version]) as [V], max([Occurrence #]) from (table) group by [Doc#])
SELECT ROUND ('6.465',2) --- result 6.46 and SELECT ROUND (6.465,2) --- result 6.47 with
It's because you're relying on an implicit conversion from a string to a decimal data type which SQL server will do to 2 decimal places by default...
Alright:
SELECT ROUND (CONVERT(DECIMAL(3,2),'6.465'),2) --- result 6.47 Now please explain this: SELECT ROUND('0.285',2) -- 0.28 SELECT ROUND(0.285,2) -- 0.29 SELECT ROUND (CONVERT(DECIMAL(3,2),'0.285'),2) --- result 0.29 The string value does not seem to be converted to decimal with 2 decimal places.
MS is on the safe side with mentioning the last digit is always an estimate But because the result of the estimate is always the same, I would like to know:
* how is a string value exactly implicitly converted?
* how exactly does the estimation work, that in case of doubt rounds a value up or off?
When adding an SSIS step to a SQL Server Agent job, when selecting the location of a config file, the dialog lets you select from the database server you're working with. If selecting the location of the package itself (when the source is File System), the dialog lets you select from the machine where Management Studio is sitting instead of from the database server. Is that intentional? And if so, why? Should I just use a fully qualified file name for the package location rather than one using a drive letter?
Hi I have new bought the SQL server 2005 enterprise, but it have 2 CDs, so what are the differences between CD1 and CD2? and so which one should i install first? or is it necessary to install both two or just need to install one of them? And about my original sql 2000 database, can i just attach it's MDF file into the sql 2005 engine, or which import wizard can load the sql 2000 MDF into sql 2005? or do i need to keep the sql 2000 engine before do this? thx
IF Object_id('GoldenSecurity') IS NOT NULL DROP TABLE dbo.GoldenSecurity; IF Object_id('GoldenSecurityRowVersion') IS NOT NULL DROP TABLE dbo.GoldenSecurityRowVersion;
