Service Pack Question

[blue]

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

[Erland Sommarskog]

blue (fl*****@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, so****@algonet.se

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

[blue]

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" <so****@algonet.se> wrote in message
news:Xn**********************@127.0.0.1...

blue (fl*****@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, so****@algonet.se

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

[Erland Sommarskog]

blue (fl*****@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, so****@algonet.se

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