fixed it I just had too many columns in the CURSOR  I removed them like so and it works now. 

CURSOR FOR
...

at the moment I get 4 emails two are correct and two are blank I thought with the delete I would only get one email per email address. 
I would...

cheers i tried to code below it still did not work however, I turned the columns into decimal and it seems fine now. Cheers again

if you can still login as yourself with sa priv then I would say just change the password and secure it in a safe location

Hi Brad,

My company is too tight to give us a blackberry so we need to rely on a call out by some one else if there is an issue. Normally...

Hi I was wondering if you have a trusted domain I have seen an issue like this where a user made a change with a trusted domain login and when...

try dropping the msdtc resource and disk and recreate it. This should solve your issue.

Courses, I don't think there are many free courses and as Steve said i would not recommended them at this stage, I would as your DBA at work if you...

Thank you for this PowerShell script this has helped me alot, I can quickly access any of my SQL boxes with out logging on to the gui.

BCP FUNCTIONS are below

bcp tablename out table.csv -S servername then the options below what you would like. if you dont want to use command line you can use...

use bcp tablename out tablename.csv that should do it.

seems like typical power hungry America, messing the world up again changing a perfectly good system in ISO9001, and making the avg persons job allot harder because they can.

Hope...

Wo you are the first person I have ever met who said the US version of the office was better than the UK version.

The us does make good comedies...

a chav means council house and violent. These people instead of getting jobs live on the dole, the dole is free money from the state, which is one of the...

not sure I understand either, but I like games lets play