Viewing 15 posts - 2,311 through 2,325 (of 7,502 total)
just a quick copy/paste from my script library:
-- how to determin SQLServer Uptime
-- zie Tracking Uptime by Brian Moran http://www.winnetmag.com/SQLServer/Article/ArticleID/38042/SQLServer_38042.html
--
-- dd 20060912 JOBI - aangepast voor SQL2005 (DMV)
--
--...
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
February 20, 2011 at 2:46 pm
Indeed, interpreting the install log files is a PITA for everybody.
the error messages start before the registration errors you posted.
And yes, the timeout messages mostly are a result of another...
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
February 20, 2011 at 11:49 am
IMO schema can be used in at least two ways:
- to outline data collections cfr Adventureworks db
(not coupled to an application !)
- to ease...
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
February 20, 2011 at 10:27 am
I would prepare a job for that and link that one to an alert.
All your test users have to do is raise the error and the restore job will get...
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
February 20, 2011 at 10:06 am
I always kick out sqlexpress whenever I need to install any other version of sqlserver.
SQLexpress is fine, but it may generate conflicts with the other versions during install, upgrade, hf,..
(during...
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
February 20, 2011 at 1:28 am
AFAIK no.
- what's the need for this to be in a sproc ?
- Can't you use a sqlagent job or a sqlcmd to perform the restore and other needed actions...
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
February 19, 2011 at 11:17 pm
You didn't attach the log files.
(best is to zip them and then attach to your reply)
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
February 19, 2011 at 11:11 pm
How about the "Intervention system for runaway jobs" : http://www.sqlservercentral.com/scripts/Maintenance+and+Management/30713/
I haven't tested/modified it for SQL2008 features though.:blush:
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
February 19, 2011 at 1:02 pm
Roy Ernest (2/18/2011)
ALZDBA (2/18/2011)
Roy Ernest (2/18/2011)
...
I am in the Caribbeans.. The Dutch carribean. ...
Next time, at SQLPass, remind me of this trip , so we can have a little chat...
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
February 19, 2011 at 10:49 am
Koen Verbeeck (2/19/2011)
Roy Ernest (2/18/2011)
I am in the Caribbeans.. The Dutch carribean.Do they speak Dutch over there?
Didn't you hear the latest "Lotus speculoospasta" advertisement on the radio.
That's the kind...
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
February 19, 2011 at 10:33 am
I think most of us must be aliens :alien::alien::alien::alien: 😀
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
February 19, 2011 at 3:24 am
Roy Ernest (2/18/2011)
...
I am in the Caribbeans.. The Dutch carribean. ...
Next time, at SQLPass, remind me of this trip , so we can have a little chat in Dutch 😀
(...
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
February 18, 2011 at 2:14 pm
Stefan Krzywicki (2/18/2011)
...
He's got one comment that is really funny though where he responds to ALZDBA (who has excellent English) with
Ian is correct to himself not me because both of...
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
February 18, 2011 at 10:54 am
Ian Scarlett (2/18/2011)
Gianluca Sartori (2/18/2011)
Do you remember Lennie, the guy with sock-puppets friends?He's back again. Nothing worth worrying about, at the moment.
http://www.sqlservercentral.com/Forums/Topic1066085-9-1.aspx
And I was unfortunate to see this post AFTER...
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
February 18, 2011 at 2:51 am
Of course Ian is correct !
The problems lies with the dev who tries to fit header rows into his row set and doesn't know how to make his combobox show...
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
February 18, 2011 at 2:30 am
Viewing 15 posts - 2,311 through 2,325 (of 7,502 total)