Recent content by leahyj

ok, thanks again.

Thank you, Why? What happens if you don't? Thanks again.

Hi, If I am restoring a user database(that already exists) to a backup server using the latest full backup and transaction logs from the production server, do I use the REPLACE option or not. Thanks

ptheriault, thanks again.

ptheriault, What kind of ratio do you usually see? Thanks

ptheriault, thanks. I downloaded the latest version and am trying it now.

Hi, Is it ok to compress/zip a sql backup .bak or .trn file? My concern is regarding corruption or loss of data, etc. Thanks

SQLBill, thanks! Can you be more specific on the copy of the DTS/SSIS packages? Thanks again.

Hi, I have a second sql server, that already has its own system databases, and a few user databases. If I want to restore some user databases from another server, do I need to restore the system databases also(before or after), OR will that make the existing user databases unusable? Thanks

I figured it out myself... used the /R switch of the FOR command instead. SET CURDIR=%CD% FOR /R %CURDIR% %%G IN (*.*) DO ( ECHO open serverip > script_ftp.txt ECHO user username password >> script_ftp.txt ECHO put %%G >> script_ftp.txt ECHO bye >> script_ftp.txt ftp -v...

I figured it out myself... used the /R switch of the FOR command instead. SET CURDIR=%CD% FOR /R %CURDIR% %%G IN (*.*) DO ( ECHO open serverip > script_ftp.txt ECHO user username password >> script_ftp.txt ECHO put %%G >> script_ftp.txt ECHO bye >> script_ftp.txt ftp -v -i -n...

Hi, I have a batch file that ftps. Here is what it does. 1. It creates a directory listing file of all directories in the current directory. 2. It changes the current directory to each sub directory. 3. It creates a file listing file of all files in the subdirectory. 4. It ftps each file in...

Hi, I have a batch file that ftps. Here is what it does. 1. It creates a directory listing file of all directories in the current directory. 2. It changes the current directory to each sub directory. 3. It creates a file listing file of all files in the subdirectory. 4. It ftps each file in...

gmmastros and qik3coder, It is sinking in thanks. I used to use this quite a bit, in MS Access when I would program a forms parameter to show all records from a query if the user didn't make a choice on the forms choice. What throws me off is that I thought I used to design the query to...

Hey gmastros, Question: what would be the difference between, Where (@PassedId Is NULL Or Data = @PassedId) and Where (Data Is NULL Or Data = @PassedId) The first one works, but I can't figure out why. Thanks