K. Brian Kelley (5/12/2011)

---

Since CCR does not own the dbo schema, you must give permission to ALTER it, too.

GRANT ALTER ON SCHEMA::dbo TO ccr;

However, you probably want to create a...

Erland Sommarskog (8/6/2013)

---

No. But why would you do START FULL POPULATION every time? If you have change tracking on, you can do START UPDATE POPULATION instead. And in that case...

If I have "MANUAL" or "DO NOT TRACK CHANGES", would I just execute this command...

Google searching revealed that sp_addarticle's @destination_table stored procedure parameter could be used for scenario 1. However, I'm not sure how to accomplish scenario 2 and whether scenario 2's solution would...

In order to move the full text indices when the database restore involves a differential backup, the "move" command can be used as long as the final full-text index location...

vstitte (8/19/2009)

---

The backupset table has the necessary information. Try running this query. You can exclude the where criteria for all database backup operations.

select TYPE, media_set_id, first_lsn, database_backup_lsn, backup_start_date, database_name, differential_base_lsn

from...

Thanks for the info. However, I'm interested in figuring out which differential database backup corresponds to which full database backup.

For example, let's say I have 5 backup files to...

Would not restoring the full text catalog until all restores are completed be a viable option? If so, how would that be accomplished?

Mayank Khatri (6/29/2009)

---

jlp3630 (6/29/2009)

---

Mayank Khatri (6/29/2009)

---

If u want to transfer data from 2005 to 2000, u will have to use SSIS or Sql Server import and export Wizard(Rt. Click on...

Unfortuantely, doing that will make the solution "manual" instead of automated.

Actually, I was mistaken about my...

Mayank Khatri (6/29/2009)

---

If u want to transfer data from 2005 to 2000, u will have to use SSIS or Sql Server import and export Wizard(Rt. Click on a database, Tasks...

JKSQL (5/5/2009)

---

If you are saving these as views then you should not have to refresh. If you are running these with create or alter statements from TSQL you should...

Are you referring to the "Heartbeat NIC" in Cluster Administrator? If so, I didn't see any problems with it (i.e., I didn't see anything unusual in the attached cluster.log file)....

Thanks everyone for your input.

Being able to hide jobs is not necessarily for a security reason per se. In our development environment, developers can set up their own jobs. However,...

That sounds good to me. A folder structure interested me because I was hoping to somehow "hide" jobs from other users.

For example, developer group A only cares about job...