Yes, I set all the datacolumns to grab all related information which include application name and ClientProcessID which shows no pertenent data. However to verify (test scenario) I did run...

My resolution document may come in handy you should only need to complete steps 4 through 8 however... I make no claim that this will resolve your issue but...

MSSQL Server 2000 Performance Counter issues

Draft

Jbabington@hotmail.com

05-21-2004

Summary:

Noticed issues related to Performance counter displaying zeros on WIN 2000 Advanced...

I just started managing this server (and several others) and the Service Pack 3a Update was over the weekend... No errors during the service pack installation, All services restarted, I...

1. Are you allocating Dynamic Memory or Fixed memory Allocations ?
2. Why do you assume you have a memory leak ?
3. What version of MS SQL <including service packs>are you running?
4. Is HTT (hyper...

Though this doesn' cover field dependancies this still could provide assistance to you in mapping column values and data type issues...

-- Get columns by Table_Name

SELECT tab.name   Table_Name,

       col.name   Column_Name,

       col.colid ...

Well, since the Crystal Reports requirement was not made by me (Client requested) I have little or no choice to alter the development tool at this time. However the meeting...

James,

What I need to do is make the Crystal reports Mimic the look and Feel of a Full Application essentially. That is the target... When Mr. Bigwig see's the Reports he...

Stacenic,

Not quite what I had in mind but...that is one way and thanks for the rapid response...and for expedience I am gonna use yer suggestion

Jim Babington

Walden,

Both Frank and Stacenic gave options for changing the SA password but also “IF” the sa password has been abused in the past you may have DTS packages...

No problem on the response and thanks for the clarification on the memory allocation of 2GB.

I still would not allocate the full amount "Fixed" I would let the server...

Darek,

Tried several times to get the error you are getting and had no luck duplicating this. These Memory Settings are immediate.

On the flip side is there any reason you are...

Red-Gate SQL Compare is a great tool for such a great price, I agree that there are other tools in the same catagories as SQL Compare - Data Compare but...

Good Point Mark !

Jim Babington

In your target database if you are unconcerned with the connections and need to rapidly (can be dangerous and advantagious) you can

1.Kill All connections in the Target database

2. Set it...