Jeff Moden (11/22/2009)

---

I have to agree with what was said.... by whose definition is it that 7.0449 should be rounded to 7.05? Are you intenionally trying to give CPA's...

Hi,

Sorry, i didnt explain myself very well did I.

All I'm trying to do is take a number and round it correctly.

For example 7.0449 should be returned as 7.05...

ha! I'm on there on the Friday sadly, so only...

I'll get back to you on that one. 😛

Hi all,

Got this working, the db collation remains in the default as does the column but it is created as an NVARCHAR, the data is stored, turns out that i'd...

One thing I have noticed is that if I create a new db with a collation of Polish CI AS and then create the column in a table (same collation)...

Hi,

Sorry for not getting back to you sooner. I dont know how much help I can be...

Hi Gail,

Yeah thats great.

Many thanks.

Richard Fryar (9/25/2009)

---

You are absolutely correct.

I am the guilty author of that article (written about a year ago) and have no idea why I wrote that.

I will correct the mistake...

Lowell (9/25/2009)

---

as you know SQL backs up whole databases, so your options are:

-- a not "real" SQl backup: send the DDL and the data to a text file via BCP,...

Hi,

I dont beleive there is a way to backup only a table directly within management studio however you have three options;

1. Backup the whole db to a disk on another...

infact scrub that.

I've managed to monitor the created objects on the tempdb and pull back some object id's.

Hopefully this will give me a little something to go on.

Thanks again.

Thanks for the response.

I'm not sure if that will pick them up, for example I imagine that my issue is a large number of inline and small procedures using temp...

Hi all,

Well having rebuilt the index yesterday the index is back at is 99% fragmentaion.

The trace I had running didnt pick anything of interest up, although I may broaden it...

Good...