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'...
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...
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
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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.