you should have post this query into DEVELOPMENT or TSQL 2K5 folder.this is related to admnistration part

i have same query which runs on other server...that also includes join.

So to make query faster put "REMOTE" word in between the INNER JOIN

for example :

select t.name,t1.cal from...

declare @LogFile nvarchar(500), @server varchar(50),@info nvarchar(500),@info2 nvarchar(500)

declare @Datafile nvarchar(500),@ans nvarchar(500)

--truncate table aud23sep

declare servercursor cursor for

select Server

from SQLServerMaster

order by Server

open servercursor

fetch next from servercursor

into @server

while...

My dear

your example will get executed as u desired bcoz execution is done in the same sequence as u write in your sql script

Hi Gila,

i m directing you towards the problem of a lady ....please help her ,i m sure u wont mind it as i posted this reply beyond this TOPIC:)

http://www.sqlservercentral.com/Forums/Topic573108-357-1.aspx#bm575413

oh.....this is a fall 🙁 in sql 2000 we have to go with

master.dbo.xp_sendmail

but sorry no idea about that

Yeah......i know re-engineering feature but its really difficult to manage 700 tables.....the reason being we basically deals with DDL commands ....so on every time it takes a...

hi ER/studio OR erwin ?? please elaborate

In simple language....whenever you have special characters use nvarchar otherise always use varchar datatype

yeah ...u r right 🙂

ALTER TABLE ADD CONSTRAINT [name of constraint] UNIQUE NONCLUSTERED

(

[column name1] ,

[column name2] ,

[column name3]

)

insert into table select 'O''rean'

replace single quote with double quote

i know .....truncate cant be stopped by trigger 🙂 but

can we think beyond the available features of sql 2005

is there any sys tables or catalog view by...

You can apply INSTEAD OF trigger FOR DELETE on that particular table

if you want i can give you script also but if you try yourself 🙂

include following script in your Stored Proc

declare @sqlcmd varchar(200)

SET @SQLCmd = 'copy c:\dba\sampl.xls c:\dba\sampl_2.xls'

EXEC master..xp_cmdshell @SQLCmd , no_output 🙂