I have had a problem in the past where an application needed to expand the database file (as it was full). The database started expanding, it application connection timed out....

If you use windows authentication, you still should set a strong sa password.

Did you install M03-031 as wwell?

If so named pipes have been 'secured'

http://support.microsoft.com/default.aspx?kbid=823492

When you use the sp_attach_single_file_db you need to attach the .mdf file.

The error you got said .LDF,hence I presume you tried to add the wrong file.

In SQL7/2000 you can a look in the msdb table 'sysdbmaintplan_history' to see if there is a reason. Try that table.

(SQL 2000 Code) 

select substring(database_name,1,17) as 'database', activity ,start_time  as 'start', message...

If you save your DTS files as .dts file (structured storage files), they still retain the previous versions.

Mind you the size of the file does get larger each time, as...

Does the account you are using to run this query under have permissions to access the objects in the query?

Also what sql version and service pack are you on.

I haven't found any problems.

I do this to stop people creating dts jobs on servers (espically production servers). The people who are allowed to develop dts jobs are granted access...

I use Latin1_General_BIN as well. As robinhc says, watch anything that uses the tempdb if the database collation is different to the server collation.

Also naming standards help a lot, as...

Not sure if its the same with sql7, but one thing to watch are sql agent jobs.

I renamed a sql 2000 box, and found that I couldn't amend any...

All I can suggest is you read some of the papers on the subject

see the following page for a start http://www.sqlsecurity.com/DesktopDefault.aspx?tabindex=2&tabid=3

and get someone to peer review the code...

You could add a 'dynamic property task' to define the connection string from something like a .ini file. Hence you would only need to change the ini file rather than...

I record the size of the both the data and log files and put the information in a table. That way I can spot trends, work out growth etc.

If the...

You will find a long list of sql version number with some descriptions at

http://www.sqlsecurity.com/DesktopDefault.aspx?tabindex=3&tabid=4

Is the listener up on the oracle side.

Also which driver are you using the microsoft oracle driver, or the oracle one?