Wait, wait, wait.

There isn't a compile of procedures in SQL Server. So that's not something you can grant permission for. There is a process where SQL Server will "compile" an...

Does it work on other databases on the same server? If so, the problem is strictly with this database.

If it's always going to be one of the three values, but not the other two, you could do a bunch of OR statements for the three different clauses. However,...

Or is the database corrupt? Have you run DBCC on it recently?

That"s great. You have a wide world of radio things to enjoy. Sample as much as you can then focus on what you find most interesting.

As for the CC...

I've been around a long time and will freely admit that I cast a jaundiced eye to changes mostly because most of them have been at the cost of...

Yes, yes and yes!

Sounds like you're on the path and headed in the right direction. Know that something like this is not simple. Happy if I've helped even a little.

Congrats on the license upgrade. one more level to go.

We aren't Cranky, it's just hard to get people to understand that everything that's new isn't always better or...

44 years as a software developer; starting from a mainframe using PL/1, then programming assembler on Intel 8080 8-bit microprocessors, to C++ and now C# on Intel servers. I've...

Can we find a way to use...

• This reply was modified 6 years, 3 months ago by Grant Fritchey.

Whoa! Whoa! Whoa!

This is my lawn. You get off my lawn.

Oh, and test your backups on the way.

I need to get the Unicorn Project and read it.

Piling on because this bears repeating.

Yes, in order to do recovery you need backups. Further, in order to ensure your backups are good, you need to test them regularly. The...

I agree with what Anthony posted above and I would add one wrinkle.

After the upgrade, leave your databases at the old compatibility mode for a period of time. Run Query...