Hi,

Below are the basic requirnments you need to do before creating indexed views.

IF sessionproperty('ARITHABORT') = 0 SET ARITHABORT ON

IF sessionproperty('CONCAT_NULL_YIELDS_NULL') = 0 SET CONCAT_NULL_YIELDS_NULL ON

IF sessionproperty('QUOTED_IDENTIFIER') = 0 SET QUOTED_IDENTIFIER...

Thanks i will try that

with regards

Dakshina murthy

Hi,

Refer the below link for information about conflicts.

http://msdn.microsoft.com/en-us/library/aa256310(SQL.80).aspx

Hi,

Try this.

INSERT INTO OPENROWSET('Microsoft.Jet.OLEDB.4.0',

'Excel 8.0;Database=C:\testing.xls;',

'SELECT Name, Date FROM [Sheet1$]')

SELECT [Name], GETDATE() FROM msdb.dbo.sysjobs

GO

Try these Links

http://www.sqlservercentral.com/Forums/Topic334873-338-335131

http://www.mssqltips.com/tip.asp?tip=1540

http://www.mssqltips.com/tip.asp?tip=1202

Regards,

Vijay Singh.C

Hmm, then no problem in creating the physical tables.

Simple recovery model Allows for High Performance Bulk Copy Operations

and it Uses Minimal Log Space

Regards,

Vijay Singh:)

Ya you can also create tables in your db. No problem. If the data is too large the Db will be heavy.

One of the DBA advised me to use...

Hi Pedro,

You can Create #table for importing bulk data.

I don't think using #table will affect anywhere in your case.

Hi John,

Thanks alot for the information provided by you.

As i am new to db i still have to learn more.

Regards,

Vijay Singh.

Hi,

I can help you to find the particular word which are used in sp's

select p.name,m.definition from sys.sql_modules m

Inner join sys.procedures p on p.object_id=m.object_id

where m.definition LIKE '%User%'--Pass the word here

Regards,

Vijay...

Hi Krishna,

I am unable to execute logshipping monitor tables and my setup is in restore mode.

Ill refere the link given by you and i will get back to you.

Thanks and...

Hi Krishna,

In my case i have not used monitor instance.

Hi rajiniforu,

All jobs are running good except Ls_alert Job.

As I am new to Db And Sql Server Can you guys give...

Hi,

Below is the information what i got when i checked the error log of LS_Alert Job

Date3/3/2009 4:58:00 PM

LogJob History (LSAlert_DEEPAKA\SQL2005)

Step ID0

ServerDEEPAKA\SQL2005

Job NameLSAlert_DEEPAKA\SQL2005

Step Name(Job outcome)

Duration00:00:01

Sql Severity0

Sql Message ID0

Operator Emailed

Operator Net sent

Operator...

Hi ,

Hope You will get some tips from the below link.

Check this link.

http://www.dba-oracle.com/t_sql_server_health_checks.htm

Regards,

Vijay Singh.

Thank you for your replies.:)

Regards,

Vijay Singh.