Viewing 13 posts - 1 through 13 (of 13 total)
Hi Ajay,
take a look at "Security Account Delegation" article in BOL ...
Alexzander N. Nepomnjashiy
Technical editor for Wrox Press:
"SQL Server 2000 Fast Answers"
Technical editor for Apress:
"Honeypot for Windows"
"SQL Server Yukon Revealed"
November 11, 2004 at 2:32 am
Hi Tom,
take a look at Quest's Spotlight® on SQL Server (at http://www.quest.com/spotlight_sql/). Free 30 days trial is also available for download from their web site.
P.S> P.S. visit our TechRepublic's...
Alexzander N. Nepomnjashiy
Technical editor for Wrox Press:
"SQL Server 2000 Fast Answers"
Technical editor for Apress:
"Honeypot for Windows"
"SQL Server Yukon Revealed"
November 5, 2004 at 12:47 am
Hi Stu,
You're talking about two different things here to me - shrinking the log file(s) is quite different to truncating the log.
yes, you are right, but originally we discuss...
Alexzander N. Nepomnjashiy
Technical editor for Wrox Press:
"SQL Server 2000 Fast Answers"
Technical editor for Apress:
"Honeypot for Windows"
"SQL Server Yukon Revealed"
November 3, 2004 at 3:14 am
Is there some secret something going on with TRUNCATEONLY that causes it to do a better job of truncating the log?
NO, there is no secrets here, at all. I've...
Alexzander N. Nepomnjashiy
Technical editor for Wrox Press:
"SQL Server 2000 Fast Answers"
Technical editor for Apress:
"Honeypot for Windows"
"SQL Server Yukon Revealed"
November 3, 2004 at 1:28 am
NO, IT'S NOT POSSIBLE:
According to SQL Server BOL: "Note Because SQL Server does not support user-defined triggers on system tables, it is recommended that no user-defined triggers be created on system...
Alexzander N. Nepomnjashiy
Technical editor for Wrox Press:
"SQL Server 2000 Fast Answers"
Technical editor for Apress:
"Honeypot for Windows"
"SQL Server Yukon Revealed"
November 2, 2004 at 1:05 am
... also, you can post your SQL Server-related questions to this forum: http://myitforum.techtarget.com/forums/tt.asp?appid=73
Alexzander N. Nepomnjashiy
Technical editor for Wrox Press:
"SQL Server 2000 Fast Answers"
Technical editor for Apress:
"Honeypot for Windows"
"SQL Server Yukon Revealed"
November 2, 2004 at 12:58 am
Yes, you are right ... According to SQL Server BOL: "Note Because SQL Server does not support user-defined triggers on system tables, it is recommended that no user-defined triggers be created...
Alexzander N. Nepomnjashiy
Technical editor for Wrox Press:
"SQL Server 2000 Fast Answers"
Technical editor for Apress:
"Honeypot for Windows"
"SQL Server Yukon Revealed"
November 2, 2004 at 12:55 am
also take a look at this article: http://www.myitforum.techtarget.com/articles/18/view.asp?id=7411
Alexzander N. Nepomnjashiy
Technical editor for Wrox Press:
"SQL Server 2000 Fast Answers"
Technical editor for Apress:
"Honeypot for Windows"
"SQL Server Yukon Revealed"
September 21, 2004 at 6:48 am
The time interval between the transaction log backups depends on database server workload and / or users activity. Monitor the transaction log grows and adjust time interval accordingly (create...
Alexzander N. Nepomnjashiy
Technical editor for Wrox Press:
"SQL Server 2000 Fast Answers"
Technical editor for Apress:
"Honeypot for Windows"
"SQL Server Yukon Revealed"
September 21, 2004 at 6:45 am
Steve, thank you for your thoughts.
Alexzander N. Nepomnjashiy
Technical editor for Wrox Press:
"SQL Server 2000 Fast Answers"
Technical editor for Apress:
"Honeypot for Windows"
"SQL Server Yukon Revealed"
April 15, 2004 at 11:40 pm
Mark, thank you VERY MUCH!
Alexzander N. Nepomnjashiy
Technical editor for Wrox Press:
"SQL Server 2000 Fast Answers"
Technical editor for Apress:
"Honeypot for Windows"
"SQL Server Yukon Revealed"
April 13, 2004 at 7:10 am
Thank you
Alexzander N. Nepomnjashiy
Technical editor for Wrox Press:
"SQL Server 2000 Fast Answers"
Technical editor for Apress:
"Honeypot for Windows"
"SQL Server Yukon Revealed"
April 13, 2004 at 1:33 am
Steve, thank you, but : "... Doing a local and moving it is also out due to disk space..."
Alexzander N. Nepomnjashiy
Technical editor for Wrox Press:
"SQL Server 2000 Fast Answers"
Technical editor for Apress:
"Honeypot for Windows"
"SQL Server Yukon Revealed"
January 24, 2004 at 4:22 am
Viewing 13 posts - 1 through 13 (of 13 total)