Viewing 15 posts - 4,366 through 4,380 (of 7,502 total)
you'll have to check the dll library of sql2005 at client level.
WMI softwarelist may also help out.
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
November 3, 2008 at 1:12 pm
Check out the ranking functions of SQL2005.
There are a couple of good articles at CCS.
- http://www.sqlservercentral.com/articles/Advanced+Querying/61716/
- http://www.sqlservercentral.com/articles/SQL+Server+2005+-+TSQL/sequentialordering/2261/
- http://www.databasejournal.com/features/mssql/article.php/3773091
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
November 3, 2008 at 1:11 pm
Especially because it is a 3th party product, I do not advise to add columns to tables.
To achieve the thing you want, create another logging table and populate that using...
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
November 3, 2008 at 1:02 pm
As already stated, doing this with a trigger is not a good thing.
However, as also mentioned, the fastest way of doing it is using a service broker solution. (i.e. inner...
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
November 3, 2008 at 12:55 pm
- Was the sql2000 query also remote and using linked servers ?
- are the linked server settings equal ?
- do the databases use the same ansi settings ?
- I...
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
November 3, 2008 at 7:05 am
Niyala (10/31/2008)
How about the issue of licensing? If I have many databases in one instance, I guess I have to pay licence fee for a single...
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
October 31, 2008 at 6:47 am
Adding to PaulBs reply...
-application lifecycle (do all applications need the same software level and/or can they tollerate a sqlserver instance level upgrade)
- cross database ownership only works within an instance...
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
October 31, 2008 at 6:20 am
100% demystification 😎
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
October 31, 2008 at 1:50 am
CU 10 is out now buildno 9.00.3294
kb:956854
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
October 30, 2008 at 8:10 am
GilaMonster (10/30/2008)
Try doing DBCC indexdefrag from time to to time on those 'no downtime' systems. It is an online operation.
I know, but I won't ...
That would just couver their needs...
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
October 30, 2008 at 2:29 am
GilaMonster (10/29/2008)
... SQL 2000? ...
Indeed.
They are not that fond to migrate the db engine.
Their argument is: if it aint broken... don't fix it...
This means that I'll only be allowed...
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
October 30, 2008 at 1:56 am
Thank you for the feedback.
The majority of our databases indexes get rebuild on a regular basis
Some are not... as always ... no downtime allowed...:hehe: :ermm: :alien:
The final step 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
October 29, 2008 at 1:39 pm
there can only be one DBO user in a database.
That user is actual database owner.
You can add another user using his own user.
If that user needs dbo-privileges, you'll need 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
October 29, 2008 at 6:19 am
GilaMonster (10/28/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
October 29, 2008 at 2:22 am
That would be a valid conclusion.
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
October 28, 2008 at 6:47 am
Viewing 15 posts - 4,366 through 4,380 (of 7,502 total)