Thanks Ninja's_RGR'us.

mail.pnreddy (3/21/2011)

---

I was able to shrink successfully.

Here are the steps i followed.

Change the DB back to Simple If it is in Full mode.

Change it back to Full mode.

Use T-sql

DBCC...

Marios Philippopoulos (3/19/2011)

---

I have a few questions for you:

Is your sql instance on 32- or 64-bit platform?

What is the RAM on the server?

Is the instance sharing resources with other applications...

Patricia Johnson (3/19/2011)

---

I am trying to reorganize indexes using a maintenance plan in SSMS.

I am getting this message:

...cannot be reorganized because page level locking is disabled....

Truncating and shrinking the log file both are same[/url]

Click here:INDEX DE-FRAGMENTATION SCRIPT for SQL server 2000 [/url]

Edit: to Fix the link

What the GUI shows . Attach me the screen shot.

Grant,

Oh... i didn't read it fullly.

---

You changed your picture 🙂

mymail.default (3/9/2011)

---

Hello,

A single stmt stored proc (the stmt is basically a view from many tables) takes about 11-12 sec. from an app. However, it runs instantaneously in SSMS.

Any ideas as...

You don't have permission to do this.

You didn't replied my 1st question

You can't run.

How your are create the login gui or script.

What permission do you have ?

How to run ?

Jeff you are right.

I think the alternative way is create a sperate user for the application and give necessary rights to the user.

Rekha

Public role couldn't have permision to view that table.

Give the grant VIEW ANY DEFINITION to public role.

Go google..

The minimum permissions that are required to see the corresponding row are CREATE DATABASE, ALTER ANY DATABASE, or VIEW ANY DEFINITION.