Viewing 14 posts - 31 through 44 (of 44 total)
Without an example, I am not sure what you are after but, do you mean using raiserror with no wait to output some info as the a procedure runs? If...
February 17, 2009 at 9:25 am
I was reading something about 'What use is CLR' and I'm sure one reply indicated that they used CLR for non-transactional work like you describe. I don't think they elaborated...
February 17, 2009 at 7:16 am
mazzz (2/11/2009)
Beyond altering your SPs to include some sort of logging statement, I don't think there's anything simple you can do.
I second that.
mazzz (2/11/2009)
February 12, 2009 at 2:50 am
I am reluctant to recommend someone I don't have direct experience of but I have seen InterSystems demonstrate various integration systems (is that what you described?) so they may be...
February 9, 2009 at 7:37 am
Pete,
I can't recall the article but, have you considered a DDL trigger?
Have a look at ddlDatabaseTriggerLog in AdventureWorks sample (under Programability -> Database Triggers).
If you don't want to...
January 22, 2009 at 3:57 am
Ok I'll bite, but please don't email me outside the forum.
I think I can see a few problems with the additions you have tried to make to this script....
September 23, 2008 at 9:51 am
Cheers for this James I didn't know this.
The point I made about being careful if you rely on the flag to identify user defined procs still holds. I'm sure there...
July 30, 2008 at 1:58 am
I believe some care is needed if you are relying on the is_ms_shipped flag being set to 1 for all MS shipped procedures. I get a list of stored procedures...
July 29, 2008 at 9:59 am
I'm not sure about any lasting effect of debugging, but check out BOL for "debugging [CLR integration]" and read the permissions and restrictions.
For the reasons given there the sensible recommendation is...
February 1, 2007 at 4:37 am
Search this site (check the scripts box) for FindStringInCode or FindStringInCode2.
May have flaws I don't know about but works a treat for me.
January 11, 2007 at 4:31 am
From BOL (searching for Table and Index Architecture)
"Each table has a set of rows in sysindexes:
A heap has a row in sysindexes with indid = 0.
A clustered index...
May 24, 2006 at 9:40 am
I had this problem some time ago on a previous PC after installing VB sp6. My memory is hazy on this but my notes suggest you check any VB (.net)...
June 20, 2005 at 7:35 am
Check the compatibility levels for the two databases. Level 80 gives the result you are looking for. Level 65 treats empty strings differently and the ltrim/rtrim functions behave differently. See...
May 7, 2004 at 2:58 am
If you are using windows authentication the background server processes on your machine (assume you have a server instance on your machine) will probably have been set up with your...
August 5, 2003 at 2:38 am
Viewing 14 posts - 31 through 44 (of 44 total)