Create an email link within the report...

Hello...

I have a column of data on my report that contains an email address. Is it possible to format this so that the person running the report can just click on the link and have that action launch their email program...like Outlook?

thanks for any help

- will

Hi Will - Yes, you can use expressions to build "mailto:" URLs, and set these for the "jump to" value in the navigation tab for the field properties.

|||

Thanks for the reply and info...this worked great.

- will

CRAXDRT.Application.OpenReport - VERY slow

I have a CR 8.0 report that's been running against MySQL through VB6 for several years now, without ANY problems.

Just a few weeks ago we changed to new servers, and all my reports are running just fine, except one, which also happens to be the biggest (~2.9M). The report is running from a network drive, although I've tried it on a local drive with no real difference in perforamnce. Here's the code I'm using to open the report:

Dim cr As New CRAXDRT.Application
Dim report As CRAXDRT.report

Set report = cr.OpenReport(fName)

Again, nothing special. This has run quite well until now. The query itself that the report generates is quite large, but executes against the MySQL server in around .2 seconds, which isn't nearly the delay I'm seeing.

This call to OpenReport takes close to 20 seconds. I'm sure this has something to do with the server change, but without information, there isn't anything that I can do do fix it...

Any ideas?I forgot to add: The report runs very fast in the Crystal Report IDE.|||Dear ejj,

Have you by any chance found the solution yet ?

I'm experiencing exactly the same problem as you described. We recently migrated our NT4 domain to a WIN2003 domain (with some new servers) and after that some reports have become slow when calling the openreport function.

The only difference is that I'm using CR9 and the report is also opening slow in the CR Developer.

Best regards,
TheDaoka|||Dear ejj,

Have you by any chance found the solution yet ?

I'm experiencing exactly the same problem as you described. We recently migrated our NT4 domain to a WIN2003 domain (with some new servers) and after that some reports have become slow when calling the openreport function.

The only difference is that I'm using CR9 and the report is also opening slow in the CR Developer.

Best regards,
TheDaoka

Well, I fixed it, but never found what the problem was.

Thourgh trial and error I removed stuff from the report until it got faster. There was a subreport in the report that I deleted and the whole thing spead up. I then re-created the SAME subreport with the SAME query and magically everything got faster.

I can't explain it. Same database, same data, same schema, etc. But, it works now. :confused:|||Hi Ejj,

I just found this in the latest hotfixes for CR9:

ADAPT00212276 Patch ID: 35846238
Description:
When a report contains subreports that are imported through UNC paths, the report is slow to open when the network
connection is down.
Crystal Reports checks to see if the UNC pathname exists, before it checks to see if the user wants to re-import the
subreport. This causes an uncecessary delay in opening the report.
New Behavior:
The order of operations when opening a report is reversed: the new algorithm checks the pathname after the user
chooses to re-import.

-------------------

I have some reports with subreports which were imported from a server that no longer exists.

I installed the latest CR dll's and now it's back to normal.

Best regards,
TheDaoka|||TheDaoka -

Thanks for the information! Don't know why I never came across that in my search, but that sounds exactly like the problem I was having.

Glad you found it! Thanks!

Crashing server (Event ID 333)

Hello,
We experience problems with machines running SQL Servers 2005 in our
production environment. This problem is rather connected to OS or network
settings but hopefully someone here can help. The error below appears several
times in a minute and leads to crash of a machine.
We have clustered environment Windows Servers 2003 SP2 x64 + SQL Server 2005
SP2. This problem started to occur after installation of automatic updates
(bunch of security updates).
Has anyone solved similar issue? Could someone help to track down the problem?
Many thanks
eXavier
Event Type:Error
Event Source:Application Popup
Event Category:None
Event ID:333
Date:07.04.2008
Time:09:01:57
User:N/A
Computer:CMPNT45
Description:
An I/O operation initiated by the Registry failed unrecoverably. The
Registry could not read in, or write out, or flush, one of the files that
contain the system's image of the Registry.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 00 00 00 00 01 00 6c 00 .....l.
0008: 00 00 00 00 4d 01 00 c0 ...M..à
0010: 00 00 00 00 4d 01 00 c0 ...M..à
0018: 00 00 00 00 00 00 00 00 ......
0020: 00 00 00 00 00 00 00 00 ......
I am a consultant by trade and help people with SQL Server problems for a
living. But I gotta say when something like this occurs MY first action
would be (and my advice to my clients would be) call Microsoft PSS!!
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net
"eXavier" <eXavier@.nospam.nospam> wrote in message
news:70DC487A-4928-40E1-9DC0-59FB0AB1B5AB@.microsoft.com...
> Hello,
> We experience problems with machines running SQL Servers 2005 in our
> production environment. This problem is rather connected to OS or network
> settings but hopefully someone here can help. The error below appears
> several
> times in a minute and leads to crash of a machine.
> We have clustered environment Windows Servers 2003 SP2 x64 + SQL Server
> 2005
> SP2. This problem started to occur after installation of automatic updates
> (bunch of security updates).
> Has anyone solved similar issue? Could someone help to track down the
> problem?
> Many thanks
> eXavier
>
> Event Type: Error
> Event Source: Application Popup
> Event Category: None
> Event ID: 333
> Date: 07.04.2008
> Time: 09:01:57
> User: N/A
> Computer: CMPNT45
> Description:
> An I/O operation initiated by the Registry failed unrecoverably. The
> Registry could not read in, or write out, or flush, one of the files that
> contain the system's image of the Registry.
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
> Data:
> 0000: 00 00 00 00 01 00 6c 00 .....l.
> 0008: 00 00 00 00 4d 01 00 c0 ...M..
> 0010: 00 00 00 00 4d 01 00 c0 ...M..
> 0018: 00 00 00 00 00 00 00 00 ......
> 0020: 00 00 00 00 00 00 00 00 ......
>
|||Hello,
I agree with Kevin it's best taht you call MS PSS for memory dump analysis
on this server crash issue. For a complete list of Microsoft Product
Support Services phone numbers, please go to the following address on the
World Wide Web:
http://support.microsoft.com/directory/overview.asp
Also, you may want to use add/edit the following registry key to see if it
helps
In the new HKEY_LOCAL_MACHINE\System\CurrentControlSet\Contro l\Session
Manager\Configuration Manager subkey, configure the following entry:
Name: RegistryLazyFlushInterval
Data Type: REG_DWORD
Value data: 60 (decimal)
You may try to increase Windows paging file size to see if it's helpful.
It's possible that this kind of issue occurs when there are some issues
related to server hardware driver. For example, if the operating system
cannot satisfy the contiguous memory blocks under the 4 GB space, the
server may become unresponsive.
Reference the following HP site details:
http://h20000.www2.hp.com/bizsupport/TechSupport/Document.jsp?lang=en&cc=us&
objectID
=c00688313&jumpid=reg_R1002_USEN
Please let's know if you have any further questions or comments. Thanks.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up responske may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Hello,
It seems the problem was really caused by drivers for extra sotrage added
during maintenace period.
Thanks for all responses!
Best Regards
eXavier
""Peter Yang[MSFT]"" wrote:

