Forum Replies Created

Viewing 15 posts - 616 through 630 (of 757 total)

  • RE: Database Mirroring

    Thanks

    February 6, 2012 at 6:40 am

    #1443079

  • RE: Database Mirroring

    Perry Whittle (2/4/2012)

    yes, it is possible. Are you using the mirroring GUI or T-SQL?

    Thanks

    I'm using the GUI

    February 6, 2012 at 12:15 am

    #1442907

  • RE: Index Defrag Procedure - Michelle Ufford

    That has nothing to do with the procedure

    February 1, 2012 at 5:37 am

    #1441154

  • RE: SQL Alerts

    Thanks

    January 5, 2012 at 6:08 am

    #1428949

  • RE: SQL Alerts

    Ninja's_RGR'us (1/4/2012)

    derekr 43208 (1/4/2012)

    Ninja's_RGR'us (1/4/2012)

    Depends on what you call complete.

    I have a few jobs that save data to a perm table, then the last step of the job (no error...

    January 5, 2012 at 4:35 am

    #1428895

  • RE: SQL Alerts

    Ninja's_RGR'us (1/4/2012)

    Depends on what you call complete.

    I have a few jobs that save data to a perm table, then the last step of the job (no error exit path), you...

    January 4, 2012 at 8:00 am

    #1428332

  • RE: SQL Alerts

    MysteryJimbo (1/4/2012)

    Thats not possible from the job itself. I would create a stored procedure to do what you are after and include the results in an attachment using database...

    January 4, 2012 at 7:58 am

    #1428329

  • RE: Format a Percentage

    Try this

    DECLARE @Sales DECIMAL (18,2)

    DECLARE @Commission ...

    December 29, 2011 at 6:52 am

    #1426416

  • RE: Log Backup Sizes

    Thanks all

    December 28, 2011 at 12:29 am

    #1425963

  • RE: Send Messages from SQL SERVER

    mahesh.dasoni (12/22/2011)

    Create a operator & then go to job properties->Notification->select email when job succeeds.

    The poster wants to be notified in the event of the job finishing and when it fails,...

    December 22, 2011 at 3:27 am

    #1424671

  • RE: Send Messages from SQL SERVER

    SKYBVI (12/21/2011)

    first configure database mail

    then create a sql job

    inside job there is an option notifications

    write email id in that ...

    Regards,

    Skybvi

    Those options allow for send mail when job finishes or...

    December 21, 2011 at 5:57 am

    #1424170

  • RE: No repeatetion of names?

    alishaik001 (12/21/2011)

    My actual query is:

    here Name is the fieldName and Employee is the TableName;

    SELECT Name FROM Employee GROUP BY Name HAVING ( COUNT(Name) >= 1 );

    From this query I got...

    December 21, 2011 at 5:21 am

    #1424151

  • RE: No repeatetion of names?

    alishaik001 (12/21/2011)

    I get this by the following query:

    SELECT Column_Name FROM TableName GROUP BY Column_Name HAVING ( COUNT(Column_Name) >= 1 );

    Inbetween SELECT and Column_Name add the keyword DISTINCT - That should...

    December 21, 2011 at 5:13 am

    #1424147

  • RE: Send Messages from SQL SERVER

    Is Database Mail configured?

    December 21, 2011 at 5:05 am

    #1424140

  • RE: No repeatetion of names?

    SELECT DISTINCT

    December 21, 2011 at 5:02 am

    #1424139

Viewing 15 posts - 616 through 630 (of 757 total)