I don't see any reason why it should hang, sorry.

Have you tried dropping the trigger?

The only possible solution I see here is to create a CLR wrapper procedure that captures the output of the original stored procedure and then returns the resultsets one by...

I don't think it can be done using a SET command. Showing or hiding column headers is something that happens on the client side, not at the server side.

You...

WayneS (6/18/2012)

---

Ladies, Gentlemen, and Threadizens of all shapes and sizes! Come one, come all for the latest news of the day!

Me, your humble dba, from out of the blue, happened...

If you add a clustered index to a heap table, all nonclustered index get rebuilt to change the row locator from RID to clustering key.

Hope this helps

Gianluca

Seems to be a provider specific error.

I'm afraid I can't offer more help on this subject. Which provider are you using?

This suggests the target table is not writable.

I would check:

1) permissions

2) journaling (check this with your DB2 DBA)

3) isolation level (you usually set this...

Can you please post your question with some additional information?

You can read this quick article on how to post a question effectively[/url].

I guess you're on SQL Server 2005 then.

Change the INSERT statement into this:

INSERT INTO @SchDetail VALUES (1,1,'2012-06-09',0); --should...

You'll need the oracle client. You can find it here.

I hate to say it, but social fluff works.

I got my latest job via Twitter. Sounds impossible, but it is so.

I don't understand your requirements completely.

What should be within 14 days? Start dates? Start dates and end dates?

Can you clarify please?

For those interested in answering this question, here's sample data...

Don't put the description of your issue in the subject, it gets truncated.

For those willing to help, this is the text hidden in the subject:

please any one help me, for...

Sorry to disagree.

Same disk = no performance gain.