Is there any default function thru which I can see windows system directory?
Actually I know that to execute system stored procedure it should be present either in MSsql folder or in windows system folder.
While I run sql scripts from dos prompt I tell the path to copy system stored procedure into windows system folder. But sometimes windows system folder is not in C drive it could be on any drive.
Can anybody highlight on this problem?
Actually I know that to execute system stored procedure it should be present either in MSsql folder or in windows system folder.
While I run sql scripts from dos prompt I tell the path to copy system stored procedure into windows system folder. But sometimes windows system folder is not in C drive it could be on any drive.
Can anybody highlight on this problem?