Search results for query: *

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

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

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

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

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 )

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

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 ?

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

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