Viewing 15 posts - 4,246 through 4,260 (of 7,499 total)
You can find it in the install bootstrap files:
e.g in the file "C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_servername_SQL.log"
search for
MSI (s) (A4:D8) [09:09:29:007]: Command Line: USERNAME=xxx COMPANYNAME=yyy ERRORREPORTING=0 SQMREPORTING=0 INSTANCENAME=MSSQLSERVER INSTALLSQLDATADIR=D:\...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
December 16, 2008 at 5:19 am
Steve Jones - Editor (12/15/2008)
Just when I thought things couldn't get worse...
Make it fool proof...... and they'll come up with a better fool 😀
It will take a while before this...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
December 15, 2008 at 2:20 pm
rbarryyoung (12/15/2008)
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
December 15, 2008 at 12:16 pm
.... a diaper issue, so to say :w00t:
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
December 15, 2008 at 5:04 am
Thank you for the comments.
Fortunately it didn't take me that much time to figure out the issue :Whistling:
I'm always using my version of sp_who to see what's going on...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
December 15, 2008 at 3:52 am
ps (12/14/2008)
My questions are:-
1. how to control the number of backup sets that can be written in a file using the device i created above( in above example 2 backups...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
December 15, 2008 at 12:11 am
Off course the @recipients parameter still needed modification ...
while @@fetch_status = 0
begin
Set @emailrecepients = @ops_manager_email + ';' + @it_manager_email
Declare @TheQuery varchar(1000)
Set @TheQuery = 'Select refno , ben_name, amount ,...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
December 14, 2008 at 12:50 pm
Here's a "dynamic" solution.
Primitive, but effective
It requests your data for all children with a total of 5
but it includes twins, triplets, ...
If you have 3 children and then are...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
December 12, 2008 at 6:17 am
As you'll see I've commented the send_dbmail , you must un-comment it.
Test it first.
drop table branch_info
go
create table branch_info
(
br_code ...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
December 12, 2008 at 12:33 am
s_kaswani (12/10/2008)
(5 row(s) affected)
Msg 137, Level 15, State 2, Line 14
Must declare the scalar variable "@ops_manager_email".
Msg 137, Level 15, State 2, Line 17
Must...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
December 10, 2008 at 1:23 pm
Simplest is to concatenate both columns in your query to a format your targetusage needs (dbmail)
Declare @email_recepients varchar(225)
declare @email_body nvarchar(max)
declare mail_merge2 cursor for select DISTINCT @ops_manager_email + ';'+ @it_manager_email,email_body from...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
December 10, 2008 at 5:19 am
So your goal is to only send one email per recepient ?
In that case, alter your cursor :
declare mail_merge cursor for select DISTINCT supervisor_email,email_body from mail_merge
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
December 10, 2008 at 2:09 am
easyest way is to use sql server profiler.
Create your trace with all filters (db) you want and script it.
Then launch it in a startup job or procedure.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
December 10, 2008 at 2:04 am
Change your dbmail-query !
Declare @TheQuery varchar(1000)
Set @TheQuery = 'Select * from dbo.mail_merge where supervisor_email = ''' + @supervisor_email + ''' '
execute msdb.dbo.sp_send_dbmail
@profile_name = 'Scn',
@recipients = @supervisor_email,
@subject = 'SCN...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
December 9, 2008 at 7:12 am
No, not using raiserror.
Other options ?
- alter the monitoring software
- write your own xp ( :sick: ) to log the message you want. :sick:
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
December 9, 2008 at 6:48 am
Viewing 15 posts - 4,246 through 4,260 (of 7,499 total)