> Hello,
> I agree with Kevin it's best taht you call MS PSS for memory dump analysis
> on this server crash issue. For a complete list of Microsoft Product
> Support Services phone numbers, please go to the following address on the
> World Wide Web:
> http://support.microsoft.com/directory/overview.asp
>
> Also, you may want to use add/edit the following registry key to see if it
> helps
> In the new HKEY_LOCAL_MACHINE\System\CurrentControlSet\Contro l\Session
> Manager\Configuration Manager subkey, configure the following entry:
> Name: RegistryLazyFlushInterval
> Data Type: REG_DWORD
> Value data: 60 (decimal)
> You may try to increase Windows paging file size to see if it's helpful.
> It's possible that this kind of issue occurs when there are some issues
> related to server hardware driver. For example, if the operating system
> cannot satisfy the contiguous memory blocks under the 4 GB space, the
> server may become unresponsive.
> Reference the following HP site details:
> http://h20000.www2.hp.com/bizsupport/TechSupport/Document.jsp?lang=en&cc=us&
> objectID
> =c00688313&jumpid=reg_R1002_USEN
> Please let's know if you have any further questions or comments. Thanks.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Community Support
> ==================================================
> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications
> <http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up responske may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> <http://msdn.microsoft.com/subscriptions/support/default.aspx>.
> ==================================================
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
|||Hello,
Nice to hear you solved the problem!
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
================================================== ===
When responding to posts, please "Reply to Group" via your
newsreader so that others may learn and benefit from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.

Crashing server (Event ID 333)

