Viewing 15 posts - 8,056 through 8,070 (of 9,715 total)
I'm glad it's working now. Sounds like the filename was kept in a table and re-running might have cleared the cache.
April 27, 2010 at 8:00 am
Well that seems to be the problem right there. The job is failing by trying to delete a file that doesn't exist.
Perhaps you should check the job, see if...
April 27, 2010 at 6:17 am
Does that file even exist? If so, is it perhaps locked by another process?
April 27, 2010 at 6:06 am
Could be several issues. Do you have access to SSMS?
Check to make sure the recovery actually recovered the schema and the objects involved. Check to make sure the user hasn't...
April 27, 2010 at 6:04 am
Create an Active Directory security group, add the users to the group, then give the group the necessary permissions. This way, when a user leaves or joins, all you have...
April 27, 2010 at 6:01 am
For the purposes of SDLC, Drop and Create gives you a date to which you can trace back changes that broke the proc, if something gets broken. The system tables...
April 27, 2010 at 6:00 am
SQL 2k5 has dropped support for a lot of the older or "other" database types in linked server OLE DB availability. Also in SSIS, unfortunately.
If you don't have a Teradata...
April 27, 2010 at 5:57 am
If you have multiple physical drives, you might consider having a file on each separate drive to help with I/O. It might speed up processing a bit. But this is...
April 27, 2010 at 5:41 am
2cams (4/27/2010)
Why will it be this side if there is so much free space? Do you need to maintain this DB...
April 27, 2010 at 5:38 am
There are probably several folks in Albany that don't frequent this group, so don't allow lack of replies to this thread to deter you from starting a local users group.
April 27, 2010 at 4:48 am
SwaroopRaj (4/23/2010)
yep.. i thought that 'truncate' would never rollback. That was the way i was taught in past. You proved that wrong for me now.
The thing that trips most...
April 23, 2010 at 8:55 am
The person who posted the question should have specified environment. I didn't have to run the code to know the VALUES statement wouldn't work in 2005. Therefore, I chose "Error"...
April 22, 2010 at 10:28 am
Thank you. I greatly appreciate your assistance.
Now all I have to do is make sure I've got space on my HD cleared out. @=)
April 22, 2010 at 8:12 am
jcrawf02 (4/16/2010)
I wouldn't think writing a blog post would really be different from writing an article? If you're going to write a slop blog, then you'd write a slop article...
April 16, 2010 at 5:31 am
Jeff Moden (4/15/2010)
April 16, 2010 at 4:47 am
Viewing 15 posts - 8,056 through 8,070 (of 9,715 total)