danielgrimes_9 (7/4/2012)

---

Hi all,

I am currently working as a Lettings Manager for a small company, and part of that roll is (unofficially) administering a Microsoft SQL 2005 Database, as the...

GilaMonster (7/16/2012)

---

tyson.price (7/16/2012)

---

Based on it needs to be recompiled everynight I was thinking the recompile option does the same thing the nightly job does. I'm wondering if once a...

GilaMonster (7/16/2012)

---

The short answer is, there's no such hint as "NoCompile" and trying to run "EXEC <SomeProcedure> WITH NoCompile" will just get you an error message saying "Incorrect syntax near...

BrainDonor (6/28/2012)

---

No, because I'm using dynamic SQL it goes out of scope:

declare @sql varchar(max);

set @sql = 'SELECT...

I beleive you can. Pull it up in Enterprise Manager, click properties, permissions, and you can set them.

Sanz (3/29/2012)

---

I have a query which takes a parameter. If a parameter is passed. the query takes 11 minutes to complete whereas if you give the values directly it takes...

ron.grace (3/8/2012)

---

I have a form that returns order details based on the input received in 4 parameters

using the following WHERE clause

WHERE HOrder.Acno = @Acno and

SUBSTRING(HDespatch.ArcOrdno,1,4) = @Unit and

SUBSTRING(HDespatch.ArcOrdno,5,8) >= @FromDate...

Decided not to go there...

Eric M Russell (2/1/2012)

---

subzzz_ (2/1/2012)

---

Sorry, my mistake.

It's a force of...

I see what you are asking but as far as...

subzzz_ (1/30/2012)

---

Hi Guys,

I've got a bit of an issue, I need to trim some data from the end of a few cells(3000+, okay not a few).

The good thing is though...

Burninator (12/13/2011)

---

You can always copy and paste. Just click the corner in the results grid to select all, then copy (ctrl-c), and paste into excel. By default when...

Grinja (5/26/2011)

---

Hi,

Has anyone got a way to identify which column is to blame when encountering error 'String or binary data would be truncated'?

I've come accross this when attempting to insert...

Couldn't resist 😀

The bisection method in mathematics is a root-finding method which repeatedly bisects an interval and then selects a subinterval in which...

That made me curious...here is a link with suggestions. Pay attention to the comments about restarting the server. With some queries listed that information is lost.

http://blog.sqlauthority.com/2009/05/09/sql-server-find-last-date-time-updated-for-any-table/