Hi Vinod.. Can you give a little more info on what is happening there as concerns the setup.

I believe you're using a domain account (as I've only seen this...

Created a new user to test this, and get exactly the same behaviour..

It also behaves exactly the same way on the same DB backed up and restored on a different...

Hi Ray M.

That query returns information that the account is granted permissions to update, insert and select on that table (as it shows...

Hi Vladan.. I mentioned in the original post that a trace showed the progress of the queries (that's where profiler came in). That did include the database user...

Server: Msg 229, Level 14, State 5, Line 1

INSERT permission denied on object '', database '', owner 'dbo'.

The and fields are rewritten from the originals, but the rest...

I've been on both sides of the interview desk also.

When hiring, it's not just all technical, but if they're coming in for a technical job, they better be able to...

Check Security bulletin boards.

Test new patches (if any) in test environment.

Planning for when things go wrong (as they will).

Writing scripts to make your job easier.

Testing/developing optimisations for frequently run queries.

Maintaining...

I'd hazard a guess from the way it tailed off there that he'd seen the Windows Event log and noticed that the Net card was failing.

The usual fix is anywhere...

Wonder how long it'll take WINE, or a fork to do this now?

Any reason you're using file append for the transaction logs?

I tend to use individual files (as they're easier to keep track of), and have a Perl script that'll check for...

If I need a daily task (or whatever time period), and I need to take into account server reboots unannounced, then I tend do write my own scheduler (using Perl)....

It's possible to set the processor affinity mask to bind a CPU to handle the interrupt requests for an ethernet card.

I believe you can do it from Taskman.

However, it's probably...

I think I'll grab a copy of that book..

I use Perl where I work (still quite new there, so still in the early days of building the scripts). I...

Are you trying to restore a backup taken from that server, and that database, or are you trying to move it from one server to another?

Half the problem is making it NOT administerable over the internet unless you've firewalls in the way.

You do have firewalls protecting it don't you?

If the answer is 'yes', then create...