Viewing 15 posts - 2,386 through 2,400 (of 3,061 total)
luckysql.kinda (8/25/2009)
I didn't find any convincing posts on google
first google hit for "mssqlsystemresource database"... http://msdn.microsoft.com/en-us/library/ms190940.aspx
What is the basic use of this
trap curious people and, it works! 😀
Didn't you mother...
August 25, 2009 at 9:25 am
RBarryYoung (8/24/2009)
molson (8/24/2009)
I think Barry lays out most of what you need:structure and discipline
Structure: Develop a clear,concise, well planned naming convention for your sprocs
Discipline: Stick to it
Heh, agreed Molson....
August 25, 2009 at 9:12 am
:w00t: ... attaching resource database?
BOL or Google mssqlsystemresource.
August 25, 2009 at 8:49 am
is TLOG growing? look for a long standing transaction.
August 25, 2009 at 7:16 am
mroja_2005 (8/24/2009)
EXEC [ServerName\SQL_01].ADVENTUREWORKS.DBO.TEST_SP
Msg 7411, Level 16, State 1, Line 1
Server 'ServerName\SQL_01' is not...
August 25, 2009 at 6:21 am
On the other hand, you can narrow the field of suspects by checking which user accounts have such privileges on the affected database.
By the way, if application is using a...
August 24, 2009 at 7:47 pm
Assuming you have already back up the transaction log file to turn as many active virtual log files inactive - statement is correct.
Just out of curiosity, what's the backup/recovery model...
August 24, 2009 at 7:20 pm
Ask your contact to compile and run procedure sp_help_revlogin
Details here... http://support.microsoft.com/kb/918992
August 24, 2009 at 3:39 pm
Since there is no NUMERIC data type in Oracle - closest one would be NUMBER I think driver was attempting some kind of data conversion from default datatype and failed.
Probably...
August 24, 2009 at 9:34 am
I think that in the described scenario storedprocs are just the fever... the illness might be...
MaverickMan (8/21/2009)
... get complicated when everyone starts creating innumerable branches.
I would stay with storedprocs...
August 23, 2009 at 6:04 pm
SK (8/23/2009)
Hopefully it can be built into a newer version, because I would love to use it.
That's a good idea, I would write a nice letter to Attunity - I...
August 23, 2009 at 5:56 pm
useracc2096 (8/20/2009)
me also use it and its really good enough.......
:w00t: is this plain spam?
August 23, 2009 at 5:49 pm
Bruce W Cassidy (8/13/2009)
Oracle uses shared code for the daemons (or Services in Windows parlance), so the overhead for the shared code isn't as big.
Sorry, on this one you are...
August 14, 2009 at 4:48 pm
Bruce W Cassidy (8/13/2009)
August 13, 2009 at 5:02 pm
Do you have a clustered index on offending table?... rebuild it, that forces recreation of PFS page then ghost flag will get set right.
If you do not have a clustered...
August 13, 2009 at 4:52 pm
Viewing 15 posts - 2,386 through 2,400 (of 3,061 total)