Hi, Can you provide the SQL syntax in order to locate the last access for the object (eg: Table, Store Procedure, Function, etc). rgds/sm
Hi, Can anyone tell me how to locate the last access for the object (eg: Table, Store Procedure, Function, etc). rgds/sm
Hi, If I use this script as below, i found no record return in fact i have this PONo exist in many store proc, view, table and funtions?...
Hi, The below script only display all the table, store proc, trigger and function name out, however I want to filter record only when PO_NO exists...
Hi I have the below script schedule auto run by server to return the SPID when there is a blocking process, please advice how to build the SQL Script...
Hi, For example I have 10 SPID return blocking in the database, with this 10 SPID how could I get the respective SQL Script running which causing the...
Hi, I want to retrieve a string PONo (example) which have been occurred in which table, store procedure, function, trigger and etc in the current...
Hi, If we use RichEdit component to insert picture and text into varchar(max) field, the performance is very slow, any advise how to keep it ? Please...
Hi, My questions:- 1) January 1 2010 will fall on which week of the Year? week 53 or week 1? 2) Which day in a week will be the first day start?...
Hi, Can I check how to identify the 1st lock process when there is more than 50 process in the Activity Monitor locking, it is very time consume to...
I had tried to build the function in SQL and the output is ???????, cannot display the wording in Chinese. Is anyone have build the sample coding in...
Dear all,How to convert invoice total into a Chinese wording. Example: USD 176.00 --> 美元壹佰柒拾陸 USD 176.00 --> 人民å¸å£¹ä½°æŸ’拾陸...
Hi, I have create a ADO middleware Server which running in the same machine with SQL server install. This ADO middleware is running as Windows...
Hi, Just to check what is the SQL script to get the DataBase Size andIndividual Table Size ? I need above script to keep a...
Hi,I have follow your way and it is working successfully, thank you very much.
Hi, I have written a stored procedure (PROC A) to generate a batch of records base on the select statement condition, and the records generated will...
Dear all, Initially self have try to connect to one of the program, after key in login name and password then press <OK> button, the program return...
1) Can anybody know what is the different of using Money and Decimal(17,2) data type in BDS 2006? 2) Which one is better to use? and why? 3) In...
Separate names with a comma.
