Check periodically if SQL server is running

Hi,

I have my SQL server installed and running on a windows 2003 server. Sometimes, the server stops unexpectedly. I want to know if there is any mechanism to alert as and when the SQL server or SQL server agent goes down.

I guess everything is a windows service. Can we have a mechanism to test this service from a script and send an alert mail when the server goes down? How can this be done from a script?

Thanks in advance

-SudhakarIf you have two servers, you could have each server send periodic commands to the other to see if they are awake.
Or you could schedule a job to e-mail you at regular intervals and when you don't get a notification you'd know something was wrong.

...or you could fix the f'ing server...|||set the services to autostart and you can use sp_procoption to send you an email everytime sql server restarts.

you ought to figure out why your server is stalling out though.|||You can also use EXECUTE xp_servicecontrol 'QueryState', 'SQLSERVERAGENT'|||I think you should kick the server, that would fix it

check if there is an existing SQL server installation

is there a way to check an SQL Server installation, i want to get the version and what edition the installed sql server is. thanks

Hi,

Try this.Hope this works for you.

select @.@.Version

(or)

exec xp_msver

both will get you about the details of installed product.

Regards,

Prashanthi

|||can you do this.. without actually connecting in the sql server?|||you can do by navigating through the Help-> About|||

You can check the Errorlog to know whats the version and edition of sql server if you dont want to connect to sql server......hope this helps

|||

Hi,

You can know about the details of your SQL Server Installation detais, like version, etc.. in registry editor. To locate the verion information navigate to the following path in your registry editor:

1. Click Start button select "Run" command and type "regedit"

2. Search the following key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer\CurrentVersion"

Or

You can also know your version by using "sqlcmd" utility.

1. In the command prompt, type "sqlcmd".

2. Type the following command exactly:

:exit(SELECT @.@.VERSION)

or

:exit(EXEC xp_msver)

I Hope it'll work. Please let me know If I m wrong.

Regards,

Kiran.Y

|||

Inaddition to what Kiran has said, you can execute the below query in sqlcmd to get the desired results...

select serverproperty('servername'),serverproperty('productversion'),serverproperty('edition'),serverproperty('productlevel')

Check if SQLXML 3.0 is installed

Hi all,
How can I check if SQLXML 3.0 is installed on a particular machine?
Thank you.
What do you want to do exactly? Do you want to check it visually or
programmatically?
Visually, you can look at Add Remove programs section. Programmatically,
simply check registry. There is a SqlXml folder in classes root. In SqlXml
folder, there is a "CurVer" key that will give you the version of SqlXml
installed on the system.
Bertan ARI
This posting is provided "AS IS" with no warranties, and confers no rights.
"Aram" <Aram@.discussions.microsoft.com> wrote in message
news:4EE8AEC5-DBED-4905-B448-82258B1796A3@.microsoft.com...
> Hi all,
> How can I check if SQLXML 3.0 is installed on a particular machine?
> Thank you.
|||I'll programmatically check the registry then.
Thank you.
Aram
"Bertan ARI [MSFT]" wrote:

> What do you want to do exactly? Do you want to check it visually or
> programmatically?
> Visually, you can look at Add Remove programs section. Programmatically,
> simply check registry. There is a SqlXml folder in classes root. In SqlXml
> folder, there is a "CurVer" key that will give you the version of SqlXml
> installed on the system.
> --
> Bertan ARI
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Aram" <Aram@.discussions.microsoft.com> wrote in message
> news:4EE8AEC5-DBED-4905-B448-82258B1796A3@.microsoft.com...
>
>

Check if SQLXML 3.0 is installed

