I think the only way to answer this question is if you can identify what kind of DBA you are and what kind of environment it is.

I've consulted for many...

sorry - the original function was designed to split integers - you should be able to modify the code so output a list of varchars rather than int

MV

astebler (12/15/2008)

---

I see the following errors in the SQL Agent Error Log each time a job is started:

- [298] SQLServer Error: 6, Specified SQL server not found....

I use a function to turn comma separated lists in varchars into tables (don't ask - i know it breaks 1st nornal form - it's something i inherited)

you should be...

Either we're allowed to assume that ALL steps succeed or that Any step could fail....

therefore If all steps succeeded then the answer is YES (because you must have taken a...

Some people are suggesting that we are assuming that the log backup is successfull but that this is not explicitly stated.....

ok - to take that point further - it is...

I agree with michael kipp

I've been to quite a few events and regardless of whether the speaker is good or bad i always pick up something from the speaker about how to portray yourself...

I'd suggest scheduling a job every hour to dunp table sizes into a table and then monitor table growth (you could use excel to produce some graphs)

here's the code i...

other than that you also have

msdb..sp_help_job

(and also sp_help_job_schedule 'myjobname')

would it not be simpler to just move your distributor to another server and have the distributor runing all of the log reader and distribution agents?

in addition to all the existing valid comments : -

you should note that table sizes will be misreported by sp_spaceused if there is no clusted index on the...

are all the jobs running concurrently ? if so there is a hard limit on the number of threads that can be allocated to these jobs

details can be found at...

just out of interest - you upgraded from 2gb of ram to 8gb - did you set /3GB and /PAE in your boot.ini. if so did you do sp_configure...

Always always always remember to make your backups on a seperate array to your data files (.mdf/.ndf)

if you lose your log file (.ldf) you can recover, but to get back...