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?

Have you tried...

AndrewSQLDBA (2/10/2010)

---

Hello Everyone

Is anyone snowed in like me?

I am trying to add a single day to a date data type value

DECLARE @TodaysDate Date

DECLARE @TomorrowsDate Date

SET @TodaysDate = 2010-2-14

SET @TomorrowsDate =...

MauroPichiliani (2/10/2010)

---

Well, talking seriously now I made an attempt to run SQL Server in Linux through WINE (WIndows is Not an Emulator). If you guys want check out the...