you need to grant the account that you use for mirroring access to the mirroring end point on the mirrored database.

http://msdn.microsoft.com/en-us/library/ms190456.aspx

What do you mean by purged?

transaction logs are truncated and space is marked for re-use after a transactional log backup,

try..

SELECT DATENAME(mm,'2009-01-23 1:12:52.253') + '-' + datename(yy,'2009-01-23 1:12:52.253')

This can be done with t-sql set up a linked server and use some insert statements to copy the data.

Or you could use SSIS to create a script to...

check the error log on the server you are trying to connect to, this will have a more detailed message and will give you the reason the login failed.

You will need to write custom script to access the active directory, this site has something similar to what you are doing..

http://www.mssqltips.com/tip.asp?tip=1657

In replication you can chose what objects that you need to be replicated, peer to peer replication (merge replication) is useful when you want to balance the load between...

If the problem is happening at regular intervals during the day, there may be a job that is scheduled to run that is locking up the tables, check your...

a data conversion transformation should be able to convert the date, you may need to convert to a string first if it does not work converting from an integer

Use the SQL server configuration manager on the server to update the account and password that the agent runs under.

The best advice would be to setup a domain account to...

You shouldn't have to change the create to an insert.

If you want to insert further data into the table then delete the part of the package that deletes and creates...

Utsab Chattopadhyay (3/17/2009)

---

Thanks. But we do not have option to intall new application on our box.

So I need to take an approach which will use native technology only and...

It is possible to set this up to run each day, further inserst will be added to your tabel.

For updates you will need to write an update T-SQL...

Use the import / export wizard as this will build the entire package for you. you will be then be able to view and edit this package to see...

Try using UNION or UNION ALL to join the results of your two queries..