Viewing 15 posts - 5,071 through 5,085 (of 7,506 total)
No, these settings are active after stop/start of sqlserver.
they report failed logins in the sql errorlog file;
You can read it directly or import it using exec sys.sp_readerrorlog
Because that proc 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
March 17, 2008 at 9:08 am
checksum is not an option in a maintenance plan gui (not manual, not with the wizard).
However you can check "verify backup integrity".
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
March 17, 2008 at 6:28 am
Jeff Moden (3/14/2008)
ALZDBA (3/14/2008)
I appreciate the feedback, Johan...
The problem is that most of the Devs nowadays are really GUI programmers that learned just enough SQL to be able to do...
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
March 17, 2008 at 3:08 am
most scripts at SSC need to be executed in a query panel or using sqlcmd unless mentioned otherwise.
So in Sqlserver Management Studio, open a query panel to the desired 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
March 17, 2008 at 12:49 am
- is msdtc running at both instances ?
- did you configure msdtc security ?
Windows 2003 vs other windows ?
- did you add the registry key ?
-- zie...
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
March 14, 2008 at 11:10 am
we monitor this in the sql errorlog by setting the Auditlevel
print 'adjust Auditlevel - Failure';
if charindex('\',@@servername ,0) > 0
begin
EXEC xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'AuditLevel', REG_DWORD, 2
...
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
March 14, 2008 at 11:04 am
Indeed 70% or our tuning time is actualy sql-education.
If our dev's would only apply the basic rules and also try to write their
code at least in two different ways,
they...
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
March 14, 2008 at 2:26 am
As you stated:
I cannot keep the user waiting for that long.
For sure the alternative is using triggers and storing differences only !
Any other alternative will take time ! No...
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
March 14, 2008 at 1:13 am
there is a nice script overhere:
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=65&messageid=107424
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
March 14, 2008 at 12:48 am
Isn't that exactly what a sysnonym stands for ?
Check BOL
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
March 13, 2008 at 4:52 pm
keep in mind sqlserver needs some background processes to manage the instance/sqlagent/.....
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
March 13, 2008 at 1:32 pm
you could create a clustered index and drop it back again.
Keep in mind this will rewrite your table data twice ! as well as the index data.
If you can...
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
March 13, 2008 at 1:30 pm
Jay (3/13/2008)
0000010011
0020010234
0102020202
What's the datatype of you column ?
I suppose it is char(10).
In that case you would need :
[Code]
alter table yourtable
set yourcolumn char(15)
go
[/Code]
Keep...
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
March 13, 2008 at 1:27 pm
- What version of sql2005 is this ? (+ sp + cu please)
- has the package been modified lately ?
- did you try sp_revoke_login_from_proxy and grant it again ?
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
March 13, 2008 at 5:58 am
- Can you post a create proc ddl for this ?
- what data type do you declare the output parameter ?
- Best is to know in front what data type...
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
March 13, 2008 at 5:24 am
Viewing 15 posts - 5,071 through 5,085 (of 7,506 total)