Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by dakle

  1. dakle

    Any good DTS books available?

    Hi! Can anyone recommend a good book that covers the DTS in detail? Thanks dakle!
  2. dakle

    MS Visual Installer fails to register a *.tlb

    Hi! I have a problem when I try to create a msi-file for my VB-application. I can create my installer file but when I am trying to install the program on another machine the setupprogram says that it can not register the files activeds.tlb and msado25.tlb. What is the problem? Is there someone...
  3. dakle

    Can I turn of logging in a database?

    Hi! I have a problem with a transactionlog that grows/fills to rapidly. My question is: Can I in any way turn of the logging to the transactionlog? The data in the database is not of a cruisal type, what I mean is that I do not have the need to backup this DB. Right now I must truncate the...
  4. dakle

    How do I change a value in an Inserttrigger?

    Hi! I have a trigger for insert where I want to change one of the values that are inserted. The value is a datetime which I want to withdraw one day from. I will do that by: SELECT @TempVal = (SELECT @Val FROM INSERTED) SELECT @NewVal = DATEADD(day, -1, @TempVal) But how do I finish the...
  5. dakle

    How do I backup and restore a Database(SQL 6.5 -> SQL2000)?

    Can I convert a database by upgrading the server through the Upgrade Wizard? Is it possible when your dealing with a SQL Server 6.5. My job is to upgrade about 40 "programs" that use SQL 6.5 and SQL 7.0 to SQL 2000. My clients want to move the programs to a test environment first...
  6. dakle

    How do I backup and restore a Database(SQL 6.5 -> SQL2000)?

    Hi! I am about to take a backup(full) on a SQL Server 6.5 database and I want to restore it on a SQL 2000 Server. How do I do that? I have heard that it is not as easy as it would be if I had my database on a SQL 7.0(insted of 6.5). If someone had a list that can walk me through the steps I...
See more

Part and Inventory Search

Back
Top