Hi, i know how to connect to the profiler and after that i am seeing the datbaseses details and i am also getting the queries which are running, but how...

Hi,

With this querry u can get the second position

DECLARE @String VARCHAR(100)

SET @String='Test_sample_proc'

Select (charindex('_',@String,CharIndex('_',@String,0)+1))

but if u want the result like Test_sample then use this,

DECLARE @String VARCHAR(100)

SET @String='Test_sample_proc'

Select substring(@String,0,(charindex('_',@String,CharIndex('_',@String,0)+1)))

Hope it helps u......

Thanks Matt,

i have used joins may times but only to select not for update.

Will it work with insert and delete also.

Hi,

If u want to get the count of date only the use this

SELECT COUNT(1) FROM XYZ WHERE CONVERT(VARCHAR(10),DATETIME,101)='2002-05-15'

I think this will work.

Thanks

Sanaullah.

Ok Thanks and we are doing the same thing here.

Actually the Admin ie is client has the insert priviliges and his userdetails has been hacked.

Yes, we are using some stored procedure but not insert procedures we use only SELECT procedures to get the details to display, its all about currency of different countries.