Few times I get such error Snap-in failed with a long CLSID string mentioned in the subject above. On this client machine previously I have SQL Server 2000 tools and recently installed 2005 version too, instantly error: Snap-in failed to initialize Name
Read More...
In SQL Server 2000 when you create a linked server then you can see that on Enterprise Manager under Security --> Linked Server. One of the Developer asked me how we can find same in SQL Server 2005 Management studio, here it is: You will find under
Read More...
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...
Having a feature of Notification on the server happenings is add-on for every DBA, Notification Services for SQL server 2005 has got that advantage. Microsoft confirms that capitalizing on the Microsoft .NET Framework and SQL Server, Notification Services
Read More...