November 19, 2007 at 4:15 am
According to Upgrade Advisor for SQL 2000 to 2005, all spt_ tables
are not available anymore.
I need to rewrite this select query. Still, I need the same result set from the query. Getting the bytes per page:
Query: select low from master.dbo.spt_values
where number = 1
and type = 'E'
Any ideas??
November 19, 2007 at 5:00 am
Just a note that this table is still available in 2005, so your query seems to work.
Regards,
Andras
November 19, 2007 at 5:10 am
Also, isn't the information your query returns the page size? In which case it is 8192 in 7, 2000 and 2005. Since 7 is the earliest compatibility mode you can use, do you really need that query?
Regards,
Andras
November 19, 2007 at 5:24 am
Yes, it do work in 2000. However, after Upgrading to SQL 2005, it will not work anymore and I want to correct all possible errors before Upgrading to SQL 2005.
I need this query when I do a calculation of the space used by all DB's and available on my hard drives.
November 19, 2007 at 5:27 am
Chrisb (11/19/2007)
Yes, it do work in 2000. However, after Upgrading to SQL 2005, it will not work anymore and I want to correct all possible errors before Upgrading to SQL 2005.I need this query when I do a calculation of the space used by all DB's and available on my hard drives.
Well, this particular query still seems to work on 2005 (as expected it returns 8192). Also, since you are migrating to 2005, but even on 2000 there is no need for this query, and you can just use the 8192 value.
Regards,
Andras
November 19, 2007 at 5:27 am
Do not want to use static values in case the OS change in the near future.
Yes, the value is 8192 (if harcoded - not good programming practice )
November 19, 2007 at 5:33 am
Please ognore last reply of OS part. Blue Monday.
Will use the hardcoded value. Thanks for the help.
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply