Viewing 15 posts - 106 through 120 (of 824 total)
Oops, I didn't notice that you did specify SQL 2000... Still, look under the extended stored procs.
February 21, 2007 at 4:37 pm
Look in Programability\Extended Stored Procedures\System Extended Stored Procedures.
February 21, 2007 at 4:35 pm
The most straightforward answer to your question is that XML is so popular because of ignorance.
At the risk of self promotion, I wrote an article on the subject several years...
February 20, 2007 at 10:34 am
"And I could represent the same data in a second hierarchy"
Thank you for making my point. In order to represent data stored in a hierarchical structure, in a different hierarchy,...
February 19, 2007 at 4:49 pm
Now there you go...
Alarms should go off when you say something like "not all data is best represented relationally." Semi structured data is an oxymoron. Granted, it is an...
February 19, 2007 at 2:37 pm
I can't imagine ever wanting to use the XML data type. The only time I'd ever store XML of any sort in the database is if there is some kind...
February 19, 2007 at 9:43 am
I don't believe there is a way to change the setting for the default trace. However, you can turn it off and then define your own custom trace. This would...
February 14, 2007 at 9:51 am
Nope, every installation of 2005 I've ever seen will return Disabled. In a way it kind of makes sense.
In SQL 2000 LicenseType was not always reliable and it never had...
February 13, 2007 at 2:37 pm
Like I said in SQL 2000 that would give you some indication of your license type, but it was not always correct. However, in SQL 2005, that query will always...
February 13, 2007 at 11:01 am
If there is a hack to change the default auditing file size or number, I haven't found it. However, you can certainly define your own trace. That's what I have...
February 12, 2007 at 10:25 am
Unfortunately Microsoft has gone from ugly to hideous in this area with 2005. 2000 used to give you some information about licensing model, although it was not terribly reliable. SQL...
February 12, 2007 at 10:16 am
Sorry for the delayed response, I haven't been getting my email notifications for a few days...
Anyway, that is a great link thanks.
I think you are correct in that the SQL...
February 6, 2007 at 12:44 pm
Call me naive, but I thought this is what a Primary Key was for...
February 6, 2007 at 7:50 am
Ummm... did you read the discussion threads? There has been quite a bit of discussion of the Read Committed Snapshot (RCS) isolation level that is new with 2005. This new...
January 30, 2007 at 4:02 pm
This may not be EXACT, but you launch the installer located in either the
\SQL Server Itanium\
\SQL Server x64\
or \SQL Server x86\
\tools\setup.exe
depending on your hardware. From there it should...
January 30, 2007 at 1:45 pm
Viewing 15 posts - 106 through 120 (of 824 total)