Forum Replies Created

Viewing 15 posts - 31 through 45 (of 91 total)

  • RE: Tool to make charts/graphs from MSSQL ???

    "... similar to Excel ..."  why not Excel?  It's not free, but I think I know what you mean.  I've tried a few charting controls for .net, and ended up...

  • RE: Help on XML display...

    Hi Daniel,

    Are you using asp.net or just an html page?  If it's just html, I'm curious too then.  If it's like asp.net, you should be able to treat xml...

  • RE: DTS Question regarding Excel installation

    HRm, though you're error message doesn't indicate this to be the problem - is the path to the test.xls file relative to the server?  For example, if the test.xls resides...

  • RE: Access Remote SQL Server

    Open TCP 1433 on your home firewall, and UDP 1434.  On a side note; I'm not sure why the udp port wasn't mentioned, perhaps someone can enlighten me if opening...

  • RE: xp_smtp_sendmail Error 550 Relaying Prohibited

    stacenic said it all, but I just want to repeat the part about restricting access to an open smtp relay.  Make sure your network admin restricts SMTP relaying to only...

  • RE: What is this forum software

    Cool thanks.  Interesting to see asp.net forum software. 

  • RE: QOD 12/18/2003...

    I got it right! woohooo! I guessed, but I got it right!

  • RE: QOD 11/26

    quote:


    Though I have great respect for those who run this site, I often feel like I am playing "guess what's on my...

  • RE: QOD 11/26

    Not that I've tried it, but at the very least you cannot say that Personal Edition cannot be upgraded to Enterprise edition. If Personal edition can be upgraded to...

  • RE: QOD 2003-11-04

    More more more.. I never heard of this before. I was glad I answered correctly because I'd feel silly if I could really use this instead of writing...

  • RE: SQL Mail and Yukon, what do you want to see...

    I have generally the same gripes as everyone else. The only thing I mentioned I haven't seen listed here already is that I'd like the ability to send notifications...

  • RE: Upgrade 6.5 to 2000

    quote:


    Yes, I guess you can say that. But you can also look at it as SQL Server is trying to create this...

  • RE: SELECT from all tables in the database

    Yea, what dinner said. A union query is the way to go for this. Using sp_msforeachtable will return multiple recordsets - using a union query will return only...

  • RE: Database Size

    select sum(size) from master.dbo.sysaltfiles

    -or- for $5 more you can have the database names.

    select db_name(dbid), sum(size) from master.dbo.sysaltfiles group by dbid

    To add on to Steve's, try this: exec sp_msforeachdb '?.dbo.sp_helpfile'

    Edited by...

  • RE: Install with Terminal Services

    maybe it seems like a bad idea because if something happens like the machine locks up, blue screens on reboot, or if you don't have terminal services set to start...

Viewing 15 posts - 31 through 45 (of 91 total)