Perhaps the AV software is taking up good chunk of CPU and is blocking the resources for your SQL Server in order for it to run the DTS.

Or, if there is a relation between the tables, you could rephrase your query to do a JOIN between the tables and bcp out into one file. If there is...

Looks like you had an extended period of inactivity. If you look under the publisher properties there's a check box whicy by default is selected to "expire after some X...

Exactly the same thing happened here. Our administrative assistant filled out the forms too. Well we will knock on their door and see if they let us in. If not...

I believe you need to stop replication. By copying files from another server, I am assuming you are talking about copying the mdf/ldf files. If thats the case then the...

>>Is this time delay because the snapshot has to be transfered over a network ?

Yes.

>>Will it take time only for the first time i apply snapshot, or for every subsequent...

I dont think it was ever 255.

check this link: http://msdn2.microsoft.com/en-us/library/ms143432.aspx

I have already registered for the conference but did now know about the SSC "party" until later. Is there any separate area where we can modify our registration or sign...

This might work:

=IIF(Fields!Q.Value = 1,"July" & vbcrlf & Fields!Y.Value.ToString, "")

Remember, its vb syntax you should be using.

You could do BULK INSERT or OPENROWSET utilities. Any particular issue with BCP for not using it?

Here's something from BOL:

-------------------

If a view is not created with the SCHEMABINDING clause, sp_refreshview should be run when changes are made to the objects underlying the view that affect the...

Schema changes are not automatically replicated in SQL 2000 T-REP. So you would need to modify the code to include the appropriate commands before issuing the schema change.

The log is truncated when you do a T-Log back up. not db backup.

Here's one way:

SELECT top 2 columna, columnb , DENSE_RANK() OVER (PARTITION BY columna ORDER BY columnb) AS DENSE_RANK

FROM yourTable

ORDER BY dense_rank

There is a scrips section in this website with tons of such scripts. check'em out.