Viewing 15 posts - 3,826 through 3,840 (of 7,506 total)
Steve Jones - Editor (4/10/2009)
Gail, happy to give you moderator privs if it wouldn't add another 150-200kb to your download 🙁.....
As long as it doesn't add Kg's ... :w00t::-D
Hey, maybe...
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
April 10, 2009 at 8:04 am
I tested it overhere and always got the correct results (x86 (std ed)and x64 (ee))
select LEFT(NULL,ABS(CAST(CHARINDEX('.',NULL) AS INT)-1))
select LEFT(NULL,ABS(CAST(CHARINDEX('.',NULL) AS BIGINT)-1))
select LEFT(NULL,ABS(CAST(ISNULL(CHARINDEX('.',NULL),NULL) AS INT)-1))
go 1000 -- executes the previous batch...
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
April 10, 2009 at 6:10 am
you may want to try it out by logging on to your server that launches the ssis package and using that service account (or proxy).
Then try to use the unc...
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
April 10, 2009 at 6:06 am
are you using the same ansi settings when executing on the different instances ?
What do you expect as a correct result ?
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
April 10, 2009 at 5:44 am
Has the account that launches the ssis package been granted read authority on your UNC path / file ?
(service account of sqlagent or proxy account of the sql jobstep that...
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
April 10, 2009 at 5:33 am
It is as useful as putting a fence around your house.
Anyone wanting to walk on your territory will have to do a bit more effort to get there.
So, maybe they'll...
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
April 10, 2009 at 1:13 am
Basically, with a migration scenario, you install a fresh sqlserver (not necessarily on a new box) of the edition you want to migrate to, and then you copy the databases,...
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
April 10, 2009 at 12:41 am
We install SSMS + BOL on every sqlserver server.
(BIDev studio will only get installed at request.)
Why do we install SSMS locally on the server ?
Because we are only allowed to...
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
April 10, 2009 at 12:21 am
I advise to use Gerts solution on SMTP mail to avoid all the hassle with the mail client.
Have a look at http://www.sqldev.net.
It will off course need an extra step to...
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
April 9, 2009 at 12:15 pm
HTH
Just make sure you test it (so you get to see the lovely pictures as desired) 😉
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
April 9, 2009 at 7:17 am
you could determine the max number of parts (e.g. 3) and write a left join statement to concatenate the 3 columns.
SELECT T1.FileData + coalesce(T2.FileData, '') + coalesce(T3.FileData, '')
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
April 9, 2009 at 5:52 am
also check SSC (this site) for scripts "split function".
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
April 9, 2009 at 5:43 am
Eswin (4/9/2009)
Hi while creating the view you can use CHECK_OPTION to prevent insert and update option.Check out the example:
http://www.rampant-books.com/t_super_sql_129_check_option_view.htm
from BOL:
CHECK OPTION
Forces all data modification statements executed against the view...
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
April 9, 2009 at 5:32 am
Krishna Potlakayala (4/6/2009)
ALZDBA (4/6/2009)
San (4/6/2009)
Somehow I managed to install SQL2k5 with different instance name and logged using "machineName\instanceName". Now another problem is that, when I select " " option...
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
April 6, 2009 at 7:45 am
San (4/6/2009)
Somehow I managed to install SQL2k5 with different instance name and logged using "machineName\instanceName". Now another problem is that, when I select " " option in SERVER NAME...
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
April 6, 2009 at 7:17 am
Viewing 15 posts - 3,826 through 3,840 (of 7,506 total)