Search results for query: *

Hi mrdenny, And thanks for your response.

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

Thanks phil, For the explanation and solution

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

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

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.

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 ?

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

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

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

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

thanks a lot

thanks

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

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

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

Thanks a lot

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.

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.

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