SEO

#1 (**permalink**) 02-28-2008, 07:45 PM

I have a MS SQL Server 2000 database that a customer of ours has sent to us
for testing purposes. Is there any way to tell what service pack this
database is at? A stored procedure of some kind that I can run on it?

Thank you,
Frank

#2 (**permalink**) 02-28-2008, 07:45 PM

blue (fluyckx@configsc.com) writes:
> I have a MS SQL Server 2000 database that a customer of ours has sent to
> us for testing purposes. Is there any way to tell what service pack
> this database is at? A stored procedure of some kind that I can run on
> it?

The database is not really at a service-pack level. That's a server-only
issue. There may be problems, though, if your server is at a lower
service-pack level than your customer's server. I don't recall whether
such problems may occur with sp_attach, or if they occur when you try
to restore a backup. But as long as you have SP3 on your server, you
should not have a problem using that database.

--
Erland Sommarskog, SQL Server MVP, sommar@algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

#3 (**permalink**) 02-28-2008, 07:45 PM

Thank you for your reply,

Here is some further information. We have SP3 installed on our server. One
of our customers sent us a database (not a backup) to use with our
application for debugging purposes. After attaching the database, and
running our software using this database, certain functionality/data is
missing. After re-applying SP3 while this database is attached, all is
well.

Please let me know if you come across anything.
Thanks,
Frank

"Erland Sommarskog" <sommar@algonet.se> wrote in message
news:Xns947EF31CEFCC6Yazorman@127.0.0.1...
> blue (fluyckx@configsc.com) writes:
> > I have a MS SQL Server 2000 database that a customer of ours has sent to
> > us for testing purposes. Is there any way to tell what service pack
> > this database is at? A stored procedure of some kind that I can run on
> > it?
>
> The database is not really at a service-pack level. That's a server-only
> issue. There may be problems, though, if your server is at a lower
> service-pack level than your customer's server. I don't recall whether
> such problems may occur with sp_attach, or if they occur when you try
> to restore a backup. But as long as you have SP3 on your server, you
> should not have a problem using that database.
>
> --
> Erland Sommarskog, SQL Server MVP, sommar@algonet.se
>
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techinf...2000/books.asp

#4 (**permalink**) 02-28-2008, 07:46 PM

blue (fluyckx@configsc.com) writes:
> Here is some further information. We have SP3 installed on our server.
> One of our customers sent us a database (not a backup) to use with our
> application for debugging purposes. After attaching the database, and
> running our software using this database, certain functionality/data is
> missing. After re-applying SP3 while this database is attached, all is
> well.

Looks as if I was not completely right then.

Checking Books Online, I find that you try this:

select databasepropertyex('yourdb', 'Version')

The result is however an internal number, and I have not seen any mapping
to service packs. But you can always compare with the master database,
which presumably is in pace with the server.

--
Erland Sommarskog, SQL Server MVP, sommar@algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Service Pack Question