Viewing 15 posts - 2,791 through 2,805 (of 5,393 total)
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...
-- Gianluca Sartori
September 6, 2011 at 8:19 am
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...
-- Gianluca Sartori
September 6, 2011 at 1:49 am
You're welcome.
Glad I could help.
-- Gianluca Sartori
September 2, 2011 at 9:24 am
Glad you sorted it out.
-- Gianluca Sartori
September 2, 2011 at 9:23 am
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...
-- Gianluca Sartori
September 2, 2011 at 6:18 am
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...
-- Gianluca Sartori
September 2, 2011 at 6:11 am
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...
-- Gianluca Sartori
September 2, 2011 at 5:49 am
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...
-- Gianluca Sartori
September 2, 2011 at 5:46 am
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...
-- Gianluca Sartori
September 2, 2011 at 5:43 am
Michael Valentine Jones (8/31/2011)
It would be simpler to use dynamic SQL and just construct the exact ORDER BY clause that you need.
Agreed. I'm a big fan of dynamic SQL. I...
-- Gianluca Sartori
September 1, 2011 at 1:12 am
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.
-- Gianluca Sartori
August 31, 2011 at 7:44 am
Edward-445599 (8/31/2011)
Gianluca Sartori (8/31/2011)
Edward-445599 (8/31/2011)
Yes its!!! coming through a jboss layer😀
OK, what's the jdbc driver? JTDS or Microsoft's?
ITS JDBC . many thanks
OK, which driver?
-- Gianluca Sartori
August 31, 2011 at 7:34 am
Edward-445599 (8/31/2011)
Yes its!!! coming through a jboss layer
😀
OK, what's the jdbc driver? JTDS or Microsoft's?
-- Gianluca Sartori
August 31, 2011 at 6:22 am
Great!
Glad you solved your issue.
-- Gianluca Sartori
August 31, 2011 at 6:21 am
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?
-- Gianluca Sartori
August 31, 2011 at 6:03 am
Viewing 15 posts - 2,791 through 2,805 (of 5,393 total)