This shows fragmentation, which can slow access to the table, but it doesn't appear to be too fragmented. It is, however, a large table, so most likely indexing better can...

I'm not the replication expert, but I had a similar situation years ago in v6.5. I used a trigger to move the inserts and updates to a separate table. Then...

You might be able to, but it would be ugly and might cause performance issues. I'd create a couple views to filter things out.

like create view myfirst as select *...

Search in syscomments. A simple query

select * from syscomments where text like '%mystring%'

will get it for you. Surfinity also makes a great search engine for searching, but I'm not sure...

http://www.sqlservercentral.com/columnists/sjones/batching.asp

Or try this

SELECT i, newid(), rand()

FROM (SELECT 1 i UNION ALL

SELECT 2 UNION ALL

SELECT 3 UNION ALL

SELECT 4 UNION ALL

SELECT 5) derived

order by newid()

to see...

It's possible you had some problem with the backup. I'd rerun it and include the verify check (see RESTORE VERIFYONLY in BOL).

If this doesn't work, be sure you run a...

What's the instance name? Are you sure it's being typed correctly? Check it in the services applet.

suser_sname() in the trigger will return the Windows login. Insert that into the field you want to keep it in.

Check the services applet in control panel for the correct name. Be sure it's set to automatic.

Return a table variable instead? Not sure how you get around this. Don't the other procs use the base proc?

will be written to the log, then written as a change in memory and flushed out. However, if you are worried about some hardware issue, if the server crashed between...

If I understand correctly, you'd need dynamic sql to make this work. If you are trying to minimize code and have the proc only run in one db, but reference...

Is this code in a stored procedure or just dynamically submitted? Have you run DBCC CHECKDB to be sure you don't have corrupt apges somewhere.

Is this the only transaction that...

What's SQA? And I have never seen this in working with 2000 querying v7.

Are you sure someone isn't working with this table and removing rows? If someone else can...