Thanks... it worked..

I tried.. but don't see any command to save DTS as .vbs.... there is a way to save it as .dts but not as .vbs.... at least i am not...

I think i posted my query in wrong topic. I have SQL Server 2000 and not SQL Server 2005.

Is there any way to automate this like opening each job and saving it to VBS to check which connection is used?

Thanks for your reply.

Basically problem we have is, we are not sure who all have created all these DTS jobs. Some of the creators might have left the organization...

I thought some more information regarding the application would help you all guys. It is a status flow based .NET Web Application. We are using Grid View to display the...

All,

Thanks for your valuable inputs. I Asked DBA's to change compatability level to 90 but he did not agree as he is not sure if that would cause any other...

I tried with RAW this also fails...

SELECT * FROM customer FOR XML RAW, ELEMENTS,

root('customers')

Steve and Colin,

Thanks for your reply.

I am leaving in remote area of Pennsylvania where it is difficult to find out one DBA. People are coming and they don’t like...

what about other parameters?

how to get parameters for

''LDAP://SERVERNAME/ DC=domainpart1,DC=domainpart2,DC=local'' WHERE objectClass= ''user''

i m having problem here now.

Thanks,

Ramesh.

Folks,

can you give some examples or some details about this? basically i am new to all this and doesn't have much idea about SMTP or anything as such.

Thanks,

Ramesh.

I would say if at possible try to avoid cursors. Think if you can change query so that it can be direct SQL instead of cursor

thanks,

Ramesh.

I think DBCC UpdateUSage would update table statistics. sp_spaceused does not look into

actual table but looks into system tables to get count which are updated once we update

statistics....

Hi Joseph,

I did not understand exactly what are you asking me to do. Can you explain in detail please? I am sorry.. i am little dumb here.

Thanks,

Ramesh.