Sql Server Table Partitioning Error 7705

Posted by Sqltimes
On July 27, 2013
0 Comments

Earlier, this week, I was playing with Table Partitioning on my test environment and ran into this issue. I never ran into this issue before, but it was interesting to run into it this time. Below is the error message: Msg 7705, Level 16, State 2, Line 1 Could not implicitly convert range values type specified […]

Posted by Sqltimes
On July 21, 2013
0 Comments

Early this week, I had an interesting challenge. One of our clients has a large database environment. They have a farm of Sql Server database servers, with databases, on each, crossing 1 terabyte size. Side bar: Terabyte sized databases are common these days, but what is not common is a supporting scalable storage architecture for […]

Sql Server Table Partitioning Error 7705

DELETE statement with OUTPUT clause