--Sql Server 2000

create table t1 (sno int, dob smalldatetime,name char(10))

create table t2 (sno int, dob smalldatetime,name char(10))

insert into t1 select 1,'01-01-2006','a'

insert into t1 select 2,'01-07-2006','b'

insert into t2 select 3,'01-01-2007','c'

insert into...

Dear Martin Vrieze

It is not the matter of man-hours and cost or solution to SURVERY task but is a creative way of using some technology and offcourse my...

Just login as

sa

or other superuser.

Best regards,

Tahir275

Happy anniversary!

Don't know about Advantage Database Server v8.1 database.

Can u run a Select query againt this linked server usign fully qualified table name,  mean with out View ???

Thanks all. NICLEY explain.

This explaination in simple english helps others as well.

Tahir275

Crossing the home land international border cannot describe in 100 Miles.

I am working away from my brith place Pakistan now in UAE. Good experience but no need for showling with...

Cricket ...Cricket ...Cricket ...Cricket ...Cricket ...Cricket ...Cricket ...Cricket ...Cricket ...Cricket ...

Any one else there to help ??????

Thanks dear

EXEC sp_addserver 'servername', 'local'

works just fine.

On named instance

SELECT @@servername

gives NULL

On named instance

SELECT @@servername

gives NULL

According to BOL

When u rename the SQLPRO12 to SQLLFG, on next startup your instance will be look like

SQLLFG\Instance1

SQLLFG\Instance2.

This is for Sql Server 2000.

but for Sql Srever 7 i think u need to...

Steve

I really don't like the way that _ _ _ author did (copier not researcher). Reply to your explanation is very essential so that such persons should know that...

Hi James

i think u can send notification like following

create table t1 (sno int )

go

create trigger trgt1 on t1 for insert

as

exec master.dbo.xp_cmdshell 'net send tahir helllooooo'

go

insert into t1...