I also get the following warning when I run this. Note DBA is my working admin database where the procedure is installed.

Warning! The maximum key length is 900 bytes....

I used this on one of our larger databases. I had to make some changes as I was getting overflow errors.

Changed all the decimal definitions from Decimal(10,2) to Decimal(15,2)

Changed...

This was my first post to SQL Central. Did I do something wrong when I pasted my code into the window?

Thanks!

David

Exactly what I was looking for. I needed a path for automated tracing that the sql agent account had permissions to, and not dump everything in the root of...

Luiz,

Wonderful script! I made another small mod to include FileGroup, FillFactor, and put some ;, and CR/LF between each step...

set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

go

/************************************************************************

* Stored Procedure: [LSP_ChangeColumnType]

*...

Chad Carter (10/9/2007)

---

We never did find out why this happened. Our solution, as stated above, was to use a link server for sending out notifications. The local sp_SQLSMTPMail...

FYI, I check out alot of HT threads on the net today. Really make me wonder how anything can work at times. I found a link to download...

I honestly don't know how well it operated when it was first installed. As for the consultants, well, they are gone and we'll leave it at that, and now...

We did. A consultant wrote this code, thats kind of the issue. I'm playing with optimizer hints right now. On a test box and using the option...

Yes, this is a non-analysis services Datawarehouse. so basically I am processing a "cube" to get aggregations at 6 different hierarchical levels/views. No matter what I do, aggregating...

Thanks. Unfortunately, it's doing an aggregation on the entire table to bring it down into smaller and smaller groups. so there is no where clause. it joins...

Jeff,

If you are still around I'd like to see a skeleton of what you accomplished. I'm trying to do the same thing with over 150 million rows. I...