Hello,
We experience problems with machines running SQL Servers 2005 in our
production environment. This problem is rather connected to OS or network
settings but hopefully someone here can help. The error below appears several
times in a minute and leads to crash of a machine.
We have clustered environment Windows Servers 2003 SP2 x64 + SQL Server 2005
SP2. This problem started to occur after installation of automatic updates
(bunch of security updates).
Has anyone solved similar issue? Could someone help to track down the problem?
Many thanks
eXavier
Event Type: Error
Event Source: Application Popup
Event Category: None
Event ID: 333
Date: 07.04.2008
Time: 09:01:57
User: N/A
Computer: CMPNT45
Description:
An I/O operation initiated by the Registry failed unrecoverably. The
Registry could not read in, or write out, or flush, one of the files that
contain the system's image of the Registry.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 00 00 00 00 01 00 6c 00 .....l.
0008: 00 00 00 00 4d 01 00 c0 ...M..Ã?
0010: 00 00 00 00 4d 01 00 c0 ...M..Ã?
0018: 00 00 00 00 00 00 00 00 ......
0020: 00 00 00 00 00 00 00 00 ......I am a consultant by trade and help people with SQL Server problems for a
living. But I gotta say when something like this occurs MY first action
would be (and my advice to my clients would be) call Microsoft PSS!! :)
--
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net
"eXavier" <eXavier@.nospam.nospam> wrote in message
news:70DC487A-4928-40E1-9DC0-59FB0AB1B5AB@.microsoft.com...
> Hello,
> We experience problems with machines running SQL Servers 2005 in our
> production environment. This problem is rather connected to OS or network
> settings but hopefully someone here can help. The error below appears
> several
> times in a minute and leads to crash of a machine.
> We have clustered environment Windows Servers 2003 SP2 x64 + SQL Server
> 2005
> SP2. This problem started to occur after installation of automatic updates
> (bunch of security updates).
> Has anyone solved similar issue? Could someone help to track down the
> problem?
> Many thanks
> eXavier
>
> Event Type: Error
> Event Source: Application Popup
> Event Category: None
> Event ID: 333
> Date: 07.04.2008
> Time: 09:01:57
> User: N/A
> Computer: CMPNT45
> Description:
> An I/O operation initiated by the Registry failed unrecoverably. The
> Registry could not read in, or write out, or flush, one of the files that
> contain the system's image of the Registry.
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
> Data:
> 0000: 00 00 00 00 01 00 6c 00 .....l.
> 0008: 00 00 00 00 4d 01 00 c0 ...M..À
> 0010: 00 00 00 00 4d 01 00 c0 ...M..À
> 0018: 00 00 00 00 00 00 00 00 ......
> 0020: 00 00 00 00 00 00 00 00 ......
>|||Hello,
I agree with Kevin it's best taht you call MS PSS for memory dump analysis
on this server crash issue. For a complete list of Microsoft Product
Support Services phone numbers, please go to the following address on the
World Wide Web:
http://support.microsoft.com/directory/overview.asp
Also, you may want to use add/edit the following registry key to see if it
helps
In the new HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\Session
Manager\Configuration Manager subkey, configure the following entry:
Name: RegistryLazyFlushInterval
Data Type: REG_DWORD
Value data: 60 (decimal)
You may try to increase Windows paging file size to see if it's helpful.
It's possible that this kind of issue occurs when there are some issues
related to server hardware driver. For example, if the operating system
cannot satisfy the contiguous memory blocks under the 4 GB space, the
server may become unresponsive.
Reference the following HP site details:
http://h20000.www2.hp.com/bizsupport/TechSupport/Document.jsp?lang=en&cc=us&
objectID
=c00688313&jumpid=reg_R1002_USEN
Please let's know if you have any further questions or comments. Thanks.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up responske may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hello,
It seems the problem was really caused by drivers for extra sotrage added
during maintenace period.
Thanks for all responses!
Best Regards
eXavier
""Peter Yang[MSFT]"" wrote:
> Hello,
> I agree with Kevin it's best taht you call MS PSS for memory dump analysis
> on this server crash issue. For a complete list of Microsoft Product
> Support Services phone numbers, please go to the following address on the
> World Wide Web:
> http://support.microsoft.com/directory/overview.asp
>
> Also, you may want to use add/edit the following registry key to see if it
> helps
> In the new HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\Session
> Manager\Configuration Manager subkey, configure the following entry:
> Name: RegistryLazyFlushInterval
> Data Type: REG_DWORD
> Value data: 60 (decimal)
> You may try to increase Windows paging file size to see if it's helpful.
> It's possible that this kind of issue occurs when there are some issues
> related to server hardware driver. For example, if the operating system
> cannot satisfy the contiguous memory blocks under the 4 GB space, the
> server may become unresponsive.
> Reference the following HP site details:
> http://h20000.www2.hp.com/bizsupport/TechSupport/Document.jsp?lang=en&cc=us&
> objectID
> =c00688313&jumpid=reg_R1002_USEN
> Please let's know if you have any further questions or comments. Thanks.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Community Support
> ==================================================> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications
> <http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up responske may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> <http://msdn.microsoft.com/subscriptions/support/default.aspx>.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Hello,
Nice to hear you solved the problem!
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
=====================================================
When responding to posts, please "Reply to Group" via your
newsreader so that others may learn and benefit from this issue.
======================================================This posting is provided "AS IS" with no warranties, and confers no rights.

CR11 and ASP.NET (VS2003)

Hi there,
While running the report on the web we expect full error message to be displayed but instead whenever report fails CrystalReportViewer always say

Failed to retrieve data from the database. Details: [Database Vendor Code: 17001 ] Failed to retrieve data from the database

When I run this report in design mode I get correct error message that is returned from Sybase Stored procedure. "Invalid Parameter Value passed"

Is there anyway I can make CrystalReportViewer to display exact error message returned from SP?

Thanks a lot
GirishAnybody Know ? Please help
Girish

cpu quota / resource management

Hello *,

Is there a way to restrict resource consumption by user or connection?

If I execute some long running reports my complete server slowes down. I'd like to assign this reports only limited resources.

Thanks,

Michael

You can configure database mirroring for the target database in your production SQL instance and create snapshot on the mirror server (your backup SQL instnace) on different machine. The principle system can be considered as your normal OLTP business system and the mirror server can be used to support your reporting system. Since the reporting system will be run on differet SQL Server instance on different machine, it will not hurt your normal business onthe principle server. HTH|||Really your easy options are limited to setting query govenor which is time based not resource based.|||Thanks for the hint, "SET QUERY_GOVERNOR_COST_LIMIT" is useful in this context. Additional question:-
Is there a way to cancel running querries? For instance by issuing a "cancel" call from a seperate thread?

Thanks,
Michael

CPU messages in log

