Its supported path

http://msdn.microsoft.com/en-us/library/ms143393(SQL.100).aspx

Few things to check

SQLMail

------

1. What is the sql service start up account? (It has to be domain account)

2. Outlook Profile should be set using same account which is sql service...

what is the output of below query?

sp_configure 'max server memory'

go

sp_configure 'Min server memory'

go

contact me at bmlakhani@yahoo.com if you still need help

whatever goes to transaction log gets mirrored. In short, yes schema changes does get mirrored.

.

Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while...

http://blogs.msdn.com/blakhani/

I have written 3 parts blog for same topic.

for those who don't want to write query, go to management studio, right click on Server, Go to Reports > Standard Reports > "Schema Change History"

This report picks data from...

The problem is your Tools are on RTM (1399) and Server is at higher build (3050)

You need to first download and apply SP2 then build 3050.

contact me at bmlakhani@yahoo.com...

I think I am late in party 🙂

I would never recommend to stop recovery process. No one can stop you doing suicide but thats crime 😎

Jokes apart, You could stop...

i tried below query having length of more than 200 characters.

C:\Windows\system32>sqlcmd -Q"select 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa

aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa

aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa11

111111111111111111111111111111111111111111111111111111'"

--------------------------------------------------------------------------------

--------------------------------------------------------------------------------

--------------------------------------------------------------------------------

----------------

aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa

aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa

aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa1111111111111111111111111111111111111111

1111111111111111

(1 rows affected)

Did i miss somthing??

can you post acutal query and error message please.

Default trace would help you in such cases if you are on SQL 2005. very few knows the power of it.

i think you are taking about renaming machine name.

You can do that but then you have to run below on both instances

1. sp_dropserver '

2. sp_addserver ' , 'local'

for example...

Would you be kind enough to post error logs from the server during problem time?

How many databases are mirrored?

did you confirm that last patch was applied properly. Can you share the setuplogs with me.

attach them here or send it to me at bmlakhani@yahoo.com