Pffff. We don't get paid enough for this. 😀

GilaMonster (1/27/2012)

---

If I'm helping someone and they come back and say something about urgent, that thread automatically goes to the bottom of my things to look at.

"It's urgent" =...

Indeed 🙂

Found a...

SQL Kiwi (1/27/2012)

---

Awesome - I didn't even bother reading that one. I like the link Cadavre posted on the other...

Gianluca Sartori (1/27/2012)

---

SQL Kiwi (1/27/2012)

---

If you are referring to "please reply me of my question...

sudhirnune (1/27/2012)

---

Found Some Answer which is Explaining teh Casue but Defeting the Purpose Max Length Column in the Sys.all_columns:

The value from sys.all_columns shows to you a size in bytes, while...

In order to help you, you need to provide sufficient information.

You need to help us help you.

Please read the first link in...

SQL Kiwi (1/27/2012)

---

Koen Verbeeck (1/26/2012)

---

I also think 200 is still not correct, as you are using a variable length column, an additional 2 bytes are used, so the total should...

sudhirnune (1/27/2012)

---

Thanks Paul,

But the Query / Columns in All_Columns is meant to show the Size of the Column and not the Size,

I that case the Size is defined as 100,...

Stewart "Arturius" Campbell (1/27/2012)

---

SQL Kiwi (1/26/2012)

---

Hiding a cross join in code that is closer to the 'right' solution makes me wonder if the author was more concerned with achieving a...

Is it possible to give some sample data and desired output?

And don't mention the case sensitivity... :angry:

An overview of the SSIS security roles:

Using Integration Services Roles

Agent security roles:

SQL Server Agent Fixed Database Roles

Kargan (1/26/2012)

---

I am unable to start the Sql Server Agent, getting following error

"The request failed or the service did not respond in a timely fashion. Consult the event log or...

Double post.

Original topic with replies can be found here:

http://www.sqlservercentral.com/Forums/Topic1242597-391-1.aspx