SQL Server installation problems !!!

Question

hi guys..i tried installing sql server 2000 , but in the beginning it showed the following error... "microsoft sql server 2000 standard edition server component is not supported on this operating system.only client components will be available for installation" ...then i tried sql server 2005 express, it gets installed , but not able to connect to a server.. server components r not installing properly.... my system has full configuration ..but no idea why its not getting installing properly..... guys pls help... i should some how install sql server 2005 and should "connect" to run a application..

Answer 1

SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[YourTable]') if it exist then it will display the result,,,with table name ,,,tpe and everything

Answer 2

Select your database and open new query window and

EXEC sp_tables @table_type = "'table'"

Answer 3

hi,

there are two tables sys.tables and sys.objects, in which data base maintain table information
please try.

select * from sys.tables where name = 'Table1'

select * from sys.objects where type = 'U' and type_desc = 'USER_TABLE'

hope this will help you.