Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: leahyj
  • Order by date
  1. leahyj

    Restore REPLACE option

    ok, thanks again.
  2. leahyj

    Restore REPLACE option

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

    Restore REPLACE option

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

    compress/zip sql backups

    ptheriault, thanks again.
  5. leahyj

    compress/zip sql backups

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

    compress/zip sql backups

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

    compress/zip sql backups

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

    restore master

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

    restore master

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

    ftp batch question

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

    batch ftp

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

    batch ftp

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

    ftp batch question

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

    stored procedure default value for int datatype parameter

    ...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 someting like "select * from table1 where id = [forms.parameter] or id is null" I guess it really was "select * from table1 where id = [forms.parameter] or...
  15. leahyj

    stored procedure default value for int datatype parameter

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

    stored procedure default value for int datatype parameter

    I did, but thanks for you input too.
  17. leahyj

    stored procedure default value for int datatype parameter

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

    stored procedure default value for int datatype parameter

    ...to add logic, i.e. If @PassID = NULL, etc. Is there a way to use a wildcard? Do I have to CAST it first? Example GO ALTER PROCEDURE [dbo].[myprocname] -- Add the parameters for the stored procedure here @PassedID int = '> 0' AS BEGIN SELECT * FROM TABLE1 WHERE TABLE1.ThisID = @PassedID
  19. leahyj

    Javascript and ASP.Net

    Thank you ca8msm, I will take a look.
  20. leahyj

    Javascript and ASP.Net

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

Part and Inventory Search

Back
Top