DELETE FROM MyTable WHERE ID NOT IN ( SELECT MAX(ID) FROM MyTable GROUP BY DuplicatevalueColumn1,...
Hi I hope you can view the version information from the registry key HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL Server90Tools
check the link...
Please check the link http://support.microsoft.com/kb/911841
Will give you list of all the MDF and LDF file locations for the databases on the server. exec sp_msforeachdb 'use [?] exec sp_helpfile'
Try using Group by clause.select test, count(test)as test1 from table1 group by test
In Object Explorer, right-click a server, and then click Properties.In the General tab, you will be able to view Root Directory, which is the...
I got the solution to my above query USE AdventureWorks;GO-- Truncate the log by changing the database recovery model to SIMPLE.ALTER DATABASE...
Hi All, How do I have to shrink the Transaction log file of the user database in SQL SERVER 2008? In the earlier version of the sqlserver we can do...
Hi All, Thanks for the information. It worked. Thanks
Hi All, My alter statement throws as Incorrect syntax near 'COLLATE' alterstatement is as below Alter table Mytable alter column [colu]...
Separate names with a comma.
