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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. dibblm

    Unable to login to database engine. (DATABASE=CASDB, EC=-2005)

    This post has actually been closed. This was posted last year, However the thread is only showing month values and not year values so the question is popping back up this year.
  2. dibblm

    Script to names of file in a directory

    Thanks will do.
  3. dibblm

    Script to names of file in a directory

    I am looking for almost the same thing with a twist. I need the directory contents of a particual directory. I have a mapped drive which contains all users who log into my network. Under that folder is a cookies folder. I need all the files in the cookies folder then move to next user. J:\...
  4. dibblm

    Unable to login to database engine. (DATABASE=CASDB, EC=-2005)

    Unable to login to database engine. (DATABASE=CASDB, EC=-2005)
  5. dibblm

    Help with spanning tapes in a library

    I have a compaq MSL5026 Library with a single 40/80 DLT drive and 14 tapes (max is 24 tpaes) I have a sql database bakcup that is 116 GB. This will of course not fit onto one drive. I need arceserve to realize the tape is full and tell the changer to mount another tape. I am not exact on this...
  6. dibblm

    Library dismounts after a mount

    Yes. I am using a Compaq MSL5026 DLX Tape Library for one. There is a web based interface that allows you to setup the barcode digits. You will have to either get the software from Compaq to install. Software allowys you to monitor and control your library as well as move tapes, Cleanings...
  7. dibblm

    Library dismounts after a mount

    I have found my own solution to this post. My tape library was set to reading only 4 digit bar codes and needed to be set to 6. When arcserve did and inventory it found duplicate tapes and dismounted them all not knowing which actual tape to mount.
  8. dibblm

    server folders

    There are alot of questions to be first answered. (1) Are you an Administrator or do you have Administrative right to the server? If not you will need to find someone with Admin rights to do so. (2) What Operating system are you running? Windows, Novell, Unix, SUN? They all have diffrent means...
  9. dibblm

    Help with SQL concatenation Query

    Thank you all for your support. Alot has been learned here today. I think this posting may probably want to be put forth as a helpfull or expert post due to the fact that it has answered many question. The unicode expression as well the iif (nullif) expressions and concatenation as well. PS...
  10. dibblm

    Help with SQL concatenation Query

    Something else I wnated to add. whenever I create a query like the above. Sql is adding a 'N' character... what is this? Is this just so SQL knows that it is a nvarchar?
  11. dibblm

    Help with SQL concatenation Query

    I can't seem to reply to you directly so I am posting back to this group. I am using SQL 2000. However would still like to know how you came across your other method. I dont like always taking the long way out and am the type to want to know how things work inside and out. I am presuming the...
  12. dibblm

    Help with SQL concatenation Query

    This message would be to Norris. I think your method is going to work best for me. However more complex but getting the job done. I have never created a UDF this is the first. I basically tried just copying your code and using what you handed me. SQL errors out wanting the variants defined...
  13. dibblm

    Library dismounts after a mount

    ; Out of the blue my library wont stay mounted. Running arcserve 9.01 with a compaq msl5026 library. If I mount my library it will read in all the media then dismount all the media reading dismounted. Has anyone seen this or can tell me where to start looking?
  14. dibblm

    Slow performance on Windows XP with GW5.5

    What version of the Novell Client are you running? Or are you running Microsoft's Client for Novell?
  15. dibblm

    Help with SQL concatenation Query

    select cfname + ' ' + (isnull(cmi , ' cmi ')) + '. ' + clname as expr1 This works and solves my null value issue I started with however I get periods on records that have no mi. I would like to delete the fact of inserting a period if there is no MI. example: John A. Doe Mary B. Jane Doe...

Part and Inventory Search

Back
Top