Running x64 AMD procs and receive the following types of messages in our SQL
log
The time stamp counter of CPU on scheduler id 3 is not synchronized with
other CPUs.
I have seen a lot of postings about this, but have not been lucky to stop
it.
Do we know what the latest is on this and what the actual fix is if any ?
ThanksSee http://support.microsoft.com/kb/931279
Linchi
"Hassan" wrote:
> Running x64 AMD procs and receive the following types of messages in our SQL
> log
> The time stamp counter of CPU on scheduler id 3 is not synchronized with
> other CPUs.
> I have seen a lot of postings about this, but have not been lucky to stop
> it.
> Do we know what the latest is on this and what the actual fix is if any ?
> Thanks
>
>|||See the workaround section of this article:
http://support.microsoft.com/kb/931279
HTH,
Plamen Ratchev
http://www.SQLStudio.com|||we tried those and they still pop up.
Have you guys used those workarounds and made them disappear ?
Its not annoying so far, but was curious to know.
"Plamen Ratchev" <Plamen@.SQLStudio.com> wrote in message
news:B633FD5B-849E-45AD-8F4A-6F1BADEC302A@.microsoft.com...
> See the workaround section of this article:
> http://support.microsoft.com/kb/931279
> HTH,
> Plamen Ratchev
> http://www.SQLStudio.com|||I have seen this happen only once on a development machine and disabling CPU
frequency variation in BIOS did the trick.
Plamen Ratchev
http://www.SQLStudio.com|||We never tried to make the messages go away since having the messages is a
minor annoyance. I probably won't try it unless the clock drift starts to
cause real problem for the SQL trace metrics.
Linchi
"Hassan" wrote:
> we tried those and they still pop up.
> Have you guys used those workarounds and made them disappear ?
> Its not annoying so far, but was curious to know.
> "Plamen Ratchev" <Plamen@.SQLStudio.com> wrote in message
> news:B633FD5B-849E-45AD-8F4A-6F1BADEC302A@.microsoft.com...
> > See the workaround section of this article:
> > http://support.microsoft.com/kb/931279
> >
> > HTH,
> >
> > Plamen Ratchev
> > http://www.SQLStudio.com
>
>

CPU is 99% used by sqlserver

Hi all ,
I have an issue hope you can help:
We have 1 server SQL server 2000 ( Small business )
running with a Pentiem 3 + 1 Go RAM. And we have only 3
Workstation like clients.
Since severals weeks, the CPU od the server is used for
99% and all client request using ACCESS is very slow.
Do you know what happened?
Thanks a lot for your help.
CanCan,
You need to monitor the CPU usage using perfmon counters concurrently
running sql profiler to see whats happening in the background.
--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"can" <canpama@.netscape.net> wrote in message
news:47c301c37616$eccb9970$a601280a@.phx.gbl...
> Hi all ,
> I have an issue hope you can help:
> We have 1 server SQL server 2000 ( Small business )
> running with a Pentiem 3 + 1 Go RAM. And we have only 3
> Workstation like clients.
> Since severals weeks, the CPU od the server is used for
> 99% and all client request using ACCESS is very slow.
> Do you know what happened?
> Thanks a lot for your help.
> Can
>|||Hi Dinesh ,
Thanks a lot to reply me . I visited your page , it is
nice and fun.
I have another question , i hope that you can help me.
My company has SQL Server 7 and clients using Access to
extract Data from Sql Server.
So my question is:
I would like to migrate all existing applications to Linus
Red Hat , i wonder if we can exporte all data to Postgress
or to My SQL or to DB2 ( Linux ) and i wonder if there are
the same product like ACCESS running with Linux:
Many thank.
Can
>--Original Message--
>Can,
>You need to monitor the CPU usage using perfmon counters
concurrently
>running sql profiler to see whats happening in the
background.
>--
>Dinesh.
>SQL Server FAQ at
>http://www.tkdinesh.com
>"can" <canpama@.netscape.net> wrote in message
>news:47c301c37616$eccb9970$a601280a@.phx.gbl...
>> Hi all ,
>> I have an issue hope you can help:
>> We have 1 server SQL server 2000 ( Small business )
>> running with a Pentiem 3 + 1 Go RAM. And we have only 3
>> Workstation like clients.
>> Since severals weeks, the CPU od the server is used for
>> 99% and all client request using ACCESS is very slow.
>> Do you know what happened?
>> Thanks a lot for your help.
>> Can
>>
>
>.
>|||Don't know if you've resolved this already...but I've had this happen on
several servers. It was a virus. I believe it was slammer. The
characteristics of it are similar. Rebooting would recover the CPU for a
while..but it would go back tying up the network, and locking up the server.
If you don't have an SA password...I would bet that it is slammer.
Gary
"can" <canpama@.netscape.net> wrote in message
news:47c301c37616$eccb9970$a601280a@.phx.gbl...
> Hi all ,
> I have an issue hope you can help:
> We have 1 server SQL server 2000 ( Small business )
> running with a Pentiem 3 + 1 Go RAM. And we have only 3
> Workstation like clients.
> Since severals weeks, the CPU od the server is used for
> 99% and all client request using ACCESS is very slow.
> Do you know what happened?
> Thanks a lot for your help.
> Can
>|||Can,
Thanks:)
>>to DB2
Try
INF: Configuring Data Sources for the Microsoft OLE DB Provider for DB2
http://www.support.microsoft.com/?id=218590
INF: Configuring Data Sources for the Microsoft OLE DB Provider for AS/400
and VSAM
http://www.support.microsoft.com/?id=219077
>>same product like ACCESS running with Linux:
Iam not aware about any.
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"can" <canpama@.netscape.net> wrote in message
news:3c1d01c3762a$9d2b7200$a301280a@.phx.gbl...
> Hi Dinesh ,
> Thanks a lot to reply me . I visited your page , it is
> nice and fun.
> I have another question , i hope that you can help me.
> My company has SQL Server 7 and clients using Access to
> extract Data from Sql Server.
> So my question is:
> I would like to migrate all existing applications to Linus
> Red Hat , i wonder if we can exporte all data to Postgress
> or to My SQL or to DB2 ( Linux ) and i wonder if there are
> the same product like ACCESS running with Linux:
> Many thank.
> Can
>
>
>
>
> >--Original Message--
> >Can,
> >
> >You need to monitor the CPU usage using perfmon counters
> concurrently
> >running sql profiler to see whats happening in the
> background.
> >
> >--
> >Dinesh.
> >SQL Server FAQ at
> >http://www.tkdinesh.com
> >
> >"can" <canpama@.netscape.net> wrote in message
> >news:47c301c37616$eccb9970$a601280a@.phx.gbl...
> >> Hi all ,
> >>
> >> I have an issue hope you can help:
> >>
> >> We have 1 server SQL server 2000 ( Small business )
> >> running with a Pentiem 3 + 1 Go RAM. And we have only 3
> >> Workstation like clients.
> >>
> >> Since severals weeks, the CPU od the server is used for
> >> 99% and all client request using ACCESS is very slow.
> >>
> >> Do you know what happened?
> >> Thanks a lot for your help.
> >> Can
> >>
> >>
> >
> >
> >.
> >