Hi all,
How can I check if SQLXML 3.0 is installed on a particular machine?
Thank you.What do you want to do exactly? Do you want to check it visually or
programmatically?
Visually, you can look at Add Remove programs section. Programmatically,
simply check registry. There is a SqlXml folder in classes root. In SqlXml
folder, there is a "CurVer" key that will give you the version of SqlXml
installed on the system.
Bertan ARI
This posting is provided "AS IS" with no warranties, and confers no rights.
"Aram" <Aram@.discussions.microsoft.com> wrote in message
news:4EE8AEC5-DBED-4905-B448-82258B1796A3@.microsoft.com...
> Hi all,
> How can I check if SQLXML 3.0 is installed on a particular machine?
> Thank you.|||I'll programmatically check the registry then.
Thank you.
Aram
"Bertan ARI [MSFT]" wrote:

> What do you want to do exactly? Do you want to check it visually or
> programmatically?
> Visually, you can look at Add Remove programs section. Programmatically,
> simply check registry. There is a SqlXml folder in classes root. In SqlXml
> folder, there is a "CurVer" key that will give you the version of SqlXml
> installed on the system.
> --
> Bertan ARI
> This posting is provided "AS IS" with no warranties, and confers no rights
.
>
> "Aram" <Aram@.discussions.microsoft.com> wrote in message
> news:4EE8AEC5-DBED-4905-B448-82258B1796A3@.microsoft.com...
>
>sql

Check Database Integrity in Maintenance Plan not working in SQL Server 2005 SP2

I installed SQL Server 2005 Enterprise, then SP1 and then SP2, Maintenance Plan worked. But if I installed SQL Server 2005 Enterprise and then SP2 directly (skipping SP1), the Check Database Integrity in Maintenance Plan was not working. The error message is as follows:

Executed as user: Domain\SqlServiceAccount. Microsoft (R) SQL Server Execute Package Utility Version 9.00.3042.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 10:56:21 AM Could not load package "Maintenance Plans\Test Plan" because of error 0xC0014062. Description: The LoadFromSQLServer method has encountered OLE DB error code 0x80004005 (Login failed for user ''. The user is not associated with a trusted SQL Server connection.). The SQL statement that was issued has failed. Source: Started: 10:56:21 AM Finished: 10:56:21 AM Elapsed: 0.047 seconds. The package could not be loaded. The step failed.

Other tasks like Rebuild Index seem to be fine. SP2 is supposed to be inclusive. Does anyone have any ideas on why this is happening.

Thanks

E.G.

I've the same problem.

Here is the details:

Date 16-04-2007 02:00:01
Log Job History (Reindex Plan)

Step ID 1
Server LISSSQL01
Job Name Reindex Plan
Step Name Subplan_1
Duration 01:17:10
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0

Message
Executed as user: INTERNAL\lisa-ouadmin. Microsoft (R) SQL Server Execute Package Utility Version 9.00.3042.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 02:00:01 DTExec: The package execution returned DTSER_FAILURE (1). Started: 02:00:01 Finished: 03:17:06 Elapsed: 4624.2 seconds. The package execution failed. The step failed.

Does anyone know how to workarround this?

Regards,

Check Boxes

Typically we use the wingdings font to render check boxes.
Not everyone has wingdings installed so sometimes it fails.
We have also used images.
Got any other slick ways to do this?On Jul 9, 10:48 am, "SurferJoe" <Surfer...@.newsgroup.nospam> wrote:
> Typically we use the wingdings font to render check boxes.
> Not everyone has wingdings installed so sometimes it fails.
> We have also used images.
> Got any other slick ways to do this?
I've used the open and closed square brackets [ ] with a space or two
between.|||Hello Surfer,
You could use a Rectangle with solid border.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.

Charts Not showing in some machines

Hello I am using crystatl reports 8.5 and Visual Basic 6.0

I have created a set up with all assemblies and installed in some machines and found that in some machines the Charts created using Crystal reports were showing but for some Blank Crystal reports appearing.

One of the machine where the chart now showing is XP PRofessional.

Need help urgently

Thanks in advanceWhere you ever able to resolve the problem? I am also having the same problem and have been looking for a week to try and resolve it and have tried all sort.

