How do you execute it?

EXEC() and sp_executesql have no limits.

In the parameter you'll have 1 or more value that has an apostrophe in it. That cause the concatenation to generate an invalid query and gives you the output...

Can you post the exact error and context of the error?

As I said I didn't let the schedule run but it was scheduled correctly on my machine (2005 standard 64...

Why am I tempted to answer : Me, without any doubt :w00t:.

Assuming the query is smaller than the total ram + disk it should run... there was a 256 table limit in sql 2000, I don't know if it's still...

Is powershell an option? I can't code with it but I'm sure google would solve that one for ya.

<oi>sql?

SSIS?

Syed Jahanzaib Bin hassan (5/11/2011)

---

declare @driveName varchar(100)

declare @query varchar(1000)

declare @fsinfo varchar(1000)

set @driveName = 'C'

set @query ='fsutil volume diskfree '+@driveName+':\'

set @fsinfo = 'fsutil fsinfo volumeinfo '+@driveName+':\'

exec xp_cmdshell @query

exec xp_cmdshell @fsinfo

check this...

Any way the connection settings are different and maybe you have a divide by datediff() which can result in 0 in java?

Other than that is it works in ssms...

colin.Leversuch-Roberts (5/11/2011)

---

It's interesting to read how different people approach the same thing. My first port of call is nearly always the query plan. I do wonder if we're a bit...

GSquared (5/10/2011)

---

I use the SSMS stats to start tuning before I go into traces. Actually, I use it before I even convert a script into a proc. Gives...

Jeffrey Williams-493691 (5/10/2011)

---

That looks like the job history - check the maintenance plan history instead. It should show you why that specific task failed.

Now, not sure why you would...

I've already tackled the problem when doing change documentation (or more change list).

Let's say you alter the invoice object. What are all the points in the application that you...

GilaMonster (5/10/2011)

---

There used to be. We had too many cases of people deleting their...

Psst, don't tell anyone but that,s not my real picture :w00t:.

I'm almost on the 3rd of a century mark (only 1000 days off)! :w00t:

Ninja/Anakin

Anyone can beat that? Count occurences on 500 M rows.

http://www.sqlservercentral.com/Forums/Topic1106314-149-1.aspx