Toreador (3/5/2010)

---

bitbucket-25253 (3/5/2010)

---

May I point out that the SSC community includes members from countries...

I'll give you one right now as i have already seen it posted in other threads: Wait a day, the next days email newsletter contains the answer to the...

You also need to be sure to GRANT CONNECT permissions to the endpoints for the service account that SQL Server is running under. Ran into that issue when trying...

Peter Brinkhaus (3/5/2010)

---

I don't know what you are trying to compute, but there's no workaround for this simply because it's mathematically undefined. You can't raise a negative number to power...

Roy Ernest (3/5/2010)

---

Jack Corbett (3/5/2010)

---

For me it's the classic "It Depends". I think it was the right move...

apat (3/5/2010)

---

Lynn,

Thanks for your quick reply.. If I do,

select POWER (column1, 1.8) * 10000.0 as newvalue from #temp with (nolock)

it gives me an error:

Msg 3623, Level 16, State 1,...

1.8 ^ 100 = 33,670,573,242,751,689,858,746,062.7772

apat (3/5/2010)

---

Hi All,

I imported some data from text file to sql server 2008. Import Export wizard created a table with varchar(255) for some columns which had float data. Then I...

First, the remote location would have to be accessable over the internet.

Second, you would have to grant proper permisions to the account that SQL Server is running under assuming it...

You need to create a trigger on each table, you can't create one trigger on two tables.

kaspencer (3/5/2010)

---

I think that I am probably one of those who has been criticised in this thread because I have complained about a number of the questions written for SQLServerCentral.

I...

Fatal Exception Error (3/5/2010)

---

Chad Crawford (3/4/2010)

---

BTW - I thought of a few more assumptions that should have been included:

--Assume you are in the database containing tblUsers

--Assume you have been...

Apparently not on my servers. Any time I delete files it asks if I'm sure I want to move them to the trash can. I think it depends...

How about we put so much detail in the question that there is one and only one correct answer? Our work requires us to make assumptions all the time....

sore, as in still after working 9 soccer games this past weekend.