Forum Replies Created

Viewing 15 posts - 33,286 through 33,300 (of 39,909 total)

  • RE: hyperlink in data table

    That appears to be a .NET and not a SQL error. I suspect you may need to insert it as <"http://...

    April 19, 2006 at 8:21 pm

    #633166

  • RE: Date Issues

    Since these will be static when this runs, I'd calcualte them and store the values in variables and then include the variables in this query.

    select @a = getdate()

    select * from...

    April 19, 2006 at 8:48 am

    #633068

  • RE: Converting a date

    Look at DATEPART and DATENAME in Books Online for hints on formatting.

    April 18, 2006 at 10:30 am

    #632899

  • RE: The Best Job

    Tobias,

    If you get there, call me. That sounds wonderful to me as well!

    April 17, 2006 at 8:09 pm

    #632876

  • RE: Tax Day

    Scott,

    Thanks for the clarification. I think it's a good idea, but one thing more to think about is that the IRS and associated schemes also employ a lot of people....

    April 17, 2006 at 4:57 pm

    #632853

  • RE: Tax Day

    I don't mean to imply I mind paying taxes. I don't want to pay more than I need to, but I love the US and am happy to support it.

    The...

    April 17, 2006 at 3:08 pm

    #632840

  • RE: Tax Day

    Thanks for the grammar notes , it was a long weekend.

    April 17, 2006 at 8:40 am

    #632768

  • RE: Hide DTS in EM from Users

    The Guest user has access to read tables in msdb, where the DTS packages are stored. You can remove the permissions to the stored procedures used to scan for the...

    April 17, 2006 at 8:39 am

    #632766

  • RE: DB Maintenance Plan

    Can you update the table?

    Doesn't look like the system procedures are really detailed.

    April 17, 2006 at 8:27 am

    #632760

  • RE: Copy tables to another server

    Interesting idea. Should work well for small datbases. I'd worry about larger ones.

    April 17, 2006 at 8:19 am

    #632759

  • RE: Not receiving newsletters

    Some of this is due to different advertisements or (yikes!) my editorials. Some filters work on keywords and catch the newsletters depending on content.

    We've had some get caught because articlesexternal.asp...

    April 13, 2006 at 9:47 am

    #632444

  • RE: Formating Email Body sent with xp_sendmail

    If you want hyperlinks, you need to include the entire HTML, meaning the <HTML><HEAD></HEAD><BODY> etc. tags in the message.

    April 13, 2006 at 9:21 am

    #632437

  • RE: The Database Debate

    Ha, Murphy comes with all electrical products, especially computers!

    April 13, 2006 at 9:16 am

    #632432

  • RE: The 36 Hour Day

    What's a verifiable source? The NY Times? MSNBC? c|Net? While I tend to agree that sources in blogs are less vetted than traditional publishing, that's not necessarily the case. Many...

    April 13, 2006 at 9:15 am

    #632431

  • RE: DBCC SHRINKFILE...

    Have you ever run a database log backup on this? How are you invoking the shrink?

    It can slow things but the shrink is an online operation that can be run...

    April 13, 2006 at 9:13 am

    #632430

Viewing 15 posts - 33,286 through 33,300 (of 39,909 total)