What is the point of “Initial Catalog” in a SQL Server connection string?

by

If the user name that is in the connection string has access to more then one database you have to specify the database you want the connection string to connect to. If your user has only one database available then you are correct that it doesn’t matter. But it is good practice to put this in your connection string.

More Related Contents:

  1. How to determine total number of open/active connections in ms sql server 2005
  2. “Cannot open user default database. Login failed.” after installing SQL Server Management Studio Express
  3. Date range overlapping check constraint
  4. Difference between database and schema
  5. T-SQL: Opposite to string concatenation – how to split string into multiple records [duplicate]
  6. What is the best way to create and populate a numbers table?
  7. Sql Server string to date conversion
  8. What is the difference between Integrated Security = True and Integrated Security = SSPI?
  9. Query to list number of records in each table in a database
  10. SQL Server query to find all permissions/access for all users in a database
  11. Generate a resultset of incrementing dates in TSQL
  12. SQL Server IN vs. EXISTS Performance
  13. PIVOT in sql 2005
  14. Create a view with ORDER BY clause
  15. What does ‘COLLATE SQL_Latin1_General_CP1_CI_AS’ do?
  16. Atomic UPSERT in SQL Server 2005
  17. How to do version control for SQL Server database?
  18. SQL Server sp_msforeachtable usage to select only those tables which meet some condition
  19. SQL Server ORDER BY date and nulls last
  20. How to check if a database exists in SQL Server?
  21. How to query values from xml nodes?
  22. How to query for Xml values and attributes from table in SQL Server?
  23. What happens to the primary key Id when it goes over the limit?
  24. Received an invalid column length from the bcp client for colid 6
  25. SQL Server recursive query
  26. How can I run just the statement my cursor is on in SQL Server Management Studio?
  27. Milliseconds wrong when converting from XML to SQL Server datetime
  28. nvarchar(max) vs NText
  29. In SQL Server, how can I lock a single row in a way similar to Oracle’s “SELECT FOR UPDATE WAIT”?
  30. Forgot SQL Server Password

Leave a Comment