I have sql server 2000 developer, sql server 2005 (workgroup, standard and enterprise), express and compact 3.5
and i need to test 2000, 2005 express and a full version of 2005 and compact all on the same machine.
Has anyone done something like this and are there any issues with this?
i have seen some threads about 2000 and 2005 being fine as long as one is a default instance and one is a named instance. Would i be able to do the same with say express being the default instance and then 2000 and 2005 both having named instances? And is there a particular order i should install? I already have 2005 express as the default instance and compact installed already.
I am learning SQL Server 2005 Express, and want to use the Northwind data base as used in many code examples. I wanted to attach the Northwind data base via SQL Management Studio, but cannot find a Northwind.mdf file.
When I do a search using 'Northwind', I see there are already a couple of different versions of Northwind already loaded. One appears to be associated with SQL Server Mobile Edition (Samples folder) and another seems to be associated with Visual Studio 8SDKv2.0Quickstart.
Can I use one of these existing Northwind databases (none have .mdf extention) for SQL Server 2005 or do I need to download yet another version?
I'm working on a DB that will be used in separate physical locations. These DBs will be identical in structure and completely independent of each other. Whilst some tables will retain similar or identical information, there is a large amount of content that will diverge.However, there is a central location that will need to manage these DBs. There will be a requirement from this central location to run reports, often comparing data between them, and to push data into each child location. There is no requirement for the child locations to 'share' information and indeed the volume concerned and the intermittent/low-bandwidth nature of their connections would make this undesirable. If an individual selection of data does need to be shared between I'm happy for it to be uploaded centrally, a decision made, and manually pushed to each child-location.
Which brings me to my real question. Should I try and include composite Primary Keys in many of the tables (to include probably an incrementing number and another field of site ID) so that when I absorb them all back centrally I can put them into one large DB. Or should I keep them as separate DBs in the central location and use some fairly 'normal' mechanisms for mirroring to sites; accepting that this will make running comparisons between them more difficult and potentially more difficult to write interactivity for centrally?
The best 'real world' comparison I can think of is transactions in retail shops. How do these transaction logs get stored centrally when they're all generating individual transaction numbers that are only unique in that location?
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 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?
We have multiple development environments on one machine for our VisualStudio .net projects.These are web applications so we have organized them by IP Address andHost Headers.When I installed Reporting Services, it installed into my default website (localhost) and that is fine.However, we want to be able to create our reports in our different .netprojects. The only projects that will allow me to create reports arethe projects using the default website.When I right click to create a new project, the Business Intelligenceprojects (reports) type is not there.Can I do this? If so, how do I configure it?
Help! I am using Script Transformation to output a new column as image[DT_IMAGE] field to store serialized object. In the VB script, the sample code as
The package always runs fine on my developing machine and will halt on other machine at AddBlobData after certain number row records were processed. I am stuck here. Anyone has any suggestion?
What I need is reading data from mutiple tables in one database and writing into a single table in another datable. In order preserve all the columns data, I use input column fields to construct a new object and then serialize it, and store the serialize data into detination db table. (The object and serialization function is coming from c# dll.)
Dim b As BusinessLicense = New BusinessLicense() b.ApprovalDate = Row.approvaldate b.BusinessId = Row.busid b.BusinessName = Row.busname b.NaicsCode = Row.naicscode b.NaicsDescription = Row.naicsdescr b.OwnerName = Row.ownername b.Phone = Row.phone b.Pkey = Row.pkey b.RenewalDate = Row.renewaldate b.StartDate = Row.startdate b.Suite = Row.suite
Row.serializedobject.AddBlobData(Serializer.Serialize(b)) '''----This is blocking line Row.infoType = BusinessLicense.TYPE
Both machine is xp with sp2. and standard SQL Server 2005 - 9.00.1399.06
Hi to everyone, I'm facing a problem that drives me crazy. I've a web application that has the following problem. When I test the application on my developement machine all runs fine, but when I put into production server there is a problem in connection pooling. Look at the following image, the blue line is the number of connection in the pool and the violet line is the number of connection reclaimed. From the image it is clear that connection are returned on the pool only in block, maybe when the garbage collection pass and reclaim the object. The strange thing is that on my developement machine all is good, and also I'm using Enterprise Library and the connection are managed internally.- Thanks to everyone for any help.
Hullo all I have two machines, One is a standalone machine and the other is on a domain network. How can I run a stored procedure/job on the standalone machine from the domain machine ? running the procedure as a Domain user results in a failed job/stored proc. also creating an sql login and attempting to run it as that user also fails. How can I solve this problem ? please e-mail me at wayde@sunnygrp.com if you have any thoughts...
Hi All;We are going to change our application server. We will copy all of ourDatabase from Mic 2000 Server OS to Mic 2003 Server OS. I found anarticle that how to move all the folders from same OS. My question isthat Would the 2003 OS be a problem when we copy all of the MC SQL 2000folders to New OS ? Has anybody done this before? Could you gimme yoursuggestions please?ThanksASA
If I use GetDate() function from client machine (using "\ServerMachineSQLExpress" instance from client machine "ClientMachine"), then from where I will get the DateTime value ?
I was wondering if there was any white papers on the migration part from microsoft? Apparently the situation is like this Currently installed MOSS 2007 in a testing pc as application server. This application server will refer another testing database server which running SQL Server 2005.
Now, wanted to move this 2 temporary server into another 2 new servers. Correct me if I'm wrong, it cannot be done by using image like Norton Ghost due to difference hardware spec.
So, if I install another fresh copy of MOSS2007 & SQL server 2005 in that 2 new servers, how can I migrate the contents, documents, etc from the testing database server?
It would be great if someone can show me the links to kb article. Thanks
We are in need of a solution to our problem. We are working for a customer and cannot use their database to work on during development. We have copied the layout and made a sample db for our development. Rather than writing down all the changes we make to our own db and then making the same changes to the customer's, is there a better way? Can we use something like sourcesafe? Thankyou
I've got a few SQL Servers at work which are development servers using SQL Server Standard Edition. I would like to downgrade them to SQL Server Developer Edition to save the Standard Edition licenses for production purposes. However, i do not wish to uninstall and reinstall SQL Server Developer Edition, restore all the dbs. Is there a way to change the version of the SQL Server ?
Hi All, Can we have 2 versions of SQL Server on the same server? Example, can I install SQL Server 2000 and 2005 on the same server? Please let me know about all the combinations possible/not possible.
Is there a way to do the following -- I need to be able to update a table based on a selection by a DDL. So here are my two update queries: 1. Update RequestData Set Approved = True Where DeptID = @DeptID2. Update RequestData Set Approved = True (Yes I need to be able to do all of the rows at once.) But it's all based on the selection of the DDL---I really don't want to have to create two seperate sql commands any ideas?
Is there a way to remove old versions of a DTS package without rewriting the entire package? These packages run fine but take up more space than I am willing to allocate.
I understand the SANs are only Supported by SQL Server 2000 Enterprise and no other versions of SQL, can anyone supply information to the contrary please?
This may seem like a wierd question, but can I have 6.5 and 7.0 running on the same machine? I need 6.5 for production builds and 7.0 for test. Is this possible? THanks
I can see that SQL server 2000 trial is available for download, but I need to try out 7 for a particular project at work. Is this available for trial download? (Has it ever been?)
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?
I'm running a SQL 7 db on a LAN in city A with other users accessing it fromanother city (city B) over a WAN. Obviously the WAN users are getting muchslower access to the data. One thing I was wondering was if it was possibleto have two versions of the database, one on each server, and have themautomatically synchronize as users at each location make changes. Or, ifthat's not possible, then at least have the city B users get any changesthat the city A users get as they are made.Thanks for any input.Neil
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.
I uninstalled the 32-bit Standard version but during install of the 64-bit trial version I got an error that the integration services could not install because the 32-bit version of COM+ was already registered and you can't have both. Need some help how to resolve this issue. Thanks
