Attend this virtual conference for a deep dive into all things Microsoft & how core Microsoft tools and technologies can help organizations stay secure and productive.
A. SQL Server only supports "after" triggers, not "before" ones. You can see what the "before" data is by looking at the virtual tables created that are accessible from the trigger. These tables are called inserted and deleted...
A. First ask yourself what your reason is for doing this? Your performance will be degraded and you will be more prone to database corruption due to network glitches (which are far more common than scsi/fibre bus glitches). Putting i/o's across...
A. No. MSDE *is* SQL Server. So you can't have both on the same machine. For info on the types of SQL Server see the sql7versions.txt member in the
faq.
A. For SQL 6.5 :- http://support.microsoft.com/download/support/mslfiles/PTK_I386.EXE
This contains everything you need for db-lib, odbc, dmo, ods, xp etc. type programming against SQL Server.
For SQL 7 look on the CD under \devtools
