steve dassin (4/10/2009)

---

Jeff Moden (4/10/2009)

---

Yep......

steve dassin (4/10/2009)

---

Lynn Pettis (4/10/2009)

---

Steve,

You just don't get it, do you? You really need to drop the cutesy talk and try being more professional in your communications. I...

Steve,

You just don't get it, do you? You really need to drop the cutesy talk and try being more professional in your communications. I really enjoy "playing" with...

steve dassin (4/10/2009)

---

Lynn Pettis (4/10/2009)

---

steve dassin (4/10/2009)

---

Jeff Moden (4/10/2009)

---

steve dassin (4/10/2009)

---

Just a note to say I'll be addressing some interesting responses from the discontinued thread:

T-Sql rant

http://www.sqlservercentral.com/Forums/Topic675554-8-1.aspx

Some of the responses were...

Jeff Moden (4/10/2009)

---

Lynn Pettis (4/9/2009)

---

Any help on that thread would be welcome. Based on further information from the OP, I'm thinking something written using SMO may be a better...

steve dassin (4/10/2009)

---

Jeff Moden (4/10/2009)

---

steve dassin (4/10/2009)

---

Just a note to say I'll be addressing some interesting responses from the discontinued thread:

T-Sql rant

http://www.sqlservercentral.com/Forums/Topic675554-8-1.aspx

Some of the responses were thoughtful and interesting, especially...

Not to...

RK (4/9/2009)

---

Lynn,

Our infrastructure guy said that there is not difference in the disk configurations between both the servers.

However I found other differences:

Server that freezes (32 bit)

AWE enabled

SQL Log on...

Can't help you unless we see the code, so please post it.

So, do I get create for an assist at least? 😉

You need to move the double quotes:

EXEC xp_cmdshell '"C:\Program Files\try.exe c:\ky\ky1.txt"';

Microsoft SQL Server does not have BEFORE TRIGGERS. You can emulate them using INSTEAD OF TRIGGERS. Check Books Online (BOL) for more information.

asimkumar.munshi (4/9/2009)

---

The first method does not work for me...so...what if i have multiple selects in the inner query...I am selecting like 20 columns in the select...

The second method is not...

Well GSquared, you beat me, but one thing. Need to add an alias in the derived table for the column as well:

select count(*)

from

(

SELECT distinct year(cumdate) as YearDt from dbo.EX1_FACT_SO

where...

Can this database be restored by the users, or dropped and recreated by the users?