Too many guesses without seeing the actual code involved. In general, I don't recommend using a hint like RECOMPILE unless there's a driving reason for it. Do you know what...

SQLRNNR (4/10/2012)

---

Grant Fritchey (4/10/2012)

---

Stefan Krzywicki (4/10/2012)

---

Jack Corbett (4/10/2012)

---

SQLRNNR (4/10/2012)

---

Stefan Krzywicki (4/10/2012)

---

SQLRNNR (4/10/2012)

---

Stefan Krzywicki (4/10/2012)

---

I just registered for the SQL Server Saturday in Waltham in May. At the end...

Stefan Krzywicki (4/10/2012)

---

Jack Corbett (4/10/2012)

---

SQLRNNR (4/10/2012)

---

Stefan Krzywicki (4/10/2012)

---

SQLRNNR (4/10/2012)

---

Stefan Krzywicki (4/10/2012)

---

I just registered for the SQL Server Saturday in Waltham in May. At the end is the ubiquitous...

From the original bit of code I copied, it was a column...

marksquall (4/10/2012)

---

To Sir Grant Fritchey and Sir Mark Tassin:

You two have mentioned something about cache. I have certain things to know abut this cache and I hope it is...

First off, you are using sp_executesql, which is good, as I said. Because of this, you're not generating hundreds & thousands of variations on the query. However, we're still looking...

Why can't we use CLR tricks? 😛

And I hope you get...

I'm not aware of a tool that's going to generate graphical reports on everything you have listed. You might take a look at some of the tools from SQL Sentry....

mtassin (4/10/2012)

---

The correct answer, as always is... it depends.

If you choose to use Dynamic SQL, then you need to be warey of injection.

Creating a dynamic SQL string by appending text...

asranantha (4/9/2012)

---

1)can we call sp into another sp if yes plz give small example?if no plz tell me reason?

2)can we call functionn into another function if yes plz give small...

Piling on to what Gail said, you need to provide a domain account for SQL Server and give it permissions to that folder.

dilipd006 (4/9/2012)

---

i had already given the db_owner...

Well, since we're recommending tools, you could check out Red Gate SQL Doc too[/url]. And to get help hooking your database into source control, there's SQL Source Control[/url], also from...

S_Kumar_S (4/9/2012)

---

And Gail, when you say "actual executions ", doesn't it mean that I might see different objects(e.g. indexes) being used in actual execution plan. Whereas they were not used...

Similar in concept, but OPENQUERY is like a pass through query. It puts the work on to the remote server.