Without digging too deeply into your code, this works for one month, doesn't it? I've written similar things and we basically needed to call the proc multiple times because the...

This is a disk issue. You need to upgrade the disk system.

Might try tracing and see if EM does something else.

I do agree that the more structured feedback is helpful to MS, and it's easier for them. It's also harder for me.

They've shifted the burden of work from their staff...

The parameter in a view is in the where clause.

select * from myView where SomeCol = 'SomeVal'

IS this Std or Ent SQL Server? Standard can only use 2GB.

I might also specify an amount for sQL Server rather than the dynamic memory management. Is this a...

Doh!, typo.

It is fixed. Glad I didn't have syntax error as a choice

Yikes, I'm confused. It is recommended, as are many things, but it's not required, i.e. needed. How is this that badly worded?

Rode as a kid a little. My kids asking for one. We'll see.

Are these user tables? Maybe reserved words for the column names?

That's what I was going to suggest!!!

update mytable

set col = substring( cast(newid()as varchar(80)), 1, 8)

It has to be some sort of security setting for the activeX stuff that the forums load.

George, you are right on about the craftsman. Too many people are no longer willing to work to be one.

DBMS ?=? ORDMS ?=? ODMS