asp如何判断sqlserver中是否存在该表

实时的获取客户的IP地址，然后判断sqlserver数据库中是否存在以该IP格式命名的表，replace了ip中的.为_了，如果存在则获取表内容，不存在则转向另外的网站
<%
dim ip
ip=Request.ServerVariables("REMOTE_ADDR")
ip=replace(ip,".","_")
if not exists ********************************** then
Response.Redirect "http://url/
else
set rs = conn.execute("select * from ["&ip&"] order by computername asc")
end if
%>

这里的****************应该怎么写？请指教。。。。。。。

SQL语句
IF not EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[你的IP表名称]') AND type in (N'U'))

ASP 实现：
dim sql,rs,cnt
sql = SELECT count(*) FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].["&IP&"]') AND type in (N'U')
set rs = conn.execute(sql)
cnt = clng(rs[0])
set rs = nothing
if (cnt = 0 ) then
  Response.Redirect "http://url/
else
  set rs = conn.execute("select * from ["&ip&"] order by computername asc")
end if

变量sql 忘了加引号，你懂的。
sql = "SELECT count(*) FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].["&IP&"]') AND type in (N'U')"