On clusters you need to install the software on all nodes within the cluster as it registers extended stored procedures, few registry keys and a number of DLL's to operate...

Should look something like this

Begin Try -- move rec from tblCustomer_deleted --> tblCustomer

set identity_insert tblCustomer on

Begin Trans

insert into...

As...

duplicate post, please direct answer to here http://www.sqlservercentral.com/Forums/Topic1211822-391-1.aspx

I'd have to agree with Gail, if you want to have official Microsoft credited learning material that you follow the link in my previous post to the learning material.

If you...

not to worry, always happy to help.

good place to start

http://www.microsoft.com/learning/en/us/certification/cert-sql-server.aspx

from what I remember as I had the VDI issue with LiteSpeed is that it was down to memory pressure.

try restarting the LiteSpeed service, if that fails restart SQL and...

do you not have an active maintenance contract with Quest?

6.5.1 is pretty recent, so you must have either expired on maintenance somtime after March or purchased 6.5.1 this year in...

the console is user specific, so you will not see any servers unless you register them under your profile

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