These wouldn't work in your context:

[' + @SN + '].msdb.dbo.sysjobhistory h

Anything inside brackets it takes as a literal name. Here, it thinks the server you're trying to access...

Lowell (3/11/2015)

---

Khades i tried with a user defined function as the default as wlel, doesn't work;

i think you're stuck with adding an trigger for insert in order to get your...

The problem with this is that every...

Can xs:complexType have xs:Sequence as a child?

I'm Doing something like this:

CREATE TABLE #Child_table(

id int,

parent_id int,

Attribute1 VARCHAR(10),

Attribute2 VARCHAR(10),

column1 VARCHAR(10),

column2 VARCHAR(10),

column3 VARCHAR(10),

column4 VARCHAR(10),

column5 VARCHAR(10))

CREATE TABLE #Parent_table(

id int,

Attribute1 VARCHAR(10),

column1 VARCHAR(10),

column2 VARCHAR(10),

column3 VARCHAR(10),

column4 VARCHAR(10),

column5 VARCHAR(10),

column6 VARCHAR(10),

column7 VARCHAR(10))

DECLARE @X XML, @Y...

wolfkillj (10/24/2013)

---

Khades (10/24/2013)

---

Koen Verbeeck (10/22/2013)

---

Unicode can handle a lot of characters. I don't know at the top of my head which characters are not supported.

If you know which characters you...

Koen Verbeeck (10/22/2013)

---

Unicode can handle a lot of characters. I don't know at the top of my head which characters are not supported.

If you know which characters you don't want,...

Aren't there other characters that UTF-8 encoding won't allow though? Such as the copyright symbol?

Oh ok. I do usually use SQL Server Configurations. I've seen it done 2 different ways.

One way is to make sure the configuration file is in the same path in...

It sounds like the location of your package is not changing whether you want to run it for prod or test, is this true?

What we usually do is have 1...

2008 R2

Page cannot be displayed :(.

I have a question, so if daylight savings were to change again in the future, I would have to go update this table correct?

Thank you once again. I appreciate your help.

What does the dbo.Tally table hold? I notice we keep querying the N column.

The character that was giving me problems is â (0xE2)

Looks like this might be in the wrong section, how do I move it to the XML secion?