Search:

A table had updated without knowing to others. I want to see when the tables is updated(time & date). I dont have any timestamp column in my table. Also, I have not created any profiler r trace...

Scope for the #table is within the window.
Single # table scope is local and
double ## table scope is global

hi,

What is the syntax for INTERSECTION Function in SQL server 2000?

I tried the following syntax, but it is not working

select <column_name> from <table_name1>
intersect
select...

Ya its working fine... thanks

I found one more solution... In enterprise manager, select the database-> diagrams and u can rename in that diagram by just clicking it...

Thanks,
Vishnu

How to rename ( change ) a column name in SQL Server 2000?

I tried the following queries... Its not working

atler table <table_name> change <old table name><new table name>

alter...

What is the query to list all the tables in database in SQL Server 2000?

Thanks in advance!

Do u mean differences between reportnet in versions 7 and 8? Both the versions contains reportnet with major and minor differences...