Under what account does your SQL Server Agent run? Is this a domain account? Is this account a Sysadmin on the distributor?

Here are some basic questions.

Is the Distributor shared by the publisher or subscriber or is the publisher, subscriber and distributor on the separate servers?

The distributor should have have Sysadmin...

The sp that it says is missing, where is it? Is it in your user DB that is being replicated or is it in your Master DB? Did you change...

GilaMonster (11/29/2010)

---

In other news...

The project from hell (the one that I spent evenings, nights and weekends on to try and meet impossible deadlines) has had the go-live date pushed out...

Depending on how the tempDB is used, you have to decide if you want to split the temp DB into seperate files. It is NOT always the case.

Regarding the...

Is this a 64 bit or a 32 bit Server? You do not see any memory starvation, do you? Usually you set the Max memory as 90% of the total...

You could create a server side trace and catch all these calls.

Or you can use the DMV dm_exec_requests join with dm_exec_sessions join with dm_exec_query_plan. This one will give the...

In your example, the problem was unclosed single quote. If you have single quote, you will have to handle it by enclosing it in another set of single quotes.

If you...

Happy Thanks giving to everyone who celebrates it..:-)

It looks at the CPU activity and also shows the file activity. That is OS level. So I think you need admin rights on the Box. I am not 100%...

I do not have any scripts as it is for doing this kind of stuff. I only have one for back up. But to read file line by line it...

Looks more like a security issue than anything. Maybe OS layer. The login that you use to connect to the SSMS is a domain admin?

I have not seen any tech document regarding that, but When using SQL Server 2008, the back up size is small(compressed back up). That means less IO on the back...

Why not use Power shell? Read the file line by line and execute each line. Then you do not have to modify the file at all.

Just thinking out loud.

Double post. Please reply here

http://www.sqlservercentral.com/Forums/Topic1025445-392-1.aspx