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

    Check of database recovery model - SQL2k

    Thx again - I made a script that created a stored procedure on all my SQL2k servers, did what I wanted it to do :-) Was using most of the TSQL commands from that last post there :D -Pug
  2. PugTheBlack

    Check of database recovery model - SQL2k

    Good enough :) atleast I can make something from that Thx alot -Pug
  3. PugTheBlack

    Check of database recovery model - SQL2k

    I am trying to find a good command to check the recovery model of each database on my server, SQL 2k SP4. I know how to do it in SQL2005, but I havent found a good command for it in 2000... Select name, recovery_model_desc from sys.databases Will do the trick in 2k5 - want a command that...
  4. PugTheBlack

    Changing recovery model to simple

    Full backup of the database Backup LOG Databasename WITH TRUNCATE_ONLY DBCC SHRINKFILE (N'Database_Log', wanted size) Full backup of the database Been using this way of doing things when things have been getting a little hairy.. Guess it is a little late for you if the database has already...
  5. PugTheBlack

    CWD question

    will try the $mycwd=cwd; option too... well we were 2 ppl working on the problem at the time, but none of us really did anything ( atleast not that we can remember :P )
  6. PugTheBlack

    CWD question

    No, and the weird thing is that I am running it on several other servers and it runs correctly on all of them .. :-\ We did have the same problem on another server for a while, but for some reason it just corrected itself... But back to the BASE question here, the getcwd call returns...
  7. PugTheBlack

    CWD question

    btw... tried the fix and put ".." instead of "." and ended up getting a listing of absolutely nothing. I have made a manual fix by hardcoding the adress into the script, but that doesn't really make the script very versatile does it ?
  8. PugTheBlack

    CWD question

    well... I hardly understand what the script says myself as I'm not German, but the words are not really important in this context... What you call the DIRNAME, and EXPR variables + the error msg ?? Of course I could translate them, but the problem has nothing to do with the german text And why...
  9. PugTheBlack

    CWD question

    Where is the cwd actually set ? When I run a perl-script from a webpage with the following directory structure g:\wwwroot\web\cgi_bin\scriptname.pl that is supposed to list the content of the folder g:\wwwroot\web it instead listst the content of C:\WINNT use Cwd; $path = getcwd; print...

Part and Inventory Search

Back
Top