Viewing 2 posts - 1 through 2 (of 2 total)
If you are connected (using the instance name) you can also find it by query (SQl2000 and up):
set nocount on
go
DECLARE @SqlPort Nvarchar(10), @instance_name Nvarchar(30), @reg_key Nvarchar(500), @value_name Nvarchar(20)
if left(CAST(SERVERPROPERTY('ProductVersion')AS sysname),2)...
September 8, 2011 at 2:09 am
#1378395
Less sophisticated but what also would work (ans also on sql 2000):
select col1, col2, col3, col4 from Mytable into #tmp_Mytable
group by col1, col2, col3, col4
truncate table Mytable
insert into Mytable select...
February 5, 2010 at 1:41 am
#1114233