SQLRNNR (8/8/2011)

Grant didn't like it at all, but I also believe his configuration was a bit different than what they...

He should take a couple of steps back, then ask about GoDaddy.

Short answer, no, I don't think much of them....

I don't have a good tutorial for you on doing this upgrade for replication. By & large, upgrades are better and safer when they're done as a side-by-side upgrade, meaning...

Also, depending on how the jobs are configured, you might have a single job doing things for multiple databases. Just to be aware in case whatever search mechanism you put...

right there with you too, bu what generated the error? Go there first. I don't know, there's got to be more to this question than first appears.

Have to add this: Why is my log full.[/url]

Just so you know, SQL Compare from Red Gate Software[/url], can even compare a live database to a backup file. You don't even have to restore the database to make...

I'm sure I'm missing something, but it looks like you're trying to use @@IDENTITY with a uniqueidentifier data type. They're not the same and that would explain the fundamental issue....

Maybe I'm a little slow, but remove the old server from your backup process. Unless there's something here you're not stating, that seems to be the answer.

A couple of us have said it. The front end.

Oh crud. Of...

In SQL Server 2005, you should handle this on the client side. In SQL Server 2008 and greater, you could use DATETIME2 data type which can also manage time zones.

You're doing the JOIN incorrectly. See, each of those columns is to be joined to the Time dimension individually. If you look at the data, it will make more sense:

ProductKey...

GilaMonster (8/6/2011)

Wasn't me, but it's very true. What...

Thank you! I hope it's useful.