Search results for query: *

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

I did, but thanks for you input too.

Hi Qik3Coder, Select * from @Temp Where (@PassedId Is NULL Or Data = @PassedId) was what I was looking for. Thanks. I also came up with this solution GO ALTER PROCEDURE [dbo].[myprocname] -- Add the parameters for the stored procedure here @PassedID varchar(10) = '%' AS...

Hi, I want to add a default value to a stored procedure parameter (datatype int), that when executing the stored procedure will grab all rows if that parameter is not passed a value to it. If possible, I don't want to add logic, i.e. If @PassID = NULL, etc. Is there a way to use a wildcard...

Thank you ca8msm, I will take a look.

Hello, I am relatively new to asp.net, coming from classic asp background and I need a brief tutorial on the differences of implementing javascript in an asp.net page, compared to the what I am familiar with using classic asp. Any small summation of the differences, if any, would be a jump...