How do I get more details on maintenance plan tasks? I have "log extended information" checked but it doesn't add much detail.
For example, I would like to see all objects listed on the update statistics job like this:
Object 'cpf' was successfully marked for recompilation
OS: Windows 2012 Enterprise
SQL Server: 2012 Enterprise
I was wondering if there is any way all SQL Server error log entries could be automatically written to Windows Event Log.Â
Hi,
In my case I have to log the errors raised by any task in a package to either windows event log, text file or SQL server. Also I need to send an email notifications to a group of people telling them about the error.
Now can I use SSIS package logging for logging the errors into the required destinations. I mean right clicking on the package and selecting Logging, then adding the required log providers and enabling the events for logging into those. I think I have to upfront select the log providers to log the error, I will not have the liberty to log the error to the destination, the name of which is passed as a variable to the package. This is okay with me though.
Now what will a custom log provider help me to do in this case. Also can I somehow configure my package to call the send mail task everytime an error is raised.
Also, one more option can be developing a package that only does the error handling. It will take in the paramters or the error codes and descriptions, the destination to write to and a flag to send mail or not for that particular type of error.
What do you think? Kindly advise.
Thanks in advance for your help and time.
Regards,
$wapnil
I would like to determine the configuration for a given database in Microsoft SQL Server 7.0/2000.
If you examine the properties of databases using SQL Server Enterprise Manager, you can see that certain options exist for a database.
For example:
- ANSI NULL Default
- Recursive triggers
- Auto Update statistics
- Torn page detection
- Auto close
- Auto shrink
- Auto create statistics
- Use quoted identifiers
Can this information be obtain via a stored procedure?
What about information regarding the SQL server configuration itself?
If I use SQL Server Enterprise Manager, I can get properties for the
server.
For example:
- "Dynamcially configure SQL server memory" vs "Use a fixed memory size"
Is this information available?
Thanks!
We just started using SQL Server. I'm new on the SQL side of things. We have SQL setup in a test environment with users connecting and performing job related functions. An in house programmer has developed software for our users which connects to the SQL Server
I'm looking for information pertaining to events that have teken place within SQL. Does SQL give you details on updates and changes made to specific tables. I'm looking for some way of looking up item numbers and the user that entered the data. We have noticed that some of the users may be entering in wrong data within certain tables. And would like to educate them on what they are doing wrong.
I need to know what certain users are logging and entering into our SQL Server.
What are the most detailed logs that SQL Server provides that has information on what the users are doing has far an entering in data.
Hi there,
I was wondering if there is a detailed view control (that can be linked to grid view control) in ordinary C# applications as we have in ASP.NET applications? Please if anyone has information regarding that let me know.
Regards
Hi,
I'm a newbe in SQL Server and I have to build "Detailed Technical Design" Document regarding the SQL Server . If anybody knows something or has an example / structure about this document please send me a replay.....
Thank you in advance
Hello,
if a customer DOB is 1933-06-30 and a date of service is on 2007-06-21
that makes them 73 and not 74. How do I calculate an accurate years of age?
Thanks in advance.
The best I can get out of my detail log is this which is no help. How do I find out what really happened. My windows app log is no help either
Date 5/24/2006 9:51:41 PM
Log Job History (DTS_xx)
Step ID 1
Server xx
Job Name DTS_xx
Step Name DTS_xx
Duration 00:00:01
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0
Message
Executed as user: xxadministrator. The package execution failed. The step failed.
All,
I have a master package with 5 Execute Package Task for sub_packages.
How to get the detailed logging information as I see in the debug model in the local file system?
Thanks A lot
Hello,
I would like to know how to set the grouping lines or the detailed line to get the function like in Excel: group plan
Example:
+ Group line GL1
Detailed Line 1
Detailed Line 2
When the grouping function is active, you see the Group line GL1 only. By clicking on the + icone, you will see all the detailed lines (like in Excel document).
Thank you in advance for your replies.
regards,
Is it possible to combine a detailed query with its related count and sum without using any #temp tables at all?
ex. select customerID, customerName,
(select count(orderID) from tblOrder where orderDate > '01/01/2003'
and orderStatus = 'active') as countActive,
(select count(orderID) from tblOrder where orderDate > '01/01/2003'
and orderStatus = 'inactive') as countInActive
from rfCustomers
something like that? I was heard SQL2k has some new feature like this, or a UDF may be required? Currently, I have to use #temp table to get it.
thanks
David
I am using the XML Task to validate an XML file against the XSD schema.
Everything works fine, but about detailed errors in the case of the failed validation?
1) I specified €śOperationsResult€? Destination property to save the task execution outcome into a file.
2) Also, I turned on all possible events for logging.
Unfortunately, neither option produces a detailed validation error message.
Option 1 saves one single word €śtrue€? or €śfalse€? to a file.
Logging produces the following message:
Task failed to validate "A validation error occurred when validating the instance document.".
As end result, it is impossible to pinpoint the problem with the xml file and, consequently, fix the issue.
The expected behavior should be a detailed error message like the following (produced by StylusStudio):
file:///c:/temp/fafa/feed_bad.xml:12824,52: Datatype error: Type:InvalidDatatypeFacetException,
Message:Value '244212' must be less than or equal to MaxInclusive '4'.
It shows a precise location of the error in the XML file plus the specific XSD rule which failed.
Any idea what could be done to get the detailed error message for the XML Task Validation?
Regards,
Yitzhak
Hello,
Is there a way to get detailed error information in an e-mail?
Thanks,
Michael
Hello,
I have a code for creating view in T-SQL. I want to ask you guys, i want to make this result set should grouped by DepoAdi column and StokKodu (this is an alias sure you can get it from code). Did i make it on group by line? My second problem is i want to add 2 columns to this query. This 2 column will calculate some values with SUM function and - operator. At CRM.Depolar.DepoBilgileri table i have a column named Miktar (this one stores int type datas) and i have a column named islemturu(this one stores 1 or 0). I want to calculate Miktar values which rows has islemturu column 0 and subtract them from which rows has islemturu column 1 value and this computing action must be based on Grouped columns.
DepoAdi | StokKodu | Miktar | IslemTuru
ABS SK101 5 0
ABS SK101 3 1
ABS SK102 4 0
ABS SK102 3 1
This is the table and i'm imaging view what i want now...
DepoAdi | StokKodu | Miktar
ABS SK101 2
ABS SK102 1
How can i add this resultset to my code..
Thanks for reading... Waiting your answers.. Happy coding...
CREATE VIEW [CRM.Depolar.DepoDurumlari]
AS
SELECT [CRM.Depolar.DepoBilgileri].DepoAdi,
[CRM.Objeler.TemelGruplar.TureyenGruplar].GrupKodu + [CRM.Objeler.ObjeKodlari].ObjeKodu AS StokKodu
FROM [CRM.Depolar.DepoBilgileri], [CRM.Objeler.TemelGruplar.TureyenGruplar], [CRM.Objeler.ObjeKodlari], [CRM.Depolar.DepoHareketleri]
WHERE [CRM.Depolar.DepoBilgileri].Id IN (SELECT DepoBilgileri
FROM [CRM.Depolar]
WHERE Id IN (SELECT Depo
FROM [CRM.Depolar.DepoHareketleri]))
AND [CRM.Objeler.TemelGruplar.TureyenGruplar].Id IN (SELECT ObjeGrubu
FROM [CRM.Objeler]
WHERE Id IN (SELECT Id
FROM [CRM.StokKartlar]
WHERE Id IN (SELECT StokKart
FROM [CRM.Depolar.DepoHareketleri])))
AND [CRM.Objeler.ObjeKodlari].Id IN (SELECT StokKodu
FROM [CRM.StokKartlar.KartBilgileri]
WHERE Id IN (SELECT KartBilgileri
FROM [CRM.StokKartlar]
WHERE Id IN (SELECT StokKart
FROM [CRM.Depolar.DepoHareketleri])))
GROUP BY [CRM.Depolar.DepoBilgileri].DepoAdi, [CRM.Objeler.TemelGruplar.TureyenGruplar].GrupKodu, [CRM.Objeler.ObjeKodlari].ObjeKodu
Hello,
How can I find the cause on the error that marked one conversation with status 'ER' in sys.conversation_endpoints?
Thanks in advance.
When looking at SQL Server error logs, I noticed that the current error
log had grown to 1MB whereas most of the files are only a few KB.
QUESTION 1: Can I set the max size for an error log file? If so, how?
QUESTION 2: If not, is there a workaround?
Thanks
We have (running SQL 2012 Std) and have enabled trace flag 1204 and 1222 for capturing deadlock through extended events. I have enabled deadlock notification through email .But it only send deadlock event occurred notification from the sql server error log . I was wondering if its possible to email the deadlock details they get generated in extended events via DB mail.
View 1 Replies View RelatedI had a problem with mirroring that I only was able to resolve when I attempted to replicate instead. Replication gave me an error message that expained the problem; mirroring simply failed.
Is there any place where mirroring logs the details of what it is doing & why it is failing?
BTW, the problem was that the server name was changed after SQL was installed. Although i knew this, the forums indicated taht SQL 2005 automatically picks up the new name after it is restarted. This apparently is not true...
Thanks
Dave S
Environment:
Running this code on my PC via VS 2005
.Net version 2.0.50727 on the server (shown in IIS)
Code is in ASP.NET 2.0 and is a VB.NET Console application
SSIS 2005
Problem & Info:
I am bringing in an Excel file. I need to first strip out any non-detail rows such as the breaks you see with totals and what not. I should in the end have only detail rows left before I start moving them into my SQL Table. I'm not sure how to first strip this information out in SSIS specfically how down to the right component and how to actually code the component to do this based on my Excel file here: http://www.webfound.net/excelfile.xls
Then, I assume I just use a Flat File Source coponent or something to actually take the columns in the Excel and split into an OLE DB Datasource to shove each column into a corresponding column in my SQL Server Table. I have used a Flat File Source in the past to do so with a comma delimited txt file but never tried with an Excel.
Desired Help:
How to perform
1) stripping out all undesired rows
2) importing each column into sql table
the logs on our database keep locking up and return and file size of 0. Does any know of a way to dump the log file. I tried: Dump Transaction log to .... but it did not want to work any ideas.
View 6 Replies View RelatedI'm running a SQL Server 2005 Express installation.
Now I notice that the SQL Server logs (under Management in Mgmt Studio Express) are
empty - no logs are in there, neither under Current, nor under the "archived".
Do I have to switch on logging explicitly??
(I'm logging on as "sa".)
Hi,I'm using SQL Server Management Studio Express and I have made a website that uses a database with stored procedures.When running pages in my webpages it cost around 2 seconds to load each page.Thanks too long!! But where is the problem???I like to see a list of all executed stored procedures with there execute time (for each page).In this way I can check if the problem is here.How can I get a logfile like this?Thanks!
View 1 Replies View RelatedWhat is the best way to clear the transaction logs. My backup job each night is ending because it says it is running out of disk space and I need to clear up the transaction logs. Any help is appreciated. I see many different options (trucate option, auto shrink, etc.), just need some assistance tosome more specific best approaches. Thanks
View 3 Replies View RelatedScenario:
I have August22 full backup and August22 and August23 transactions log backups . I want to get the August23 and August23 full backup. So I performed a restore backup with August22 full backup and all the August22 trn backups. Then I backed up giving it August23 name and repeated the process with the August23 trn backups. But, I get an error saying that the transactions haven't been rolled foward far enough. But, I am not missing any trns! I will really be grateful if anyone would help.
thanks.
Im having issues truncating my transaction logs. I have logs in excess of 40 gigs. All the info in the BOL is very vague. Any assistance would be apreciated.
Regards
SeTi Ni
When we backup the transaction log,will it truncate the log or it will grow from there?Truncate log on check point is desabled.
Thanks!
Currently, my client is allowing all the developers to log in as sa and most servers have a NULL sa password. Not a good idea. I am recommending them to move to integrated security with NT groups and to move away from using the sa login altogether. Then to secure the sa login, actually give it a password (something cryptic). I also wanted to set up an alert whenever someone logs in using the sa password. How can that be accomplished? A trigger on the sysprocesses table would work but seems a little risky.
View 8 Replies View RelatedI am currently trying to export from SQL to notes via NotesSQL.I have set up the necessary ODBC data sources & DTS job. I am encountering errors when I attempt to execute the DTS package . I.e "job failed"
- How do I drill down to aquire more detailed error logging on the package to find out exactly what's wrong with DTS?
Thanks
Paul
I've truncated and shrunk the database and now, it says that the size of the db is 14 mb and 8mb is free. However, on the file system, the mdb and
ldb files together adds up to 14 mb. How can I free up the 8 mb for other usage?
Thanks,
Anthony
In Enterprise Manager, Management and then SQL Server Logs, when I clicked on Current or Archive#1 or 2 etc, nothing happens. This has been going on for the past 3 weeks does any one knows what is causing such problems?
View 1 Replies View RelatedWhen I'm in EM, there is one log that when I click on it to view it hangs my EM. All other logs (current and others) I can click and view just fine. I'm on my way out to the server to see the log in the file directory but what could cause this?
Thanks..
to take the transaction log back up regularly I should have truncate log on check point false. If I do so then how will I truncate the log.
regards,
Renu