No. It's because Money only goes to four decimal places.

If you simply divide @m by 1000 (in the sample provided), you'll see it cut off the final digit, because...

Not sure what you mean.

If you want to lock down the contents so nobody can access it, you can that through the security rules. You'll start getting error messages...

I'd have to see table designs and sample data before I could even begin to critique this.

Kit G (12/15/2010)

---

Lynn Pettis (12/15/2010)

---

I'm not in a position to test, but don't you get the same issue when using decimal(19,4) as you do when usinf money?

Now I may be...

I don't like to mess with the master database if I can avoid it.

Creating user objects in there creates a liability with regards to backup and recovery planning.

I don't know if you can do it in Profiler, but I know traces can do it, so I assume Profiler can (since it's just a GUI for creating a...

What I do for that kind of thing is create a database called "Common", and then call the function with "Common.dbo.MyFunction()" from anywhere on the server.

Those are stored in system tables in msdb.

Alvin Ramard (12/15/2010)

---

GSquared (12/15/2010)

---

Darn! ...

Steve Jones - SSC Editor (12/15/2010)

---

If your company has a copy of SQL Toolbelt from Red Gate, I'd run SQLDoc against the database and get a lot of information in...

Have you tried using the "sys.all_objects" view?

Darn! Now I'm going...

You can modify that sys.all_columns query to look for different things. Perhaps "name" instead of "address" would allow you to find a table of companies, including their names? ...

Okay. You may need to add some delays between alerts then. It looks like you're filling up the queue by calling it too many times in too short...

webin (12/14/2010)

---

Yes got scammed into doing it .....since the other person decide to pursue other work some where else....(Fired)

Yes all the data is in different tables...except client info is...