How Can I check what service pack I have?

I need to Know waht service pack I have for sqlserver?
I possible to know that?
http://www.aspfaq.com/2160
http://www.aspfaq.com/
(Reverse address to reply.)
"Lorena" <Lorena@.discussions.microsoft.com> wrote in message
news:D7E0B2B0-A9D1-4BAD-8D8C-D31590BA3D2D@.microsoft.com...
> I need to Know waht service pack I have for sqlserver?
> I possible to know that?
>
>
sql

How Can I check what service pack I have?

I need to Know waht service pack I have for sqlserver?
I possible to know that?http://www.aspfaq.com/2160
http://www.aspfaq.com/
(Reverse address to reply.)
"Lorena" <Lorena@.discussions.microsoft.com> wrote in message
news:D7E0B2B0-A9D1-4BAD-8D8C-D31590BA3D2D@.microsoft.com...
> I need to Know waht service pack I have for sqlserver?
> I possible to know that?
>
>

How can I check the version?

Hi, I need to know what's is the latest service pack of my sql 7.0, how can
I check it?
How do I know which user is using sql database?
Thanks,
SarahHi, I need to know what's is the latest service pack of my sql 7.0, how canI
check it?
run
SELECT @.@.version statement to view the version
7.00.699 SP1
7.00.642 SP2
7.00.961 SP3
7.00.1063 SP4
How do I know which user is using sql database?
sp_who or sp_who2 to see who is logged in.
"Sarah G." <sguo@.coopervision.com> wrote in message
news:u%23lFgq0GEHA.3068@.TK2MSFTNGP11.phx.gbl...
> Hi, I need to know what's is the latest service pack of my sql 7.0, how
can
> I check it?
> How do I know which user is using sql database?
> Thanks,
> Sarah
>|||Thank you so much,
Sarah
"Prasad Koukuntla" <prasad.koukuntla@.scapromo.com> wrote in message
news:eh9exu0GEHA.1240@.TK2MSFTNGP10.phx.gbl...
> Hi, I need to know what's is the latest service pack of my sql 7.0, how
canI
> check it?
> run
> SELECT @.@.version statement to view the version
> 7.00.699 SP1
> 7.00.642 SP2
> 7.00.961 SP3
> 7.00.1063 SP4
> How do I know which user is using sql database?
> sp_who or sp_who2 to see who is logged in.
>
> "Sarah G." <sguo@.coopervision.com> wrote in message
> news:u%23lFgq0GEHA.3068@.TK2MSFTNGP11.phx.gbl...
> can
>

how can I change SQL 2005 Licence key

we have a server installed SQL 2005 with Microsoft Action Pack Product Key,
because we had to install a application program before we got the Licence.
Now we got the Licence and Product Key for this server. Their are two
questions I am wondered.
One is I couldn't find the licence infromation in SQL menues. Where can I
find the Licence information in SQL?
The other is How can I swap the Licence Key in this situation.Do you really need to change SQL2005 license key?
I have never found any need to fiddle with the SQL2005 license key. It's
hard coded in the install media--well, I'm not sure whether that's always th
e
case, but it's always the case where I have dealt with SQL2005.
Linchi
"snailsnail" wrote:

> we have a server installed SQL 2005 with Microsoft Action Pack Product Key
,
> because we had to install a application program before we got the Licence.
> Now we got the Licence and Product Key for this server. Their are two
> questions I am wondered.
> One is I couldn't find the licence infromation in SQL menues. Where can I
> find the Licence information in SQL?
> The other is How can I swap the Licence Key in this situation.
>

how can I change SQL 2005 Licence key

we have a server installed SQL 2005 with Microsoft Action Pack Product Key,
because we had to install a application program before we got the Licence.
Now we got the Licence and Product Key for this server. Their are two
questions I am wondered.
One is I couldn't find the licence infromation in SQL menues. Where can I
find the Licence information in SQL?
The other is How can I swap the Licence Key in this situation.
Do you really need to change SQL2005 license key?
I have never found any need to fiddle with the SQL2005 license key. It's
hard coded in the install media--well, I'm not sure whether that's always the
case, but it's always the case where I have dealt with SQL2005.
Linchi
"snailsnail" wrote:

> we have a server installed SQL 2005 with Microsoft Action Pack Product Key,
> because we had to install a application program before we got the Licence.
> Now we got the Licence and Product Key for this server. Their are two
> questions I am wondered.
> One is I couldn't find the licence infromation in SQL menues. Where can I
> find the Licence information in SQL?
> The other is How can I swap the Licence Key in this situation.
>

how can I change SQL 2005 Licence key

we have a server installed SQL 2005 with Microsoft Action Pack Product Key,
because we had to install a application program before we got the Licence.
Now we got the Licence and Product Key for this server. Their are two
questions I am wondered.
One is I couldn't find the licence infromation in SQL menues. Where can I
find the Licence information in SQL?
The other is How can I swap the Licence Key in this situation.Do you really need to change SQL2005 license key?
I have never found any need to fiddle with the SQL2005 license key. It's
hard coded in the install media--well, I'm not sure whether that's always the
case, but it's always the case where I have dealt with SQL2005.
Linchi
"snailsnail" wrote:
> we have a server installed SQL 2005 with Microsoft Action Pack Product Key,
> because we had to install a application program before we got the Licence.
> Now we got the Licence and Product Key for this server. Their are two
> questions I am wondered.
> One is I couldn't find the licence infromation in SQL menues. Where can I
> find the Licence information in SQL?
> The other is How can I swap the Licence Key in this situation.
>sql

