There is a view that you can query

select * from sys.database_mirroring

you can read more about the mirroring catalog views on

http://msdn.microsoft.com/en-us/library/ms178655(SQL.90).aspx

Have a look at SQL prompt from Redgate, this should have what you are looking for

We use Virtual Box from SUN

http://www.virtualbox.org/

I perfer it to VMware, as it is free and can run on a lot of different operating systems, this suits us...

Have you looked at the possibility of removing the HDD and extracting the information from there? or is it completly fried ?

Though that may be the max allowed limit in SQL server the pratical limit would be a whole lot lower, I don't think i have ever seen a table...

yes pretty much, not sure...

sp_SetValue

is not recommended as it may take longer to process as SQL server will think that it could be a system stored procedure.

also you can not guarantee that future versions...

susan.susan28 (7/15/2009)

---

I dont have much experience with standard edtion.Yes i need sysnchronous without witness but when the principal is down how the mirror side we can make as principal and...

You can do this in SSIS easily,

what is the common column between the tables that you can join on?

I dont think you were expecting too much, everyone should have least got the first one, and I have seen very similar repsonses when interviewing people. It seems that...

What do you mean by 'Lock the table' ?

I do not use prefixes for object names for the reasons stated above, also I use SQL prompt and I find that the use of prefixes does...

You may find it easier to use some T-SQL to perform this task as i am sure it is not possible using Reporting services, also there are a number...

Also be aware that peer to peer transactional replication is available only in SQL Server 2005 Enterprise Edition (it may work on 2008 i am not sure)

So...

If the databse if 175gig , how much free space do you have available? as this will determine how much the db can shrink..

you can use

SP_spaceused

to check unallocated...