CPU 100%

Hi guys
My SQL Server 2000 SP3 have for no apparent reason begun running 100% cpu
and it does not drop off.
All the CPU is used by the SQLServer service.
Any ideas?
Thanks
Regards
Jonas
It seem to be our virus protection that triggered the SQLServer service to
use 100%CPU. Once virus protection was disabled CPU usage dropped to normal
level.
Regards
Jonas
"Jonas Larsen" <Jonas.Larsen@.Alcan.com> wrote in message
news:uF71v%238jEHA.704@.TK2MSFTNGP09.phx.gbl...
> Hi guys
> My SQL Server 2000 SP3 have for no apparent reason begun running 100% cpu
> and it does not drop off.
> All the CPU is used by the SQLServer service.
> Any ideas?
> Thanks
> Regards
> Jonas
>
>
|||check sysprocesses(nolock) order by cpu where status !='sleeping'
then dbcc inputbuffer(spid) find out what SQL is running.
"Jonas Larsen" wrote:

> Hi guys
> My SQL Server 2000 SP3 have for no apparent reason begun running 100% cpu
> and it does not drop off.
> All the CPU is used by the SQLServer service.
> Any ideas?
> Thanks
> Regards
> Jonas
>
>
|||Could you let me know what virus protection are you using? Also, operating
system and SQLServer details.
I ask because we're looking at installing virus protection and don't want
the same symptoms as you...
Thanks
|||Hi Griff
We use Trend Micro Office Scan. However this is the first time in more than
a year.
Regards
Jonas
"Griff" <Howling@.The.Moon> wrote in message
news:ue$ZfCAkEHA.2696@.TK2MSFTNGP10.phx.gbl...
> Could you let me know what virus protection are you using? Also,
operating
> system and SQLServer details.
> I ask because we're looking at installing virus protection and don't want
> the same symptoms as you...
> Thanks
>

CPU 100%

Hello
We have running our server-client application on line. The server Win2000
is showing (Tasks Administrator) use of CPU 100%. SQL Server (process
sqlservr.exe) is the great consumer of memory. I am afraid a collapse in
the server.
What do you suggest me to solve or to mitigate this matter?
THXS
Hello Harvey,
Are you still able to connect to SQL Server? If you can, connect to SQL
Server using Query Analzyer as a sysadmin. Execute the command 'sp_who2
active'. This will show you all the active connections in SQL Server.
That will give you an idea which connection(s) is consuming all the CPU
time.
I also recommend reviewing the following article on using Profiler and
Performance monitor to troubleshoot performance issue.
HOW TO: Troubleshoot Application Performance with SQL Server
http://support.microsoft.com/default...b;en-us;224587
Hope this helps.
Yih-Yoon Lee
Harvey Triana wrote:
> Hello
> We have running our server-client application on line. The server Win2000
> is showing (Tasks Administrator) use of CPU 100%. SQL Server (process
> sqlservr.exe) is the great consumer of memory. I am afraid a collapse in
> the server.
> What do you suggest me to solve or to mitigate this matter?
> THXS
>
|||Thanks Yih-
Saludos.
"Yih-Yoon Lee" <yihyoon.online@.gmail.com> escribi en el mensaje
news:%23dfb302%23EHA.2112@.TK2MSFTNGP14.phx.gbl...[vbcol=seagreen]
> Hello Harvey,
> Are you still able to connect to SQL Server? If you can, connect to SQL
> Server using Query Analzyer as a sysadmin. Execute the command 'sp_who2
> active'. This will show you all the active connections in SQL Server.
> That will give you an idea which connection(s) is consuming all the CPU
> time.
> I also recommend reviewing the following article on using Profiler and
> Performance monitor to troubleshoot performance issue.
> HOW TO: Troubleshoot Application Performance with SQL Server
> http://support.microsoft.com/default...b;en-us;224587
> Hope this helps.
> Yih-Yoon Lee
> Harvey Triana wrote:
|||"Harvey Triana" <harveytriana@.hotmail.com> wrote in
news:uauwev1#EHA.1564@.TK2MSFTNGP09.phx.gbl:

