Basically, SSMS is a 32-bit application even when we install 64 bit SQL Installation. When we launch the SQL Server Import and Export wizard (DTSWizard) it runs the 32-bit version of it which needs the 32-bit version of Office libraries. if we have installed a 64-bit office then these office libraries will not talk to […]
Basically, collation defines the rules for how strings of characters data are stored and compared. Based on the norms of a particular language it will vary. Query conditions will change depending on the language configured. The server collation acts as the default collation for all the system databases and also newly created databases. we can
Changing SQL Server Collation After Installation Read More »
By Default in SqlServer, new database files are being created and stored in %Program Files%\\Microsoft SQL Server\\MSSQLXXX.MSSQLSERVER\\MSSQL\\DATA. This path can be changed to desired or configured path. To change Data and log files path Connect to SqlServre using SSMS Select connected Server and then Properties From Server properties –> Select Page (left side) –> Database
Change the Default Locations for Data and Log Files in SqlServer Read More »
