this kind of naming can cause real problems - never include a decimal point or space in your database name

i'd advise changing to the following

select a.Emp_no,a.Emp_Name,a.Faulty_ItemSLNO,

b.Item_Name as Faulty_Item, a.Date_OfRep, a.Replacement_ItemSLNO,

c.Item_Name as Replacement_ItemName,a.Date_OfAlloc

from Item_Allocation a

left join Item_Master_Table b on a.Faulty_ItemSLNO=b.Item_SlNo

left join...

is sql2005 set to "allow remote logins" in the footprint configuration tool

can you post a create table statement for one of these medicservicefeed tables?

you can also use union hints

select x,y,z from a union all

select x,y,z from b

option(CONCAT UNION)

which will "attempt"...

select @@version

SELECT SUBSTRING(@@VERSION,21,CHARINDEX('(',@@VERSION,1)-21)

should give you just the version number major and minor part without text

as long as your full backup is INIT and your differentials are NOINIT you're on course for having the right backups

(assuming they both go to the same file)

then we would...

you could create 2 steps for each "logical step"

on success of step1 call step2a

on failure of step1 call setp2b

setp 2a just does sql code

step 2b does an xp_sendmail (or whatever...

NOINIT will be causing your backups to append - that's why the backup is growing - it should be 1.5GB accordig to your figures

ok - so we bit the bullet and applied it to the cluster at 6am this morning. It is cluster aware (apparently the patch was withdrawn in march because the...

does anyone know if this hotfix rollup is cluster aware?

in query analyser run the following

use master

go

exec sp_helpdb

the 3rd column shows database owner

last year it was 400 servers with somewhere in the region of 5000 databases (2 dba's), but after consolidation this year 100 servers with a total of maybe 70tb of...

use in query analayser the alter table statement

for example

alter table mytable alter column mycolumn varchar(100) NOT NULL

Enterprise mangler does some odd things when changing tables due to backwards compatability...

select * from mytable where myid in (select top 5 myid from mytable order by mydatefield desc)

are you running sql server accounts under localsystem or a domain account - lock pages in memory is usually defined under the security policy (i think) for your user account