Thanks for the scriter tool.

I will check out the scripting options.

Thanks,

Nikita

Anthony,

Pardon my ignorance.

First approach I thought of using RSSscripter but the following link does not work:

http://www.sqldbatips.com/showarticle.asp?ID=62

From what I understand, you do not need to backup-restore dbs with that...

Since this is read_only database, it will not have any transactions to backup. Just keep it in the simple mode and take full backups may be once in a week...

Thanks everyone for the reply.

I knew that this is the best I can do with the current set up but wanted to confirm.

I just feel bad that all our Enterprise...

I guess I did not phrase the question clearly.

Users do need access within database to perform their duties but they should be connecting to database only through the application they...

Any suggestion, please?

The thing confuses me as if I change the working set size to 1 but I have fixed memory and min/max set the same as fixed memory, what good will...

Oops

Topic was posted before I finished typing.

We have this silent fight and blame game going on between dbas and developers. Basically the application queues up tons of application calls to...

Thanks Colin

I ran waitstats on my db.

This is top 5 lines of what I got after running it for 30 minutes:

wait type ...

I would prefer native sql backup/litespeed/sql backup over any enterprise backup solution.

My reason is simple. I would like to control my database backups. If Commvault or any other software...

I meant to say thanks to kestak

Thanks Grasshoper

Backups and reindexing are the main concern for me. This is a backend database for SAP so there is nothing much we can do as far as design is...

Thanks for all the replies.

Total number of rows being inserted in the temp table was max 530. We did recompile the procedure to see if it makes any difference...

We already have orcale clent installed on the server. TNSping to the oracle server connects just fine. That's why I am concerened whether I did anything wrong this time or things are...