Search results for query: *

HI - I am DBA for a public service body. I would say that processor speed is not your main concern. Transaction processing rates will ultimately depend on database structure and application design, and not on raw processor speed. You don't say whether you are running a client/server...

Hi - I'm a DBA also trying to change the default location for new databases, so that my team of developers can create new databases and transaction logfiles on separate hard drives, and I can keep these away from 'master'. I've shown them how to do this, but do they remember? I agree with...

Thanks for the clarification Terry

Microsoft's Technical Bulletin at http://support.microsoft.com/support/kb/articles/Q242/3/77.asp , entitled 'INF: How to Use Data Transformation Service(DTS)', refers to something called 'Object Transfer Manager', or 'Transfer Manager' which it suggests, provides features not available in DTS...

Terry, I think I've resolved my problem - It seems to have been a permissions issue - by setting file and folder permissions to 'Everyone/Full', at least, I've restored my databases to a working state. I'll worry about the security issue seperately! Many thanks for your time, and for a great...

Hi JuanCarlos. The stored Procedures in my installation are under 'Databases'=>'master'=>'Stored Procedures'. I don't know what the Spanish names for the stored Procedures are, are, but Spanish Dictionary equivalents at http://lucas.hispalinux.es/ORCA/glosario.html include attach 1...

Hi Terry, thanks for getting back to me. The data drives are all physical drives on the local NT server on which SQL Server is running

I have a very similar problem to 'demoman'! I have had to reinstall SQL Server 7 and SP3 on an NT4 Server (SP6a) and set up new (different) locations for the 10 existing databases. Both ~.mdf, and ~ldf files are to be relocated to new seperate folders. Prior to uninstalling, I performed full...