> Hello
> We have running our server-client application on line. The server
> Win2000 is showing (Tasks Administrator) use of CPU 100%. SQL Server
> (process sqlservr.exe) is the great consumer of memory. I am afraid a
> collapse in the server.
Run a trace to find out what SQL Server operations are running. Do you have
the likes of autoshrink on? Are you indexes correctly defined? Are
statistics upto date?
|||Also make sure you are on SP3 or better... If the proc is 100% consistently
( even with no users), that is an indicator of the slammer virus...
Otherwise, look for big queries as the others have suggested.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Harvey Triana" <harveytriana@.hotmail.com> wrote in message
news:uauwev1%23EHA.1564@.TK2MSFTNGP09.phx.gbl...
> Hello
> We have running our server-client application on line. The server Win2000
> is showing (Tasks Administrator) use of CPU 100%. SQL Server (process
> sqlservr.exe) is the great consumer of memory. I am afraid a collapse in
> the server.
> What do you suggest me to solve or to mitigate this matter?
> THXS
>
|||ok Wayne
...
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> escribi en el mensaje
news:ewix%23f9%23EHA.208@.TK2MSFTNGP12.phx.gbl...
> Also make sure you are on SP3 or better... If the proc is 100%
> consistently
> ( even with no users), that is an indicator of the slammer virus...
> Otherwise, look for big queries as the others have suggested.
>
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Harvey Triana" <harveytriana@.hotmail.com> wrote in message
> news:uauwev1%23EHA.1564@.TK2MSFTNGP09.phx.gbl...
>

CPU 100%

Hello
We have running our server-client application on line. The server Win2000
is showing (Tasks Administrator) use of CPU 100%. SQL Server (process
sqlservr.exe) is the great consumer of memory. I am afraid a collapse in
the server.
What do you suggest me to solve or to mitigate this matter?
THXSHello Harvey,
Are you still able to connect to SQL Server? If you can, connect to SQL
Server using Query Analzyer as a sysadmin. Execute the command 'sp_who2
active'. This will show you all the active connections in SQL Server.
That will give you an idea which connection(s) is consuming all the CPU
time.
I also recommend reviewing the following article on using Profiler and
Performance monitor to troubleshoot performance issue.
HOW TO: Troubleshoot Application Performance with SQL Server
http://support.microsoft.com/defaul...kb;en-us;224587
Hope this helps.
Yih-Yoon Lee
Harvey Triana wrote:
> Hello
> We have running our server-client application on line. The server Win2000
> is showing (Tasks Administrator) use of CPU 100%. SQL Server (process
> sqlservr.exe) is the great consumer of memory. I am afraid a collapse in
> the server.
> What do you suggest me to solve or to mitigate this matter?
> THXS
>|||Thanks Yih-
Saludos.
"Yih-Yoon Lee" <yihyoon.online@.gmail.com> escribi en el mensaje
news:%23dfb302%23EHA.2112@.TK2MSFTNGP14.phx.gbl...[vbcol=seagreen]
> Hello Harvey,
> Are you still able to connect to SQL Server? If you can, connect to SQL
> Server using Query Analzyer as a sysadmin. Execute the command 'sp_who2
> active'. This will show you all the active connections in SQL Server.
> That will give you an idea which connection(s) is consuming all the CPU
> time.
> I also recommend reviewing the following article on using Profiler and
> Performance monitor to troubleshoot performance issue.
> HOW TO: Troubleshoot Application Performance with SQL Server
> http://support.microsoft.com/defaul...kb;en-us;224587
> Hope this helps.
> Yih-Yoon Lee
> Harvey Triana wrote:|||"Harvey Triana" <harveytriana@.hotmail.com> wrote in
news:uauwev1#EHA.1564@.TK2MSFTNGP09.phx.gbl:

> Hello
> We have running our server-client application on line. The server
> Win2000 is showing (Tasks Administrator) use of CPU 100%. SQL Server
> (process sqlservr.exe) is the great consumer of memory. I am afraid a
> collapse in the server.
Run a trace to find out what SQL Server operations are running. Do you have
the likes of autoshrink on? Are you indexes correctly defined? Are
statistics upto date?|||Also make sure you are on SP3 or better... If the proc is 100% consistently
( even with no users), that is an indicator of the slammer virus...
Otherwise, look for big queries as the others have suggested.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Harvey Triana" <harveytriana@.hotmail.com> wrote in message
news:uauwev1%23EHA.1564@.TK2MSFTNGP09.phx.gbl...
> Hello
> We have running our server-client application on line. The server Win2000
> is showing (Tasks Administrator) use of CPU 100%. SQL Server (process
> sqlservr.exe) is the great consumer of memory. I am afraid a collapse in
> the server.
> What do you suggest me to solve or to mitigate this matter?
> THXS
>|||ok Wayne
...
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> escribi en el mensaje
news:ewix%23f9%23EHA.208@.TK2MSFTNGP12.phx.gbl...
> Also make sure you are on SP3 or better... If the proc is 100%
> consistently
> ( even with no users), that is an indicator of the slammer virus...
> Otherwise, look for big queries as the others have suggested.
>
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Harvey Triana" <harveytriana@.hotmail.com> wrote in message
> news:uauwev1%23EHA.1564@.TK2MSFTNGP09.phx.gbl...
>

CPU 100%

Hi guys
My SQL Server 2000 SP3 have for no apparent reason begun running 100% cpu
and it does not drop off.
All the CPU is used by the SQLServer service.
Any ideas?
Thanks
Regards
JonasIt seem to be our virus protection that triggered the SQLServer service to
use 100%CPU. Once virus protection was disabled CPU usage dropped to normal
level.
Regards
Jonas
"Jonas Larsen" <Jonas.Larsen@.Alcan.com> wrote in message
news:uF71v%238jEHA.704@.TK2MSFTNGP09.phx.gbl...
> Hi guys
> My SQL Server 2000 SP3 have for no apparent reason begun running 100% cpu
> and it does not drop off.
> All the CPU is used by the SQLServer service.
> Any ideas?
> Thanks
> Regards
> Jonas
>
>|||check sysprocesses(nolock) order by cpu where status !='sleeping'
then dbcc inputbuffer(spid) find out what SQL is running.
"Jonas Larsen" wrote:

