Hi Deni,

Thanks for the update. Very nice of you.

Hi,

I gave him something like this, again had to grant him public rights on sysjobs and syschedules on msdb

Use Msdb

go

select 'Start_Full on upside' as Job_Name,  name as schedule_Name,

case freq_type

 when 1   ...

Thanks a lot Phill Carter. I was planning to do a repair_rebuild. Any way waiting for the customer to get back before taking the database offline

Itz helpful

Cheers

Hi Greg,

Thanks for your comments. Can you please tell me if this will work

If I save the DTS package as a structured storage file, and...

Hi Randy and Dan,

Thanks for substantiating to that. Quiet helpful for me, I was looking for such a solution.

Thank you. Let me try this solution the next time.

Cheers

Hi,

This job will run for nearly 30 min. We have scheduled transaction log backup.. How will i be able to do this. Is it advisable

Thanks for your quick reply

Hi,

Thanks for your help

Hi,

I can also see this in error log

By checking the N:\MSSQL2000\MSSQL\LOG\ERRORLOG on the SQL we found the following entries:

2005-07-07 05:51:00.77 spid52 Starting up database 'STS_telecom-em-sps1_1731241258_10451'.

2005-07-07 05:51:00.84 spid52 Non-clustered...

Also please not that I am not able to connect from SQL server to any sharepoint url

thanks

Hi,

Please see my error message

Event Type: Warning

Event Source: Microsoft Search

Event Category: Gatherer

Event ID: 3036

Date: 6/30/2005

Time: 2:24:18 PM

User: N/A

Computer: TELECOM-EM-DB3

Description:

The crawl seed <MSSQL75://SQLServer/3a81b327> in project <SQLServer SQL0003100005> cannot...

Hi

I have even tried that using the following command and still not able to

exec sp_grantlogin N'NT Authority\System'

exec sp_defaultdb N'NT Authority\System', N'master'

exec sp_defaultlanguage N'NT Authority\System','us_english'

exec sp_addsrvrolemember N'NT Authority\System',...

Hi Sushila,

I have added Builtin\administrators via EM. I did not get any errors while adding. It was successful.

DO I NEED TO RESTART SO THAT IT USES THIS LOGIN AS STARTUP...

Wow great.. This answers mine issue as well. Hats off

Thanks

To further our discussion let me give you a link

http://regions.cmg.org/regions/mcmg/Virtual%20memory%20constraints%20in%2032bit%20Windows.pdf

If you can make sql server to use memory dynamically it may be helpful