Viewing 15 posts - 3,226 through 3,240 (of 7,499 total)
Or by activating a login trigger (needs sp2) which only alows 'sa' or members of sysadmins sqlgroup.
Could be usefull if you intend to acivate it for a maintenance window, but...
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 6, 2010 at 6:23 am
if you want to, you can attach the errorlog file to your reply (if it is not to big) so we can have a look
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 6, 2010 at 4:37 am
How does your .net application connect to sqlserver
or
how is the webservice you are calling connecting to sqlserver ?
If it is tunneling credentials, chances are a user ( 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
January 6, 2010 at 4:34 am
Spend 100$ for a 1.5TB USB disk.
Hook that onto your server.
Create the db backup to that usb disk
robocopy the backup file to your network safe zone location.
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 6, 2010 at 3:25 am
Is your target transaction log big enough to be able to process all incoming replication commands ?
- file size
- autogrow enabled ? ( grow by reasonable MB !)
- can your...
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 6, 2010 at 3:21 am
You need to provide full rows (all columns and in the exact column order ! ) if you want to use bulk insert !
Workaround:
Create a view that contains only 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 6, 2010 at 3:14 am
GoofyKC (1/5/2010)
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 6, 2010 at 12:11 am
btw Error: 250071 is an error number > 49999 which indicates it is a user defined error code !
Order your devs to figure out in which occasions they raise this...
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 4, 2010 at 5:38 am
why would you only allow sa to connect ?
Is it for sql server (software) maintenance ?
You could start sqlserver using the maintenance parameter. (check books onlin for startup parameters...
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 3, 2010 at 3:08 am
You are probably on the right track ...
tempdb is used for way more activities than just holing the data for temporary tables. Cursors, sorts, group by, intermediate results for working...
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 1, 2010 at 4:37 am
I would first restrict the growth of tempdb, so it doesn't fill up your disk.
I would start a sqlserver profiler session to capture the ongoing queries.
You'll probably find a set...
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
December 31, 2009 at 9:32 am
of course you should also pose the question : WHY ??
If this is some kind of "primitive" encryption, SQLServer nowadays has a better alternative !
Is it to confuse network sniffers...
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
December 30, 2009 at 12:11 pm
start from scratch !
create a new windows account with no privileges at all ( none on windows, none on sqlserver)
Then grant that account only the needed auth on your sqlserver...
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
December 30, 2009 at 12:03 pm
btw there is a sql7/2000 version posted in this forum thread:
http://www.sqlservercentral.com/Forums/Topic512777-338-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
December 30, 2009 at 2:36 am
Vinay Thakur-585143 (12/29/2009)
can you please brief about:
"Maybe one of your processes keeps a permanent lock on one of your objects."
also how can be "deadlock happen" as reindex is run...
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
December 29, 2009 at 3:02 pm
Viewing 15 posts - 3,226 through 3,240 (of 7,499 total)