e.g.

- setting startup parameters if your service account doesn't have local sysadmin at windows level.

- granting auth at windows level ( e.g. to push backup files to a safe...

toddasd (12/28/2011)

---

Dev (12/28/2011)

---

george sibbald (12/27/2011)

---

can I then recommend that you...

please also double check guidelines of the software using your sqldb.

In some cases your software may be out of support when modifying physical stuff. :sick:

Did you check their performance blog...

have a look at Moving Database Files Detach/Attach or ALTER DATABASE?[/url]

suhailquadri (12/27/2011)

---

thank you bro.. but it doesn't return emp details when i hit querry like this

-- Statement that executes the CTE

SELECT Emp.*

...

indraneelandhavarapu-866099 (12/27/2011)

---

No Roy i cant do what you suggested....bcoz there is lot of joins and logic happening inside the function...

I just have to pass the parameters and union all those...

some interesting linked server refs:

http://www.sql-server-performance.com/2007/linked-server/

http://www.sqlusa.com/articles2005/linkedserver/

http://searchsqlserver.techtarget.com/tip/Tricks-to-increase-SQL-Server-query-performance

http://www.sqlservercentral.com/articles/Linked+Server/62246/

http://www.benjaminnevarez.com/2011/05/optimizer-statistics-on-linked-servers/

maybe actual hierarchyid datatype can serve you better with this quest, but here's a shot using a cte:

;

WITH cteOrgHierarchy

AS (

-- Anchor member definition

...

marmarhm2002 (12/26/2011)

---

Thank you Todd, but it seems that I can't use synonyms inside a function.

I'm receiving the following error:

Invalid use of side-effecting or time-dependent operator in 'CREATE SYNONYM' within a...

Even tough I don't like what you're about to do.

( only using it for linked server purposes, which is IMHO not the most optimal way to use sqlserver at all...

Did you check Books Online (and especially its examples on the topic)

Recursive Queries Using Common Table Expressions

FYI.

I noticed on my dev instance ( that was in a stopped stated during the apply of SP1CU4) that it only runs the upgrade scripts, not at install time, but...

another very nice read on sqlserver statistics : SQL Server Statistics by Holger Schmeling

marmarhm2002 (12/24/2011)

---

hello,

I want to access several DBs in my function. I execute this function on different servers so I've tried to

restrict access to specific DBs in each server with...

Steve Jones - SSC Editor (12/19/2011)

---

PaulB-TheOneAndOnly (12/17/2011)

---

For documentation purposes I would fully qualify the non-local table - that way whoever reads the code in the future will be immediately aware...