this will disable the xp_cmdshell command.

===============================

EXECUTE sp_configure 'xp_cmdshell', 0

RECONFIGURE

For configuring more option use

EXECUTE sp_configure this will help to know which options you can configure.

( available in both SQL 2000...

Absolutely true, its a proper way of checking whether there is any data exists in the table or not.

Hi Balavardhan,

Check your linked server connection properties, may be you have not properly added the linked server.

EXEC master.dbo.sp_addlinkedserver @server = N'LinkedServer', @srvproduct=N'SQL Server'

EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'LinkedServer',@useself=N'False',@locallogin=NULL,@rmtuser=N'Login',@rmtpassword='PWd'

Hi !,

SELECTPro.[name] AS SPName, Para.[name] AS ParameterName,

Typ.[name] AS ParameterDataType, Pro.[type_desc]

FROMsys.procedures Pro

INNER JOINsys.parameters Para

ONPro.object_id = Para.object_id

INNER JOINsys.Types Typ

ONPara.system_type_id = typ.system_type_id

ORDER BY Pro.[name]

Its true that there is a problem while creating script in SQL 2005.

You can alos use Apex SQL studio which is a 3rd aprty tool.

hi !,

Try this once.

EXECUTE sp_msforeachtable 'print "?" dbcc DBREINDEX ("?")'

hi !

You seems to be really new in Database. you can check on BOL for inner join syntax. but for your reference here is the syntax for Inner Join..

Select ...

absolutly correct karthikeyan, but beforeDB design we need to analyze do we really need a trigger. If yes the for what purpose we will desing it , trigger may be...

Hi gail i m not wasting any person time, i have already explained you the view and the trigger.

but its k.. i got my answer thxs for your valueable...

MCITP (Database Dev)

Hi !

You also have to trnasfer the other Database objects like User, Logins, UDT..

Hi karthikeyan,

when we think abount DB Design the 1st trigger comes in mind is DDL trigger on database.

Trigger depends on the requirements.

hi !

You can definatly do that but SSIS also give u facility to run DTS packges creatde in 2000 using Execute DTS 2000 package task.

Regards,

Abhijit More

Hi !,

I have written the view in the same way as you had mentioned.

I have added the one trigger for insert, update, delete operation, in which i just insert the...

Hi !,

hope this code will help u.

create table join1

(

IDINTIDENTITY(1,1) PRIMARY KEY CLUSTERED,

Mydatesmalldatetime default(getdate())

)

GO

create table join2

(

IDINTIDENTITY(1, 1) PRIMARY KEY CLUSTERED,

join1IDINT,

Productvarchar(100)

)

Go

Alter table join2

Add constraint fk_join1_t1 foreign key (join1ID)

references join1 (ID)

insertjoin1(Mydate)

SelectGETDATE() UNION

SelectGETDATE()...