Viewing 6 posts - 1 through 6 (of 6 total)
Make sure the login that runs SQL Agent runs has permission to access the script and if the script needs to access some other share/machine then login that runs sql...
March 17, 2004 at 8:40 am
I tried that , it returns zero.I recreated the Index and it fixed the problem.
February 25, 2004 at 9:32 pm
I've had this problem , where I would forget checking when transaction log backup ran last. I would check for failure of the job, but some one would have disabled...
January 8, 2004 at 5:12 pm
The only reason that coverting date to char will fail is if you have "odd" values in date field. You can find this out be
Select * from table where...
July 15, 2003 at 10:40 am
From my experience never turn on "Auto-Shirnk" option in production database.SQL might starts shirnking database and will hinder the regular SQL operation. I have seen other processes "hang" because of...
April 17, 2003 at 12:32 pm
Excel probably has an upper limit of 64K rows and your result probably exceeds that limit. I have seen this error while pasting a huge result in to Excel.
Thanks
April 11, 2003 at 1:32 pm
Viewing 6 posts - 1 through 6 (of 6 total)