Forum Replies Created
Viewing 15 posts - 6,016 through 6,030 (of 7,499 total)
-
RE: Server cannot resolve (local) name
- Can you find anything related in Win-eventlog and/or sqlserver-logfiles ?
- Haven't encountered this issue yet, although I also RDC the server to manipulate packages.
- Are you using windows or...
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
-
RE: Update with Left Outer Join
select *
from calllog T1
left outer join asgnmnt T2
on T2.callid=T1.callid
where T2.assignee='Hanli Burger'
and T1.callstatus='Pending'
Update T1
set colx = case when T2.coly is null then colx else T2.coly end
from calllog T1
left outer...
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
-
RE: Progressive Search / SELECT
I don't like to propose this, but serverside cursors
can provide that functionality. With the ado-propreties for the resultset/command you can specify a batchset....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
-
RE: Server cannot resolve (local) name
regarding DTS, do you use your client's EM to edit the package ? (and have no local default instance of sqlserver at your client)
or do you use remote desktop to the...
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
-
RE: Stored procedure works in query analyzer but not when scheduled as ajob
I can see the "Executed as user: NT AUTHORITY\SYSTEM".
So I guess your sqlagent is being serverd by "Local System".
You may want to change that to an account that has authority...
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
-
RE: Searching for records that contain Unicode characters
I guess if you try to select a convert(varchar(...), yourcol) you'll find out.
select convert(varchar(...), yourcol) as varcol
, yourcol
from yourtable
where convert(varchar(...), yourcol) <> yourcol
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
-
RE: Converting my SELECT into a DELETE
just my 2ct...
- use aliasses !
IMO it makes it way easyer to read and may even reduce your chances for mistake. If you...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
-
RE: Moving a SQL Server 2000 machine to a new domain
sorry for the late response.
I'm at SQLPass 2006 for the moment
and I didn't check my SSC...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
-
RE: Stored procedure works in query analyzer but not when scheduled as ajob
- wich account is jobowner ?
- how did you setup authentication for the linked server ?
is there a mapping for the jobowner ?
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
-
RE: Serious wildcard issue with matching comparisons using LIKE
... One other issue that might be a factor is that at the moment all our databases are set to a compatibility of 80 rather than 90. This is the...
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
-
RE: What domain rights does the sql server Service acount have to have ?
..domain admin ? No reason at all !
It doesn't even have to be local admin on the box ! The one installing sqlserver needs to be member of the...
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
-
RE: MSSQLSERVER service fails with event id 5731 after installation of SP1,
topic "Moving System Databases" in BOL describes it clearly.
When I find some time I'll have to test this procedure myself. (this will be after 3 weeks because I'll have...
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
-
RE: MSSQLSERVER service fails with event id 5731 after installation of SP1,
- So you moved the systemdb's and the RTM still worked ?
- what are your startup parameters for sqlserver ?
- check the original locations to see if sp1 put new...
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
-
RE: indexes on different drive
that's one of the things they did not alter for sql2005.
You still have to mention the filegroup for each index and there is no setable default (other then the normal...
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
-
RE: Connection to a Named Instance
A default instance for sql2000 uses the reserved name MSSQLSERVER;
If you stated MSSQLSERVER for your named instance, you may be in troubles !
Be specific and mention the names you've used.
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
Viewing 15 posts - 6,016 through 6,030 (of 7,499 total)