ATTACH single file...

sp_attach_single_file_db @dbname = 'tman' ,

    @physname =  'E:\Program Files\Microsoft SQL Server\MSSQL\Data\tman_data.mdf'

We probably have 400 Windows servers here and of them about 25 SQL Servers. We installed our first SQL 2005 and we did it on 64 just because we see...

I thought Microsofts position on VMWARE is that SQL Server is not supported. Maybe I am wrong but years ago they did not support it.

Not quite sure. The way I handle SPs for SQL 2000 is I take db backups of all dbs including master.model.msdb. THEN... I stop SQL Server and all of the...

Personally I wish they would do that. They used to in SQL Server 6.5 but since 7.0 they no longer do that.

I feel your pain I really do. I agree with what you stated. I have ALWAYS stated the SQL Server 2000 was by FAR the easiest to use vs. Oracle...

We have it here and have for about 4 years. We use it for minor SQL Server things, ease of use for some Oracle stuff and DB2 Unix admin. Some...

I don't know if it is THAT back to pick oracle over ss...

I have a list of complaints about Mgt. Studio vs. Ent. Manager, ones that people have not addressed...

Can no longer grant a user access to a list of tables in...

I like the reports, the fact that there is an auto refresh for alot of screens and a button to manually refresh. scripting to a file or a query window.

Things...

I agree. I don't like the 2005 query tool as much as Q. Analyzer at all. For that matter I don't like Mgt. studio as much as Ent. Manager for...

We have DEV, Test, PQA, and Prod environments. DEV is pretty much open for developers to do what they want. Test has a few more restrictions. PQA no one knows...

I think it is almost endless. At some point there will most likely be a degraded performance. We have a 95 gig db with 4,800 tables in it right now....

Simply go onto Oracle's website and look for training. Oracle University. Look for the class you want and find a city ... they offer training in almost all Metro areas...

I was able to add 1 gig of memory to the server and it does appear to have helped some. We also took a look at a long running process...