Can you have a updatable Distributed Partioned Views between SQL
Server 2000 and SQL Server 2005 ? The reason I ask is the down time to
upgrade all 2000 sql servers to 2005 at the same time is prohibitive in
our environment.
Nevermind, I have tested and confirmed this works.
Showing posts with label versions. Show all posts
Showing posts with label versions. Show all posts
Thursday, March 29, 2012
Distributed Partioned Views between different SS versions
Can you have a updatable Distributed Partioned Views between SQL
Server 2000 and SQL Server 2005 ? The reason I ask is the down time to
upgrade all 2000 sql servers to 2005 at the same time is prohibitive in
our environment.Nevermind, I have tested and confirmed this works.
Server 2000 and SQL Server 2005 ? The reason I ask is the down time to
upgrade all 2000 sql servers to 2005 at the same time is prohibitive in
our environment.Nevermind, I have tested and confirmed this works.
Distributed Partioned Views between different SS versions
Can you have a updatable Distributed Partioned Views between SQL
Server 2000 and SQL Server 2005 ? The reason I ask is the down time to
upgrade all 2000 sql servers to 2005 at the same time is prohibitive in
our environment.Nevermind, I have tested and confirmed this works.
Server 2000 and SQL Server 2005 ? The reason I ask is the down time to
upgrade all 2000 sql servers to 2005 at the same time is prohibitive in
our environment.Nevermind, I have tested and confirmed this works.
Tuesday, March 27, 2012
Distinguish SQLServer and MSDE instances
How can I tell which of the SQLServers listed on the network are
specifically MSDE.
I want to make sure that I have licenses for all the full versions of
SQLServer that are running.
Thanks.
Alan
Issue one of the commands on the servers you want to find that out:
Select @.@.Version
--OR
EXEC master..xp_msver
HTH, Jens Suessmeyer
|||Another command would be to SELECT SERVERPROPERTY('Edition');
http://msdn.microsoft.com/library/?u...asp?frame=true
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team
SQL Server Developer Center: http://msdn.microsoft.com/sql
SQL Server TechCenter: http://technet.microsoft.com/sql/
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Jens & Alan,
Thanks very much.
Regards,
Alan
"Alan Z. Scharf" <ascharf@.grapevines.com> wrote in message
news:Ol87ezb6FHA.3276@.TK2MSFTNGP10.phx.gbl...
> How can I tell which of the SQLServers listed on the network are
> specifically MSDE.
> I want to make sure that I have licenses for all the full versions of
> SQLServer that are running.
> Thanks.
> Alan
>
>
specifically MSDE.
I want to make sure that I have licenses for all the full versions of
SQLServer that are running.
Thanks.
Alan
Issue one of the commands on the servers you want to find that out:
Select @.@.Version
--OR
EXEC master..xp_msver
HTH, Jens Suessmeyer
|||Another command would be to SELECT SERVERPROPERTY('Edition');
http://msdn.microsoft.com/library/?u...asp?frame=true
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team
SQL Server Developer Center: http://msdn.microsoft.com/sql
SQL Server TechCenter: http://technet.microsoft.com/sql/
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Jens & Alan,
Thanks very much.
Regards,
Alan
"Alan Z. Scharf" <ascharf@.grapevines.com> wrote in message
news:Ol87ezb6FHA.3276@.TK2MSFTNGP10.phx.gbl...
> How can I tell which of the SQLServers listed on the network are
> specifically MSDE.
> I want to make sure that I have licenses for all the full versions of
> SQLServer that are running.
> Thanks.
> Alan
>
>
Subscribe to:
Posts (Atom)