User Profile

Collapse

Profile Sidebar

Collapse
Alfred
Alfred
Last Activity: Jan 5 '07, 07:40 AM
Joined: Oct 2 '06
Location: My hometown is in Manila Phil.
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Alfred
    started a topic Removing Name pipes
    in SQL Server

    Removing Name pipes

    Hi guys,

    I need some help, is anyone of you knows how to remove the name pipes in the server network utility after i have installed the MSSQL 2000? I tried removing the name pipes it seems the option to remove it is disable.

    Thanks a lot.
    See more | Go to post
    • Alfred
      started a topic Transfer user password from old database to a new one
      in SQL Server

      Transfer user password from old database to a new one

      Hi guys,

      I have transferred one database from one machine to another and created all the users and their access rights. Could anyone help how to transfer the users previous "PASSWORD" from the old machine to the new one?

      Thanks for replying in advance.
      See more | Go to post
      • Alfred
        replied to How to delete repeated entries from table using T-SQL statement
        in SQL Server
        Hi,

        You may select distinct the duplicate entry and save it in a temporary table, then delete the double entry to the main table and insert the content of the temporary table to the main table.
        See more | Go to post

          Leave a comment:

        • Alfred
          replied to MSSQL Script execute in .bat
          in SQL Server
          For anyone who will encounter same problem as I did, the solution for my problem was on the .bat file and not in MSSQL. I added the -W in the command in my .bat file.
          See more | Go to post

            Leave a comment:

          • Alfred
            replied to Sql Backup
            in SQL Server
            Hi Satpal

            If your MSSQL version range from 6.5 to 2000 you may use the MSSQL Enterprise Manager to view and manipulate your databases. For MSSQL 2005, use the SQL Server Management Studio.

            What type of backup do you need? Kindly state what version of SQL server do you have for me to send you a step by step guide....
            See more | Go to post

              Leave a comment:

            • Alfred
              replied to Sql Server 7 To Sql 2000 Upgrade
              in SQL Server
              Hi Alwyn,

              Are you going to use the same machine for the upgrade? Are you also going to migrate your OS?

              If your going to use the same machine simply install the MSSQL 2000 in your machine, during installation there is an option there that would ask you to update the current version of your MSSQL.

              If your going to use a different machine install the MSSQL 2000 then restore the backup of your database from...
              See more | Go to post

                Leave a comment:

              • Alfred
                started a topic MSSQL Script execute in .bat
                in SQL Server

                MSSQL Script execute in .bat

                Hi Guys, anyone out there who could help me with my problem?

                I have created a .bat file that would execute the mssql script and give an .txt file as an output. The script run successfully except for the output, the output save as .txt file was not in order unlike the output that was derrived from the query analyzer. As I try to solve my problem I observe that the lines separating the header and the data was the cause of un-order format,...
                See more | Go to post
                No activity results to display
                Show More
                Working...