Recent content by ringworm24

Ojay I am struggling here to use BCP as well Hi I am trying to use BCP to save the results of an SP to a file here is my code DECLARE @Cmd VARCHAR(1000) SELECT @Cmd = 'bcp "exec mydatabase..my_sp" QUERYOUT "d:\reports\bob.csv" -w -t"," -T' EXEC master..xp_cmdshell @Cmd I get invaild object...

Still dosnt help the csv file has huge spaces it in ie. xxxx ,aaaa ,bb ,etc why are these spaces being inserted? If a run the SP from query analzer and save it then the are no spaces!!! please help

I asked this a few days ago and some replied RTrim everything, thanks for the suggestion but, thats not the answer, I know what the problem is I am excuting the stored procedure using ISQL so i can run it through the sql server agent, and for some reason it is that engine which is inserting the...

Hi, I have an automated report which has lots of unwanted spaces in in it and a few empty rows at the EOF. When I run the report from Query analyzer and save as csv it has no spaces, where is the auotmated report getting the spaces from and how can I stop this? Many Thanks

Hi, My PC froze (XP) and I had to reboot. now just before you would expect the log in screen to appear it restarts the PC. Safe mode and command prompt suffer similar thing. What can I do??? PLease help

yes, ithappens when accessing it, It sounds like it is taking off , its very loud. there is no rattling just seems to be trying very hard to read it. happens with all cd's

My CD works fine but it makes a very loud whirking sound almost like it is burning to disk (its not). Its very anoying and effecting others in the office.

If I have a integer of hours i.e 50 What would be the simplest way to add it to the current date and time? i.e what will the date and time be in 50 hours time? Thanks