Syed,

I just made the comment because I had to email 3 people once and I came accross that limitation. On the other end you shouldn't be changing systems tables like...

What I meant was other thing runing concurrently in SQL server not external programs.

I would try two approaches.

1. Convert the batch that call those stored procedures into a separate...

sqlquery:

The difference between F3 and 31 is that the 31 is not generating non-clustered indexes nor the declared referential integrity on the primary keys in the schema.

the non-clustered indexes may not...

EM uses sp_MStablespace which in turns reads from sysindexes whis is not accurate until you update ussage. With QA you get the actual values (Count(*))

hth

If that is the case, Are you sure nothing else is running on that server when the execution time is longer ?

as a side note the space available for separating emails with ";" is very limited you won't probably be able to acomodate more than 4 ( and some times, depending...

The posters above are assuming that the TSQL we are talking about here is a stored procedure, is that true?

There is also another fact. Even if the execution plan is the...

From BOL:

DBCC DBREINDEX is an offline operation. While this operation is running, the underlying table is unavailable to users of the database.

hth

Are you expecting updates on the subscriber?

If the anwser is yes, have you partitioned it some how? (manually, automatically)

Ah...

Suppose you create a computed column with [Flag & 2] and set up an index on it, that column may no be "selective" enough, therefore you have waisted space and resources...

>>.. someone told me to use trace.. but i think this is overkill and might(possible) give additional overhead on the server...<<

That someone was me noeld

Mine is in us_english but I think that the right place should be on the name column :

Select A.[name] as 'column_name',

 B.[id] as 'column_id',

 0 as color,

 0 as error,

 0 as selected,

 0...

If you use VSS for your back-end object scripts, that functionality is already there

>>I have absolutely no control over the content of these files<<

If you can't establish rules around what you recieve from those agencies it will be extremelly difficult to build a...

Glad to help !