Jeff Moden (10/9/2009)

---

...

Look closely... he didn't say INDEX(1)... he said INDEX = 1 and the clustered index is always #1. Take a look at BOL...

If a clustered index exists,...

Hint: XML.

Here's the SQL 2005 version:

select [name], is_disabled from sys.triggers

Funny, I still haven't gotten anything. Odd. 🙂

No, you cannot use a stored procedure in a view.

However, what you can do is to create a table and then use INSERT..EXEC to dump the results or your stored...

Steve Jones - Editor (10/9/2009)

---

Just an FYI, since THE THREAD is so heavily visited. We've started our own ASK site at http://ask.sqlservercentral.com. Not my idea, and I'm not sure how...

You can also very easily control something like this from the DTExec command line (or SQL Agent Job Step definition), either through the command line options, or through package configurations...

Matt Wilhoite (10/7/2009)

---

Try looking at the left(), mid(), and charindex() functions in books online. You should be able to parse anything you need with those. There might be...

Oh and yes, Template Packages are also a huge help.

My experience also is that "Don't Save Sensitive.." and relying on Trusted Connections is by far the easiest way to do shared development.

Other crucial aspects facilitating successful collaborative development in...

Here's a start:

DECLARE @sql AS NVARCHAR(MAX)

SELECT @sql = VIEW_DEFINITION FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'YourViewName'

SELECT @sql = @sql + '

UNION SELECT * FROM SLS_CURRENT_MONTH'

BEGIN TRANSACTION

BEGIN TRY

DROP...

It was one of those...

RBarryYoung (10/8/2009)

---

GilaMonster (10/8/2009)

---

Testing....

Using an inequality character

SELECT session_id FROM sys.dm_exec_requests WHERE session_id > 50

Using escape codes for inequality

SELECT session_id FROM sys.dm_exec_requests WHERE session_id > 50

Using angle brackets to designate a placeholder

USE...

GilaMonster (10/8/2009)

---

Testing....

Using an inequality character

SELECT session_id FROM sys.dm_exec_requests WHERE session_id > 50

Using escape codes for inequality

SELECT session_id FROM sys.dm_exec_requests WHERE session_id > 50

Using angle brackets to designate a placeholder

USE <Database...

Lowell (10/7/2009)

---

i thought the dependancy issue was only (potentially) inaccurate...