|
|
Browse by Tags
All Tags » access ( RSS)
-
|
No doubt that the error on subject line will get no where! This is presented when trying to open a Database Properties using SQL Server Managment Studio, going back to history on the SQL instance where this is presented is an upgraded database instance...
|
-
|
One of the SQL Server 2008 upgrade process hampered with the error on the subject line and following text box was displayed: For some reason the similar issue hasn't been displayed when Upgrade Advisor has been chosen to find the first hand issues...
|
-
|
SQL Server Upgrade task needs a thorough planning and testing before you deploy the process in production environment. In this regard when performing an upgrade to a replicated environment, DBAs must make sure that all changes have been applied to all...
|
-
|
Beginning of this year I have posted here about Build your BI skills in fast track data warehouse and based on that I have had few questions and feedback on how best we can take help of SQL Server 2008 features to build the fast track data warehouse....
|
-
|
As it states on the subject line this is an error that would cause when the system is trying to load assembly due to the permissions, the second part of the subject also needs consideration that server may be running out of resources & security issue...
|
-
|
What is your biggest challenge when you need to upgrade a SQL Server 2008? Do you have a clear process of migrating non-SQL Server databases to SQL Server? Whatever is the reason or need to install SQL Server 2008 you must review the installation requirements...
|
-
|
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...
|
-
|
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...
|
-
|
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...
|
-
|
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,...
|
-
|
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...
|
-
|
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...
|
-
|
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...
|
-
|
You may be aware that a user in a SQL Server 2005 database can only see metadata that the user either owns or on which the user has been granted some permission. A default policy enhanced as compared to how a DBA can control the security access to the...
|
More Posts Next page »
|
|