Reputation
2,183
Top tag
Next privilege 2,500 Rep.
Create tag synonyms
Badges
8 29
Newest
 Yearling
Impact
~122k people reached

Dec
23
revised Why doesn't “As SYSDBA” work from SQL Developer?
added 476 characters in body
Dec
23
comment Why doesn't “As SYSDBA” work from SQL Developer?
@BalazsPapp OK, thanks. I've been out sick the last two days, but I am back now, and I have some of this information.
Dec
21
comment Why doesn't “As SYSDBA” work from SQL Developer?
Oh, and how do I find that database parameter?
Dec
21
comment Why doesn't “As SYSDBA” work from SQL Developer?
Yeah, one of the problems here is that this server has 3 Oracle Homes, two of them Oracle 11G (i have no idea why), and I am not sure which one is being used for this database (i wouldn't mind help figuring out directions to figure that out either). In any event i can't just post the config files for security reasons, I will have to clean them first, and of course that will take some time ...
Dec
20
asked Why doesn't “As SYSDBA” work from SQL Developer?
Nov
21
comment How can I get individual rowcounts like SSMS?
Agreed. I have been in the hospital the past week (severe vertigo) and will not get to post the question myself anytime soon, so please go ahead.
Nov
10
awarded  Peer Pressure
Nov
9
comment How can I get individual rowcounts like SSMS?
Maybe SSMS is reading the TDS directly?
Nov
9
comment How can I get individual rowcounts like SSMS?
The mystery to me is how SSMS sorts it out correctly.
Nov
9
comment DDL trigger permission Error
What does "Now M trying to create a table through user2" mean? Be specific and give examples.
Nov
9
comment How to automatically shrink a SQL Server transaction log only if it exceeds a certain limit (e.g. 20 GB)
When you shrink or truncate your Log file, you are breaking your Log recovery chain. This means that any Log backups taken after that point are no good until your next FULL backup. I strongly urge you to find another solution to your problem.
Nov
9
comment How can I get individual rowcounts like SSMS?
I have tried this and it does work for me. Oddly, the StatementCompletions and the InfoMessages from PRINT statements in the stored procedures don't seem to be synchronized wrt each other (I get a bunch of StatementCompletions, then a bunch of PRINT statement outputs, though they are supposed to be interleaved) But I guess that's an SSMS trick for another day...
Oct
27
accepted How can I get individual rowcounts like SSMS?
Oct
27
revised How can I get individual rowcounts like SSMS?
spelling
Oct
27
comment How can I get individual rowcounts like SSMS?
If you had read my question, you would have seen that I am already doing that. It is not in there.
Oct
27
revised How can I get individual rowcounts like SSMS?
added 399 characters in body
Oct
27
comment How can I get individual rowcounts like SSMS?
I cannot modify these procedures. I can modify the client code, including using something other than ExecuteNonQuery.
Oct
27
asked How can I get individual rowcounts like SSMS?
Sep
24
awarded  Self-Learner
Sep
18
comment Help required with query (join) optimization
The function is 90% likely to be the problem here. You should convert it to an inline table-valued function and also declare it to only receive a specific datatype for its parameter.