Viewing 15 posts - 4,156 through 4,170 (of 7,503 total)
If you cannot fine any reasonable / related message in sqlservers errorlog,
I would suggest to at least run DBCC CheckDB (for the db if you know it, 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
January 14, 2009 at 12:07 am
IMO your variable is declared to small !! char(10) seems rather small.
Be sure to match you declared size to the size of the column in de table ddl.
DECLARE @Driver_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
January 13, 2009 at 11:59 pm
a log file can only shrink up to the last virtual log file it has in use.
This script will write dummy data to the log file, until it's first VLF...
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
January 13, 2009 at 11:41 pm
Can you check it restrictions apply to the number of user connections ?
/* "user connections" is an advanced config setting
enable show advanced options */
exec sp_configure 'show advanced...
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
January 13, 2009 at 7:41 am
Feedback:
I've upgraded the dev servers to SP3 and got the approval to re-test it in cooperation with one of our biztalk devs.
After I activated the "old" logon trigger again, 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
January 13, 2009 at 6:19 am
Did you read:
-SQL2005 http://msdn.microsoft.com/en-us/library/ms188706(SQL.90).aspx
-SQL2008 http://msdn.microsoft.com/en-us/library/ms188706.aspx
- http://www.sqlservercentral.com/articles/SQL+Server+2005/61765/
- http://www.sqlservercentral.com/articles/Development/3144/
- http://msdn.microsoft.com/en-us/library/ms345146.aspx
- http://www.sqlservercentral.com/Forums/Topic414210-338-1.aspx
- http://www.sqlservercentral.com/Forums/Topic623669-360-1.aspx
also keep in mind, if partitioning an existing table, you may still end up with DOWN TIME for your application(s)...
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
January 13, 2009 at 5:30 am
As always, play it safe and start with a full backup scenario of ALL your databases (including systems databases !)
If all backups completed successfully, only then start the sp3 exe.
Read...
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
January 12, 2009 at 12:58 pm
did you log grow over night to 17 Gb ?
or is it due to the fact you do not make log-backups ?
In full recovery mode, you need to make log-backups...
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
January 12, 2009 at 12:31 pm
you should be able to update directly to SP3.
There is a CU1 for sp3, but you'll have to check it the items fixed would match your usage environment.
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
January 12, 2009 at 12:25 pm
Indeed, a word of caution should be said.
Undocumented surely means the behaviour may change with every hotfix/cumulative update/service pack/new version.
They may even be removed without any notification or alternative !
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
January 12, 2009 at 7:23 am
Thank you for the confirmation 🙂
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
January 11, 2009 at 11:53 pm
There are some more special characters you need to double up when using them in T-sql or in a dynamic sql string.
If you use variables from you calling application (vb.net,..)...
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
January 11, 2009 at 11:26 am
Books online has good info.
"create event notivication" and further...
Be sure to use the most recent one (dec.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
January 11, 2009 at 11:13 am
- figure out how many times the application calls the sproc in a single application run. (or how many times it executes the cmd-object)
it must be a loop of some...
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
January 10, 2009 at 10:59 am
Best is to run your code on a box where you have a sql2005 client installed.
If you need to run the code locally on a box, best is 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
January 10, 2009 at 7:56 am
Viewing 15 posts - 4,156 through 4,170 (of 7,503 total)