thank you.

I just found out that my script that I made is working and was right all along.

The vendor of this product created roles and assigned them to the users....

I have read many articles. I have tried :

dropping and re-creating login/user

making sure the default database is propperly set

make sure "simple file sharing" is disabled

thanks,

Joseph

I am in the fight the largest fire mode.

Right now, these are vendor applications. I have changed some of their code and added indexes and got my hand slapped...

Does this hold for SQL Server 2005? Does it have to be Enteprise to take advantage of /3gb switch?

I am a new and only DBA at medium sized company....

My understanding is that the /3GB switch is NOT the same as AWE.

AWE need SQL Enterprise.

/3GB is a Windows parameter to allow any 32big application the ability to consume UPTO...

On a production database, I would perform this off hours and when you have admin control.

You can "backup log with truncate_only", this will get rid of all uncommitted...

The backup log does not correlate with physical file size on the OS. It is relevant to the "free space" found in the log. Right click on the...

Can I run this enterprise manager on an English OS?

Thanks,

Joseph

Doing database backups do not take care of the logs. When you do a "full" backup, SQL Server backups the contents of the database and enough of the tran...

They started of smaller, but grew quickly (what I was told).  I am walking into the middle of things are trying to organize and layout standards.  Most things here are...

Can I use SSIS on a 2000 db for this?  I do have SSIS setup on another server. 

Will running ssis from another server cause network traffic overhead?  Like zipping...

No 3rd party tools.  I can use the advance feature to put the output to a flat file and see if there is a completion to the job running.  Will...

no hung processes

Sorry, should have mentioned that.  I have started and stopped the agent services.  Same result, when the agent comes back up, the status is still "executing".  This is a 24x7...

yes.  I get the same result remote and local.

Joseph