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!

  • Congratulations strongm 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: henin
  • Order by date
  1. henin

    sp_send_dbmail , a query into @recipients

    Hi mrdenny, And thanks for your response.
  2. henin

    sp_send_dbmail , a query into @recipients

    Hi everyone, using sp_send_dbmail , for the @recipients parameter i tried a query as follows: DECLARE @mailist VARCHAR(2000) SET @mailist= ' select email from server.db.dbo.table where lastname=' + '''' + 'aaa' + '''' exec msdb.dbo.sp_send_dbmail @profile_name='my_profile'...
  3. henin

    "if" statement, i'm having problems

    Thanks phil, For the explanation and solution
  4. henin

    "if" statement, i'm having problems

    Hi everyone, My procedure recieves one argument, "myNumber". I'd like to declare as many variables as "myNumber"'s value as follows: If (@myNumber=1) DECLARE @firstName VARCHAR(20) IF (@myNumber=2) BEGIN DECLARE @firstName VARCHAR(20) DECLARE @secondName VARCHAR(20) END When i run the above...
  5. henin

    sql sever evaluation version, i have just installed

    Hi Denny, And guess what. Apparently i was installing client only.. The server installation was on the other CD... I guess there's no other way of thanking you but with a star... And thanks again
  6. henin

    sql sever evaluation version, i have just installed

    Thank you Denny, You are right, installing IIS didnt change anything. far as i rememeber (and i guess i'll have to try again) I checked all boxes. I had 2 choices, i opened each cohice (clicking the +) and signed every thing at the list. I'll try again, maybe this is where i went wrong.
  7. henin

    sql sever evaluation version, i have just installed

    One more thing. Trying to reinstall i'm told that IIS is not installed on my computer. I was informed that from the first time i installed 2005 but skipped it thinking it was not important. Could that be the reason for not having server name ?
  8. henin

    sql sever evaluation version, i have just installed

    Thanks again, I preferred the "evaluation" because i need the 2005 server installed at home in order to learn "SSIS" which, as i understood, doesnt exist in the "express" version. I dont care about expiration or db limitation. All i need is few days for the SSIS learning. Ah, almost forgotten, i...
  9. henin

    sql sever evaluation version, i have just installed

    Hi George And thanks for your help. I tried "local" and "(local)" and "localhost" but nothing worked up (this is "server name" i'm talking about). Then i selected "run" from "start" menu, wrote: "Services.msc" anf from the list i got, i searched for "SQL SERVER" and all i could find was "sever"...
  10. henin

    sql sever evaluation version, i have just installed

    Hi Borislav, And thanks for your reply. This is how i try to connect (and fail to do so): 1. I click: "SQL SERVER Management studio" shortcut 2. In the "SERVER TYPE" text box I leave the default: "Data base engine" as is. 3. In the "SERVER NAME" text box I write "localhost" according to your...
  11. henin

    sql sever evaluation version, i have just installed

    At my home computer. Now i'm trying to connect ("sql sever management studio") but i dont know the server's name nor user name. I dont rememeber ever asked to supply any during the installation. Bottom line- the evaluation version of sql server 2005 is installed but i cannot log in. How do i get...
  12. henin

    a function to a string of the day of the week

    Hi everyone Is there a built in function in the sql server that shows the day of the week as follows: dayofweek('20080129')->"tuesday"', dayofweek('20080130')->"wednsday" etc ? or must i create it myself ? thanks
  13. henin

    sql 2005, "profiler" how do i activate

    Hi everyone, In order to trace queries commited by all users, i need to use "profiler" but i dont know where it is to be found and how to activate it. I'll be grateful for any assistance. Thanks
  14. henin

    sql 2005 sp_send_dbmail, what is "profile_name" ?

    Hi mrdenny ! where can i find sysmail_help_profile_sp procedure ? I didnt find it in "master" stored procedures/
  15. henin

    sql 2005 xp_sendmail, error message

    I tried it but a @profile argument is required and this is above my ability. should i install exchange sever for that ?! it seems i'd rather stay with the good old xp_sendmail then get myself involved with mail server problems.
  16. henin

    sql 2005 sp_send_dbmail, what is "profile_name" ?

    OK, I'm ignorant but without asking i'll stay that way for ever. Using "sp_send_dbmail" i'm required to provide value to: "@profile_name" argument. The trouble is i have no idea what it means.. How do i get to know what is my "profile_name" ? Thanks.
  17. henin

    sql 2005 xp_sendmail, error message

    Thanks, never heard of it but i'll try to find out how it works.

Part and Inventory Search

Back
Top