Alert in Email !

Dear Professional,
I am using one extended stored procedure to send email from SQL Server. Now
the question is how can I email my self from SQL Server if CPU usage greater
than 30% or available memory greater than specific value,
Can any body guide me regarding that?
Thanks
Check into setting an Alert using Performance Monitor [Administrative
Tools], [Performance].
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Rogers" <naissani@.hotmail.com> wrote in message
news:u6gK5tjDHHA.3492@.TK2MSFTNGP02.phx.gbl...
> Dear Professional,
> I am using one extended stored procedure to send email from SQL Server.
> Now the question is how can I email my self from SQL Server if CPU usage
> greater than 30% or available memory greater than specific value,
> Can any body guide me regarding that?
> Thanks
>
|||First of all thanks for your reply, in the Action Tab there is a option to
execute any batch file, now I want to execute my sql server job through
this, is there any command available which I run through batch file that
will run one of SQL JOB.
Thanks and waiting for your reply.
"Arnie Rowland" <arnie@.1568.com> wrote in message
news:%238mI2%23mDHHA.4060@.TK2MSFTNGP03.phx.gbl...
> Check into setting an Alert using Performance Monitor [Administrative
> Tools], [Performance].
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
> You can't help someone get up a hill without getting a little closer to
> the top yourself.
> - H. Norman Schwarzkopf
>
> "Rogers" <naissani@.hotmail.com> wrote in message
> news:u6gK5tjDHHA.3492@.TK2MSFTNGP02.phx.gbl...
>
|||From a Batch file, you could use osql.exe (or sqlcmd.exe for 2005) and
EXECUTE sp_start_job.
Check in Books Online about osql/sqlcmd, and also about sp_start_job.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Rogers" <naissani@.hotmail.com> wrote in message
news:%238$%23RroDHHA.4060@.TK2MSFTNGP03.phx.gbl...
> First of all thanks for your reply, in the Action Tab there is a option to
> execute any batch file, now I want to execute my sql server job through
> this, is there any command available which I run through batch file that
> will run one of SQL JOB.
> Thanks and waiting for your reply.
>
> "Arnie Rowland" <arnie@.1568.com> wrote in message
> news:%238mI2%23mDHHA.4060@.TK2MSFTNGP03.phx.gbl...
>
|||Thanks, one last thing if you can help me out. I want to learn locking
machanism in dept in SQL Server but I can see so many definition, any
website you know that can explain the locking by practical query and in
detail?
Thanks
"Arnie Rowland" <arnie@.1568.com> wrote in message
news:emYZJ1oDHHA.1224@.TK2MSFTNGP04.phx.gbl...
> From a Batch file, you could use osql.exe (or sqlcmd.exe for 2005) and
> EXECUTE sp_start_job.
> Check in Books Online about osql/sqlcmd, and also about sp_start_job.
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
> You can't help someone get up a hill without getting a little closer to
> the top yourself.
> - H. Norman Schwarzkopf
>
> "Rogers" <naissani@.hotmail.com> wrote in message
> news:%238$%23RroDHHA.4060@.TK2MSFTNGP03.phx.gbl...
>

After re-installing SQL server, app did not work

For some reasons, I uninstalled and reinstalled SQL server in local pc. Now, none of my app is working. My pc is XP professional with sp2 and VS.NET is 2003.
I spent a couple of days but no luck. It drived me crazy!
Help!!!did you add the MACHINENAME/ASPNET user account to the db?|||In Web.config file, I use "sa" in connection string, do I need to add ASP.NET account?|||if you are using the useraccount "sa" to connect to the sql server then the user "sa" should have access to the database.

After installing reporting services Dev edition ASP does not work

I was running ThinSlicer a ASP application fine on my Windows 2000
professional workstation running SQL develeper edition. This was
running fine under IIS 5 until I installed reporting services developer
edition on the same Win 2k Professional running IIS 5 now thinslicer
does not work so is quite a few ASP applications I am not sure what
reporting services install as done to IIS that these other ASP
applications are stuffed.
I get the following error when I access Thinslicer now after installing
reporting services :
when I run
http://myworkstation/Thinslicer/Ts.asp
This was working fine before I installed reporting services not sure
what changes reporting services as done.
The page cannot be displayed
There is a problem with the page you are trying to reach and it cannot
be displayed.
----
Please try the following:
Click the Refresh button, or try again later.
Open the myworkstation home page, and then look for links to the
information you want.
HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services
----
Technical Information (for support personnel)
Error Type:
Microsoft VBScript runtime (0x800A01C2)
Wrong number of arguments or invalid property assignment: 'objTS.Cut'
/Thinslicer/ts.asp, line 81
Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; (R1 1.5); .NET CLR
1.1.4322)
Page:
GET /Thinslicer/ts.asp
Time:
Saturday, May 14, 2005, 6:57:19 PM
More information:
Microsoft SupportSounds like somehow the ThinSlicer components have become hidden from the
application. I don't know why this would happen, but if ThinSlicer came with
an installation program you could try running it again.
"karenmiddleol@.yahoo.com" wrote:
> I was running ThinSlicer a ASP application fine on my Windows 2000
> professional workstation running SQL develeper edition. This was
> running fine under IIS 5 until I installed reporting services developer
> edition on the same Win 2k Professional running IIS 5 now thinslicer
> does not work so is quite a few ASP applications I am not sure what
> reporting services install as done to IIS that these other ASP
> applications are stuffed.
> I get the following error when I access Thinslicer now after installing
> reporting services :
> when I run
> http://myworkstation/Thinslicer/Ts.asp
>
> This was working fine before I installed reporting services not sure
> what changes reporting services as done.
>
> The page cannot be displayed
> There is a problem with the page you are trying to reach and it cannot
> be displayed.
> ----
> Please try the following:
> Click the Refresh button, or try again later.
> Open the myworkstation home page, and then look for links to the
> information you want.
> HTTP 500.100 - Internal Server Error - ASP error
> Internet Information Services
> ----
> Technical Information (for support personnel)
> Error Type:
> Microsoft VBScript runtime (0x800A01C2)
> Wrong number of arguments or invalid property assignment: 'objTS.Cut'
> /Thinslicer/ts.asp, line 81
>
> Browser Type:
> Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; (R1 1.5); .NET CLR
> 1.1.4322)
> Page:
> GET /Thinslicer/ts.asp
> Time:
> Saturday, May 14, 2005, 6:57:19 PM
>
> More information:
> Microsoft Support
>

AES (128 bit block) : Can I use it?

If I've got a 64-bit OS such as Windows XP Professional x64 Edition running and I have the SQL Server 2005 Express Edition, is AES permittable or does TRIPLEDES still need to be used?

SQL Server 2005 does not support AES encryption on Windows XP. You can visit http://msdn2.microsoft.com/en-us/library/ms345262.aspx for more details.

-Raul Garcia

SDE/T

SQL Server Engine