...up.

Cheers,

- Mark

...this, just to...

Cheers,

- Mark

Are you after a map of all the system tables?

Microsoft produces a hardcopy schema that you can put up on the wall. Don't put it up near an Oracle...

I don't think you can necessarily improve query performance with changes here, but you can probably improve disk space usage.

Just wondering...how big is your database log? Is it being...

I selected my answer with a pin.

Stupid pin.

I couldn't even understand the question... just goes to show that there's always something new to learn.

Cheers,

- Mark

Thanks Andy.

I know someone who's benefited from all those posts. Me!

Cheers,

- Mark

Have you displayed the query plan to see what is the most resource-intensive bit?

Cheers,

- Mark

I would suggest change your admin SP that counts sysprocesses rows, rather than looking to change the way SQL's working for you.

You'll probably upset the SQL Development Team...

Same here. Sometimes when there's debate abouut a question I like to go back and see what the debate's about, but often difficult.

Cheers,

- Mark

Glad you pointed that out Frank. I'm longer self-employed, having recently accepted a permanent position. Changed my profile accordingly.

Cheers,

- Mark

My thoughts at first too Andy, but then: a) can connect as sa, and b) it issues "18456 Level 16" which means it's making contact and then being rejected.

Been trying...

Maybe when someone hits 1,000 an email should be fired off to their boss.... "hey, how about giving this guy something TO DO!".

Cheers,

- Mark

quote:

---

I'm having an irritating problem. I'm english

---

You said it... not me