220 reputation
49
bio website onallthingsweb.wordpress.com
location United States
age 36
visits member for 2 years, 10 months
seen Jul 21 at 16:13

Computer Aid Inc. Consultant, Microsoft MVP.


Jul
2
awarded  Curious
Feb
12
awarded  Notable Question
Jan
15
awarded  Popular Question
Jan
9
awarded  Yearling
Nov
15
awarded  Notable Question
May
31
awarded  Popular Question
May
20
awarded  Caucus
May
20
awarded  Constituent
May
14
awarded  Popular Question
Nov
21
accepted One Complex Stored Procedure Causes Estimated Cost Exception
Nov
21
comment One Complex Stored Procedure Causes Estimated Cost Exception
That makes a lot of sense, thanks. I'm not surprised a setting like that requires a heavy permission.
Nov
21
comment One Complex Stored Procedure Causes Estimated Cost Exception
@MartinSmith It is a stored procedure that's responsible for setting up a yearly process, which has quite a few tables involved. I need the inserts all to be grouped together in a transaction; it needs to be in the same stored procedure. The process is run by a windows service, so however long it takes is not an issue (but it is fairly efficient as is). I just need it to run... I'm sending an email to the administrators to cover that end, but need to be aware of what to do if that doesn't work out. Thanks.
Nov
21
accepted sqlnet.ora or tnsnames.ora changes require reboot?
Nov
21
asked One Complex Stored Procedure Causes Estimated Cost Exception
Oct
24
asked sqlnet.ora or tnsnames.ora changes require reboot?
Oct
24
accepted Adding Row Version to SQL Server table
Sep
25
comment Disabling Checking of Schema On Function/Stored Procedure Creation
(d) has a very interesting workaround...
Sep
25
accepted Disabling Checking of Schema On Function/Stored Procedure Creation
Sep
24
comment Disabling Checking of Schema On Function/Stored Procedure Creation
@MrBrownstone I have a table missing a column, and it says it can't create the function because of that...
Sep
24
comment Disabling Checking of Schema On Function/Stored Procedure Creation
@shark It's that a change script requires a dependency on a function being there, which it wasn't at the time... to do that would require manual intervention; I wanted something more automatic.