Observant...

Trey Staker (3/31/2010)

---

@paul-2 -- Thanks

Your links on that dear thread were very helpful. That is what I had on my study agenda today, it saved me a google...

http://msdn.microsoft.com/en-us/library/ms175523.aspx does.

If each statement were indeed treated as its own transaction, then Hugo's query...

Encrypt the compressed backup you mean?

Otherwise, encyption and compression do not play nicely together...

Dear Dr. Deere,

Dear deer are dear deer, dear.

HowardW (3/31/2010)

---

I'm still kind of interested in why it would return NULL in one of those examples and blank in another. As far as I understand, they would both have...

"It depends"™

Script the structure and then use a tool like this:

http://www.red-gate.com/products/SQL_Data_Generator/index.htm

Try providing some detail?

http://www.sommarskog.se/share_data.html#tableparam

When using string functions with Unicode data, make sure it is Unicode data:

SELECT SUBSTRING(N'??????????',20,1)

Notice the N prefix to the literal string.

edit: sorry HowardW, missed your post :blush:

steveb. (3/31/2010)

---

One way to acheive this would be to create a reference table with the distinct ALPA values and the desired ranking of each value, then to order your...

Managing Unstructured Data with SQL Server 2008

Hey David,

Assuming the box is licenced per-processor, would you expect any advantage to running the separate distribution databases in separate instances?

Paul

Richard M. (3/31/2010)

---

I'd suggest creating a new post with that inquiry, so it gets proper attention. Embedding it here will probably not produce answers you need, plus it makes it...

anshu84onnet (3/31/2010)

---

thanks for getting me that point master database was selected as default at that point so not getting data now got the data thanks a lot....i need one...