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?

Single Proc? Dual Proc? Quad Proc? Single Core? HyperThreaded? Dual Core? Quad Core?

Disk subsystems? Are they then same/similar?

Nope. Permission issue.

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 option than a stored...

This may take more work. Even under a privledged account, I get an error with the CREATE DATABASE part of the stored proc.

Don't give up hope yet. If...

Mike Levan (4/9/2009)

---

I think Tara wants to check dbname from 4 different servers and more over she dont need to give create command, she can directly create database as it...