Showing posts with label message. Show all posts
Showing posts with label message. Show all posts

Friday, March 30, 2012

Having SQL Profiler while SQL Express Installed

This is a multi-part message in MIME format.
--=_NextPart_000_0008_01C6B584.FD651AD0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Dear All,
Is it possible for me to have a SQL profiler install in my local while i = have running SQL Express in my machine?
Please advise, thank you.
--=_NextPart_000_0008_01C6B584.FD651AD0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Dear All,

Is it possible for me to have a SQL profiler install in my local = while i have running SQL Express in my machine?

Please advise, thank you.
--=_NextPart_000_0008_01C6B584.FD651AD0--This is a multi-part message in MIME format.
--=_NextPart_000_0034_01C6B540.6D9D7D50
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
If you have a copy of sql server and want to install the management =tools you can install them on a machine regardless of the edition of sql =server actually running on the machine. However, I haven't tried running =Profiler against SQL Express, but I don't see why you can't. But you'll =have to actually try that yourself.
Mark
"Connie" <yfchan@.kdu.edu.my> wrote in message =news:%23LrYcIUtGHA.1888@.TK2MSFTNGP03.phx.gbl...
Dear All,
Is it possible for me to have a SQL profiler install in my local while =i have running SQL Express in my machine?
Please advise, thank you.
--=_NextPart_000_0034_01C6B540.6D9D7D50
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

If you have a copy of sql server and =want to install the management tools you can install them on a machine =regardless of the edition of sql server actually running on the machine. However, I =haven't tried running Profiler against SQL Express, but I don't see why you can't. But =you'll have to actually try that yourself.
Mark
"Connie" wrote in message news:%23LrYcIUtGHA.=1888@.TK2MSFTNGP03.phx.gbl...
Dear All,

Is it possible for me to have a SQL profiler install in my =local while i have running SQL Express in my machine?

Please advise, thank you.

--=_NextPart_000_0034_01C6B540.6D9D7D50--sql

Wednesday, March 28, 2012

Having Problems Installing SQL Server 2005 Express

I am running WinXP Home edition, and I was trying to install SQL Server Express, but the error message is too vague for me fix. It says my computer lacks the "Service Pack Requirements" to run the software, but I'm afraid I don't know which service pack requirements the error is talking about. What Service Pack do I need to download?

Here is the report from the install:

System Configuration Check

- WMI Service Requirement (Success)

Messages

WMI Service Requirement

Check Passed

- MSXML Requirement (Success)

Messages

MSXML Requirement

Check Passed

- Operating System Minimum Level Requirement (Success)

Messages

Operating System Minimum Level Requirement

Check Passed

- Operating System Service Pack Level Requirement. (Error)

MessagesOperating System Service Pack Level Requirement.

The current operating system does not meet Service Pack level requirements for this SQL Server release. Install the most recent Service Pack from the Microsoft download center at http://go.microsoft.com/fwlink/?LinkId=50380, and then run SQL Server Setup again. For hardware and software requirements, see the readme file or SQL Server Books Online.

- SQL Server Edition Operating System Compatibility (Success)

Messages

SQL Server Edition Operating System Compatibility

Check Passed

- Minimum Hardware Requirement (Warning)

Messages

Minimum Hardware Requirement

The current system does not meet the recommended hardware requirements for this SQL Server release. For detailed hardware and software requirements, see the readme file or SQL Server Books Online.

- Pending Reboot Requirement (Success)

Messages

Pending Reboot Requirement

Check Passed

- Default Installation Path Permission Requirement (Success)

Messages

Default Installation Path Permission Requirement

Check Passed

- Internet Explorer Requirement (Success)

Messages

Internet Explorer Requirement

Check Passed

- COM Plus Catalog Requirement (Success)

Messages

COM Plus Catalog Requirement

Check Passed

- ASP.Net Version Registration Requirement (Success)

Messages

ASP.Net Version Registration Requirement

Check Passed

- Minimum MDAC Version Requirement (Success)

Messages

Minimum MDAC Version Requirement

Check Passed

- Edition Change Check (Success)

Messages

Edition Change Check

Check Passed

THe same requirements for Windows XP Professional applies to XP Home:

http://www.microsoft.com/sql/editions/express/sysreqs.mspx

YOu nedd SP2 in order to have the setup working.

HTH, Jens Suessmeyer.


http://www.sqlserver2005.de

|||I am having the same problem. But I have XP Professional SP2 installed. What more could I need?|||I don′t know if that also applies to the .NET Framework existance, because I already has it on my computers. But do you have .NET Framework installed (2.0) ?

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

I installed the Sp2 and problem resolved

Having Problems Installing SQL Server 2005 Express

I am running WinXP Home edition, and I was trying to install SQL Server Express, but the error message is too vague for me fix. It says my computer lacks the "Service Pack Requirements" to run the software, but I'm afraid I don't know which service pack requirements the error is talking about. What Service Pack do I need to download?

Here is the report from the install:

System Configuration Check

