Viewing 15 posts - 451 through 465 (of 595 total)
I think this question could have been worded better. My answer was "incorrect" because I read the question in the context of a stored procedure, which can use OUTPUT to...
June 24, 2007 at 6:56 am
Here's a bit of trivia - Katmai was Intel's code name for the original Pentium III processor. You'd think that somebody at MS would have known that
June 21, 2007 at 8:17 am
In Access, right-click on any linked table and then click Linked Table Manager. Check-mark the bad tables and click OK. This will refresh the links. You don't need to delete and...
June 21, 2007 at 7:01 am
Are ADT's compatible with the current release of Visual Studio .NET?
A couple years ago I had done some C# programming with .NET 2003 and a SS2000 db that used UDT's...
June 19, 2007 at 9:13 am
I cannot agree with Steve's original comment about Microsoft being "transparent".
I have a Vista test PC that runs Windows Defender, which supposedly seeks out tracking cookies & other such nasties....
June 4, 2007 at 9:55 am
This sounds more like an OS-level issue, not a SQL Server issue. There are two products you could try, might shed some light on things:
Belarc Advisor http://www.belarc.com/free_download.html can show all...
June 3, 2007 at 9:54 pm
Sure, they're the dominant IT company now that they've achieved their long-awaited monopoly status. But much of what comes out them is pure marketing hype. Any MS Partner can verify...
June 3, 2007 at 9:15 pm
Slightly off-topic...
Still trying to turn off the Vista sync center, because it still wants to sync "SQL Server 2000" (the exe, not the databases, which I suppose might make sense,...
June 3, 2007 at 1:51 pm
Just go to http://wvmitchell.blogspot.com/ and in the SEARCH BLOG box type
backup restore
and you'll see both versions explained a little better. I just woke up from my Saturday nap 😮 still...
June 2, 2007 at 5:04 pm
Maybe this will help. I am using a dumpdevice named par_pos_1, instead of using the file name method, but here are my two versions:
(both versions start out like this)
June 2, 2007 at 4:51 pm
Good article, and a great discussion. But let's not forget that performance should not be the only criterion - your code needs to be maintainable and extensible. Using temp tables...
June 2, 2007 at 6:25 am
If you install the original Sql 2000, then apply SP3 you will see a series of dialogs like "running script x of 11" so perhaps Sql 2005 is doing a similar...
June 1, 2007 at 9:28 am
If anybody is still watching this topic, here's another $0.02 worth.
I believe that there are far more secret little versions of Sql 2005 than simply RTM, SP1, SP2, and SP2a.
When...
May 31, 2007 at 8:37 pm
That's too funny. I once dated a girl who ate like that. It was simply how she was raised.
May 31, 2007 at 7:53 am
According to the BOL, when you run RESTORE DATABASE using the NORECOVERY option, it will not roll back any uncommitted transactions and permit you to run a RESTORE LOG to apply the...
May 27, 2007 at 10:01 am
Viewing 15 posts - 451 through 465 (of 595 total)