Do you run Service Broker on that system?

If so, what does the following query return on msdb?

SELECT count(*) FROM sys.conversation_endpoints with (nolock)

Do you know what table(s) causing the msdb growth?

You could run the following code against the msdb:

create table #tableSize

(name varchar(100), rows int, reserved varchar(50), data varchar(50), index_size varchar(50), unused varchar(50))

...

The following approach might cover for some missing Home Addrees values, too (that would be eliminated by the LEFT OUTER JOIN approach).

But the CrossTab method posted by R.P.Rozema is definitely...

You could also have a look at the CrossTab article referenced in my signature.

Maybe Rusanus Blog[/url] can help you to narrow down the issue.

You'll need to figure out "how far" the message is transferred and work from there.

Let's see if I can help to clarify a few things:

Yes and no. A user always has a DEFAULT schema.

As per BOL:

WITH...

What is the exact error message you get?

Is the db set to a max size or is can it grow unlimited but the drive full?

There's no reason to be sorry.

Instead you should post the solution you found so others migt benefit.

Did you try to iterate through the example I posted?

You might find that the concept you described won't lead to a valid solution since we would need a value of...

pandeesh (8/29/2011)

---

As a rule, we can have first matching combination to be selected:

for Mr.Lutz example,we can put A1 for first occuring combination(30,30,20,20).

Please let me know if you need any more...

Nope, no (easy) way to solve it from my point of view.

How would you sort the following:

A1,1,100

A2,1,200

1,60

1,30

1,30

1,20

1,55

1,20

1,15

1,30

1,25

1,5

1,20

There are multiple possible solution and it would require a minimum of three steps...

Yes.

But you don't have to have the statement in the SELECT list. All that's required is it has to be a valid statement that can be used in the SELECT...

How will you decide if a product is already in the target database? Obviously, you can't use the ProductId so you have to use the "natural key". And what is...

Grant Fritchey (8/26/2011)

---

Need the advice of the Thread.

Putting together an article on the most common backup errors (apart from not having one) and how to avoid them. I have four...

tshad (8/26/2011)

---

That was what I was looking for.

I added in the Order by without the Top just to see how it would order and it worked great.

3Main2MainClass

2MainNULLMainClass

1MainNULLNULL

Not sure what this...