AFAIK, there's no way.

If you take a look at msdb.dbo.sp_update_job, you will find this check hardcoded:

-- Check permissions beyond what's checked by the sysjobs_view

-- SQLAgentReader and...

I strongly suggest to avoid coding such a parser. It could tak you months or years and never work completely.

Don't re-invent the wheel, there are lots of parsers ready to...

You're welcome.

Glad I could help.

Glad you sorted it out.

Triggers are executed inside an auto-generated transaction.

You need to configure the MSDTC to allow two-phase commit.

I wrote an article on a similar topic some months ago and you should find...

You need to pivot the results:

WITH SampleData

AS (

SELECT EmpCode,

CAST(ShiftDateTime AS DateTime) AS ShiftDateTime,

RN = ROW_NUMBER() OVER (PARTITION BY EmpCode, CAST(ShiftDateTime AS Date) ORDER BY ShiftDateTime)

FROM (VALUES

('2058', '01/02/2011...

In SQL Server 2005 the service pack takes care of it. You just have to run it from the active node and it will spawn a setup process on each...

I wrote an article on this topic some months ago.

There's a lot of permissions you have to grant to the SQL Server service user or interactive user in order to...

Can you post the error message? Maybe it's not so cryptic after all.

You can always use an integrity check routine such as the one on Ola Hallengren[/url]'s site. It's a...

Agreed. I'm a big fan of dynamic SQL. I...

See http://jtds.sourceforge.net/faq.html.

The property to set in the connection string is "prepareSQL". To leave the original SQL untouched, you can set it to 0.

OK, which driver?

😀

OK, what's the jdbc driver? JTDS or Microsoft's?

Great!

Glad you solved your issue.

Wild guess: it's a Java application, isn't it?

If so, there are connection properties that handle how the statements are submitted to the RDBMS.

If not... can you share more details please?