I tried to set up name based virtual hosts with different document roots as described in the apache docs. (see below). Only the first document tree is accessible from both server names. Can anyone tell me what needs to be done or corrected to get this to work?
NameVirtualHost 1.2.3.4...
Before you back up the SQL 2k DB, set its compatibility level to 70 with sp_dbcmptlevel. This MAY waxor some of the stuff in your db. This can't be combatted, except by making a dupe and backing that up. Then you can probably restore from the backup your 2k server makes.
Yes, it can be done in 2000. Not in 7.0, though.
the syntax is:
Create Function blah(variable as datatype)
as
select * from table where datacol = variable
go
(you can use anything you want for the other stuff)
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.