This function will round any number to any base you chose. So in your case just pass number + 5, 5 to get your desired results:

CREATE FUNCTION RoundToBase(@value money,...

SQL Bill:

How bout this one.

It creates a table.

Uses sp_configure to move settings into that table then add in the settings that have changed and what date they were...

For a new comer to SQL it shoulds like Siraj has the right idea. He has a concept of down time. I see to many times people just installing and...

Thanks, I'm gonna try it.

Thats a really good idea. I like the netsend thing. What would be the best way to get idle time? Its not in sp_who or sp_who2. Do I need to...

I wasn't too clear. When it scripts it will have

Create Table owner.tablename

Just change that line to

Create Table dbo.tablename

Then run in query...

You can also run

sp_changeobjectowner @objname = ...

Holy Cow, 16,000 pages. Yeah I'd leave it as is too.

In the Table Creation Window there is a little Script Button. It looks like a scroll. Create the fields and settings but don't save. Script the object. Close the creation...

Great Info PearlKnows, I just used it. Been working with SQL for years. Things you learn. Thanks for the info.

I did it for 14 days, but you should change to what makes sense. Don't forget to find an identifier, that script will delete all jobs after 14 days!

Ick, thats not too smart a way to do a SQL Process. It only runs once but creates a job to do it? Thats strange. You sure its not rerunning...

I know you can send yourself an email through SQL Mail if SQL Agent Stops.

Do you know that you can change the property of the SQL Agent Service though...

Fhanlon, look up DBCC SHOWCONTIG under books online it gives you a good start on the procedure.

As a SQL admin/developer for over 8 years, I fully understand the frustration expressed here in the article. Its not about being an expert on DB2, or what the technical...

Try (explination after):

select

[text],

...