Dec 2023 Discount: Comprehensive Database Performance Health Check | Testimonials

SQL SERVER – Fix: Error Msg 128 The name is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks
SQL Download, SQL Error Messages, SQL Scripts, SQL Server Security
Error Message: Server: Msg 128, Level 15, State 1, Line 3 The name is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted. Causes: This error occurs when using a column as the DEFAULT value of another column when a table is…
Read More

SQL SERVER – SQL Commandments – Suggestions, Tips, Tricks

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks
Best Practices, Database, Software Development, SQL Backup and Restore, SQL Constraint and Keys, SQL DateTime, SQL Download, SQL Error Messages, SQL Function, SQL Index, SQL Joins, SQL Server DBCC, SQL Server Security, SQL Stored Procedure
Few days ago, while searching for something on web site, I came across a very good article of 25 SQL Commandments. I really enjoyed reading it. It was for Oracle, I re-wrote it for SQL Server. First 18 points are taken from original article and last 2 I added to…
Read More

SQL SERVER – Fix: Sqllib error: OLEDB Error encountered calling IDBInitialize::Initialize. hr = 0x80004005. SQLSTATE: 08001, Native Error: 17

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Error Messages, SQL Server Security, SQL Utility
Error received: Sqllib error: OLEDB Error encountered calling IDBInitialize::Initialize. hr = 0x80004005. SQLSTATE: 08001, Native Error: 17 Error state: 1, Severity: 16 Source: Microsoft OLE DB Provider for SQL Server Error message: [DBNETLIB]SQL Server does not exist or access denied The simple fix: Microsoft SQL Server 2005 >> Configuration Tools…
Read More

SQL SERVER – DBCC command to RESEED Table Identity Value – Reset Table Identity

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks
SQL Index, SQL Scripts, SQL Server DBCC, SQL Server Security
DBCC CHECKIDENT can reseed (reset) the identity value of the table. For example, YourTable has 25 rows with 25 as last identity. If we want next record to have identity as 35 we need to run following T SQL script in Query Analyzer. DBCC CHECKIDENT (yourtable, reseed, 34) If table…
Read More

SQL SERVER – SQL Server 2005 Samples and Sample Databases (February 2007)

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks
SQL Coding Standards, SQL Download, SQL Error Messages, SQL Joins, SQL Scripts, SQL Server Security
The samples download provides over 100 samples for SQL Server 2005, demonstrating the following components: Database Engine, including administration, data access, Full-Text Search, Common Language Runtime (CLR) integration, Server Management Objects (SMO), Service Broker, and XML Analysis Services Integration Services Notification Services Reporting Services Replication The samples databases downloads include…
Read More

SQL SERVER – FIX : Error 15023: User already exists in current database.

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks
DBA, SQL Cursor, SQL Download, SQL Error Messages, SQL Joins, SQL Scripts, SQL Server DBCC, SQL Server Security, SQL Stored Procedure
Error 15023: User already exists in current database. 1) This is the best Solution. First of all run following T-SQL Query in Query Analyzer. This will return all the existing users in database in result pan. USE YourDB GO EXEC sp_change_users_login 'Report' GO Run following T-SQL Query in Query Analyzer…
Read More