harshalnag did this help you or did you do something different?

just a couple of basics; if the job starts but takes longer than 3 minutes to complete,the next scheduled job will not run, and the schedule will not resume until/...

awesome language skills, Aeterna; looks like it is Turkish.

My Google-fu was weak;

using google translator gave me this:

i think we'd...

here's my best guess;

if you are going to update the main table, you need to update it from the virtual table INSERTED, which might be joined to other tables...

easy...you just have to explicitly use the EXEC or EXECUTE command:

CREATE PROCEDURE MyProc (@tblname sysname)

AS

BEGIN

SET NOCOUNT ON

--ack! someone used this proc! send an email

--current incarnation of EmailEventSend has no parameters

EXEC...

yeah, pre-caffeine coding messes me up almost every day; I know how the little things can getcha.

glad you got it now!

at a minimum, you are missing the AS keyword:

CREATE MyProc

AS--buncha code

CREATE PROCEDURE [dbo].[EmailEventSend]

--Send Email Notification

AS

BEGIN

EXEC msdb.dbo.sp_send_dbmail

@profile_name='Basic',

@recipients='mike@somewhere.com',

...

Reminds me of the Monty Python "Is your name not Bruce" skit, where everyone was named Bruce, and they renamed newcomers to avoid confusion. Can't have a "Michael" running around...

easy to grab what you need; here's a better example:

select

parsename(convert(varchar,serverproperty ('productversion')),4) As T4,

parsename(convert(varchar,serverproperty ('productversion')),3) As T3,

parsename(convert(varchar,serverproperty ('productversion')),2) As T2,

parsename(convert(varchar,serverproperty ('productversion')),1) As...

i would use the PARSENAME function to return the 8/9/10:

select serverproperty ('productversion') --9.00.4035.00

select parsename(convert(varchar,serverproperty ('productversion')),4) --"9"

amalanto (2/25/2010)

---

Thank you sir.

Right now We have achieved by calling UDF.I want to know whether is it poassible through stored procedure.

Create Function dbo.Result(@TranId int)

Returns @t Table(@col1 varchar(10),@col2 Datetime)

Begin

Insert into...

amalanto in that case you have to create a table which will capture the results inside the stored procedure; so you need to know the structure and datatypes returned;something like...

i don't believe you can; the whole purpose of encryption is to hide the data....if the data was encrypted, but exposed as unencrypted in a view, it defeats the purpose,...

old post Joie; someone must have run a search and replied to the thread today; i last posted on this thread July of 2009;

i've had this happen to me too.

if you change your screen resolution to something smaller than it is currently(ie 800x600 if you are running 1024 x or higher), windows will...