Is this transactional or merge replication? Are you running sp_rename on the publisher or subscriber?

John

It depends on whether your publication is set up to replicate schema changes.

USE PublicationDatabase;

-- Execute one of these depending on whether your replication is transactional or merge

SELECT replicate_ddl FROM sysmergepublications;

SELECT...

What version of SQL Server are you using? Double-click on the Back Up Database Task, and you should find the backup location in the Destination tab.

John

No, backups don't take any locks on tables. There'll be a small IO penalty, but I'd be surprised if you even notice that. The frequency of your backups,...

I'm not sure what you mean. Do you mean delete the maintenance plans, or delete the existing backups? You'd have to remove the maintenance plans yourself. You...

Oooh, that's nasty. I think you need to go into each plan and amend it by hand, I'm afraid. Or take this opportunity to move on to something...

How are you doing your backups at the moment - maintenance plans, Ola Hallengren's solution, or some other method?

John

Is datetime the actual data type of the column? If so, then (quite rightly so) you cannot change the way the value is stored. It's stored as a...

It does for me. Generates a huge long script with lots of sp_addlinkedserver statements (and others). Are you sure you're in Object Explorer Details, not Object Explorer?

John

Yes. Click on Linked Servers in Object Explorer, then go to the Object Explorer Details window. Select all the linked servers, right-click and choose Script Linked Server as.

John

I think some third-party utilities, for example LiteSpeed, allow you to do object-level restores. I've never used that functionality myself, so I don't know how well it suits your...

That first message suggests a Kerberos issue. Try working through this[/url].

John

I think unless you change the design of your database, this is always going to be a bit flaky. However, this will work for the data you posted:

WITH Inners...

There are pros and cons. Your query will return (possibly) unexpected results if there are gaps in the data or two dates in the same week. But yes,...

Actually, DENSE_RANK would probably be a better choice than ROW_NUMBER. That way, if for any reason you have two dates that are in the same week, they won't appear...