Have you started looking at CREATE ENDPOINT?

Are the two instances running under a domain account?

Sounds like concatenation with a null value. Check out the code I posted and see if it works.

Did a little reformatting of your code, if you want give it a try.

Lookup CONVERT in Books Online. That is the best place to start to answer your question.

Try declaring a local variable inside your sproc to use in building the BreadCrumb, then at the end assign that local variable to the output parameter.

Just shooting in the dark...

Also, quick question, are the SQL Server instances running under a domain account?

george sibbald (2/10/2010)

---

right click on the primary database, select properties, select database mirroring, follow the steps through the wizard.

A witness is not a requirement, up to you whether you require...

Look at how I have setup the exec of the stored procedure. You need to do something very similiar to return the value of the output parameter to your...

winslet (2/10/2010)

---

You have to follow sequence in configuring the SQL Server Database Mirroring.

Full backup,

Trans backup,

Restore full backup on secondary with NORECOVERY,

Rectore Trans log backup on secondary with NORECOVERY,

Enable Trace flag...

And yes, I am currently in the process of setting up database mirroring myself. There is actually quite a bit to do to get it up and running.

You should...

Have you created the database mirroring endpoints on the two servers?

Are you using NT Authentication or Certificates for the connection between the two servers?

Have you granted CONNECT permissions as needed...

EDIT: Also, change the first two parameters as needed to match your data.

Try the following from SSMS.

declare @ BCrumb varchar(2000); -- Had to add a space between the @...

Again, based on the sample data, please show us what the expected results of the query would be. This will help us help you.

This procedure is located in the msdb database. If your connection is to another database, you would execute like...

Help us help you, based on the sample data in the original post what is the expected results?