Please can you help?|||I have no luck with that.
So i have moved to vb.net from vb6.0 and with .net you have no such problems.

Sorry i cannot help you.

thanks and regards
vimal

Character set, Sort Order, Unicode Collation

Please, a command/script to see how I installed my Sql
Server (Character set, Sort Order, Unicode Collation), I
was looking for them at Knowledge Base, but couldn't find
anything.
ThanksThis should do it:
select serverproperty('collation')
Regards,
Paul Ibison|||Hi,
Add on , Execute the below procedure to get the charecter set and sort
order. This procedure will work for all versions.
sp_helpsort
--
Thanks
Hari
MCDBA
"Robert Duval" <r.duval@.discussions.microsoft.com> wrote in message
news:1ddf001c45512$bfedc6e0$a601280a@.phx.gbl...
> Please, a command/script to see how I installed my Sql
> Server (Character set, Sort Order, Unicode Collation), I
> was looking for them at Knowledge Base, but couldn't find
> anything.
> Thanks

Character set, Sort Order, Unicode Collation

Please, a command/script to see how I installed my Sql
Server (Character set, Sort Order, Unicode Collation), I
was looking for them at Knowledge Base, but couldn't find
anything.
ThanksHi,
Add on , Execute the below procedure to get the charecter set and sort
order. This procedure will work for all versions.
sp_helpsort
Thanks
Hari
MCDBA
"Robert Duval" <r.duval@.discussions.microsoft.com> wrote in message
news:1ddf001c45512$bfedc6e0$a601280a@.phx
.gbl...
> Please, a command/script to see how I installed my Sql
> Server (Character set, Sort Order, Unicode Collation), I
> was looking for them at Knowledge Base, but couldn't find
> anything.
> Thanks

Character set, Sort Order, Unicode Collation

Please, a command/script to see how I installed my Sql
Server (Character set, Sort Order, Unicode Collation), I
was looking for them at Knowledge Base, but couldn't find
anything.
Thanks
Hi,
Add on , Execute the below procedure to get the charecter set and sort
order. This procedure will work for all versions.
sp_helpsort
Thanks
Hari
MCDBA
"Robert Duval" <r.duval@.discussions.microsoft.com> wrote in message
news:1ddf001c45512$bfedc6e0$a601280a@.phx.gbl...
> Please, a command/script to see how I installed my Sql
> Server (Character set, Sort Order, Unicode Collation), I
> was looking for them at Knowledge Base, but couldn't find
> anything.
> Thanks

Character Set (code page)

I have to test an application under a Greek version of Windows.
I heave installed Windows XP - Greek. The Greek characters appears OK in the application contros (edits), but Crystal Reports viewer continues showing U.S.English character set.
Please, does anybody know how to set Greek character set for the Crystal Reports?
Any clue should be very appreciated.
Thanks!I've got the same problem. :confused:|||Hey, crystalreportsgurus around the world, wake up!

Changing URL's for Reporting Services

I have installed reporting services by default into the default web site in
IIS. (I'm running Windows Server 2003) and need to move this to a branded
URL...Is my only option to uninstall/reinstall? I can take care of setting
IIS to the new URL...however what is the proper method of moving the Virtual
Directories that Reporting services installed.
Thanks
--
Report DeveloperHave you heard about the concept of URL rewriting?
You can use custom httpmodules or httphandlers to achieve you goal, or just
simply write custom web app's error 401 page.
"Matt" <Matt@.discussions.microsoft.com> wrote in message
news:F206573B-9F9A-437F-BA07-3C284F329137@.microsoft.com...
>I have installed reporting services by default into the default web site in
> IIS. (I'm running Windows Server 2003) and need to move this to a branded
> URL...Is my only option to uninstall/reinstall? I can take care of
> setting
> IIS to the new URL...however what is the proper method of moving the
> Virtual
> Directories that Reporting services installed.
> Thanks
> --
> Report Developer