For cluster configurations, this is how I set things up:

S:\ drive contains system databases (all files, mdf and ldf)

G:\ drive contains user database data files

L:\ drive contains user database log...

I have done the same thing on prior...

The next thing to check is that the user for that connection has Execute privileges for the stored procedure (which includes access to that database).

FWIW - when you get to SQL Server 2008 SP1 (and greater), you will have the ability to rollback a service pack. But, until then - to rollback you...

Michael Valentine Jones (9/24/2009)

---

Lynn Pettis (9/24/2009)

---

Taking Michael Valentine Jones version and making it a bit more the way I'd write it, it would look like this:

select

...

gmamata7 (9/28/2009)

---

In my case, I have moved masterlog.ldf to a different drive but master.mdf and mssqlsystemresource.mdf & mssqlsystemresource.ldf are on the same location, which is satisfying the above statement "The...

You can convert the CTE's into derived tables - are as Steve mentioned, create Views for each one. For example:

SELECT {column list from derived tables}

FROM (SELECT {list of columns...

Person is the schema the object belongs to.

Books Online is the documentation for SQL Server. You can get to it either by going to Help from SSMS, or:

Start | Programs | Microsoft SQL Server 2005 |...

If you do not filter the update (use a where clause), SQL Server will update every single row in the table. I would recommend using the where clause because...

espanolanthony (9/25/2009)

---

so once again can someone answer please........

But that will create lot of fragmentation. and i think after that rebiulding idexes is not a good idea since that will take...

;With budgets (account, total)

As (Select account

,sum(amount)

From dbo.Gl

Where accType...

Seth,

Yes, that was part of what I was thinking - but, the original query did not have anything in the select and was trying to reference columns using the fully...

That is good to know - glad I could help.

I don't think the problem is the linked server, but the fact that you are not aliasing the tables. You can no longer use the full table reference for...