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
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
Viewing 2 posts - 1 through 2 (of 2 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy