The reason for this question is to test an app on DIFFERENT EDITIONS of SQL specially reagarding indexed views!

so far the NO EXPAND hint is the only thing I found...

1. the fact that  you don't  have where clause on the query makes me believe that a missing index is not the issue

2. The fact that when run local on...

David, Let me simplify the scenario so that you understand what I mean:

Update TblName Set fld1 = x, Fld2 =y ... where pk =@pkey

if @@rowcount = 0

begin

 insert into...

And Adding to Kenneth the

if Exists()

 Update

else

 Insert

is a BAD assumption. Supposed you are on a heavily transactional environment (Web App is a good candidate) and the exists Fails for two users...

Assuming that the view definition (text) is less that nvarchar(4000) in length you can use

SELECT TABLE_NAME AS Name, VIEW_DEFINITON  AS DEFINITION

FROM INFORMATION_SCHEMA.VIEWS

HTH

So, if it says that my log file is using 1.06 % of the space should I truncate it?

My opinion is NO. Why? If you shrink it and is going...

At the end of this thread you can find the code to detect if a job is running or not and all you will have to code after that...

just keep in mind that sp_startjob will run asynchronusly and if you need to wait for it extra code is necessary

hth

  >> The DBA doesn’t want to add all of the users <<

If that is the reason you should think about using WINDOWS INTEGRATED SECURITY. Then just grant access to...

for this task you should use:

exec msdb..sp_update_jobschedule ...

Besides the changes to the schedule values it is important to maintain the version, to notify sql agent for data refresh and to perform some...

In line with the previous replies. The  lookup tables are (should be) DIFFERENT Entities. The business purpose of the model CAN change therefore the ablity to change will be crippled...

Include the Field List.

insert into Server2.mydb.dbo.table1 (fld1,fld2,...)

select fld1,fld2,... from Server1.mydb.dbo.table1 order by add_item

Example 1 AND 2

ARE WRONG. You should specify the field list ALWAYS!

It has been documented and you should follow the practice. the Fact that the second case worked was an...

Update d Set Room_Name = Case when Cnt is null or Cnt = 0 then Room_name

         Else Room_name + Char(asccii('A') + Cnt)) end

from

 sims d

 join

   (select id, Room_name...

OPEN tnames_cursor

FETCH NEXT FROM tnames_cursor INTO @tablename

WHILE (@@fetch_status <> -1)

BEGIN

 SELECT @sqlstring = 'DBCC DBREINDEX(' + @tablename + ', " ", 0, SORTED_DATA_REORG)'

 EXEC (@sqlstring)

 FETCH NEXT FROM tnames_cursor INTO @tablename

END

CLOSE tnames_cursor    ...