> Hi guys
> My SQL Server 2000 SP3 have for no apparent reason begun running 100% cpu
> and it does not drop off.
> All the CPU is used by the SQLServer service.
> Any ideas?
> Thanks
> Regards
> Jonas
>
>|||Could you let me know what virus protection are you using? Also, operating
system and SQLServer details.
I ask because we're looking at installing virus protection and don't want
the same symptoms as you...
Thanks|||Hi Griff
We use Trend Micro Office Scan. However this is the first time in more than
a year.
Regards
Jonas
"Griff" <Howling@.The.Moon> wrote in message
news:ue$ZfCAkEHA.2696@.TK2MSFTNGP10.phx.gbl...
> Could you let me know what virus protection are you using? Also,
operating
> system and SQLServer details.
> I ask because we're looking at installing virus protection and don't want
> the same symptoms as you...
> Thanks
>

CPU 100%

Hello
We have running our server-client application on line. The server Win2000
is showing (Tasks Administrator) use of CPU 100%. SQL Server (process
sqlservr.exe) is the great consumer of memory. I am afraid a collapse in
the server.
What do you suggest me to solve or to mitigate this matter?
THXSHello Harvey,
Are you still able to connect to SQL Server? If you can, connect to SQL
Server using Query Analzyer as a sysadmin. Execute the command 'sp_who2
active'. This will show you all the active connections in SQL Server.
That will give you an idea which connection(s) is consuming all the CPU
time.
I also recommend reviewing the following article on using Profiler and
Performance monitor to troubleshoot performance issue.
HOW TO: Troubleshoot Application Performance with SQL Server
http://support.microsoft.com/default.aspx?scid=kb;en-us;224587
Hope this helps.
Yih-Yoon Lee
Harvey Triana wrote:
> Hello
> We have running our server-client application on line. The server Win2000
> is showing (Tasks Administrator) use of CPU 100%. SQL Server (process
> sqlservr.exe) is the great consumer of memory. I am afraid a collapse in
> the server.
> What do you suggest me to solve or to mitigate this matter?
> THXS
>|||Thanks Yih-
Saludos.
"Yih-Yoon Lee" <yihyoon.online@.gmail.com> escribió en el mensaje
news:%23dfb302%23EHA.2112@.TK2MSFTNGP14.phx.gbl...
> Hello Harvey,
> Are you still able to connect to SQL Server? If you can, connect to SQL
> Server using Query Analzyer as a sysadmin. Execute the command 'sp_who2
> active'. This will show you all the active connections in SQL Server.
> That will give you an idea which connection(s) is consuming all the CPU
> time.
> I also recommend reviewing the following article on using Profiler and
> Performance monitor to troubleshoot performance issue.
> HOW TO: Troubleshoot Application Performance with SQL Server
> http://support.microsoft.com/default.aspx?scid=kb;en-us;224587
> Hope this helps.
> Yih-Yoon Lee
> Harvey Triana wrote:
>> Hello
>> We have running our server-client application on line. The server
>> Win2000 is showing (Tasks Administrator) use of CPU 100%. SQL Server
>> (process sqlservr.exe) is the great consumer of memory. I am afraid a
>> collapse in the server.
>> What do you suggest me to solve or to mitigate this matter?
>> THXS|||"Harvey Triana" <harveytriana@.hotmail.com> wrote in
news:uauwev1#EHA.1564@.TK2MSFTNGP09.phx.gbl:
> Hello
> We have running our server-client application on line. The server
> Win2000 is showing (Tasks Administrator) use of CPU 100%. SQL Server
> (process sqlservr.exe) is the great consumer of memory. I am afraid a
> collapse in the server.
Run a trace to find out what SQL Server operations are running. Do you have
the likes of autoshrink on? Are you indexes correctly defined? Are
statistics upto date?|||Also make sure you are on SP3 or better... If the proc is 100% consistently
( even with no users), that is an indicator of the slammer virus...
Otherwise, look for big queries as the others have suggested.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Harvey Triana" <harveytriana@.hotmail.com> wrote in message
news:uauwev1%23EHA.1564@.TK2MSFTNGP09.phx.gbl...
> Hello
> We have running our server-client application on line. The server Win2000
> is showing (Tasks Administrator) use of CPU 100%. SQL Server (process
> sqlservr.exe) is the great consumer of memory. I am afraid a collapse in
> the server.
> What do you suggest me to solve or to mitigate this matter?
> THXS
>|||ok Wayne
...
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> escribió en el mensaje
news:ewix%23f9%23EHA.208@.TK2MSFTNGP12.phx.gbl...
> Also make sure you are on SP3 or better... If the proc is 100%
> consistently
> ( even with no users), that is an indicator of the slammer virus...
> Otherwise, look for big queries as the others have suggested.
>
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Harvey Triana" <harveytriana@.hotmail.com> wrote in message
> news:uauwev1%23EHA.1564@.TK2MSFTNGP09.phx.gbl...
>> Hello
>> We have running our server-client application on line. The server
>> Win2000
>> is showing (Tasks Administrator) use of CPU 100%. SQL Server (process
>> sqlservr.exe) is the great consumer of memory. I am afraid a collapse in
>> the server.
>> What do you suggest me to solve or to mitigate this matter?
>> THXS
>>
>

CPU 100%

