is the insert of the order done by a stored proc?

you could amend the logic in the proc so that if the parameters meet the criteria then send a mail

if...

in my professional opinion, in all the interviews which i have conducted to hire junior and senior DBA's in the companies I have worked in, we have always found that...

if your production server can take the load of production OLTP traffic and reporting traffic, you could look at database snapshots

otherwise I would say your looking at either logshipping or...

take a look at cast and convert functions, they can manipulate the data into a decimal value with what ever precision you give it.

EG

PRINT CONVERT(DECIMAL(10,2),ROUND(12.3456789, 4, 0))

7 points for that, amazing, have a good holiday all in the US

think what you are looking for is a central management server, will require all the "100" servers being registered under the CMS but you can execute a query against the...

take a look at the custom counters part of spotlight this is a powerful part of the app as it allows you to write your own metrics

if your clued up...

This is a quote from Richard Jones @ Quest

Idera is more expensive than Quest

Idera pricing per server for Diagnostic Manager for SQL (20% maintenance charge each year after)

Lic & 1 Yr Maintenance - £1620

Lic & 2 Yr Maintenance...

you may want to look at renaming a SQL server as well (will try and find a link somewhere) as this is part of our recovery but may not be...

to close existing connections you can set the database to single user which will close all connections to that db but leave the connection issuing the command in the db.

alter...

your best asking the person doing the handover what they mean by refresh, once you know it might be obvious, if not we are here to help

can i ask why you would want to do that.

surely that means that the database is not production as you would never want to go back to a point in...

in terms of?

what we call a refresh in our organisation is a copy of the live database, being placed onto the DEV/UAT/SYSTEST environment so that development have a like for...

by external / remote do you mean from outside of your organisation or nothing can use SQL apart from anything which runs on the SQL host?

e.g block all WAN traffic...