Viewing 15 posts - 16 through 30 (of 72 total)
BTW is that "IF @@OPTIONS IS NULL" trick documented anywhere along with FMTONLY ON? If not, how did you discover it?
To my knowledge, @@OPTIONS = NULL is not explicitly documented,...
June 25, 2015 at 1:40 pm
Do not use this feature. This feature has been replaced by sp_describe_first_result_set (Transact-SQL), sp_describe_undeclared_parameters (Transact-SQL), sys.dm_exec_describe_first_result_set (Transact-SQL), and sys.dm_exec_describe_first_result_set_for_object (Transact-SQL).
But don't you see...it is the Microsoft tools such as...
June 25, 2015 at 9:44 am
I agree with Erik's Erland's suggestion #3 too. Having the user create the stored procedure in a different schema sounds to be the way to go. I'll...
April 2, 2015 at 1:07 pm
Thanks, Eric. So it sounds like there is not a way to have ownership of created objects automatically assigned to the user that creates them. That's too bad...and...
April 2, 2015 at 12:15 pm
I do have some code to watch for and log changes to SQLAgent job definitions: that works well, though it requires creation of a sqlver schema in the system...
January 22, 2015 at 7:39 pm
Great! If it is OK with you, I'll see about using your approach in SQLVer: I'm happy to have all the help and improvements I can get.
Thanks again.
January 22, 2015 at 9:29 am
Richard, thanks for the comment. Just to clarify, sqlver.sputilPrintString does in fact print the entire string. The issue is that as does the code you posted, multiple PRINT...
January 22, 2015 at 9:21 am
🙂 You can of course remove the PRINT statement if you want SQlVer to run in "stealth" mode.
January 22, 2015 at 8:25 am
If you run into errors when creating spShowSlowQueries, please try commenting out the creation of spShowSlowQueries.
While useful, that procedure isn't really needed for the core version tracking functionality.
January 22, 2015 at 8:14 am
Ah, good points: Yes, SQLVer at present doesn't track renames: that is something I need to fix. Originally (in SQL 2005) renames did not fire a DDL...
January 22, 2015 at 8:11 am
Hi, all. One other neat feature that SQLVer provides is a quick and easy way to search through stored procedure and function source code for a specified string. ...
January 21, 2015 at 10:30 pm
FYI, I actually have two variants of SQLDOM--one that creates permanent objects in the database (i.e the "persist" version), and one that creates only temporary objects.
The article really deals with...
December 31, 2014 at 12:44 pm
for the row DEID 8
the OpenTagStartPos is 82 and the CloseTagEndPos is 53.
Is this a typo?
Yes..a typo. That row actually returns a br for the tag (not a b),...
December 29, 2014 at 1:49 pm
patrickmcginnis59 10839 (12/19/2014)
David Rueter (12/18/2014)
For example, if HTML included something like <a href="getRecord?id=6">Click for details</a> it would be trivial for a malicious user to call "getRecord?id=5" to retrieve data he...
December 19, 2014 at 8:53 am
I agree that GUIDs for clustered indexes are a bad idea, and GUIDs for primary keys are not generally ideal. But there is at least one additional consideration that...
December 18, 2014 at 12:36 pm
Viewing 15 posts - 16 through 30 (of 72 total)