Viewing 15 posts - 1,171 through 1,185 (of 7,499 total)
t-sql is the language
sql server is the engine
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
September 11, 2013 at 4:50 am
as far as I know, there is no way of telling the connection actually comes from a linked server definition.
What you can do is do some connection tracking and...
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
September 10, 2013 at 7:47 am
for us - the db crowd - there has been no need to alter stuff as the mail team just re-routed the relay definition for smtp.
They prepared their action well...
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
September 10, 2013 at 4:46 am
We used smtp with exchange, so we had to get all ip-addresses granted to be able to use the smtp relay for dbmail.
I'm not even sure if we also need...
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
September 10, 2013 at 3:49 am
Soon the Thread will be posting its own ranted forum questions itself π
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
September 10, 2013 at 3:14 am
you could collect an inventory scanning all your sqlserver instances or active dbmail configurations and for dbmail profiles.
ref: http://technet.microsoft.com/en-us/library/ms177580.aspx
/* is dbmail config activated ? */
Select *
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
September 10, 2013 at 3:11 am
Basically it means:
- Immediatly go to jail 
- do not pass the GO square
- You'll not collect $200 salary
: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
September 10, 2013 at 2:41 am
If corruption re-occurs, it is time to check your disks, .. double check if your case can be found in the BUGs of Service packs or Cumulative updates you didn't...
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
September 9, 2013 at 3:41 am
Please don't x-post.
This post has already been replied to: http://www.sqlservercentral.com/Forums/Topic1488317-391-1.aspx
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
September 9, 2013 at 3:39 am
of course if depends on the level of granularity of the grants for your current QA-accounts.
IMO scripting all grants may be the easiest approach.
Then, use restore db and run 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
September 9, 2013 at 3:36 am
it depends if the backup has been taken before the corruption occured.
One way of testing this is using Allens automation script : Test Your SQL Server Backups with PowerShell[/url]
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
September 9, 2013 at 3:17 am
As Gail stated, your "and o.type = 'abcd'" is part of the join predicate for the left join.
if you only want abcd typed rows in your result, you should move...
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
September 6, 2013 at 6:15 am
Of course it is a choice to just add a gender value and an indicator it is a value to be double checked.
Updating the current column content isn't such a...
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
September 2, 2013 at 1:31 am
Koen Verbeeck (8/28/2013)
craig.schlieve (8/28/2013)
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
August 28, 2013 at 7:45 am
kapil_kk (8/28/2013)
ALZDBA (8/28/2013)
if that meets the requirement, it's ok.
But what abt the scenario for which I posted the question...
How can I implement this:
Scenario is: Currently if made any changes in...
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
August 28, 2013 at 5:01 am
Viewing 15 posts - 1,171 through 1,185 (of 7,499 total)