link server problem with oracle (remotly)
Fri, 05 Sep 2008 04:03:55 GMT
hi
I have found a problem in link server
OLE DB provider 'OraOLEDB.Oracle' reported an error.
[OLE/DB provider returned message: ]
OLE DB error trace [OLE/DB Provider 'OraOLEDB.Oracle' IRowset::GetData
returned 0x80004005: ].
but i have 10000 records in oracle database when i apply query in qury
a ...
|
SQL 2008 auditing question
Thu, 4 Sep 2008 13:03:01 -0700
I have been playing with the new auditing feature a little bit.
There is an option to send the audit data to a file. It is a binary format
and you can view the info using the EM with the audit viewer. However, I
would like to harvest this data for my own use, say put it into a text file.
Anyone know how ...
|
Auditing vs CDC
Wed, 3 Sep 2008 18:33:00 -0700
I am not sure what feature to use. Auditing in 2008 appears to capture all
the DML, an "who" and "when". This is almost everything I need, but is
missing the change in data. CDC seems to have the data changes, but is
missing the who, and does not capture select.
Any thoughts? ...
|
creating windows domain account with $ in SQL2000
Tue, 2 Sep 2008 11:29:02 -0700
Looking for help on IIS security with SQL2000 using domain\machinename$ is
this a hidden Domain account or a reference to the local machine? ...
|
restore backup : access denied
Thu, 28 Aug 2008 10:38:45 -0700
box # 1 : SQL Server 2005 Developer Edition , mixed-mode , logged-in as
Windows log-in account ( BUILTIN\Administrators ) :
create a .bak file
box # 2 : SQL Server 2005 Express Edition , Windows authentication mode ,
logged-in as Windows log-in account ( BUILTIN\Administrators ) :
attempt to restore . ...
|
Website & SQL Server Security
Thu, 28 Aug 2008 09:41:52 -0700 (PDT)
Ok,
im sure this has been dealt with before but when i read other posts i
kinda get lost in the jargon. Ok the reason for my being here is that
i developed a website that recently got hit by a sql injection attack.
Of the back of that i have decided to rethink my security strategy to
ensure it doesnt happen ...
|
UNderstanding SQL and Microsoft GP
Thu, 28 Aug 2008 07:49:01 -0700
I am trying to get and understanding of the security with SQL and GP.
Unfortunately, I know alot about GP but virtually nothing of SQL. Our IT
person handles the SQL side. The confusion I am running into with with some
of these new tools with GP10 there are rights you have to have to deploy
these things. ...
|
|
|
Understanding SQL and Microsoft GP
Thu, 28 Aug 2008 07:49:01 -0700
I am trying to get and understanding of the security with SQL and GP.
Unfortunately, I know alot about GP but virtually nothing of SQL. Our IT
person handles the SQL side. The confusion I am running into with with some
of these new tools with GP10 there are rights you have to have to deploy
these things. ...
|
Change mangement
Wed, 27 Aug 2008 15:23:08 -0700
Hi,
I need to create a change management procedure, server/database changes etc.
Does any one have any pointers, I would rather go with a database solution so
its centralised and can be reported on using reporting services rather than a
paper trail.
Thanks for any advice
Sammy ...
|
How to verify whether a user has been added to a database role?
Tue, 26 Aug 2008 16:41:00 -0700
I want to validate whether a user has been added to a particular database
role. I cannot use the is_member function since it only works with the
current user. ...
|
