okay so it really bugs me when I say code "can't" do something

--**********************************************************

--Enable the ability to set advance settings and xp_cmdshell

--**********************************************************

exec sp_configure 'show advanced options', 1

go

reconfigure

go

exec sp_configure 'xp_cmdshell', 1

go

reconfigure

go

--******************************************************

--Declare variable's...

the problem is the HFMSYDB without the underscore date on it.

try

delete from

@myTable2

where FileNames not like 'HFMSYSDB_%' or FileNames is null

and then change it to

delete from

@myTable2

where FileNames <>'HFMSYSDB'

you will...

Try:

--**********************************************************

--Enable the ability to set advance settings and xp_cmdshell

--**********************************************************

exec sp_configure 'show advanced options', 1

go

reconfigure

go

exec sp_configure 'xp_cmdshell', 1

go

reconfigure

go

--******************************************************

--Declare variable's to use in the code and set their values

--******************************************************

declare @myTable as table...

Wow this is an old thread from a Customer ago. funny where a little over a year will take you.

I've used this cleanup task alot since I left so...

Essentials Questions

To improve your proficiency, ask yourself the following questions on a regular basis:

• In a seemingly serious situation, what nuggets of humor or irony can I find?

HAHAHAHA......Thier Website...

Here are the only things I could find

A structure with extra internal load paths or external supports in excess of the minimum required for stability.

it seems like it could...

I can think of 2 ways off the top of my head, but the easiest ways are not to set seperate SQL Agent jobs.

1. Create a Maintenance Plan and have...

most of mine have been taken, but I have a semi-clean story.

I was working with the Army on a FileNet project that had a SQL backend. All the FileNet...

Trust me I completely agree.....that would not have been my first option. This was a cluster where I set up and documented the whole process, at the end of...

Thanks Govind-326906, just came across this thread, my Node2 was missing the x86 folder all together. I copied it over from Node 1 and restarted the SQL Agent from...

sorry i came late to the party, but i was wondering if this would be helpful, or along the lines you were looking for. to execute you would just...

enable it at the begining of your script and disable it at the end of the script, even if you put something in the <insert script> part of the...

I think that is where I was having the disconnect, if you run a dbcc shrink without switching to simple recovery, all that happens is that the empy virtual log...

well you learn something new every day. I could have sworn that broke the log chain. Thanks for setting me straight!:-D

if you are doing nightly backups it is possible that even though the log file is 24 GB you are not using all the space within it. To see...