Hi,

Even I am not able to attach the database to the sql server, although i deleted the LDF file from the specified location.

If some body specifies the backup file of...

Basically, i want to get the rows from remote server to local database and update the local stored procedures in remote database.

For that reason i have to create a linked...

Thank you for Quick turn around..

After your reply i checked with all the data. JCACTIME column contain some invaild records due to this i am facing issue.

I am gr8full to...

Thank you for quick turn around.

The trick worked fine for me. My problem got resolved with your solution.

Thank you,

Venu Yelchri

I have to talk to our Project Manager to reinstall the SSIS services as it is working in some cases (if we do it by connecting to that server).

I will...

Thank you for quick turn around. SSIS was installed in the same machine, looks like it has been not working properly. I tested the importing/exporting data in another server where...

Is it possible to uninstall only SSIS?

We are using Service Pack 2

Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86) Feb 9 2007 22:47:07 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition...

Thank you very much for the information.

Thank you very much for your quick turn around...

In the same way can we know which user has accessed last time along with date and time?

Thank you very much it worked fine.

Creating mail profile is nothing but creating outlook profile. and add that out look profile to SQL Mail.

Looks like some mistakes happened while creating outlook profile.

Follow the above steps...

If you want to sent emails from SQL Mail in SQL Server 2000, the windows SQL Server login account and exchange server should be in one domain. then only u...

Thank you very much

i got the solution to get machine name. i used host_name() function to get system name and added one more column to the ChangeLog table with default...

Thank you very much

i am able to trace the all the modifications which are done to the database objects.

is it possible to get from which system these objects are being...