On CBS.com: Don’t go to a psychic
2 Resources for

columns_updated function

  • Subscribe to this listing via:
  • RSS
  • Email

TechRepublic Resources

Audit data using SQL Server 2005's COLUMNS_UPDATED function
Auditing data changes in your production environment is very important, especially if you are dealing with confidential information. Besides tracking the data that has been modified, it is also useful to track the individual field names that have been modified. This information is great for your auditing department, and it...
Tags: Function, Audit, Microsoft SQL Server, Auditing, Trigger, Microsoft SQL Server 2005, COLUMNS_UPDATED, COLUMNS_UPDATED Function, System Function, Tim, Databases, Enterprise Software, Software, Data Management, Tim Chapman
Blog posts 2008-05-13
Audit data using SQL Server 2005's COLUMNS_UPDATED function
DBA Tim Chapman looks at how the SQL Server 2005 COLUMNS_UPDATED function works and then discusses how to parse out the field names. Auditing data changes in your production environment is very important, especially if you are dealing with confidential information. Besides tracking the data that has...
Tags: Microsoft SQL Server, Microsoft SQL Server 2005, Tim Chapman, COLUMNS_UPDATED, Databases, Enterprise software, sys.fn_IsBitSetInBitmask, trigger, update statement, audit, SQL Server Newsletter, Function, Auditing, Microsoft SQL Server 2000, Listing B, COLUMNS_UPDATED Function, System Function, Listing C, Software, Data Management
Technical articles 2007-04-16

Additional Resources

