R u planning to implement Mirroring (Like ur subject says)on ur other SQL Server?

If yes, Install SQL on ur other box, take up full backup of ur Active server A,...

Nice to know, definetly will help to keep in mind next time I have same problem.

using :

1)Linked server or

2)Openrowset

There is this SQL I found on this website that uses default trace of ur SQL 2005, it will give u some information but not much about what could have...

You might have Date that is out of range of 'Datetime data type' dates i.e. Less than January 1 1753 or greater than Dec 31 9999. If your date is...

rambilla4 (6/11/2009)

---

If I click setup.exe from the installation files, the installation wizard is coming up but not the uninstallation wizard.

I have the sql software in 2 folder;

1)Servers ->this is the...

SQL Server Management studio is just a client tool. You need to know more about SQL Server, management studio will come with it. You can start with a baisc SQL...

Do u mean SQL Server? Whats AQL Server?

.

Thanks for the update.

What kind of SQL server 2005 edition do you have? What kind of operating system do you have your SQL server installed?

I am sorry, but whats the question here?

search google on TableDiff utility, it comes with SQL 2005 installation used for table comparisons just for the kind of task u r looking for.

Gila,

Please look at this MSDN...

A normal Shrink doesnt effects log chain because u r not messing or truncating any data in log file, u r just shrinking space that was occupied by log file...