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
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.