Microsoft are not trying to force any naming convention on table or object names, if that is what you are asking. The old rules of not using sp_ as the...

Yes, naturally Profiler cannot say anything about how the file is created. That is not SQL Server, it is Enterprise Manager that does that. And I don't see why you...

I think it is automagically dropped when you create a 'real' index that SQL Server can use instead of it.

Is it not an auto-created statistics then? Does the name start with '_WA_Sys_...'?

It is not an urgent matter, but I am still wondering what 'Task Manager' in the CMD column means...

I can not give a complete answer to that, but it definitely...

maybe someone ran "truncate table tablename". This would be a non-logged delete.

I'm not sure exactly in which context this is, but just to make sure noone misunderstands it when reading....

Does SQL Server itself deletes rows for any reason? How can I know what is happening?Do you think our app flaws somewhere?

As said above, no, of course SQL Server...

Do you mean you want to store the resultset from the procedure in a temporary table? If so, it can't be dynamically created. You can however create it 'manually' and...

I don't have any script readily available for reading and generating a table definition, but I'm sure there are some here at SSC or at least you'll find it by...

What exact error message did you get? The limitations that might come into play here are:

Columns per SELECT statement: 4,096

Columns per INSERT statement: 1,024

Length of a string containing SQL statements...

Well, you could still use the suggestion I made. First connect to server A and generate the script. Then open the script in Query Analyzer and connect to server B,...

I defniitely agree with JP. Most importantly, you want to:

Keep transactions as short as possible. Start them as late as possible and close them as soon as possible.

Use Enterprise Manager. Right click the table and select All tasks/Generate Script.

You use the virtual table INSERTED, which contains all the rows that where inserted by the statement that triggered the trigger.

create trigger Ztrigger

on TZ for

insert as

begin

  INSERT INTO TY (y_name)

  SELECT z_name...

Are the servers allowing remote connections? Check in SQL Server Surface Area Manager.