Hi, Can anyone tell me how to locate the last access for the object (eg: Table, Store Procedure, Function, etc). rgds/sm
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...
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 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.
