why dont you just drop the object?

Personally never heard of it and cant really see the use either? What would worry me most is that the new password would be in the log which anyone...

Anamika (2/23/2010)

---

Hi All,

Thanks for the great support.

Now, how do I set memory for sql server and OS?

the max option in sql says 2147483647 (in MBs)

but the physical memory in the...

TheSQLGuru (2/18/2010)

---

Animal Magic (2/18/2010)

---

TheSQLGuru (2/17/2010)

---

sanketahir1985 (2/17/2010)

---

Hii

Do not change any configuration settings without having the root cause why RAM is getting utilized. ByDefault sql server uses available RAM.

2ndly run...

Use SSIS (2005) or DTS (2000) to extract and load the data.

Or use BCP if you want too.

how much data are you moving, and whats the purpose of the move?

TheSQLGuru (2/17/2010)

---

sanketahir1985 (2/17/2010)

---

Hii

Do not change any configuration settings without having the root cause why RAM is getting utilized. ByDefault sql server uses available RAM.

2ndly run the perfmon in...

you could grant access to the sys.objects view or you could create your own view and give them access to that

something like this would do it.

select name

from...

Anamika (2/17/2010)

---

Hi All,

Thanks a lot for your inputs.

I'm working on those.

and i have installed performance dashboard reports to find out the time taking queries.

Once i find some significant...

Roy Ernest (2/3/2010)

---

PK is needed to identify which is row is being updated/inserted/deleted for Transactional and merge replication

I assume you know what snapshot replication is and why it does not...

what do you mean by a unique index? do you mean a unique key? show us the table schema and an example of a row that is duplicated....

Excellent. if anything goes wrong ill show my boss your post :-P;-)

Thanks for the link, ive just read through it and that appears to be a "how to" guide to raising the level, which im...

what exactly did you do to...

I assume you have either changed the service account to an account that doesnt exist, or you have the password wrong. Like the others said check the error logs...

Tara-1044200 (2/3/2010)

---

I dont think reindexing helped me because reindex will rebuild all indexes and my database grown instead of reclaiming space back.

Only 1 solution i see getting my space back...