Hi all,

Yes, i did that!!

and have also added one more join but still it was taking bit longer

so stored the 1st 3 joins result into a temp table and...

Thanks for the replies 🙂

the problem was with the on clause

"on b.PO71 = c.LinkfileLineSeq"

PO71 was varchar while LinkfileLineSeq was decimal!!

the query did started running..but it is taking ages!!

Seems like...

Thanks for the reply. Checked the link, really helpful.

Thanks once again!

hi again,

Though am able to convert tsv to table now..but was wondering why did it truncated the columns when i converted tsv- to excel -to table?

Total number of...

Hi,

Thanks for the replies. 🙂

tried both and it worked!!:Wow:

Thanks a tonne !!

-Shree

hello everyone, i found the answer!!!

Just in case if anyone gets stuck with the same query

i converted the smalldatetime column in the same way the variable was converted!

cast(CONVERT(CHAR,DATEADD(d, -1,DATEADD(mm, DATEDIFF(m,...

Check this link

http://www.sqlservercentral.com/articles/Monitoring/monitoringdriveanddatabasefreespace/1415/

Thanks a lott for the replies..:)

To monitor databases size, am using " sp_helpdb" - this gives size allocated to all the databases on a server but not the available space!

i tried using " EXEC sp_msforeachdb...

I forgot that we can use " DBCC SQLPERF(logspace)" to get the details for the log files!!

Thanks once again David!

- Shree 🙂

Hey Thanks David!!

Just tried the script you gave..it works great!..however it returns only the data files for all the databases..

Can we do something to get the log files as well..??

Thanks

Shree...