Forum Replies Created

Viewing 15 posts - 421 through 435 (of 761 total)

  • RE: Database Mail Configuration

    anthony.green (5/17/2012)

    This will point you in the right direction if you dont have the traceflags enabled on your instances

    http://msdn.microsoft.com/en-us/library/ms186385.aspx

    Will need to refactor the job to send the mail, or get...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    May 17, 2012 at 11:00 pm

    #1489475

  • RE: Passing parameter Dynamically to Open Query inside Function

    ColdCoffee (5/17/2012)

    What is the original requirement?

    I was trying to Execute a Stored Procedure from inside a Function. This was not actually a Business Requirement. Just for learning purposes and to...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    May 17, 2012 at 10:59 pm

    #1489474

  • RE: Passing parameter Dynamically to Open Query inside Function

    No, Preetham.

    It doesn't work. It will just return the value of @res which in this case is "(Select * From OpenQuery(ABHI, @tmp))". It won't execute the Open Query. I actually...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    May 17, 2012 at 10:30 pm

    #1489467

  • RE: Database Mail Configuration

    anthony.green (5/17/2012)

    This will point you in the right direction if you dont have the traceflags enabled on your instances

    http://msdn.microsoft.com/en-us/library/ms186385.aspx

    Will need to refactor the job to send the mail, or get...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    May 17, 2012 at 2:16 am

    #1488828

  • RE: Database Mail Configuration

    Thanks Loundy.

    I'll give that a shot. 🙂

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    May 17, 2012 at 1:39 am

    #1488812

  • RE: Database Mail Configuration

    Thanks for the reply Joe.

    Yes, that was the problem. I was behind a Proxy which was blocking outbound SMTP.

    I finally got it working.

    I have another small question. Can I configure...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    May 16, 2012 at 11:07 pm

    #1488781

  • RE: Database Mail Configuration

    saidapurs (5/16/2012)

    Hi Vijay,

    You are using GMAIL SMTP, please use your company SMTP & test it....

    Regards

    Satish

    Doesn't Gmail SMTP work??....If I am behind a Proxy...I might need...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    May 16, 2012 at 1:04 am

    #1488189

  • RE: Daily Comulative Report in SQL Server

    Yes, Anthony. You are right.

    Just a few days back someone(a developer) was telling me that one can be a good developer if and only if he feels "the excitement" in...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    May 15, 2012 at 6:54 am

    #1487644

  • RE: Daily Comulative Report in SQL Server

    That's a very nice solution by Anthony. 🙂

    But, if you are not comfortable with PIVOT then you can use a simple CASE Statement like this:

    --Declaring Temporary Table

    declare @tab table (product...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    May 15, 2012 at 6:42 am

    #1487637

  • RE: ad hoc queries

    Different people may have different point of Views on this. But, from what I know:

    An AD-HOC Query is a query which is created on the fly, for a specific Non-Generalizable...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    May 15, 2012 at 6:25 am

    #1487632

  • RE: Need help to write query for the mentioned scenario in SQL Server 2008

    rakesh_itcvrce (5/15/2012)

    Thanks vinu512

    It works 🙂

    You're Welcome. I'm glad it helped You. 🙂

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    May 15, 2012 at 3:37 am

    #1487588

  • RE: Help on Select statement

    Eugene Elutin (5/14/2012)

    vinu512 (5/14/2012)

    Phil Parkin (5/14/2012)

    vinu512 (5/14/2012)

    tbabs25 (5/14/2012)

    Can anyone help me in coverting the output I am geting when a type in my select statement.

    I get a number in return...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    May 14, 2012 at 5:14 am

    #1487028

  • RE: Help on Select statement

    Phil Parkin (5/14/2012)

    vinu512 (5/14/2012)

    tbabs25 (5/14/2012)

    Can anyone help me in coverting the output I am geting when a type in my select statement.

    I get a number in return instead of data.

    select...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    May 14, 2012 at 4:47 am

    #1487022

  • RE: Calculations

    Following links might be useful to you:

    1. Calculating Quartile in SQL Server

    2. Inter Quartile Range

    If you manage to find out the NTile using the first link then IQR is going...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    May 14, 2012 at 4:44 am

    #1487018

  • RE: Login failed for SQL Agent account

    Error 50000 is a user-defined error.

    Look for the "RAISERROR()" and check what the code is around that and the conditions that will cause the error to fire.

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    May 14, 2012 at 4:31 am

    #1487011

Viewing 15 posts - 421 through 435 (of 761 total)