You can get logshipping to work on SE but you need speacilized scripts to do so. MS helped us with this back in SQL 7.0 for our high-availibility systems. (scripts...

Hi - I must be missing something on the usage of your query; I get the same results for each database I tried it on. I also was hoping for...

Thanks - thought it was me!!!

Thanks to all for the info!!!!

Anytime I need to stop/start the Virtual SQL servers in our cluster I also do it thru Cluster Admin.. If you try to stop the service thru EM you will end up...

I've also heard that Windows defrag was based on Diskkeeper. In my experience the "WIndows" tool is a lot slower and less efficient. As suggested, if you have the maint...

I use the Maint. Plans for our Productio & non-production servers. With the amount of servers I support at any given time (30+) it just makes things easier. Yes, the...

You could try running with Blat (www.blat.net).

I've also found in the past that on some "stubborn" logfiles that wouldn't shrink I've run DBCC CHECKDB against the database. I'm not sure why but this appears to free the...

I recall something that happened quite awhile ago; I believe it had something to do with the permissions that were setup for the SQL account that ran the backups. Not...

I have similar setup; one drive has data segments, another transaction log segments. The errorlogs I leave out on the "default" install directory.

It seems like sp_helprotect doesn't list "all" permissions on each object in the database. What would the syntax be to list this?

Thanks!

It seems like sp_helprotect does list "all" permissions on each object in the database. What would the syntax be to list this?

Thanks!

If the new server is on your Lan you could also use DTS to transfer the SP's.

We consolidate our servers by utilizing a SQL "Farm". This is a SQL clustered environment where we re-locate similar applications to reside together on a specific instance. These are dependent...