Ever wondered why is there no SQL server management studio after a successful installation of your SQL Server 2005? This is because by default the SQL 2005 installer does not install this tool. To install the studio just run "SqlRun_Tools.msi" from your setup disk. On enterprise edition, "SqlRun_Tools.msi" is located on D:\Tools\Setup.
Location from CD:
After running the SqlRun_Tools.msi, new items will be displayed on Microsoft SQL Server 2005 menu
Sunday, November 28, 2010
Saturday, November 13, 2010
collation error occures in sql2k5
If a collation error occurres then can be resolved by mentioning the collation in query such like that
SELECT Column1, Column2
FROM MyTable M
WHERE EXISTS (SELECT * FROM ThisTable T WHERE M.Column1 = T.Column1
COLLATE Latin1_General_CI_AS)
SELECT Column1, Column2
FROM MyTable M
WHERE EXISTS (SELECT * FROM ThisTable T WHERE M.Column1 = T.Column1
COLLATE Latin1_General_CI_AS)
Subscribe to:
Posts (Atom)