Thank you, that makes sense.

I'm looking for the boot.ini file but...

abhijeetv (9/29/2008)

---

I have copy-pasted the text in your messege and tested with 20000 as well as 615.00 hard-coded values, I do not get error in the out put but I...

We tried the move for mail accounts on servers using both OUTLOOK (sql mail) and SMTP (db mail) to send mail.

For SQL Server 2005 instances using smtp (db mail): All...

Steve Jones - Editor (9/26/2008)

---

Is there a stop/start in 2005 as there was in 2000? Don't see one, and I think that each time you call the XP, it logs...

Will Summers (9/26/2008)

---

To be fair though, there are some new nice features as well. Here is one: being able to monitor a job running in the little popup dialog, after...

It's true that SSMS 2005 has its problems. My main peeve is the excessive memory resources it requires. I have often had to use Task manager to kill the SSMS...

Sorry guys, but I'm not getting the right results.

Take this NUMERIC(16,2) value: 615.00

When I use:

I get: $615615.00

When I use:

I get syntax error.

When I...

Actually, this is not giving me the right results:

I have this value in the database: 615.00000

In the report it shows...

thank you! I'll try that.

Registry: back up the Microsoft SQL Server node under HKEY_LOCAL_MACHINE -> SOFTWARE -> Microsoft.

Installation: copy the SQL installation folder to a safe location, preferably on another machine or network share....

John Marsh (9/20/2008)

---

Hello,

Does this problem happen every time or is it just a one of?

If it has just happened once then may be check the account under which you are...

Clustered indexes are most beneficial in range queries, ie. those including clauses (such as GROUP BY,...

dmc (9/17/2008)

---

I want to determine the last time a database (the tempdb) experienced an increase in the data file size. Is there a way to determine the day/time when...

I don't think it's possible but I'd be very interested in being proven wrong.

Run the following query on a schedule and store in a table for later analysis:

SELECT

OBJECT_NAME( s.[object_id] ) AS TableName

,i.name AS IndexName

,s.user_updates

FROM

sys.dm_db_index_usage_stats s

INNER JOIN

sys.indexes i

ON

s.object_id = i.object_id

AND...