I can see from tempdb..sysobjects that the schema of the table variable is created at the same time when a table is defined.

I used the following script:

DECLARE @tblAAAA...

Rudy,

When you say NIC setting, you meant the NIC of my computer, or the NIC of the server? My computer is an IBM R40 laptop, while the server is...

Thanks for all the advice. I traded the network connections with the other DBA, but the problem persists.

However, this time, I noticed that my connection from Enterprise Manager (EM)...

thanks, "rows" column of sysindexes is what I am using now.

I just noticed that the value of "rows" different type of indexes, say idind=1 (cluster) or 2 (noncluster), for the...

Denish/Steve,

Thanks for the reply. That was actually an interview question that I was asked last week, and I came with something like:

select CAST(a.ID AS varchar(1)) + CAST(b.ID AS varchar(1))...