Hi,
Get an error in the log, "The time stamp counter of CPU on scheduler id 1 is not synchronized with other CPUs." and for the moment I just wan't to disable all the server loggings.
Indeed errors should be investigated, but not for the moment...
Thanks!
Rickard
I would like to use logging to be able to view information about the package execution afterwards, especially to be able to find out which task that failed and why it failed.
Something similar to this:
-----------------------------------------------------------------------------
The execution of the following DTS Package succeeded:
Package Name: XXX
Package Description: YYY
Package ID: {5ADDA98B-1F27-404B-8EC4-3568FA4523F6}
Package Version: {0DAA5592-D123-4936-94FC-717DDC581866}
Package Execution Lineage: {4D353C5F-444E-4870-8A4F-B35B635F3646}
Executed On: ServerName
Executed By: XXX
Execution Started: 2005-06-22 07:14:27
Execution Completed: 2005-06-22 07:40:17
Total Execution Time: 1550,422 seconds
Package Steps execution information:
Step 'DTSStep_DTSDataPumpTask_1' succeeded
Step Execution Started: 2005-06-22 07:18:30
Step Execution Completed: 2005-06-22 07:18:31
Total Step Execution Time: 0,031 seconds
Progress count in Step: 37
Step 'DTSStep_DTSActiveScriptTask_2' was not executed
Step 'DTSStep_DTSExecuteSQLTask_33' failed
Step Error Source: Microsoft OLE DB Provider for SQL Server
Step Error Description:The statement has been terminated. (Microsoft OLE DB Provider for SQL Server (80040e2f): Cannot insert the value NULL into column 'ID_adress', table 'VPKBA.dbo.aktAdress'; column does not allow nulls. INSERT fails.)
Step Error code: 80040E2F
Step Error Help File:
Step Error Help Context ID:0
Step Execution Started: 2005-06-22 07:40:14
Step Execution Completed: 2005-06-22 07:40:17
Total Step Execution Time: 3,672 seconds
Progress count in Step: 0
-------------------------------------------------------------------------------------
I have tried different events to be logged on the Details-tab on Configure SSIS Logs, but I don't get the information that I want.
I also want to send this log-file as an attachment in a couple of Send Mail task in the same package. But then I get this error:
Error at Mail Error [Send Mail Task]: Either the file "filename.txt" does not exist or you do not have permissions to access the file.
The file does exist and there is no permission problem because I don't get this error when I remove logging.
Isn't it possible to do this in SSIS-packages?
It works in DTS-packages.
Regards,
Sara
Hi,
we are using MS SQL 7.0 and whenever the sp EXECUTE msdb.dbo.sp_sqlagent_get_perf_counters runs it causes huge io reads and at the same time CPU Util of Database server goes to 100% though the CPU util of this proc is 0 or near zero..
I am not sure though that this is the problem ...but to check whether this is the problem i need to disable this...
This runs every 20 seconds and i know we can disable this is sQL 2000
by changing registry settings ...
Is there a similar way for SQL 7.0 to disable this sp
Hi,
is it possible to enable a user to perform changes on some SQL Server tables,
but to disable the changes on the same tables via MS Access for this user?
E.g. I can change a table on SQL Server, and me and some other users access the table via MS Access. I disabled the changes on the table by other users in general, only I can perform changes.
But I also want to disable the changes for myself if I view the table in MS Access.
Thanks
Katarina
Hi ,
Recently i enabled audit by selecting properties of the server and enabling audit-all.
Now i disabled audit by select audit level=NONE.Still i get trace files.
Can anyone help me,how to stop this?
I also rebooted the server??
Hi,
I disabled audit by right-clicking the server->security->and disabled audit->none..But also we seeing audit files.
Can anyone help me??
How can I disable windows authentication mode in SQL Server using sql query or a windows command.
I know how to do it using management studio. i.e., security --> logins --> Builtin/Administrators --> status --> login --> disabled.
But I need to do this using the command.
Hi,
View 4 Replies View RelatedI have a trigger that executes AFTER INSERT, UPDATE, DELETE. Is there a way to disable and then reenable only the "AFTER DELETE", letting AFTER INSERT, UPDATE act normally?
View 6 Replies View Relatedthe disable trigger will be enable again.Because I already disable the trigger on last month, but when I check through the database, it enable again.I understand that, when we restore the database, all the trigger will be enable.How about SQL Cluster? will it enable the trigger??
View 3 Replies View Related
Hello,
I have a big problem with SQL Server 2000 and Visual Basic .Net. I wont disable named Pipes from code write in Visual Basic (.Net). How make this ?
This problem is very important for me.
Help me! Please!!!
Hi all,
I am sorry if i am posting this error in an inappropriate froum.
Well in my asp.net intranet web application i want to enter a number to the database(sql sever 2005) that has a column(schoolkm) whose type is decimal(9, 2). Now if i want to enter the value 1.5 in the text box and enter that value to the database through interface then that value automatically rounds to 2. But when i get into the table and enter that value by hand then that value enters perfectly i.e. without rounding of. I want to know the reason and how can i cure this problem.
Regards & thanks in advance
It's often said or done that when inserting or updating into a 'large' table that disabling the non-clustered indexes can is needed for performance.
Now I know the obvious way to find out if this is best or not is by testing the different options. I was wondering if there was a rule of thumb to this?
Say you have a table with half a billion rows and 4 non-clustered indexes and are only updating half a million rows then sometimes disabling every night and re-enabling can take way more time than the actual update. Haven't found an articles advising to disable them when a table is over X rows and you are updating Y% of them...
Is there a way to do this at the server level?
Thanks
Hi,
I have windows 2003 (SP1) server with sql server 2000 (SP3) .
In the server network utility, I have enables only TCP/IP protocol and disabled the Named pipe protocol.
Now if I try to connect to the sql server from a remote machine, I get the message saying "unable to connect either server does not exist or ......".
I have configured the firewall to allow communication on TCP port 1433. It didn't help. I tried to disable the firewall completely, still it didn't work.
It works only if I enable Named pipe in the server's server network utility.
- Abhijit
We have tested mirroring with success.
Now we want to completly disable mirroring, and have done this on all mirrored database.
It seems though that the server stille maintains the mirror endpoints, hence you can do a "telnet localhost 5022".
How can we disable the mirroring endpoints ?
Martin Tan
SQL DBA
Any command through that can I delete/disable the DWORD value "Pendingfilerename operations" so that while I start the SQL Install work, it does not fail due to this and can write this as one of the precheck options.
View 0 Replies View RelatedHI all,
I would like to ONLY allow using SQL Server authentication and restrict Windows Authentication. At the moment, i set the security to "SQL server and windows authentication". Now, even though i set the password for "sa", i can ignore the SQL Server authentication and just use Windows authentication to manipulate database objects???
can anybody give some suggestions to restrict windows authentication and allow sql server authentication?.
Thanks in Advance
Best Regards
Ihsan
I have the following setup:
- An MSSQL 2014 Standard server that houses multiple small databases (in excess of a hundred).
- These databases are frequently dropped and restored by an application that uses this SQL Server.
- There is a business need for this setup at this time, so I can't get away from it. Therefore answers like "don't have so many small databases that are frequently dropped and restored" would be somewhat unuseful
This is the problem I have:
- When I connect SSMS 2014 to the server and expand the "Databases" node, it takes forever to display. In comparison, SSMS 2008 connected to SQL 2008R2 server with the same number of databases displays the Databases tree very quickly.
I ran a trace to see what exactly SSMS 2014 is doing. When the "Databases" node is expanded, it runs a query that checks each database for Memory-Optimized Tables (new and wonderful feature of SQL 2014 for sure, but I'm not using it, at least yet). Naturally, when you have to loop through over a hundred DBs, it takes time. Worse yet, if one of these DBs is in process of being restored, the query sits and waits to time out before proceeding to the next DB. Sometimes this causes outright timeouts. Here is the query:
use [MyDatabase]
SELECT
ISNULL((select top 1 1 from sys.filegroups FG where FG.[type] = 'FX'), 0) AS [HasMemoryOptimizedObjects]
To be sure, this is NOT a SQL Server performance issue. This server processes a rather heavy workload and has been doing so for over a month, and the workload completes within expected time limits or better. Even so I've done some basic performance measuring, and the server itself is quite all right.
Moreover, if I connect SSMS 2008 to it, I get an error message (Index out of bounds or somesuch), but SSMS 2008 does connect, and displays the Databases tree much faster than SSMS 2014.
I'd like to turn off the option to check for Memory Optimized Objects altogether, as I'm not using the feature.
Am customizing SQL server MGMT tools 2012 for Mass deployment.Client had asked to remove Customer Feedback option from help menu.how to disable that.
View 6 Replies View RelatedIs there a way to disable trigger for a time window and enable it when desired.
View 1 Replies View RelatedIs it possible to disable a trigger to manually manipulate data without completely removing it? Thank you.
View 2 Replies View RelatedA quick question, how can I disable identity for the identity column
without dropping that column? Thanks!
Xiao
Is there a way to disable logging ?
I'm about to split a 1000000 rows table into three other tables , and would prefere not to log this action ...
Does anyone know how to do it in a SQL 7.0 statement ?
I don't seem to be able to find a command to disable triggers. Can this
be done in SQL7?
Thanks.
Is it possible to disable a trigger in SQL Server 6.5?
Is so, how can i do that?
read-only option
dbo-use option
...
Anyone any ideas ?!?
Hi,
can I disable a trigger in Sqlserver 2000??? When i run a store procedure who works with one table i want that the trigger doesn´t work it. After that the trigger would be enabled again.
I know i can delete it and create it again but something like "ALTER TRIGGER DISABLED" would be ok.
Thanks.
Sorry, may be it is very simple, but
how can I disable all trigger on a tabled under sql 2000
CDC is disabling when we do bulkinsertsupdateschange schema .how to findout why CDC disabled and how to prevent it ?
View 3 Replies View RelatedHi,
Is there any way to disable the primary key constraint?.I want to move the records from one table to another.say column 'x' in the source table doesnt contain a primay key.But my target table column 'x' contains primay key.
How to ovecome this problem?
Thanks in advance
Hello all.
Could anyone advise me how to disable indexes on a specific table at the start of a script, then re-enable them at the end?
Thanks all.
I am looking for a way to disable DatabaseMail90.exe (temporarily) while still allowing emails to queue up.
At first, I thought the solution was sysmail_stop_sp... but if I use this... calls to sp_send_DBMail fail with the following message:
Mail not queued. Database Mail is stopped. Use sysmail_start_sp to start Database Mail.
I'd like the emails to be queued... I just want to postpone sending them. Anyone know how to do this?
- Alan D. Nelson