Viewing 15 posts - 1 through 15 (of 63 total)
fixed it I just had too many columns in the CURSOR I removed them like so and it works now.
CURSOR FOR ...
January 4, 2019 at 1:44 am
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...
January 3, 2019 at 7:08 am
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
February 29, 2012 at 9:24 pm
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
June 20, 2011 at 8:19 pm
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...
December 11, 2010 at 7:49 pm
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...
September 27, 2010 at 4:27 pm
try dropping the msdtc resource and disk and recreate it. This should solve your issue.
September 27, 2010 at 8:54 am
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...
March 26, 2009 at 8:13 am
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.
October 20, 2008 at 5:56 pm
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...
August 19, 2008 at 10:52 pm
use bcp tablename out tablename.csv that should do it.
August 19, 2008 at 10:29 pm
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.
August 11, 2008 at 12:40 am
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...
August 11, 2008 at 12:17 am
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...
July 30, 2008 at 8:34 pm
not sure I understand either, but I like games lets play
July 30, 2008 at 1:44 am