- WMI Service Requirement (Success)

Messages

WMI Service Requirement

Check Passed

- MSXML Requirement (Success)

Messages

MSXML Requirement

Check Passed

- Operating System Minimum Level Requirement (Success)

Messages

Operating System Minimum Level Requirement

Check Passed

- Operating System Service Pack Level Requirement. (Error)

MessagesOperating System Service Pack Level Requirement.

The current operating system does not meet Service Pack level requirements for this SQL Server release. Install the most recent Service Pack from the Microsoft download center at http://go.microsoft.com/fwlink/?LinkId=50380, and then run SQL Server Setup again. For hardware and software requirements, see the readme file or SQL Server Books Online.

- SQL Server Edition Operating System Compatibility (Success)

Messages

SQL Server Edition Operating System Compatibility

Check Passed

- Minimum Hardware Requirement (Warning)

Messages

Minimum Hardware Requirement

The current system does not meet the recommended hardware requirements for this SQL Server release. For detailed hardware and software requirements, see the readme file or SQL Server Books Online.

- Pending Reboot Requirement (Success)

Messages

Pending Reboot Requirement

Check Passed

- Default Installation Path Permission Requirement (Success)

Messages

Default Installation Path Permission Requirement

Check Passed

- Internet Explorer Requirement (Success)

Messages

Internet Explorer Requirement

Check Passed

- COM Plus Catalog Requirement (Success)

Messages

COM Plus Catalog Requirement

Check Passed

- ASP.Net Version Registration Requirement (Success)

Messages

ASP.Net Version Registration Requirement

Check Passed

- Minimum MDAC Version Requirement (Success)

Messages

Minimum MDAC Version Requirement

Check Passed

- Edition Change Check (Success)

Messages

Edition Change Check

Check Passed

THe same requirements for Windows XP Professional applies to XP Home:

http://www.microsoft.com/sql/editions/express/sysreqs.mspx

YOu nedd SP2 in order to have the setup working.

HTH, Jens Suessmeyer.


http://www.sqlserver2005.de

|||I am having the same problem. But I have XP Professional SP2 installed. What more could I need?|||I don′t know if that also applies to the .NET Framework existance, because I already has it on my computers. But do you have .NET Framework installed (2.0) ?

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

I installed the Sp2 and problem resolved

Having Problems Installing SQL Server 2005 Express

I am running WinXP Home edition, and I was trying to install SQL Server Express, but the error message is too vague for me fix. It says my computer lacks the "Service Pack Requirements" to run the software, but I'm afraid I don't know which service pack requirements the error is talking about. What Service Pack do I need to download?

Here is the report from the install:

System Configuration Check

- WMI Service Requirement (Success)

Messages

WMI Service Requirement

Check Passed

- MSXML Requirement (Success)

Messages

MSXML Requirement

Check Passed

- Operating System Minimum Level Requirement (Success)

Messages

Operating System Minimum Level Requirement

Check Passed

- Operating System Service Pack Level Requirement. (Error)

MessagesOperating System Service Pack Level Requirement.

The current operating system does not meet Service Pack level requirements for this SQL Server release. Install the most recent Service Pack from the Microsoft download center at http://go.microsoft.com/fwlink/?LinkId=50380, and then run SQL Server Setup again. For hardware and software requirements, see the readme file or SQL Server Books Online.

- SQL Server Edition Operating System Compatibility (Success)

Messages

SQL Server Edition Operating System Compatibility

Check Passed

- Minimum Hardware Requirement (Warning)

Messages

Minimum Hardware Requirement

The current system does not meet the recommended hardware requirements for this SQL Server release. For detailed hardware and software requirements, see the readme file or SQL Server Books Online.

- Pending Reboot Requirement (Success)

Messages

Pending Reboot Requirement

Check Passed

- Default Installation Path Permission Requirement (Success)

Messages

Default Installation Path Permission Requirement

Check Passed

- Internet Explorer Requirement (Success)

Messages

Internet Explorer Requirement

Check Passed

- COM Plus Catalog Requirement (Success)

Messages

COM Plus Catalog Requirement

Check Passed

- ASP.Net Version Registration Requirement (Success)

Messages

ASP.Net Version Registration Requirement

Check Passed

- Minimum MDAC Version Requirement (Success)

Messages

Minimum MDAC Version Requirement

Check Passed

- Edition Change Check (Success)

Messages

Edition Change Check

Check Passed

THe same requirements for Windows XP Professional applies to XP Home:

http://www.microsoft.com/sql/editions/express/sysreqs.mspx

YOu nedd SP2 in order to have the setup working.

HTH, Jens Suessmeyer.


http://www.sqlserver2005.de

|||I am having the same problem. But I have XP Professional SP2 installed. What more could I need?|||I don′t know if that also applies to the .NET Framework existance, because I already has it on my computers. But do you have .NET Framework installed (2.0) ?

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

I installed the Sp2 and problem resolved

Having problems deploying a report.

