You said above that you ran the code against CustomerId and it worked. I'll bet CustomerId is an integer column.

And what level of access does that user have? Is the server set up with 'sa' and no password?

Yes, setting up procs is work, but your core issue is...

It's not an alias you're looking for but some formatting. Try changing to this:

CAST(SizeInGigs=floor( backup_size/1024000000) AS VARCHAR) + ' GB'

An alias is a way of masking or changing a...

The only thing I can think of would be to lower the cost threshold for parallelism. But then you're likely to see multiple threads in queries that will not benefit...

I nornally wouldn't pile on to something like this with a...

What about trying it like this:

select * from customertable where customercode = '01042'

If customercode is a string, you need to wrap the number being passed so that it's a string...

I didn't read through everything, but you are issuing DDL commands within your procedure which will cause recompiles of the procedure while it executes. That may not be the cause,...

Matt Miller (5/5/2008)

---

Jeff Moden (5/2/2008)

---

Matt Miller (5/2/2008)

---

Grant Fritchey (5/2/2008)

---

How did you know what I had planned for the week-end... 😀

I have to ask though, what's drowning breath exercise? While we...

It depends. All the data is stored in tables. So even when you query a view, except for materialized views, you're querying the tables that make up the view. The...

This is the kind of information you can get out of the Books Online as well as a gazillion third party books and web sites. Do a little basic research...

Maybe I need to clarify that. I hate out of control recompiles. On rare occasions I've found queries that benefit from having WITH RECOMPILE attached to them so that you...

The max appears to be 256. I suspect you'll run into other problems long before you hit that limit.

As to the post that 10-12 is a max, I just don't...

Volunteer to build a database for the local church, community group, Boy/Girl Scout troop, soup kitchen, community farm... Whatever. They can't pay you, but you can use actual user requirements...

You would probably need to develop this for yourself, although if you search around someone else may have written a script or a piece of code. You might also want...

Even if it's not RBAR, recompiles can cause queries to block themselves. See this link to identify what the cause is, if you're having a recompile. This MSDN article is...