AndrewSQLDBA (6/26/2012)

---

Hello Everyone

I hope that you all are having a wonderful day.

This has been bothering me for sometime now, but I had to take the time today to try and...

You need to backup http://msdn2.microsoft.com/en-us/library/ms174387.aspx

and then restore your master key http://msdn2.microsoft.com/en-us/library/ms186336.aspx

Do you have any kind of replication setup?

that's probably sharepoint service.

DBCC Class?

tim 37654 (5/15/2012)

---

Hi Guys

Thanks for the replies.

The code that does the insert is standard Dreamweaver CS5 insert code, no SP involved:

If (CStr(UploadFormRequest("MM_insert")) = "form1") Then

If (Not MM_abortEdit) Then

...

check here:

http://www.sqlservercentral.com/Forums/Topic831649-338-1.aspx#bm831679

Did you try ALTER DATABASE yourdb SET PARTNER RESUME;

Also see statuses for principal

select * from sys.database_mirroring where mirroring_role =1

and mirrored db

select * from sys.database_mirroring where mirroring_role =2

Got me thinking so i only choose 3 and 5 missed 2...Good Question.

🙁 never added salt before.

great question 🙂 thank you

i did and i tried

alter partition scheme psMonthYearByDate next used fgData2013

after adding one i scripted out partition scheme and got this:

CREATE PARTITION SCHEME [psMonthYearByDate] AS PARTITION [pfMonthYearByDate] TO (

[fgData2010], [fgData2010],...

Thank you SQLKiwi

SQL Kiwi (11/7/2011)

---

One more time, with PATH syntax:

SELECT

aosms.iStudentid AS [StudentId],

aosms.oldClassID AS [OldClassID],

aosms.newClassID AS [NewClassID]

FROM dbo.ArrayOfStudentMoveSummary AS...

Thank you Drew.

The subquery is unnecessary. You can write this as follows:

SELECT iStudentid as StudentId, OldClassID, NewClassID

FROM @tblMoveStudentList as StudentMoveSummary

FOR XML auto,ROOT('ArrayOfStudentMoveSummary'),ELEMENTS

If you alias the table, it will use that...

Thanks GSquared for the SQL

Those static values not needed.

This is what I added

SELECT StudentMoveSummary.* FROM

(SELECT iStudentid as StudentId, OldClassID, NewClassID FROM @tblMoveStudentList) as StudentMoveSummary

FOR XML auto,ROOT('ArrayOfStudentMoveSummary'),ELEMENTS

OUTPUT:

<ArrayOfStudentMoveSummary>

<StudentMoveSummary>

...