Hi guys
My SQL Server 2000 SP3 have for no apparent reason begun running 100% cpu
and it does not drop off.
All the CPU is used by the SQLServer service.
Any ideas?
Thanks
Regards
JonasIt seem to be our virus protection that triggered the SQLServer service to
use 100%CPU. Once virus protection was disabled CPU usage dropped to normal
level.
Regards
Jonas
"Jonas Larsen" <Jonas.Larsen@.Alcan.com> wrote in message
news:uF71v%238jEHA.704@.TK2MSFTNGP09.phx.gbl...
> Hi guys
> My SQL Server 2000 SP3 have for no apparent reason begun running 100% cpu
> and it does not drop off.
> All the CPU is used by the SQLServer service.
> Any ideas?
> Thanks
> Regards
> Jonas
>
>|||check sysprocesses(nolock) order by cpu where status !='sleeping'
then dbcc inputbuffer(spid) find out what SQL is running.
"Jonas Larsen" wrote:
> Hi guys
> My SQL Server 2000 SP3 have for no apparent reason begun running 100% cpu
> and it does not drop off.
> All the CPU is used by the SQLServer service.
> Any ideas?
> Thanks
> Regards
> Jonas
>
>|||Could you let me know what virus protection are you using? Also, operating
system and SQLServer details.
I ask because we're looking at installing virus protection and don't want
the same symptoms as you...
Thanks|||Hi Griff
We use Trend Micro Office Scan. However this is the first time in more than
a year.
Regards
Jonas
"Griff" <Howling@.The.Moon> wrote in message
news:ue$ZfCAkEHA.2696@.TK2MSFTNGP10.phx.gbl...
> Could you let me know what virus protection are you using? Also,
operating
> system and SQLServer details.
> I ask because we're looking at installing virus protection and don't want
> the same symptoms as you...
> Thanks
>

CPU @ 100%

I have SQL 2000 and have been running it for quite some time without any
problems. A few days ago I have noticed that it seems to be using all the
available CPU and it really slowing down the server. I cant understand why
it is doing this.
I have tried stopping and starting and also restarting the computer but
nothing works.
Does anyone know how I could work out why it is doing this?It could be the slammer virus. Are you on sp3? Also, is it the SQL Server
process that is using 100% CPU?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Kris" <kris@.NOSPAMplanetsilicon.co.uk> wrote in message
news:c2v9kj$19u$1@.titan.btinternet.com...
> I have SQL 2000 and have been running it for quite some time without any
> problems. A few days ago I have noticed that it seems to be using all the
> available CPU and it really slowing down the server. I cant understand why
> it is doing this.
> I have tried stopping and starting and also restarting the computer but
> nothing works.
> Does anyone know how I could work out why it is doing this?
>

Counting GUID s

Is there a way to do a count on a guid in sql 2000, if I try I get an
error when running the query.
thanks for your help
pltaylor,
I know, this is a bogus restriction. Cast the column as a varchar(36).
select count(cast(MyGUID as varchar(36)))
from ...
-- Bill
<pltaylor3@.gmail.com> wrote in message
news:1173896580.729093.117070@.d57g2000hsg.googlegr oups.com...
> Is there a way to do a count on a guid in sql 2000, if I try I get an
> error when running the query.
> thanks for your help
>
|||pltaylor,
I know, this is a bogus restriction. Cast the column as a varchar(36).
select count(cast(MyGUID as varchar(36)))
from ...
-- Bill
<pltaylor3@.gmail.com> wrote in message
news:1173896580.729093.117070@.d57g2000hsg.googlegr oups.com...
> Is there a way to do a count on a guid in sql 2000, if I try I get an
> error when running the query.
> thanks for your help
>

Counting GUID s

Is there a way to do a count on a guid in sql 2000, if I try I get an
error when running the query.
thanks for your helppltaylor,
I know, this is a bogus restriction. Cast the column as a varchar(36).
select count(cast(MyGUID as varchar(36)))
from ...
-- Bill
<pltaylor3@.gmail.com> wrote in message
news:1173896580.729093.117070@.d57g2000hsg.googlegroups.com...
> Is there a way to do a count on a guid in sql 2000, if I try I get an
> error when running the query.
> thanks for your help
>|||pltaylor,
I know, this is a bogus restriction. Cast the column as a varchar(36).
select count(cast(MyGUID as varchar(36)))
from ...
-- Bill
<pltaylor3@.gmail.com> wrote in message
news:1173896580.729093.117070@.d57g2000hsg.googlegroups.com...
> Is there a way to do a count on a guid in sql 2000, if I try I get an
> error when running the query.
> thanks for your help
>

Counting GUID s

Is there a way to do a count on a guid in sql 2000, if I try I get an
error when running the query.
thanks for your helppltaylor,
I know, this is a bogus restriction. Cast the column as a varchar(36).
select count(cast(MyGUID as varchar(36)))
from ...
-- Bill
<pltaylor3@.gmail.com> wrote in message
news:1173896580.729093.117070@.d57g2000hsg.googlegroups.com...
> Is there a way to do a count on a guid in sql 2000, if I try I get an
> error when running the query.
> thanks for your help
>|||pltaylor,
I know, this is a bogus restriction. Cast the column as a varchar(36).
select count(cast(MyGUID as varchar(36)))
from ...
-- Bill
<pltaylor3@.gmail.com> wrote in message
news:1173896580.729093.117070@.d57g2000hsg.googlegroups.com...
> Is there a way to do a count on a guid in sql 2000, if I try I get an
> error when running the query.
> thanks for your help
>