hotfix/service pack directory

I remember seeing a post in this newsgroup for a website maintaining a
(fairly) comprehensive list of hotfixes, service packs and cumulative
update packs for SQL Server.
Anyone care to re-post?
Maybe Aaron Bertrand's blog?
http://sqlblog.com/blogs/aaron_bertrand/default.aspx
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"horseradish" wrote:

> I remember seeing a post in this newsgroup for a website maintaining a
> (fairly) comprehensive list of hotfixes, service packs and cumulative
> update packs for SQL Server.
> Anyone care to re-post?
>
|||take a look here
http://www.aspfaq.com/sql2005/show.asp?id=20
and here
http://www.aspfaq.com/sql2000Builds.asp
Denis The SQL Menace
http://sqlservercode.blogspot.com
http://sqlblog.com/blogs/denis_gobo/default.aspx
On Nov 27, 4:34 pm, horseradish <dontcal...@.illcallu.net> wrote:
> I remember seeing a post in this newsgroup for a website maintaining a
> (fairly) comprehensive list of hotfixes, service packs and cumulative
> update packs for SQL Server.
> Anyone care to re-post?
|||Check this one
http://sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx
Manu
"horseradish" wrote:

> I remember seeing a post in this newsgroup for a website maintaining a
> (fairly) comprehensive list of hotfixes, service packs and cumulative
> update packs for SQL Server.
> Anyone care to re-post?
>

hotfix/service pack directory

I remember seeing a post in this newsgroup for a website maintaining a
(fairly) comprehensive list of hotfixes, service packs and cumulative
update packs for SQL Server.
Anyone care to re-post?Maybe Aaron Bertrand's blog?
http://sqlblog.com/blogs/aaron_bertrand/default.aspx
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"horseradish" wrote:
> I remember seeing a post in this newsgroup for a website maintaining a
> (fairly) comprehensive list of hotfixes, service packs and cumulative
> update packs for SQL Server.
> Anyone care to re-post?
>|||take a look here
http://www.aspfaq.com/sql2005/show.asp?id=20
and here
http://www.aspfaq.com/sql2000Builds.asp
Denis The SQL Menace
http://sqlservercode.blogspot.com
http://sqlblog.com/blogs/denis_gobo/default.aspx
On Nov 27, 4:34 pm, horseradish <dontcal...@.illcallu.net> wrote:
> I remember seeing a post in this newsgroup for a website maintaining a
> (fairly) comprehensive list of hotfixes, service packs and cumulative
> update packs for SQL Server.
> Anyone care to re-post?|||Check this one
http://sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx
Manu
"horseradish" wrote:
> I remember seeing a post in this newsgroup for a website maintaining a
> (fairly) comprehensive list of hotfixes, service packs and cumulative
> update packs for SQL Server.
> Anyone care to re-post?
>|||It must be this one =)
http://sqlserverbuilds.blogspot.com/
--
Ekrem Önsoy
"horseradish" <dontcallme@.illcallu.net> wrote in message
news:Ot30H1TMIHA.6060@.TK2MSFTNGP05.phx.gbl...
>I remember seeing a post in this newsgroup for a website maintaining a
>(fairly) comprehensive list of hotfixes, service packs and cumulative
>update packs for SQL Server.
> Anyone care to re-post?

hotfix/service pack directory

I remember seeing a post in this newsgroup for a website maintaining a
(fairly) comprehensive list of hotfixes, service packs and cumulative
update packs for SQL Server.
Anyone care to re-post?Maybe Aaron Bertrand's blog?
http://sqlblog.com/blogs/aaron_bertrand/default.aspx
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"horseradish" wrote:

> I remember seeing a post in this newsgroup for a website maintaining a
> (fairly) comprehensive list of hotfixes, service packs and cumulative
> update packs for SQL Server.
> Anyone care to re-post?
>|||take a look here
http://www.aspfaq.com/sql2005/show.asp?id=20
and here
http://www.aspfaq.com/sql2000Builds.asp
Denis The SQL Menace
http://sqlservercode.blogspot.com
http://sqlblog.com/blogs/denis_gobo/default.aspx
On Nov 27, 4:34 pm, horseradish <dontcal...@.illcallu.net> wrote:
> I remember seeing a post in this newsgroup for a website maintaining a
> (fairly) comprehensive list of hotfixes, service packs and cumulative
> update packs for SQL Server.
> Anyone care to re-post?|||Check this one
http://sqlsecurity.com/FAQs/SQLServ...63/Default.aspx
Manu
"horseradish" wrote:

> I remember seeing a post in this newsgroup for a website maintaining a
> (fairly) comprehensive list of hotfixes, service packs and cumulative
> update packs for SQL Server.
> Anyone care to re-post?
>|||It must be this one =)
http://sqlserverbuilds.blogspot.com/
Ekrem nsoy
"horseradish" <dontcallme@.illcallu.net> wrote in message
news:Ot30H1TMIHA.6060@.TK2MSFTNGP05.phx.gbl...
>I remember seeing a post in this newsgroup for a website maintaining a
>(fairly) comprehensive list of hotfixes, service packs and cumulative
>update packs for SQL Server.
> Anyone care to re-post?