Oh dear me no.

On SQL Server 2005, the master and resource databases must reside in the same location.

For full information see Moving System Databases on MSDN. Be sure to...

lokhande.deepali (11/7/2009)

---

To resolve the problem backup your database;

Backup log database with truncate_only

this will truncate the non active logs from your log file then try to shrink your database...

Of course? But the log is 100% full...how do you propose to shrink it?

There is no restriction on...

First question: yes that's perfectly fine, though you'll need to manually copy the tail-log backup from the old share to the new share. That assumes that log shipping was...

I prefer the EXISTS. The plan seems more efficient, and the construct more natural.

TOP (1) would also work in place of the DISTINCT, but I'd still prefer the semi...

Here's a script to aid the discussion:

declare @data

table

(

room_name varchar(20) not null,

...

declare @Employee table (employee_id int primary key, name char(1) not null, memostatus char(1) null);

insert @Employee (employee_id, name) values (1, 'a');

insert @Employee (employee_id, name) values (2, 'b');

insert @Employee (employee_id, name) values...

declare @Employee table (employee_id int primary...

Anyone interested in SSIS should be familiar with the name Jamie Thompson.

See http://consultingblogs.emc.com/jamiethomson/archive/2005/05/30/SSIS_3A00_-Enumerating-files-in-a-Foreach-loop.aspx for this question (notice the Enumerate Subfolders box), but also check out the wealth of great stuff...

Jeff Moden (11/6/2009)

---

As a side bar, I'm sorry they're forcing you to do this in SSIS... I do this type of stuff all in T-SQL because every time I turn...

As a general point, if you find yourself regularly performing 12 joins to get at the data you need, the database design may be too normalized. Consider de-normalizing the...

Bob, your posts always make me laugh!

Jeff Moden (11/6/2009)

---

Paul... like the other post, not being snarky here... I just don't...

Knock a quick SSIS package together to read from the linked servers and populate a central table. Access the central table from Reporting Services. Or define a distributed...

I suppose I should mention that this won't work if...