Audit data using SQL Server 2005's COLUMNS_UPDATED function
QuestionIs there a way to tell when the last time a DB has been accessed by using a query, sp, etc? I do not want to browse the log files of over 82 databases. Thanks in advance
Tags: Databases, ITPains, Microsoft SQL Server 2005, audit, Microsoft SQL Server
Discussion threads 2007-04-17
Subclassing ActiveX (zip)
The control element accomplishes a subclassing for a window stated by its handle. The window function is the function of a window, which completely determines the behavior of the window and thus the reaction of the window to user inputs. This window function is replaced by another function by the...
Tags: Window, ActiveX, Control Element, Window Function, Construction
Software downloads 2008-02-13
Windows API Hooking SDK (zip)
Windows API Hooking SDK helps you hooking Windows APIs or functions in other DLLs, and replace the API function or DLLs' function to your own function, that is to say, intercepts Win32 functions and re-writing target function to easily custom and extend existing system or application's function, whether in an...
Tags: Function, API, SDK, Microsoft Windows, Operating Systems, Software
Software downloads 2005-05-18
Excel Function Dictionary (zip)
The Excel Function Dictionary is a file of over 150 very helpful examples of Excel function usage. The Excel Function Dictionary is created by Peter Noneley. The file is free and has been going since 1998.
Tags: Excel Function Dictionary, Microsoft Excel, Microsoft Office, Office Suites, Software
Software downloads 2006-12-14
Function Grapher (zip)
Function Grapher is an easy-to-use software for 2D, 2.5D and 3D function graphing, animation and table data visualization. 2D and 2.5D function graphs can be plotted in Cartesian and polar coordinate systems,and 3D function graphs can be plotted in Cartesian,cylindrical and spherical coordinate systems.Version 3.3 adds axis scaling.
Tags: 2D, GraphNow Software, Function Grapher
Software downloads 2007-11-23
User Defined Function (UDF) on a network
I have created a UDF and an Excel Add-in which contains this function. I want to call this function on a spreadsheet that can be viewed by anyone in my group on our network. The problem is that even if others have the add-in installed, Excel changes the...
Tags: Microsoft Office, PRODUCTIVITY, network, arizenn, Microsoft Excel, add-in
Discussion threads 2007-06-08
Key combination
Hello. I have a Dell Latitude C800. Can anyone tell me if there is a key combination to turn off the screen?Thank youScreen disable key combinationEvery laptop/notebook should have this function. I,m not familiar with the key pattern on a Latitude but it will probably include one of the function...
Tags: Notebooks, gbnine@..., function key
Discussion threads 2007-06-22
Variables in Reporting Services
I am calling the AddTime function successfully in the detail section a table on my MS Reporting Services report. When I try to access this value using the GetMyTime function from the footer section of that same table, it comes back empty. Any ideas?Thanks, Chris-------------------Begin Code:-------------------Public lTimeTot as LongPublic Function...
Tags: Reporting Services, Code
Q&A 2005-11-14
Finance Calculator (zip)
This calculator helps you to understand and calculate various financial parameters based on an in-built self-explanatory tutorial. Some of the financial functions are: the N function is used to find the term or Number of periods usually Months that it takes to pay off a loan. The function I/Y is...
Tags: Function, Financial, Loan, PV Function, PMT Function, FV Function, Financial Accounting, Manufacturing, Finance
Software downloads 2005-07-19
How do I enable S.M.A.R.T. function in Hard Disk?
I want to enable S.M.A.R.T. function in my hard disk. My hard disk supports S.M.A.R.T. function but in the boot screen it shows S.M.A.R.T.- Disabled. Can anyone give me some help and tell me how to enable S.M.A.R.T. function in my hard drive.
Tags: enabling s.m.a.r.t. function in hard disk, hard drive, off-topic, S.M.A.R.T., S.M.A.R.T. function, sulabh08@...
Discussion threads 2006-10-06
JavaScript: Document Object Model
I have recently converted my Client-end scripts to 'JavaScript' from the original 'VBScript'. I did this as Netscape & other browsers except IE would not support VBScript. Yet the problem is not solved. I have written a validation function in tag. I address the form controls by the DOM...
Tags: XML, Scripting languages, Web browsers
Q&A 2004-12-21
A Clever Demonstration of the SAS SUBSTR Function
The SAS SUBSTR function differs from the substring function in other programming languages as it can be used on either side of the assignment operator. This paper demonstrates its practical usage by building programs to separate and manipulate text. Specific topics include: Proper Syntax Use; Comparison with the COLON MODIFIER;...
Tags: SAS Institute, SAS SUBSTR Function
White papers 2005-03-09
MS Excel Concatenate function
I have an user who needs a very specific result from his Excel spreadsheet when he uses the Concatenate function. He wants each separate piece of data to line up in the column with the Concatenate function. Some of the cells used for the information need to show the first...
Tags: Microsoft Office, Microsoft Corp., kwales52000@..., Microsoft Excel
Discussion threads 2007-07-19
Can a PDF document call a function from an external dll?
Hello, everyone. I have a requirement to call an external function from a library dll, from within the pdf file. Can some of the software masters out there help me with this subject? I am greatly appreciate for your help. If you know another way of...
Tags: tienchau2000@..., Adobe PDF
Discussion threads 2007-03-05
Access Ontimer function
I have a database that uses the Ontimer function to generate a real time clock onscreen. I have found that for some reason, if for instance, Iopen up another form then cose it, the front end form stops monitoring the Ontimer function and my clock stops running up. Anyone know...
Tags: Ontimer function, OnTimer, tonymcveigh@..., software, Access Ontimer, Microsoft Access
Q&A 2006-07-04
Keyboard Function
Please help me... i want to know how to enable the disabled function of ctrl+alt+del... and other special function of computer keyboard...Check with your AdminIf these functions are disabled, it is most likely that your system admin has set a group policy or other restriction to limit what users can...
Tags: hardware, keyboard, nicy031086@..., windows
Discussion threads 2007-01-14
Sicyon Lite (exe)
Sicyon is all-in-one freeware tool for every scientist. The core of Sicyon is an VBScript/JScript scripter and the principal features are: estimate a function using variables and user-defined functions; matrix operations; plot/tabulate a function; find real roots, minimums, maximums and definite integral of a function; fit a function over data...
Tags: Function, Freeware, Sicyon, Productivity, Scripting Languages, Software/Web Development, Web Development
Software downloads 2006-02-09
In Excel,
Can you tell me please which function I should use to find the cost price per unit?Thank you.Not aware of a function for thatwouldn't that be "TotalCost" / "Number of Units"? Or am I missing something?
Tags: zimonar@..., windows, window xp, Microsoft Excel
Discussion threads 2007-03-01
  • << Previous
  • page 1 of 1
  • Next >>

Content Types

Blog posts (1 results)
Technical articles (1 results)


Network Administration in Windows Server 2003
While the role of a Windows network administrator would never be considered easy, you can lighten your load by knowing the ins and outs of Microsoft's ...
Buy Now
Microsoft Excel - Advanced Functionality
This Microsoft Excel - Advanced Functionality presentation is a preformatted solution for training staff to maximize Microsoft Excel's more advanced f ...
Buy Now