.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
ASPEvil
david stephan
Santhakumar Munuswamy
Fauzul Azmi
Post New Web Links

How to identify which process updated a table {not resolved}

Posted By:      Posted Date: October 01, 2010    Points: 0   Category :Sql Server
 

I have a table in SQL Server 2005 database.

This table gets updated daily by an unknown process which I'm trying to find out.

 

I've tried every possible way I know, like:

1. "View Dependencies" by right clicking on the table.

2. SELECT * FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_DEFINITION LIKE '%INSERT%<TABLE_NAME>%'

3. SELECT OBJECT_NAME(ID),* FROM sys.syscomments WHERE TEXT LIKE '%<TABLE_NAME>%'

4. None of my stored-procedure is encrypted, I've check this by issuing the following stmt:
SELECT * FROM sys.syscomments WHERE encrypted=1


Other things I think would be DTS/SSIS packages, BCP or BULK UPLOAD. I've check out the DTS/SSIS projects sources, but all in vain.

Help appreciated.

Thanks,
Manu

Manoj Pandey


View Complete Post


More Related Resource Links

Cube Refreshment with Data updated in Table

  
HI All, I have cube which is MOLAP,and i have created SSIS package to process the cube,now i want to start the job as soon as data got uploaded into the Relational database. Please guide me in this as i am new to ssas. Regards Shraddha

How to identify new row in repeating table and repeating section of browser enable infopath form

  
Hello All,   I have Exp form that contain repeating table as well as repeating section. When i click insert new item it inset new row but i didn't got identification of that row. Is there is way to get identification of each row in repeating table as well as section.  Please help on this.  Thank you.

Analysis Service Process Dimension Cause : OLE DB error: OLE DB or ODBC error: ORA-00942: table or v

  
Dear Gurus, I'd face a "STRANGE" problem. I'm using SQL2008 connect to Oracle Data Source (OracleOldDB.1) When I process a snow-flake dimension . There is a ORA-00942 problem. But if I past the SQL Statement to a Oracle Tool . It worked without any problem. Does any body ever face this "STRANGE" problem ? And I'd try to remove this table from data-source-view and re-join it . Still same problem !!  Wilson

BATCH PROCESS FOR SQL TABLE!! ANY HELP!!!!!!

  

I have a table in my database and I need to create a BATCH Process to populate the table daily at a  given time.

The table should be emptied and repopulated each time the BATCH Process runs. I am pulling the data into the table from a VIEW?????? ANY HElp

I HAVE NO IDEA....

 


BATCH PROCESS FOR SQL TABLE!! ANY HELP!!!!!!

  

I have a table in my database and I need to create a BATCH Process to populate the table daily at a  given time.

The table should be emptied and repopulated each time the BATCH Process runs. I am pulling the data into the table from a VIEW?????? ANY HElp

I HAVE NO IDEA....


Variable value within SQL Server table Configuration is not being updated within load of DTSX packag

  

Hi,

I am probably missing something obvious here; -
I have created a package with a variable named; - ServerName and a value of 'KIERAN-PC'
I exported this variable as an SSIS configuration within a SQL Server table

I noticed the following record appeared within the SQL Server configuration table.

 

how to find who had recently updated/delete the table

  

Hi,

  i need to find who had updated or deleted the table in sql server 2000 ,please tell me the way to find it.


SQL Trigger INSERT, UPDATE table name (inserted updated)

  
I am trying to make a trigger for INSERT, UPDATE.  For INSERT you get a table named inserted that you can use, and for UPDATE you get updated.  But what is the name if you doing a trigger for both?

Please on how to check updated records in a master table.

  

I have two tables. One is holding records temporarily while the other is master table. I am trying come up with a sql that will be picking a record at a time from temporal table then check is if the record has been update dated in the master table. If it has been updated it does nothing else it updates. Now I am having challenges. The table fields are as follows: Please help

 

Master table

Id   Firstname  Surname  Location  Amount   status  Position

 

 

 

Temporla  Table

Id   Firstname  Surname  Location  Amount   status  Position


Showing Table when a text box value is updated.

  

Hi Friends,

I have three text boxes.The value of first text box should be less than the value of second text box.If the condition is passed then the third text box calculates the % of second text box with the first TB and shows up a table.

I want to show up a table when a textbox value is updated( greater than '0').Can any one please suggest me some java script code for this.

Thanks


The merge process could not retrieve column information for table 'dbo.xxxx'. Verify that you have

  

Hi, we have a merge pull replication in SQL Server 2008 R2 (publisher) and SQL Express 2008 (subscribers)

The publication contains almost 200 articles.

We are having trouble in only one article.

When we update / insert a row in that table, all the subscribers fail to sync with the following error:

The merge process could not retrieve column information for table 'dbo.Tipo_Movimiento_Caja'. Verify that you have sufficient privileges on the database and retry the operation. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147201016)

Cannot synchronize the subscription because the schemas of the article at the Publisher and the Subscriber do not match. It is likely that pending schema changes have not yet been propagated to the Subscriber. Run the Merge Agent again to propagate the changes and synchronize the data. (Source: MSSQLServer, Error number: 25007)

The script of that article is really simple, and it has no join filters:

exec sp_addmergearticle @publication = N'IPoint_Pub', @article = N'Tipo_Movimiento_Caja', @source_owner = N'dbo', @source_object = N'Tipo_Movimi

Export Visio Database Table Names to Excel

  
If you use the Enterprise Architect edition of Microsoft Visio for data modeling regularly, then there is a good chance that at some point you've wanted to export just the table names into Excel. You might want to do this to map logical ERD entities to physical data model tables, track project status by entity, or track overlap between database versions.

Insert value using Table Value Functions

  
a real gem in Sql Server 2008. mostly people still using Stored procedure may be they shifted to SQL Server but they are not using TVF right now.

Using jQuery to Filter Table Rows

  
The project is using the .net GridView control, so I had limited control over the output HTML code. Still, I think this code can work for most tables. One thing to notice: you should use the class "filterable" on your table or on one of its parents for the code to work.
First, we need a text box:

RadioButton Groups, Table Rows And NamingContainers in asp.net

  
The RadioButtonList. Very handy for inviting users to select just one item from a list although because of the screen real estate it takes up, used less and less in favour of the DropDownList. In plain HTML, the browser knows to enforce the unique selected value amongst a list of radio buttons because they all have the same value for their name attributes.

RadioButton Groups, Table Rows And NamingContainers

  
(In which AJAX-enhanced CheckBoxes become more useful than RadioButtons but inheritance saves the day, and a simple RadioButton-derived control establishes the purpose of a control's naming container)

The RadioButtonList. Very handy for inviting users to select just one item from a list although because of the screen real estate it takes up, used less and less in favour of the DropDownList. In plain HTML, the browser knows to enforce the unique selected value amongst a list of radio buttons because they all have the same value for their name attributes.

ASP.NET Architecture - ASP.NET Worker Process - HTTP Pipleline - Http Modules and Handlers

  
"ASP.NET is a powerful platform for building Web applications, that provides a tremendous amount of flexibility and power for building just about any kind of Web application. Most people are familiar only with the high level frameworks like WebForms and WebServices which sit at the very top level of the ASP.NET hierarchy. In this article I'll describe the lower level aspects of ASP.NET and explain how requests move from Web Server to the ASP.NET runtime and then through the ASP.NET Http Pipeline to process requests.
ConfigurationFilter ConfiguredValue PackagePath ConfiguredValueType
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend