Browse by Tags

SQL Server Migration Assistant tools from other data sources - 2005 & 2008 versions

Published 4 August 8 7:58 AM | SSQA.net

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. _________________________________________________________________________________________________________________________...

Filed under: sql server, version, access, oracle, data sources, sysbase, migration assistant

SQL Server 2005 unable to drop schema error: Cannot drop schema <> because it is being referenced by object

Published 22 April 8 3:1 AM | SSQA.net

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...

Filed under: sql server, access, best practices, object, 2005, tsql, schemas, alter authorisation

SQL Server 2005 ETL process - made simple and easy to learn with SSIS tutorials

Published 5 November 7 9:47 AM | SSQA.net

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...

Filed under: sql server, ssis, users, BOL, access, import, 2005, etl, tutorial, integration services, newbie

How to make unwanted access to SQL Server 2005 by an operating system administrator more difficult

Published 12 October 7 5:55 AM | SSQA.net

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...

Filed under: sql server, security, kba, access, sa, system administrator, operation system

How to read Database transaction log in SQL Server?

Published 27 September 7 7:13 PM | SSQA.net

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,...

Filed under: sql server, ssms, tools, transaction log, dba, read, access, audit, log file, third party, resolution

FIX: A SQL Server Agent job fails when you run the SQL Server Agent job in the context of a proxy account in SQL Server 2005

Published 22 August 7 2:4 PM | SSQA.net

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...

Filed under: sql server, kba, access, agent, account, proxy

TSQL to generate GRANT statements from a database

Published 17 August 7 5:45 AM | SSQA.net

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...

Filed under: sql server, performance, access, permission, system, tsql, grant

FIX: An access violation may occur, and you may receive an error message, when you query the sys.dm_exe_sessions dynamic management view in SQL Server 2005

Published 14 August 7 11:53 AM | SSQA.net

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...

Filed under: sql server, dmv, kba, violation, access, sys.dm

An error has occured while establishing a connection to the server. When connecting to SQL Server 2005,this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.(provider:Named Pipes ....)

Published 26 July 7 7:49 AM | SSQA.net

Error: An error has occured while establishing a connection to the server. When connecting to SQL Server 2005,this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.(provider:Named Pipes Provider...

Filed under: sql server, performance, management, security, ssms, error, access, sql express, tcp, named pipes, remote

FIX: You may receive an access violation or error 942 when you drop a database in SQL Server 2005

Published 10 July 7 4:49 PM | SSQA.net

Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition, SQL Server 2005 Enterprise X64 Edition & SQL Server 2005 Enterprise Edition Notification Contents: New and All Modifications FIX: You may receive an access violation or error...

Filed under: sql server, database, kba, violation, access, drop

Restrict Access to SQL Server using "Certificates"

Published 2 July 7 4:7 AM | SSQA.net

Within SQL Server 2005 you could take help of certificates to restrict the access from a particular client's machine. Few times (even me) confused with or get an impression that SSL encryption is same, for more information on SSL( Secure Sockets Layer...

Filed under: sql server, performance, databases, security, access, encryption, certificate

FIX: Error message when you run the CHECKPOINT statement after you restore a database that has a read-only user-defined filegroup in SQL Server 2005: "The operating system returned error 5(Access is denied.) to SQL Server

Published 27 June 7 11:42 AM | SSQA.net

Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and All Modifications FIX: Error message when you run the CHECKPOINT statement after you restore a database...

Filed under: sql server, restore, database, kba, access, checkpoint, denied

xp_cmdshell: a call to 'CreateProcess' failed with error code: '5'

Published 24 May 7 8:5 AM | SSQA.net

Problem: SQL Server 2005 error: xp_cmdshell: a call to 'CreateProcess' failed with error code: '5'. We get above error when trying to execute XP_CMDSHELL even though it has been enabled using Surface Area Configuration tool and the login...

Filed under: sql server, databases, access, permissions, xp_cmdshell

List of KBAs that are modified for SQL Server Enterprise X64 edition

Published 22 May 7 1:2 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition FIX: You receive error messages when you use SQL Server Management Studio or SQL Server Business Intelligence Development Studio...

Filed under: sql server, package, ssis, ssms, xml, violation, access