The default is to use all available processors to parallel queries.

Which radio button is checked? "Use all available processors" or "Use"?

As for the configure & running.  Don't really understand that...

Hi Edward,

I am assuming you are using DBCC SHRINKFILE?  Have you backed up the log since running the command?  I have found that log space is not freed up immediately.

Check...

Hey,

Couple of ways...

1)  Profiler trace and filter on ObjectName.  This will show you all activity on the table.

2)  Create a trigger on the table to capture deleted rows and do...

Have to agree..Hockey is awesome to watch, but I think thats a game where you need to be there.  Its fine on tv...Takes a while to tune your eyes onto...

Alternatively, you can run a profiler trace and filter on database id to see who is logging in and what they are doing etc.

Hello All,

Thanks for the feedback so far.  Yes we are using a domain account and no, the SQL Agent has not been stopped or disabled.  Also, the NT account isn't...

Nice one...That worked!

Thanks,

Clive

Hey,

The job is scheduled to run every 30 minutes between 7:30am and 8:00pm (Mon thru Fri).  It runs without a problem during these times, but guaranteed, tomorrow I will need...

Resolved it.

Not sure who, but someone turned on the ODBC trace on our application server.  Turn it off and the jobs run without any problems.

Cheers

Thanks lot. Unfortunately, I didn't install it, but it was installed without me knowing!

It hasn't caused any issues as yet. I was just seeing if there was any...

[I have seen this also in my nephew's league to the point where parents get ejected and find it disturbing. What kind of sportsmanship are they teaching their kids? And...

Hey,

We use IBM Client Access Express to connect to JDE (AS400 on DB2). We use the standard drivers that are installed with that.

Driver: Client Access ODBC Driver (32-bit)

Version: 6.00.07.00

File:...

Thanks for all the reply's.

Fortunately, the project is not complete and i'm not revisiting. I'm trying to document the objects as I create them. I find that the...

Congrats Frank!

Best of luck!

Clive Strong

cstrong@kingston-technology.com

Agree with Graeme.

Keep all the DB sp's in one place. It makes it more managable. Also, you have to consider the implications of extra permissions to enable you...