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.
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...
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...
Thanks for the information. It worked.
My alter statement throws as
Incorrect syntax near 'COLLATE'
alterstatement is as below
Alter table Mytable alter column [colu]...
Separate names with a comma.