I am working with a MS 2005 SQL Server database. I have the following error message. A connection could not be made to the report server http://localhost/ReportServer. I am trying to develop these on a network server. Is this a configuration issue, that it is expecting this on the local machine.

Thanks!

Terry B

Hi,

are you sure that the user (which deploy the report) have access rights to the report server. You can administrate this under http://localhost/reports and then under security, there you must add the AD-user.

I hope this help.

|||

When I go on the internet and type in Http://localhost I receive a not found error message. It claims to be Under Construction and references the IIS Help. But other reports from the server do deploy and I cannot see them from either machine

Thanks!

Terry

|||

Hi,

when localhost the SQL-Reporting-Server is, you must take the url http://localhost/Reports! It is importen to give the subweb Reports to go to the administrationwebsite of the reporting server...

Friday, March 9, 2012

Hardware compatability

Does SQL Server Express Edition work with a Pentium M computer? When I downloaded it there was a message that it wasn't the proper hardware but everything else fits the requirements for an install.
Did you install .Net framework >2.0 and Wininstaler 3.0?

Which version your operational system is?|||I installed everything in the order that is directed by the SQL Server Express Edition site. When I installed SQL Server Express, it did install successfully on my desktop, which is a Pentium IV, Windows XP Professional machine. However, when installed on my laptop, a Pentium M, Windows XP Professional, machine, everything installed except for a warning sign which said the hardware is incompatible. In checking my properties section on My Computer, everything else matches the requirements for an install and I have enough hard drive space and RAM. That's why I was wondering if a Pentium M system will handle the SQL Server Express Edition install.|||What's the service pack instaled on your Windows ?|||Windows SP2
|||Which speed you CPU is?|||My system is:
Intel Pentium M
1.60GHz
590MHz
504 MB of Ram
19 GB hard drive space available

Hardware compatability

Does SQL Server Express Edition work with a Pentium M computer? When I downloaded it there was a message that it wasn't the proper hardware but everything else fits the requirements for an install.

Did you install .Net framework >2.0 and Wininstaler 3.0?

Which version your operational system is?|||

I installed everything in the order that is directed by the SQL Server Express Edition site. When I installed SQL Server Express, it did install successfully on my desktop, which is a Pentium IV, Windows XP Professional machine. However, when installed on my laptop, a Pentium M, Windows XP Professional, machine, everything installed except for a warning sign which said the hardware is incompatible. In checking my properties section on My Computer, everything else matches the requirements for an install and I have enough hard drive space and RAM. That's why I was wondering if a Pentium M system will handle the SQL Server Express Edition install.

Thanks for your help on this.

|||

What's the service pack instaled on your Windows ?

|||

Windows SP2

|||

Which speed you CPU is?

|||

My system is:
Intel Pentium M

1.60GHz

590MHz

504 MB of Ram

19 GB hard drive space available

Hardware compatability

Does SQL Server Express Edition work with a Pentium M computer? When I downloaded it there was a message that it wasn't the proper hardware but everything else fits the requirements for an install.

Did you install .Net framework >2.0 and Wininstaler 3.0?

Which version your operational system is?|||

I installed everything in the order that is directed by the SQL Server Express Edition site. When I installed SQL Server Express, it did install successfully on my desktop, which is a Pentium IV, Windows XP Professional machine. However, when installed on my laptop, a Pentium M, Windows XP Professional, machine, everything installed except for a warning sign which said the hardware is incompatible. In checking my properties section on My Computer, everything else matches the requirements for an install and I have enough hard drive space and RAM. That's why I was wondering if a Pentium M system will handle the SQL Server Express Edition install.

Thanks for your help on this.

|||

What's the service pack instaled on your Windows ?

|||

Windows SP2

|||

Which speed you CPU is?

|||

My system is:
Intel Pentium M

1.60GHz

590MHz

504 MB of Ram

19 GB hard drive space available

Friday, February 24, 2012

Handling a SQL Exceptions and Custom Error Messages

Hello guys,

I need some ideas on how to handle an exception or a user defined error message.

I have a procedure that creates a new user. Lets say if the e-mail address entered is already in use. What are some of the best practices for notifying the user that the e-mail address is already in use?

This is what I was thinking...

Solution #1
-----
My proc will raise an error with a message id that is great than 50000, then my DAL will recognize this is a user defined error and spit back to the user instead of trapping it.

Solution #2
-----
The proc should have an output param ( @.CreationStatus CHAR(1) ).
If the @.CreationStatus has a value for example "E", I will have lookup the value for "E" in my app and spit back that custom error message. I don't really like this option because it is too concrete.

What are some of the ways you deal with this situation?

Your suggestions are greatly appreciated.

Thank you!

You could return a @.status value with (0=success, 1= failure and an appropriate status message @.Statusmsg ( = 'Success' if @.status = 0, custom error message if @.status = 1)

From your application you could check the value in @.status and if its not 0, then display the message from @.statusmsg. You can handle this in a number of ways, It comes down to setting up one standard way of doing it across all procs and communicating with your team and documenting it so the same logic is followed across all procs.