Viewing 15 posts - 23,026 through 23,040 (of 39,823 total)
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...
July 20, 2009 at 12:04 pm
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...
July 20, 2009 at 12:01 pm
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.
July 20, 2009 at 11:38 am
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...
July 20, 2009 at 11:37 am
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...
July 20, 2009 at 11:22 am
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.
July 20, 2009 at 11:03 am
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...
July 20, 2009 at 10:21 am
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...
July 20, 2009 at 10:08 am
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...
July 20, 2009 at 10:06 am
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...
July 20, 2009 at 10:04 am
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...
July 20, 2009 at 10:04 am
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,...
July 20, 2009 at 9:54 am
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...
July 20, 2009 at 9:26 am
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...
July 20, 2009 at 9:22 am
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...
July 20, 2009 at 9:19 am
Viewing 15 posts - 23,026 through 23,040 (of 39,823 total)