We are currently on SQL server 2005 service pack 1 for our sql server installation here.
Our reporting services and the database services for the reporting is on one Server box.
The datasource used for the reporting is on a different server.
Since Microsoft support for sp1 is ending in April, I am planning to upgrade the server next month. However we are also planning to use a different server for reporting which may not be available by April.
My question is can I have the SQL Server which hosts the datasource on Service Pack 2, while the reporting services and its databases are on SP1? I don't want to spend time on upgrading a server that is to be retired if I don't have to.
I posted this question before, and got a response about Windows Update. However, I work in a larger corp. and need to know if there are any other answers to this? We use a patch client that rolls out patches and service packs after we have tested them in our environment. What can we do to stay as up to date as possible for security patches?
How are security patches for SQL Server Express made available (e.g., as separate distributions or bundled into other Microsoft patch distribution mechanisms)? Are there specific procedures that I need to put in place to ensure that it gets patched on end user machines?
Does Anyone know if there is a way to verify the SQL Service Pack Version on 7.0 on Windows 2000 Advanced server?
I'm getting this results for select @@version
Microsoft SQL Server 7.00 - 7.00.623 (Intel X86) Nov 27 1998 22:20:07 Copyright (c) 1988-1998 Microsoft Corporation Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 1)
I installed Service Pack 5 on SQL 7.0 successfully, but when I go back to run @@version, it gives me Service Pack 2 which is the old pack. Does anyone know why and had an experience with this?? Thanks wonderful people!!!
I have a cluster server, with SP3 coming out I wanted to upgrade the SP2 I have right now, when I start SP3 installation it starts and quickly exits from the program. DO I need to uncluster the server before applying SP3? or there is a way arround it?
has anyone had this experience before after we installed service pack 2 our jobs are taking about 10hrs, some run it says it's succesfull but it didn't update the tables.
I have installed service pack-1 on SQL SERVER 7.0 Standard Edition. After the pack is installed @@version is still showing 7.00.623 instead of 7.00.699 HELP !!!
Does anyone else have any concern about this Watson technology creeping in to SQL Server in SP3? I don't like it in Explorer and I'm sure not going to like it in SQL Server!
BTW, Forrest article about the new security patches at http://www.databasejournal.com/news/article.php/1475241 is in error, I think, when it refers to SP4.
Is the sql server 2000 service pack 3 worth applying to production database server or should I still wait. i do have sql 2000 service pack 2 on the server ?
I am binding bunch of SQL object change t/sql code into one service pack and then distribute to around 1500 databases.
gradually, I feel I need to put the table/proc/trigger/field/datatype/data size.... all the changes into a kind of database so that could let me or other developers quickly pull out all the change info against a particular object, say table customer. It may have changed 15 times already, from enlarge customerName data size from 30 to 50, add a unique constraint to force the customerName uniquenss, add an index on companyPhone field, modify a delete trigger when an customer becomes inactive to append to a historyCustomer table before delete it....
Of course, the db should also include servicePack release date, each object release reason, approved by.....
At first, it sounds simple and not a big deal, but when I draw something and found the relationship between table--field--datatype--size--constraint is not so simple. Is there something even 'raw' available there already, so I might take a short cut and move on?
Is there a way to check what version of SQL 6.5 is currently in use? I installed SP5 but want to verify whether it is recognized as the current version. Also, what is the release # for SP5?
I just installed service pack 5.0a on a server.While I was installing it, when it came to the screen "updating system catalogs" it froze up and I had to reboot the machine.I could not get past this screen on successive attempts. When I do Select @@version it gives me the correct version though.
is there a way to uninstall the sql service pack,or is there another way of finding out whether the service pack was correctly installed.
Hi All, Feeling a little dense but I don't seem to be able to find out which sp's have been installed for SQL Server. Seems like it should show up under help. Can anyone tell me how to find out? Thanks
Has anyone heard any news about when Microsoft will release Service Pack 5 for MS SQL 6.5? I had originally heard this would be towards the end of summer.... but I think that time has passed.
Has it already been released and I am unaware? I`ve checked the Microsoft site and haven`t seen it.
Has anyone ever heard of this version? I have looked in the FAQ's and this one is not listed, however when we do a SELECT @@VERSION. It returns a 6.50.274
Anyone know which service pack this is, and if so, is it a baddy?
Does Anyone know if there is a way to verify the SQL Service Pack Version on on Windows 2000 Advanced server? I had downloaded SP 3 from microsoft site for intel.
I'm getting this results for select @@version
Microsoft SQL Server 7.00 - 7.00.623 (Intel X86) Nov 27 1998 22:20:07 Copyright (c) 1988-1998 Microsoft Corporation Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 1)
