Viewing 15 posts - 4,246 through 4,260 (of 7,502 total)
it is not a bug,
it is a limit one must know about.
If you need more than 8000 bytes, you need an implicit convert to varchar(max).
,replace(cast('abcdefghicde' as varchar(max)) ,'cde' ,'xxx') As...
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 10:37 am
kwoznica (12/16/2008)
I am still fairly new to SQL Server so please pardon the simple questions I may ask on these forums.
As a junior dba I feel it is...
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 9:57 am
Keep this in mind !!!!
the KB states:
Note If you are upgrading from SQL Server 2005 SP2 Cumulative Update 10 or from SQL Server 2005 SP2Cumulative Update 11, you must apply...
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:50 am
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
Viewing 15 posts - 4,246 through 4,260 (of 7,502 total)