There has been a discussion on this a year ago, and Operations won out with their plan. Seems to be the classic case of DBA vs SA and who controls...

The reason I ask is that we use Veritas BackupExec to do our backups. BackupExec requires and installation of SQL Server in order to access the DLL files to do...

I shut down the server, restarted, then did a DIR /OD /TA /S

(order date, last access date, all subdirs) in C:\MSSQL7, and trimmed out all the files with old dates....

I shut down the server, restarted, then did a DIR /OD /TA /S

(order date, last access date, all subdirs) in C:\MSSQL7, and trimmed out all the files with old dates....

Our databases (including master, msdb, etc) and log files are located on a separate drive from the program files - D:\MSSQL7\Data and D:\MSSQL7\Log.

Is this normal for SQL2k to keep...

I'm running SQL 7 & OLAP Services. There is no logging tab. I tried enabling the error handling - Package Properties / General / Error Handling / Error file:...

Yeah, everything is using our svcSQLDW service account. This account is in the Admin group, so should have permission to do everything. When signed on as svcSQLDW (and other...

Antares686:

I cannot log on as SQLAgentCmdExec - is there a password?

SQLAgent (and also MSSQLServer, MSSQLServerOLAPService) are all running under our svcSQLDW service account. svcSQLDW is in the Administrator...

Steve:

the DTS package #2 is executed from the VB program with:

Ret = Shell("DTSRun /S " & SERVER & " /N " & PACKAGE & " /E")

With RUNAS it works fine. The VB prog executes and writes the end-of-job file as it should.

This is a little late, but I had a similar problem with msmdarch and SQL7/OLAP. I believe I resolved it by reinstalling the add-in. Is this still an add-in with...

That's the impression that I have over here. I think all employers have been burned by this at one time or another. I have known MSCEs that seem to know...

Andy, you're either an early bird or a nite owl! Thanks for the advice.

Jay

Thanks, guys. I'm thinking that in the current business climate a few brownie points might not be a bad idea. But if no one here (Europe) really looks at...

The data loads are not within transactions. We are using DTS to load and cleanup data for prep for the data warehouse. Transaction logs are never needed, we simply do...