> 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?

"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/techinfo/productdoc/2000/books.asp

> 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.