Forum Replies Created

Viewing 15 posts - 23,026 through 23,040 (of 39,823 total)

  • RE: PASS or Class?

    This is my first time to Connections, so I can't answer. You might ping Brad McGehee from his blog and ask him.

    I think that most conferences have a lot of...

  • RE: Script to move all database data

    ApexDiff should allow you do generate a script you can give to people. SQLCompare does.

    The restore should allow you to restore to a different name and path with the MOVE...

  • RE: Connectivity issues

    Be sure you allow remote connections. This is disabled by default in some places.

    Also, check the firewall. That would be my guess that it's preventing TCP 1433 from coming through.

  • RE: Script to move all database data

    I'd really recommend you look at one of the compare tools out there. I work for Red Gate, but ApexSQL and other companies have similar tools.

    It's not that this is...

  • RE: PASS or Class?

    They do repeat some popular sessions at PASS on the last day, but no guarentee they'll be the ones you want. They record all sessions, and they offer some online...

  • RE: xp_cmdshell problems

    Very strange. I might look at the Process utility from sysinternals and see if you can get some clue about process might be stuck there.

  • RE: Selecting columns based on user input?

    I'd be curious to know what you decide to do and why. It's a good debate, and others can learn from this. If you have a blog, post it there...

  • RE: xp_cmdshell problems

    Be sure you log on as the SQL Agent account to check things. It's possible that there was a security difference.

    The other thing to look at is could the...

  • RE: PASS or Class?

    I'd say PASS, but get a list of questions on internals that you want to learn more about. Have a notepad, and ask a few of the experts or MS...

  • RE: What is the Use of On-Line Off-Line in ms sql.

    I use it for the same reasons, but I don't believe you can do this with tempdb.

    tempdb is used for all sorts of operations in databases. If you take tempdb...

  • RE: error timeout

    You would need to determine what queries are being run. This will be in the code or you can use Profiler to check what is happening.

    From there, try running that...

  • RE: How to specify a Port number for OLE Source

    This should either work, or not work. If it's intermittent, you likely have some network or resource issue.

    I'm not sure what most people use, but I've used this for years,...

  • RE: update trigger not updating across databases

    If it was security, I'd expect that it wouldn't update the original table and a rollback would occur. Is that what is happening?

    Also, I'd write it in case multiple rows...

  • RE: Selecting columns based on user input?

    You're not necessarily duplicating lots of code. You might dup some, but you're also separating out and abstracting the functions to do a specific thing. That's what's done in many...

  • RE: Certification High School

    The editorial covered a couple things, one is that "cheating" devalues the exams for everyone. It isn't doing a friend a favor, nor yourself.

    I don't have a problem with high...

Viewing 15 posts - 23,026 through 23,040 (of 39,823 total)