Forum Replies Created

Viewing 14 posts - 1 through 14 (of 14 total)

  • RE: TSQL Virus or Bomb?

    Hi Razvan,

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


    Joseph Gama

  • RE: TSQL Virus or Bomb?

    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...

  • RE: Linked Server - Connection problem

    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",...

  • RE: Visual Basic-find server name

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

  • RE: update a Image Column

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

  • RE: connect sql server 200 and oracle 8i

    You can create a linked server with sp_addlinkedserver

    sp_addlinkedserver [ @server = ] 'server'

    [ , [ @srvproduct = ] 'product_name' ]


  • RE: Checking Linked Server If Running ??

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

  • RE: Connection timeout from Access Data Project

    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...

  • RE: Checking Linked Server If Running ??

    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:

  • RE: How Safe are Your Passwords?

    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...

  • RE: How to append the Binary data's in SQL2000.

    You can use STUFF:


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


    STUFF ( character_expression , start , length , character_expression )




  • RE: Reporting from a continuosly populating table

    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...

  • RE: connection to SQL Server

    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.


  • RE: How Safe are Your Passwords?

    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...

Viewing 14 posts - 1 through 14 (of 14 total)