GRANT VIEW SERVER STATE TO username

Or through SSMS:

Under security > logins for the server, right click on the SQL Login and select properties.

Select the Securables page.

Click Add... and select the...

I think you're going to just have to stop the log readers or synchronizing and move forward with the cleanup steps without checking the MSdistribution_status

C3C1L (1/21/2010)

---

Thanks so far for the advice. My initiative starts now by asking for help because this is new to me and I don't have a set plan other...

Is it being blocked? If so, can you tell which process it is?

Stopping Agent in Production...

Is it deadlocking with the distribution agent? Try running this and see how many undelivered commands there are compared to delivered.

SELECT * FROM distribution.dbo.MSdistribution_status

It might end up being faster to...

Create a new publication on server A specifically for subscriber server C that only includes those tables.

Yeah, tosscrosby-60625 is right, it's like a small guitar. There's a few different sizes that can be tuned in various ways and even different shapes including a banjo-style body. And...

This value reflects both the size of your data file(s) and the size of the log file(s)

You can see the breakdown between the two using...

There is no SAC tool in 2k8.

Instead, open your 2008 Management Studio.

In Object Explorer, right click on the server name > select facets

In the window that opens up, select Surface...

I play guitar and ukulele, but I wouldn't say I'm a musician.

I did have some small success in remixing songs for night clubs, does that count?

In our environment I ended up writing a CLR Proc to workaround the fact that xp_fixeddrives does not properly display space information for mounted volumes. Now we have something like...

Directions for using gmail for smtp are here.

http://techblissonline.com/gmail-smtp/

Did you set up the SQL Agent settings?

Right click on SQL Agent > Properties > Alert System

Check Enable Mail Profile

Select Database Mail from the Mail System dropdown

Select the profile you...

SSCrazy has the right idea. A domain level account set up specifically for running the jobs. SA is overly privileged and we've had a number of problems in the past...

Check for a database trigger. The table ddl_log is generally created along with a database trigger in order to log database level changes. Yours is probably missing though the trigger...