we need to report on what changes were made to one particular column of a table. We need to report the old value, the new value and the date and userid (these are also fields in the table).
I assume we use an update trigger with a query to capture the old and new values in a temp table?
Does anyone have any sample syntax for such a situation?
If I'm on a remote machine, meaning a computer not in the WSFC cluster, and I open SSMS 2014, point it to a SQL Instance, and open activity monitor:
1. I get all the panes and charts except % Processor Time.
2. Then, if I authenticate to the cluster's domain by mapping a drive with valid domain credentials, I'm free to put performance counters in the Perfmon - - - but SQL Activity Monitor shuts down with“The Activity Monitor is unable to execute queries against server SQL-V01INSTANCE1..Activity monitor for this instance will be placed into a paused state.Use the context menu in the overview pane to resume the activity monitor.
Additional information: Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))(Mscorlib)”
3. Of course, the Activity monitor can't be resumed via the context menu. Removing counters and closing the perfmon do not work. I dropped the mapped drive and rebooted the machine. That brought back 95% of the information in the Activity monitor.
4. Further experimentation showed that any mapping of drive shares present on the SQL Server to the computer running SSMS cut off functionality of the 'overview' pane in the remote machine's SQL Activity monitor -- the monitor that had been trying to watch the server offering the shares.
Hiya!I've combed the SQL Server 2000 online help but I don't see anythingakin to Sybase ASE's 'montor' views - equivalent to Oracle's V$views. The views are performance views which contain per sessioninformation such as:- SPID- number of logical read/write and physical read I/Os accumulatedthus far- CPU accumulated- Memoryetc.Does anyone know if I can snarf that data from SQL Server 2000?Thx!--Pablo Sanchez, Blueoak Database Engineeringhttp://www.blueoakdb.com
View 3 Replies View RelatedWe have a database on the live server which powers a website. Then our client has a copy of the database at their office. Their is Merge replication set up between the two running every half a hour.
Now they want to be able to look at the merge replication history.
With my little knowledge, I believe that the place to get this data from is the distribution database on the publishing machine which is the live server. Now for obvious reasons we cannot replicate the
distrubution database to their side so we need to come up with some way of giving them the data. They also want a history of replication.
So the way I was thinking of fixing it was to have a job that copies some of the last days data from the distrubution database onto the main database and add that table to the replication so they got it every day. Also writing a ASP page so they can look at the last days
data straight from the distrubution database.
Here are my questions:
Question 1:
How long does the replication store history for?
Question 2:
Is thier any simpler way of allowing them to see the replication history?
Question 3:
Are their any other things I should be worried about?
Thanks for any feedback, Nixies
Hi everyone,
Once our company encoutered database disk full issue, so we cannot insert any more data. So is there way I can monitor the data file size? or is there a monitor tool to sending out alert?
for example,
It can show me how many percentage of data file has been used e.g. 90%. so I know it's critical and I need to increase more space for database or disk drive.
thank you in advance
Hi,
Not sure if this question makes sense, but is it necessary to purge old data in msdb tables used by the db mirroring monitor job?
I'm just wondering if an insert into the data table every minute of the day would still be needed a month from now. I'm thinking this data would be useful for the purpose of "alerts" and to have access to its recent history, but other than that, is it recommended (or necessary)? Would these records keep accumulating until manually purged?
TIA.
I am currently working on SQL Server 2014 and I want to know how can i monitor my Windows Event Log from SQL Server?
View 3 Replies View RelatedI have setup transactional replication everything on one box. later(two or three weeks later), Replication monitor is show red X Under my publishers (publications is disconnected). this is SQL2005.
Everyone known how to fix this problem?
Thanks,
Frank
Vipin writes "Hello
Can it be possible that triggers can be fired to affect tables lying in different database.
Database may be on same Machine or may be on different machine.
Explain with Example"
How do I set up an insert trigger to copy all of the inserted data to another table? In other words, when someone adds a new paramater in the params table, I want to automatically create a matching set of data in the goals table. Thanks,Krista
View 2 Replies View RelatedWhen you import data using DTS into a table that has triggers - do the triggers fire off if there are triggers for on insert or on after insert?Thanks,--Micah
View 1 Replies View RelatedHello,
I have a need to do something in a trigger, I have read all the in's and out's of when to use or not to use a trigger, so I am not looking for an answer like that.
What i am wondering is how to get the fields from a record that triggered the trigger.
for example
an on insert trigger......
Inserted record example:
Field names: key field1 field2 field 2
field data 1 Jack filed baseball
i want to do a trigger that will insert the differnt fields into differnt tables
on insert (very rough example)
insert field1 into names
insert field2 into status
insert field3 into sports
++++++++++++++
or better yet is it possiable to send var's to a stored procedure for example:
create procedure [insert data]
(@ID [int],
@field1 [nvarchar](10),
@field2 [nvarchar](10),
@field3 [nvarchar](10))
as
insert @field1 into names
insert @field2 into status
insert @field3 into sports
++++++++++++++
ON record insert have a trigger send the data for the record that was inserted to the stored procedure.
Hope this makes sence:
Tdar
I've imported data from an Excel spreadsheet to a table that has fields to match the destination table I'm trying to populate. The destination table has an Insert trigger with several checks on certain fields to make sure they have corresponding records in other tables.
If I do a statement like
"INSERT INTO destinationTable
(
ItemId,
Product,
SuperID,
etc etc
)
SELECT * FROM oldtable"
it runs for a while then gives me error messages from the trigger and rolls back the Insert.
The trigger has code such as
"IF (SELECT COUNT(*) FROM inserted WHERE ((inserted.Product Is Not Null))) != (SELECT COUNT(*) FROM tblInProduct, inserted WHERE (tblInProduct.Product = inserted.Product))
BEGIN
(Error message code goes here)
END"
So, do I need to do an INNER JOIN to each of the related files?
When I try that, I get this error:
"Msg 121, Level 15, State 1, Line 2
The select list for the INSERT statement contains more items than the insert list. The number of SELECT values must match the number of INSERT columns."
Is SQL counting the foreign key fields as separate fields, or what?
This isnt an problem as such, its more of a debate.
If a table needs a number of update triggers which do differing tasks, should these triggers be separated out or encapsulated into one all encompassing trigger. Speaking in terms of performance, it doesnt make much of an improvement doing either depending upon the tasks performed. I was wondering in terms of maintenance and best practice etc. My view is that if the triggers do totally differing tasks they should be a trigger each on their own.
www.handleysonline.com
I set up the collector, and specify the Run As as my AD account in the Collector Set - Properties - General screen. My AD account is the local admin of the remote server.
However, the collector does not seem to work. Although the collecting set is shown as running, the The blg file stays at 64K. If I open it, there is nothing inside (no counter at the bottom). What did I miss?
Hi all,I am fairly new to using triggers and was seeking some help from thosethat have experience with them. I am looking to transfer data from aSQL 2000 database to a Visual FoxPro database on another computer. Iwould like to transfer about three fields of data to a VFP table eachtime an insert is made on the SQL table. I am some what familiar withthe structure of creating the trigger but here is what I would likehelp with: Selecting the SQL data to transfer, Connecting to VFPdatabase, Insert SQL data into VFP table.CREATE TRIGGER [xyz] ON [dbo].[AAA]FOR INSERT??? Select a,b,c from SQL table??? Connect to VFP Database and Table??? Insert into VFP table Values a,b,cAny information, tips, or even an example Trigger procedure would helpand be greatly appreciated.Thank you,Brett
View 1 Replies View Related
Hey!
DDS triggers 3 - 4 times on Report Servers with 15 mints apart..any ideas?
Hi, Today, I heard about Sql Profiler, and I seems to be a tool to monitor, analyze, and fine tune sql server. Is there a tool like this for SQL Server Express 2005? thanks,John
View 1 Replies View RelatedHullo. I have a SQL SCHEDULER Job that keeps hanging.
1) How do I monitor this? I would like to have another Sql Job monitor the first one hourly, and send me an email if it is hanging. Isn't there a system table that tells me a job status?
1a) Once I find the job, how can I "Stop it" automatically?
2) Is there a way to have the Job stop itself it it runs for more than 20 minutes?
Thanks.
~Le
Hi ..
i have a task to monitor the sql jobs..
i wish to do with this with C# or asp.net application.
please help me to finish this..
Hi all,
Can anyone please tell me whether there are any ways we can check whether a connection that was opened to a SQL Server database is closed. Is there a tool we can use?.
Thx
Hakl
Would the Performance Monitor be the best tool
to use if you wanted to find out how many transactions
are being process a day?
How do I access performance monitor (system monitor).I am using Windows 2000 professional, SQL server 2000. Do I need to set up analysis service or something? I am not seeing system monitor on my box? am I missing something?
View 5 Replies View RelatedHello all,
I want to know whether any performance monitoring tools/procedure available in market for SQL Server other than Performance monitor, Profiler, Query Ananlzer of SQL Server.
thank you in advance.
regards,
Nana
Hi guys!
Please tell me where is mistake?
I have win.nt workst. 4.0 and SQL Server 6.5 Client Configuration Utility installed.
I open Performace monitor and try to add to chart sql server which already have been registered in SQL Enterprise Manager.
And I have error message: Computer name not found.
Why??????
Thank you.Sev
Until this week, I had full functionality of SQL Monitor`s capabilities to monitor SQL Server. Now, when I select our Production Server and attempt to `Add to Chart` I am unable to view/select any SQL Server... entries in the `Object` dropdown list box. When I click the down arrow with the Development server selected I DO see all of the SQL Server selections. This inability to `see` the SQL Server functions in the Performance Monitor for the Production server exists regardless of whether I attempt to view them from a Win NT 4.0 Workstation or at the Server`s console. Again, I had full functionality from both locations last week. The logins have not changed. What has changed?
ANY help would be GREATLY appreciated. I need to monitor this system and I`m running blind at the monent.
TIA
Mike Gaudet
Visages, Inc.
Hello,
I do all my monitoring locally for disk space, locks, blocking, I've 10 production servers, We need to centralised the monitoring server so from one server all the monitors can be done. Does anyone has any ideas how memory, cpus consumption, disk space, all alerts, locks, blocking, log space and job completition monitoring can be handled.
Any idea or guidance is appreciated
Thanks
Roma
Help ????????
I have a winnt and sql server 6.5 when i open up sql performace monitor it doesn't show any thing it comes blank when i go to reintialize the sqlserver object is not there i need to know how can i fix it
its urgent
girimanjesh
I'm trying to record all the queries running on a specific database to a file.
Does anybody know of free or commercial utility that can do that?
Hi,
How do most of you monitor your SQL servers (i.e. performance, cpu utilization, job failures...)? Can you recommend any tools that are not too costly?
Thanks.
Mary
I have discovered that there is an extended procedure called xp_fixeddrives, which can check how much space you have on your SQL Server's drives, it works fine. Can some one tell me what can I use to monitor the above (space used on drive) on servers that do not have SQL at all. Remember I want to call that from my SQL NOT from VB
View 1 Replies View RelatedIs there anyway that you can automate performance monitor from the cmd line. I.e feed it some parameters like server and counters and receive a log file at the end.
Cheers
Is there a way to allow a user to run activity monitor without making that user system admin
View 9 Replies View Related