April 16, 2018 at 12:02 pm
Hello fellows,
I'm trying to build a couple of scripts for day 2 day dba tasks and i have been wondering if you guys recommend using the undocumented stored procedures of SQL Server like 'xp_readerrorlog' 'xp_servicecontrol'
Do you guys use them? no ? why not? would you recommend using them?
Greetings.
April 16, 2018 at 12:12 pm
Alejandro Santana - Monday, April 16, 2018 12:02 PMHello fellows,I'm trying to build a couple of scripts for day 2 day dba tasks and i have been wondering if you guys recommend using the undocumented stored procedures of SQL Server like 'xp_readerrorlog' 'xp_servicecontrol'
Do you guys use them? no ? why not? would you recommend using them?
Greetings.
Normally I would not suggest using anything that is undocumented on the SQL platform
😎
Can you tell us what you are doing, might help us providing alternatives?
April 16, 2018 at 12:28 pm
Eirikur Eiriksson - Monday, April 16, 2018 12:12 PMAlejandro Santana - Monday, April 16, 2018 12:02 PMHello fellows,I'm trying to build a couple of scripts for day 2 day dba tasks and i have been wondering if you guys recommend using the undocumented stored procedures of SQL Server like 'xp_readerrorlog' 'xp_servicecontrol'
Do you guys use them? no ? why not? would you recommend using them?
Greetings.
Normally I would not suggest using anything that is undocumented on the SQL platform
😎Can you tell us what you are doing, might help us providing alternatives?
I'm trying to automate a little bit about the services that are running at the moment with xp_servicecontrol and trying to read the SQL Server error log to make different small reports like failed logins, failed backups, engine errors and insert them in a small database to keep a record of how the database was at that time, it's like the first thing i do at morning, i log in, check logs, check if any backup failed etc.
Its to have a history for the higher ups.
these help me be a little bit faster in checking services, error logs.
Thanks alot. 😀
April 16, 2018 at 12:36 pm
Alejandro Santana - Monday, April 16, 2018 12:28 PMEirikur Eiriksson - Monday, April 16, 2018 12:12 PMAlejandro Santana - Monday, April 16, 2018 12:02 PMHello fellows,I'm trying to build a couple of scripts for day 2 day dba tasks and i have been wondering if you guys recommend using the undocumented stored procedures of SQL Server like 'xp_readerrorlog' 'xp_servicecontrol'
Do you guys use them? no ? why not? would you recommend using them?
Greetings.
Normally I would not suggest using anything that is undocumented on the SQL platform
😎Can you tell us what you are doing, might help us providing alternatives?
I'm trying to automate a little bit about the services that are running at the moment with xp_servicecontrol and trying to read the SQL Server error log to make different small reports like failed logins, failed backups, engine errors and insert them in a small database to keep a record of how the database was at that time, it's like the first thing i do at morning, i log in, check logs, check if any backup failed etc.
Its to have a history for the higher ups.
these help me be a little bit faster in checking services, error logs.
Thanks alot. 😀
Before I dig deeper into the problem, can you use xp_cmdshell?
😎
April 16, 2018 at 12:47 pm
Eirikur Eiriksson - Monday, April 16, 2018 12:36 PMAlejandro Santana - Monday, April 16, 2018 12:28 PMEirikur Eiriksson - Monday, April 16, 2018 12:12 PMAlejandro Santana - Monday, April 16, 2018 12:02 PMHello fellows,I'm trying to build a couple of scripts for day 2 day dba tasks and i have been wondering if you guys recommend using the undocumented stored procedures of SQL Server like 'xp_readerrorlog' 'xp_servicecontrol'
Do you guys use them? no ? why not? would you recommend using them?
Greetings.
Normally I would not suggest using anything that is undocumented on the SQL platform
😎Can you tell us what you are doing, might help us providing alternatives?
I'm trying to automate a little bit about the services that are running at the moment with xp_servicecontrol and trying to read the SQL Server error log to make different small reports like failed logins, failed backups, engine errors and insert them in a small database to keep a record of how the database was at that time, it's like the first thing i do at morning, i log in, check logs, check if any backup failed etc.
Its to have a history for the higher ups.
these help me be a little bit faster in checking services, error logs.
Thanks alot. 😀
Before I dig deeper into the problem, can you use xp_cmdshell?
😎
Yes i can, but i have never really used it.
April 16, 2018 at 1:04 pm
Alejandro Santana - Monday, April 16, 2018 12:47 PMEirikur Eiriksson - Monday, April 16, 2018 12:36 PMAlejandro Santana - Monday, April 16, 2018 12:28 PMEirikur Eiriksson - Monday, April 16, 2018 12:12 PMAlejandro Santana - Monday, April 16, 2018 12:02 PMHello fellows,I'm trying to build a couple of scripts for day 2 day dba tasks and i have been wondering if you guys recommend using the undocumented stored procedures of SQL Server like 'xp_readerrorlog' 'xp_servicecontrol'
Do you guys use them? no ? why not? would you recommend using them?
Greetings.
Normally I would not suggest using anything that is undocumented on the SQL platform
😎Can you tell us what you are doing, might help us providing alternatives?
I'm trying to automate a little bit about the services that are running at the moment with xp_servicecontrol and trying to read the SQL Server error log to make different small reports like failed logins, failed backups, engine errors and insert them in a small database to keep a record of how the database was at that time, it's like the first thing i do at morning, i log in, check logs, check if any backup failed etc.
Its to have a history for the higher ups.
these help me be a little bit faster in checking services, error logs.
Thanks alot. 😀
Before I dig deeper into the problem, can you use xp_cmdshell?
😎Yes i can, but i have never really used it.
Suggest you research a bit on the topic, I'll try to post something here when I have the time.
😎
April 16, 2018 at 1:13 pm
Eirikur Eiriksson - Monday, April 16, 2018 1:04 PMAlejandro Santana - Monday, April 16, 2018 12:47 PMEirikur Eiriksson - Monday, April 16, 2018 12:36 PMAlejandro Santana - Monday, April 16, 2018 12:28 PMEirikur Eiriksson - Monday, April 16, 2018 12:12 PMAlejandro Santana - Monday, April 16, 2018 12:02 PMHello fellows,I'm trying to build a couple of scripts for day 2 day dba tasks and i have been wondering if you guys recommend using the undocumented stored procedures of SQL Server like 'xp_readerrorlog' 'xp_servicecontrol'
Do you guys use them? no ? why not? would you recommend using them?
Greetings.
Normally I would not suggest using anything that is undocumented on the SQL platform
😎Can you tell us what you are doing, might help us providing alternatives?
I'm trying to automate a little bit about the services that are running at the moment with xp_servicecontrol and trying to read the SQL Server error log to make different small reports like failed logins, failed backups, engine errors and insert them in a small database to keep a record of how the database was at that time, it's like the first thing i do at morning, i log in, check logs, check if any backup failed etc.
Its to have a history for the higher ups.
these help me be a little bit faster in checking services, error logs.
Thanks alot. 😀
Before I dig deeper into the problem, can you use xp_cmdshell?
😎Yes i can, but i have never really used it.
Suggest you research a bit on the topic, I'll try to post something here when I have the time.
😎
Thanks alot, i've been reading something and it looks really nice.
🙂
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply