Thanks..

ANother doubt, does the ldf file contain just the logs of the transactions from the source database? Asking because the ldf file is about 10GB.. Is it possible to...

Thanks Gordon.

Do I need to detach the database before I restore the files using sp_attach_db procedure? I tried to run sp_detach_db, I get 'cannot detach the database because...

Hi Brian,

I'm executing it on the same database, not sure why its failing.. Do I need to login as sa user for this?

Thanks so much

Yes.. database is set to autocreate statistics to true and auto update statistics to true..

Thanks

IS there no way to see the sql statements or what the session did? (if I did not have sql trace on?)

Thanks

Thanks Matt!

Please can someone help me...

declare @ACI varchar(5)

create table #tmp (Res nvarchar(5))

insert into #tmp

exec ('SELECT ACI FROM...

Actually we have the cast function in sql server now, I'm converting this into Oracle so I need to know the equivalent for it.. Thanks

Thanks, Is this function in sql server

cast(convert(nvarchar(20), getdate(), 101) as datetime)

equivalent to trunc(sysdate) in Oracle?

Thanks again

Sorry, just trying to understand how this code works..

This is set in the declare section of the procedure..

@SYSDATETRUN = cast(convert(nvarchar(20), getdate(), 101) as datetime)

Is the above statement the...

Thank you so much. It was more than helpful.

I've another sql query that I need help within the procedure..

...

declare @ACI varchar(5)

create table #tmp (Res nvarchar(5))

...

I tried this, but not sure if it is right.. it returns 267 rows though..

SELECT Q.*, p.pmtco, p.pmtno, p.pmtbk, p.pmtrcn, p.pmtamt

FROM qtral Q left outer join pymt p on Q.chpmtno...

Yes, right Paul. That 1 record is in qtral but not in pymt table.

But, I need to join so even if the record is in qtral but not...

Hi friends,

When I run this query I get 267 records:

SELECT Q.*

FROM qtral Q

WHERE exists (SELECT 1

FROM qtral Qx

where Qx.tral_no = Q.tral_no

and Qx.tral_pd = Q.tral_pd

group by Qx.tral_no,...

Thanks for your reply... But our team wants to go with connectionstrings and i'm not able to get it work.. Apparently they say I can just use the connectionstring in...