There is no easy or best way, but few options are available such as DMO or SMO or even using Enterprise Manager for SQL 2000 or SS Management Studio for SQL 2005. Look for DBPublish wizard tool in this case that will help quite a bit and a lso you can
Read More...
When you have a Vista operating system along with SQL Server, the common error you get when trying to perform any sort of SYSADMIN sort of tasks. For instance when creating a database: TITLE: Microsoft SQL Server Management Studio ------------------------------
Read More...