From the blog of Technical Rollup mail that we receive from Microsoft here is the list of SQL Server Migration Assistant tools available from Microsoft to migrate/upgrade data from other data sources such as Access, Sybase & Oracle. _________________________________________________________________________________________________________________________...

Recently I have received an email about unable to drop schemas that are adopted in the database design within an environment, here it goes. I'm setting up an automatic build process that also includes building one or more databases. Initially it was decided to used separate databases for various...

Still most of the users in SQL Server 2005 are afraid of using SSIS - SQL Server Integration Services for their ETL process and procedures. I would say the newbie users are in luck to obtain help easily on the web by referring to the blogs and forums/newsgroups in this cyber age. In this regard Microsoft...

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and Major Modifications How to make unwanted access to SQL Server 2005 by...

Another frequently asked questions in the forums and newsgroups, I have seen similar ones recently. I believe most of the newbie users ask this question and even more as interview based questions. So here is the catch in order to accomplish the task, say you need to provide a solution to log and show...

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications FIX: A SQL Server Agent job fails when you run the SQL Server Agent job in the context of...

select p . state_desc + ' ' + p . permission_name + ' OBJECT::' + s . name collate Latin1_general_CI_AS + o . name collate Latin1_general_CI_AS + ' TO ' + u . name collate Latin1_general_CI_AS + 'GO' , p .* from sys.database_permissions p inner join sys.objects o on p...

Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications FIX: An access violation may occur, and you may receive an error message, when you query the sys.dm_exe_sessions dynamic management view...