Hi Razvan,

I finally got the code and I will post it soon, the problem was solved.

Peace

Joseph Gama

Hi Razvan,

Thank you for letting me know about that problem. You are right and there are two solutions in TSQL: one is to store the entire code in a text record...

To use windows authentication go to ENterprise manager and you should find your server under "Microsoft SQL Servers". Then, right click on the server name and "edit SQL server properties",...

If you use SQLDMO you can find all the SQL server names and info.

You can use UPDATETEXT to add 100 more bytes or WRITETEXT to replace totally with new data.

You can create a linked server with sp_addlinkedserver

sp_addlinkedserver [ @server = ] 'server'

[ , [ @srvproduct = ] 'product_name' ]

[...

Why not use OPENQUERY to execute some SQL code simply to test the Oracle server?

Can you show a sample of the code you are using to create the recordset, including the connection string? It could be that the recordset is empty or the data...

You can use OPENDATASOURCE or OPENROWSET to connect to Oracle using an ad hoc connection that does not make use of the linked server.

Please check out the online Transact-SQL Reference:

Thank you. I based my article on NGSS work. They are the best security consultants that I can think of. Their work on SQL injection was also a pioneer and...

You can use STUFF:

STUFF

Deletes a specified length of characters and inserts another set of characters at a specified starting point.

Syntax

STUFF ( character_expression , start , length , character_expression )

Arguments

character_expression

Is...

When you say online do you mean you are displaying the table in the web using ASP?

The you should refresh the page usint a metatag to refresh every minute or...

If you go to Enterprise MAnager you can ccheck "Registered sQL server properties" and see if you have windows authentication or SQL Server authentication. Your code requires SQL Server authentication.

Try...

Thank you. You are right, it is a matter of time and opportunity. Faster machines make brute force attacks easier, phone, email, ICQ and other faceless media allow for daring...