MS Word & XML
I heard a rumor that MS Word can open XML docs to a cetain degree. Can anyone confirm this? If so how?? Thanks Mark
2002-03-06
2 reads
Stored Procedures
Stopping unauthorised used start/stopping sqlserve
I have just started working with SQLserver 2000 and have been experimenting with it to get a feel for how it works. While playing with it I have found that if I have SQL server 2000 installed on two desktops in the same domain I can use Server Service Manager on each machine to stop […]
2002-03-06
Jobs fail on test server
I have set up a new test server and loaded the databases via backup/restore from our production server. I am encountering a problem with a particular job that will not run. The only difference between the servers is the production server is Win NT 4.0 SP6 and the test server is Windows 2000 Server SP2. […]
2002-03-06
2 reads
deleting Foriegn Keys
I set up triggers so that if I delete from the PK table the FK would delete and it is not working. Am I missing something? Please let me know. Ayisat Idris
2002-03-05
1 reads
Unconvential joins
I have a table which gathers measurements one / row asynchronically. That's why one column is datetime. Idnr is the primary key. If I want to know daily average period between inserts, I must use this kind of self-join (sorry,I'm in Oracle mode now, syntax differs slightly) SELECT t1.datetime,avg(t2.datetime-t1.datetime) FROM testresult t1, testresult t2 WHERE […]
2002-03-01
When and how do you move changes to production?
I'm wondering if there are better ways to make changes to a production environment than those I use. Seeing as I only have about 2 and a half years of experience with databases. For major rollouts of new features I create a script using the scripting feature of Enterprise Manager at the time they are […]
2002-02-15
153 reads
SQL Server Security Part 3
Comments posted to this topic are about the content posted at http://qa.sqlservercentral.com/columnists/ckempster/sqlserversecuritypart3.asp
2002-02-15
10 reads
Data Dictionary from within SQL Server 2000
Mindy explores the metadata stored in SQL 2000 to show you how to produce a simple and useful data dictionary!
2007-10-02 (first published: 2002-02-11)
36,116 reads
DTS Log is out of order
When my DTS package completes it writes an error log out to a path on the server. The problem is that the steps are out of order. It makes it very difficult to read. I went into disconnected edit and found that the steps were out of order there too, but it executes in the […]
2002-02-06
4 reads
The undocumented nature of sp_readerrorlog in SQL Server 2000
Sp_readerrorlog can read any file on the hard disk, not just error logs. Read on to learn how!
2002-02-05
1,157 reads
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers