sorry Gile,

i will send it today.

gile and all . i have one more dout in trace

Question : i want to no what are the events are...

Hi all

i can sechudule the back up for sql server 2005, but i can t.

but in my local server , i have sql 2005, &...

Hi All

Finally i got it.

But i got it in sql -2005,

If i run the same procedure , i am getting the same errors.

Is there any...

HI

This is the T-sql

EXECUTE master.dbo.xp_create_subdir N'C:\Documents and Settings\swdev.team\Desktop\bak\ITAM'

GO

BACKUP DATABASE [ITAM] FILEGROUP = N'PRIMARY' TO DISK = N'C:\Documents and Settings\swdev.team\Desktop\bak\ITAM\ITAM_backup_2009_06_15_184702_5511435.bak' WITH NOFORMAT, NOINIT, NAME = N'ITAM_backup_2009_06_15_184702_5511435', SKIP,...

yep

this is in the job history

ERROR: the job failed the job was invoked by user sa. the last step to run was step1(subplan_1).

When i click on...

Hi All,

This was the query:

BACKUP DATABASE [ITAM] FILEGROUP = N'PRIMARY' TO DISK = N'C:\Documents and Settings\swdev.team\Desktop\bak\ITAMCompact_12Jun2009.bak' WITH NOFORMAT, NOINIT, NAME = N'ITAM-Full Filegroup Backup', SKIP, NOREWIND, NOUNLOAD, ...

Hi

ur error defines definetly problem in schema , please verify that it is retrving the date from one mor schema that which u are not define...

Hi sarvan

pls disply ur error correctly.

Pleas verify that shema of table is in correct form ..

Regards

sat

Hi

This really help me to work , and also i achived the performance by implementing the mentioned indexed scripts ,

As i am new to...

HI All

1)I run the same Query in the DTA(Databasetuning advisor) it show some recomended indexes to implemented , and also it is recomended to apply for statictis...

HI

this was my query,

by including the schema name there will be any diffrence in the performance

--Invoice

select distinct Comp_Abbreviation

,t13.Cust_Name

,t3.OPF_Cust_Ord_No

,Convert(varchar(20)

,t3.OPF_Cust_Ord_Date,106) as OPF_Cust_Ord_Date

,dbo.concatvals(t2.InvoiceNo,'tblOPF') as OPF_No

,t3.Opf_Type

,t2.InvoiceNo2...

Hi

It is a really a good Article for the biginers as like me . and good ideas u have given

Regards

ksr

Hi

Gail &Markus

The error when i am applying the schema name for that particular two tables(dbo.tblleadstatus&dbo.tblsalsestage) query is running sucussfully and

after that when i am applying with...

INNER JOIN tblLeadStatus ON tblLeadDetails.LeadStatus = dbo.tblLeadStatus.LStatusID

INNER JOIN tblSalesStage tSS ON tblLeadDetails.CurrentStage=tSS.StageID

GO

when i am applying the schema name here it is showing the error.

Remaining is ok

Regards

sateesh

Thanks A lot for all frinds who help me in in this issue .

Especially

Gail Shaw & manu

Through ur views i had learn...