http://www.sqlmag.com/authors/author/author/5777317/rsscomment/5777317en-USFri, 25 May 2012 08:33:42 GMTFri, 25 May 2012 08:33:42 GMThttp://www.sqlmag.com/article/ole-db/microsoft-proceeds-with-data-mining-and-knowledge-management#commentsAnchorSun, 06 May 2012 09:53:07 GMT
could you please suggest me prerequisites for learning data mining effectively... please mail as soon as possible...]]>dipaliSun, 06 May 2012 09:53:07 GMThttp://www.sqlmag.com/article/ole-db/microsoft-proceeds-with-data-mining-and-knowledge-management#commentsAnchorhttp://www.sqlmag.com/article/business-intelligence/trends-insights-thinking-outside-the-box#commentsAnchorTue, 04 Dec 2007 05:13:40 GMT
I don’t hear to much about Knowledge management today. Perhaps it’s overcome by DW and BI, perhaps it’s just too complex to be implemented nowadays. But for sure, it’s a great field to research.]]>MarcosTue, 04 Dec 2007 05:13:40 GMThttp://www.sqlmag.com/article/business-intelligence/trends-insights-thinking-outside-the-box#commentsAnchorhttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server4720#commentsAnchorTue, 06 Mar 2007 14:43:01 GMT
helpful]]>rknelsenTue, 06 Mar 2007 14:43:01 GMThttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server4720#commentsAnchorhttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server7612#commentsAnchorWed, 16 Nov 2005 14:14:57 GMT
If you want to run DTS from Access save the DTS script and paste it into an Access module. By changing the appropriate variables it is easy to run a DTS process automatically by starting Access with the scheduler, run the module from the on_load event of the startup form and checking a persistance table in your database to see if the process has been run for the appropriate period.]]>JamesWed, 16 Nov 2005 14:14:57 GMThttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server7612#commentsAnchorhttp://www.sqlmag.com/article/odbc/questions-answers-and-tips-about-sql-server491#commentsAnchorFri, 09 Sep 2005 04:10:23 GMT
how can i assign a value to a local variable dynamically. can u give me a example also]]>Anonymous User Fri, 09 Sep 2005 04:10:23 GMThttp://www.sqlmag.com/article/odbc/questions-answers-and-tips-about-sql-server491#commentsAnchorhttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server7953#commentsAnchorSun, 22 May 2005 02:51:25 GMT
sir, we have foxpro data, and we are try to use sql server 2000. while we use dts on windows 2000 profession no proble encounters. but using the same in xp multimedia center and windows 2003 server it show the field ’rn01’ db_numeric error. and i cannot able to convert. Please help. my email id ismail_tce@yahoo.co.in]]>Anonymous User Sun, 22 May 2005 02:51:25 GMThttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server7953#commentsAnchorhttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server4536#commentsAnchorThu, 19 May 2005 02:55:33 GMT
i am not getting sql prompt on win98 of desktop edition 7.0 ]]>Anonymous User Thu, 19 May 2005 02:55:33 GMThttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server4536#commentsAnchorhttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server7225#commentsAnchorTue, 10 May 2005 21:18:36 GMT
Very helpful with regards to copying DB Diagrams, however I still can’t do it from server to another server. This will work great when copy DB Diagrams from DB to DB in same server. How can I do that from a DB of Server1 to DB of Server2?]]>Anonymous User Tue, 10 May 2005 21:18:36 GMThttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server7225#commentsAnchorhttp://www.sqlmag.com/article/windows-client/questions-answers-and-tips-about-sql-server492#commentsAnchorWed, 27 Apr 2005 23:37:35 GMT
SELECT MAX(SAL) FROM EMP WHERE SAL != (select MAX(SAL) from emp)]]>Anonymous User Wed, 27 Apr 2005 23:37:35 GMThttp://www.sqlmag.com/article/windows-client/questions-answers-and-tips-about-sql-server492#commentsAnchorhttp://www.sqlmag.com/article/product-review/db2-does-data#commentsAnchorWed, 06 Apr 2005 20:29:40 GMT
Keep it up to date.]]>Anonymous User Wed, 06 Apr 2005 20:29:40 GMThttp://www.sqlmag.com/article/product-review/db2-does-data#commentsAnchorhttp://www.sqlmag.com/article/internet/questions-answers-and-tips-about-sql-server3776#commentsAnchorWed, 23 Mar 2005 09:55:35 GMT
How can I count the number of rows in a BCP file?]]>Anonymous User Wed, 23 Mar 2005 09:55:35 GMThttp://www.sqlmag.com/article/internet/questions-answers-and-tips-about-sql-server3776#commentsAnchorhttp://www.sqlmag.com/article/windows-client/questions-answers-and-tips-about-sql-server492#commentsAnchorTue, 22 Feb 2005 20:20:03 GMT
I have a table Employee, in that have a column name Salary, I want to retrieve second maximum salary in single select statement without using a sub query in it. Can you please guide me, whether it is possible or not if its how. thanks ]]>Anonymous User Tue, 22 Feb 2005 20:20:03 GMThttp://www.sqlmag.com/article/windows-client/questions-answers-and-tips-about-sql-server492#commentsAnchorhttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server4762#commentsAnchorMon, 21 Feb 2005 14:10:34 GMT
How does sql server store null value in text data type column? I have to use like ’NULL%’ to retreive this column from the database using quary analyzer. ]]>Anonymous User Mon, 21 Feb 2005 14:10:34 GMThttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server4762#commentsAnchorhttp://www.sqlmag.com/article/windows-client/questions-answers-and-tips-about-sql-server3604#commentsAnchorFri, 18 Feb 2005 23:38:33 GMT
It seems that it took out replaced the two single quotation marks with one. Let me try again: Jim’s shoe becomes Jim’ ’s shoe]]>Anonymous User Fri, 18 Feb 2005 23:38:33 GMThttp://www.sqlmag.com/article/windows-client/questions-answers-and-tips-about-sql-server3604#commentsAnchorhttp://www.sqlmag.com/article/windows-client/questions-answers-and-tips-about-sql-server3604#commentsAnchorFri, 18 Feb 2005 23:36:31 GMT
Replace all the single quotation mark (’) in the string with two single quotation marks in a row (’). Ex: Jim’s shoe becomes Jim’s shoe. ]]>Anonymous User Fri, 18 Feb 2005 23:36:31 GMThttp://www.sqlmag.com/article/windows-client/questions-answers-and-tips-about-sql-server3604#commentsAnchorhttp://www.sqlmag.com/article/ole-db/questions-answers-and-tips-about-sql-server494#commentsAnchorTue, 15 Feb 2005 00:38:32 GMT
suppose i have two or more identical (values are same) rows in a table ,then if i want to delete only one row from that table keeping other identical rows intact then what should i do in sql 7.0? ]]>Anonymous User Tue, 15 Feb 2005 00:38:32 GMThttp://www.sqlmag.com/article/ole-db/questions-answers-and-tips-about-sql-server494#commentsAnchorhttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server4536#commentsAnchorFri, 28 Jan 2005 09:09:20 GMT
I am getting connection errors when creating a profile from Power Builder 6.5 to SQL Server 2000 Can any one did this. Please help]]>Anonymous User Fri, 28 Jan 2005 09:09:20 GMThttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server4536#commentsAnchorhttp://www.sqlmag.com/article/windows-client/questions-answers-and-tips-about-sql-server492#commentsAnchorSun, 23 Jan 2005 00:00:30 GMT
hi, how to know BCP(bulk copy of MS SQL server) status as success or failure?.how to know directly and how to know via java program?]]>Anonymous User Sun, 23 Jan 2005 00:00:30 GMThttp://www.sqlmag.com/article/windows-client/questions-answers-and-tips-about-sql-server492#commentsAnchorhttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server4720#commentsAnchorWed, 05 Jan 2005 08:04:23 GMT
Good document]]>Anonymous User Wed, 05 Jan 2005 08:04:23 GMThttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server4720#commentsAnchorhttp://www.sqlmag.com/article/windows-client/questions-answers-and-tips-about-sql-server#commentsAnchorWed, 15 Dec 2004 23:29:26 GMT
i need a sql query to find whether a particular column contains both values(fire,mh) not any one ]]>Anonymous User Wed, 15 Dec 2004 23:29:26 GMThttp://www.sqlmag.com/article/windows-client/questions-answers-and-tips-about-sql-server#commentsAnchorhttp://www.sqlmag.com/article/odbc/questions-answers-and-tips-about-sql-server491#commentsAnchorThu, 25 Nov 2004 00:00:29 GMT
how can we connect a table in tempdb in multiuser environment ?]]>Anonymous User Thu, 25 Nov 2004 00:00:29 GMThttp://www.sqlmag.com/article/odbc/questions-answers-and-tips-about-sql-server491#commentsAnchorhttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server5044#commentsAnchorMon, 22 Nov 2004 03:59:51 GMT
can you tell who runs fastest in the group? ]]>Anonymous User Mon, 22 Nov 2004 03:59:51 GMThttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server5044#commentsAnchorhttp://www.sqlmag.com/article/odbc/questions-answers-and-tips-about-sql-server3103#commentsAnchorThu, 21 Oct 2004 07:03:20 GMT
Regarding modifying sysstat column in sysobjects. I’m OK with modifying system table. But it is a computed column. How do you get around the error that a computed column is not allowed to be modified?]]>Richard Ding Thu, 21 Oct 2004 07:03:20 GMThttp://www.sqlmag.com/article/odbc/questions-answers-and-tips-about-sql-server3103#commentsAnchorhttp://www.sqlmag.com/article/odbc/questions-answers-and-tips-about-sql-server3103#commentsAnchorThu, 21 Oct 2004 07:03:20 GMT
Regarding modifying sysstat column in sysobjects. I’m OK with modifying system table. But it is a computed column. How do you get around the error that a computed column is not allowed to be modified?]]>Richard Ding Thu, 21 Oct 2004 07:03:20 GMThttp://www.sqlmag.com/article/odbc/questions-answers-and-tips-about-sql-server3103#commentsAnchorhttp://www.sqlmag.com/article/odbc/questions-answers-and-tips-about-sql-server3103#commentsAnchorWed, 15 Sep 2004 15:28:19 GMT
I asked for SQL disk quota errs.]]>rblue9030Wed, 15 Sep 2004 15:28:19 GMThttp://www.sqlmag.com/article/odbc/questions-answers-and-tips-about-sql-server3103#commentsAnchorhttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server7792#commentsAnchorWed, 25 Aug 2004 23:31:26 GMT
Sahana, you can do this by having another application that picksup the contents of text file and sends to db. ]]>sanjaykattimaniWed, 25 Aug 2004 23:31:26 GMThttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server7792#commentsAnchorhttp://www.sqlmag.com/article/odbc/questions-answers-and-tips-about-sql-server3103#commentsAnchorTue, 06 Jul 2004 07:23:16 GMT
With regard to the question [Q: How do you hide an object in the Enterprise Manager (EM)? ] do you recommend updating the system objects directly which is not a good practice and MS itself discourages to do so.]]>Satya SK Jayanty Tue, 06 Jul 2004 07:23:16 GMThttp://www.sqlmag.com/article/odbc/questions-answers-and-tips-about-sql-server3103#commentsAnchorhttp://www.sqlmag.com/article/internet/questions-answers-and-tips-about-sql-server3458#commentsAnchorFri, 25 Jun 2004 04:35:36 GMT
Can we use SQL provider for all versions of SQL Server?]]>Ashok kumar Fri, 25 Jun 2004 04:35:36 GMThttp://www.sqlmag.com/article/internet/questions-answers-and-tips-about-sql-server3458#commentsAnchorhttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server5214#commentsAnchorTue, 22 Jun 2004 15:58:31 GMT
I’m trying to install SQL Server 6.5 Enterprise Manger on a Windows 2000 workstation and when I try to register the client I get "Unable to connect to SQL Server (reason: [DB Library] Unable to connect: SQL Server is unavailable or does not exist) Register anyway?]]>Nancy Campbell Tue, 22 Jun 2004 15:58:31 GMThttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server5214#commentsAnchorhttp://www.sqlmag.com/article/installation2/questions-answers-and-tips-about-sql-server8316#commentsAnchorWed, 16 Jun 2004 04:14:22 GMT
I work as Senior Developer for SQL SERVER 2000 SQL programmer. Actually I am a GUI programmer but migrated to back end. Is it good to go in this back end side. whether there vacancies for SQL Server 2000 SQL programming. i need the reply in my mail id. Regards Sankar]]>sankar Wed, 16 Jun 2004 04:14:22 GMThttp://www.sqlmag.com/article/installation2/questions-answers-and-tips-about-sql-server8316#commentsAnchorhttp://www.sqlmag.com/article/training-and-certification2/microsoft-s-online-university-moli-#commentsAnchorSun, 13 Jun 2004 14:31:26 GMT
Looking to get Microsoft Office Certified Online Would like to know the cost. Excel, word powerpoint, Access]]>Mary Lazarus Sun, 13 Jun 2004 14:31:26 GMThttp://www.sqlmag.com/article/training-and-certification2/microsoft-s-online-university-moli-#commentsAnchorhttp://www.sqlmag.com/article/windows-client/questions-answers-and-tips-about-sql-server4980#commentsAnchorWed, 26 May 2004 03:49:20 GMT
I AM TRYING TO IMPORT DATA FROM TEXT FILE WHICH CONTAINS ENGLISH ANd GERMAN FONTS. BUT IT IS ONLY IMPORTING ENGLISH FONTS . I AM USING BULK INSRT]]>SAJU PAUL THERATTIL Wed, 26 May 2004 03:49:20 GMThttp://www.sqlmag.com/article/windows-client/questions-answers-and-tips-about-sql-server4980#commentsAnchorhttp://www.sqlmag.com/article/windows-client/moving-and-copying-databases#commentsAnchorTue, 18 May 2004 05:18:20 GMT
Hi, the "Integrating Windows Messaging with SQL Server, May 1997" doesn’t really explain how to send sql mails directly to the internet. Probably I got the incorrect link, can you help me please? I’m trying to figure out a way of sending mail alerts without passing through MS Outlook or Exchange.]]>Jen Tue, 18 May 2004 05:18:20 GMThttp://www.sqlmag.com/article/windows-client/moving-and-copying-databases#commentsAnchorhttp://www.sqlmag.com/article/dts/locating-dts-packages#commentsAnchorSun, 25 Apr 2004 09:12:18 GMT
scenario one is what i want to do. But want to give clients a vb exe. An example please.]]>sanjay kumar Sun, 25 Apr 2004 09:12:18 GMThttp://www.sqlmag.com/article/dts/locating-dts-packages#commentsAnchorhttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server5214#commentsAnchorMon, 12 Apr 2004 22:49:29 GMT
Could someone please help me, how to retrieve records from three tables in sqlserver database]]>Silas Eschole Mon, 12 Apr 2004 22:49:29 GMThttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server5214#commentsAnchorhttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server7225#commentsAnchorWed, 07 Apr 2004 13:34:35 GMT
Thank you for the insight that BOL overlooked. run shrink file BEFORE the remove file of alter database will work.]]>SteveWed, 07 Apr 2004 13:34:35 GMThttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server7225#commentsAnchorhttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server4762#commentsAnchorWed, 31 Mar 2004 04:49:54 GMT
i have a trouble saving database from one table to another table,in vb i have design a form and connect with table1 an other form.access the data from table one by entring seatno, then i want sdave this data an other table plz help me]]>asqab Wed, 31 Mar 2004 04:49:54 GMThttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server4762#commentsAnchorhttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server5412#commentsAnchorTue, 16 Mar 2004 07:18:49 GMT
Does SQl 6.5 support auditing? If yes how?]]>Karren Tue, 16 Mar 2004 07:18:49 GMThttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server5412#commentsAnchorhttp://www.sqlmag.com/article/windows-client/questions-answers-and-tips-about-sql-server3604#commentsAnchorWed, 03 Mar 2004 03:24:25 GMT
respected sir, I am having problem with insertion of a string that contain a single quotation (’) because it terminate the string when I enter it and rest of the query result with an error. So I want a escape character that can tell the query that it is not a end of string while it is a part of the string. many thanks ]]>hemantWed, 03 Mar 2004 03:24:25 GMThttp://www.sqlmag.com/article/windows-client/questions-answers-and-tips-about-sql-server3604#commentsAnchorhttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server7506#commentsAnchorSun, 29 Feb 2004 23:25:33 GMT
Pls help me : My SQL server runs on a Terminal Service computer slowly. Enterprise Managet says just 32 Mb memory max while the computer has 1Gb physical RAM. Pls tell me if there is something concerns between SQL Server and Terminal Service. Thank you, Sirs and Madam. ]]>Phan Thu Phong Sun, 29 Feb 2004 23:25:33 GMThttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server7506#commentsAnchorhttp://www.sqlmag.com/article/internet/questions-answers-and-tips-about-sql-server3458#commentsAnchorFri, 02 Jan 2004 23:12:21 GMT
how to use INTERSECT in SQL Server 7.0 I am using (select * from T1) intersect (select * from T2) but it gives error in sql server 7.0 please guide me how to use]]>AshishFri, 02 Jan 2004 23:12:21 GMThttp://www.sqlmag.com/article/internet/questions-answers-and-tips-about-sql-server3458#commentsAnchorhttp://www.sqlmag.com/article/windows-client/olap-rolap-molap-and-holap#commentsAnchorMon, 15 Dec 2003 07:42:25 GMT
Great review of OLAP types...just what I needed for my exam this afternoon...]]>Michael Beck Mon, 15 Dec 2003 07:42:25 GMThttp://www.sqlmag.com/article/windows-client/olap-rolap-molap-and-holap#commentsAnchorhttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server5214#commentsAnchorWed, 10 Dec 2003 03:50:58 GMT
i want install sqlserver2000 as server in windowsxp.but it does not support in windowsxp .can any one help me how to install sqlserver as server in windowsxp]]>saravananWed, 10 Dec 2003 03:50:58 GMThttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server5214#commentsAnchorhttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server7225#commentsAnchorSun, 30 Nov 2003 19:56:59 GMT
Very helpful with regards to copying DB Diagrams, however I still can’t do it where I don’t have both DBs on the same machine... Thanks anyway!]]>Chris Scholten Sun, 30 Nov 2003 19:56:59 GMThttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server7225#commentsAnchorhttp://www.sqlmag.com/article/windows-client/understanding-snmp#commentsAnchorSat, 22 Nov 2003 12:02:40 GMT
your information is helpfull.can u mail me with more information regarding snmp manager.]]>BharathSat, 22 Nov 2003 12:02:40 GMThttp://www.sqlmag.com/article/windows-client/understanding-snmp#commentsAnchorhttp://www.sqlmag.com/article/windows-client/olap-rolap-molap-and-holap#commentsAnchorSat, 22 Nov 2003 00:56:46 GMT
It is an informatative article, but it would be better if it suggests an OLAP product taking into consideration that this product provides at least the following minimal set of functions:Roll-up, Drill-down, Slicing, Dicing, and Pivot. And to clarify why they suggest this product. Thank you for your time and consideration. Waiting the response. Regards, ]]>Nassib Elkadri Sat, 22 Nov 2003 00:56:46 GMThttp://www.sqlmag.com/article/windows-client/olap-rolap-molap-and-holap#commentsAnchorhttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server5412#commentsAnchorWed, 19 Nov 2003 07:49:06 GMT
i have a SQL Server 6.5 and i try to rename a Table. How proceed...]]>CarlWed, 19 Nov 2003 07:49:06 GMThttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server5412#commentsAnchorhttp://www.sqlmag.com/article/installation2/questions-answers-and-tips-about-sql-server8316#commentsAnchorSun, 16 Nov 2003 22:01:58 GMT
it’s my first time lear about SQL Server 7.0 and i don’t know about the meaning of SQL Server 7.0, how to use it, etc please tell more about SQL Server 7.0 thank’s]]>AntiranikSun, 16 Nov 2003 22:01:58 GMThttp://www.sqlmag.com/article/installation2/questions-answers-and-tips-about-sql-server8316#commentsAnchorhttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server7953#commentsAnchorFri, 14 Nov 2003 03:45:46 GMT
I have two SQL Server 2000 databases. I used DTS for data copying with large tables in structure as well as with no of records. I exported the data, the DTS report showed that all objects and data transferred successfully. However, in original table some coulmns with NULL values are observed as empty spaces i.e. NOT NULL values in my target database.]]>Prashant Deshmukh Fri, 14 Nov 2003 03:45:46 GMThttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server7953#commentsAnchorhttp://www.sqlmag.com/article/internet/questions-answers-and-tips-about-sql-server3866#commentsAnchorFri, 31 Oct 2003 06:45:59 GMT
Very basic information but really great to go through once again. Thanx i got the topic refreshed]]>NaushadFri, 31 Oct 2003 06:45:59 GMThttp://www.sqlmag.com/article/internet/questions-answers-and-tips-about-sql-server3866#commentsAnchorhttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server4536#commentsAnchorFri, 03 Oct 2003 12:46:01 GMT
i am trying to instaal sql server 7.0 desktop edition on win98 , when it gets to connecting to server my system hangs,please tell me why,]]>hilary Fri, 03 Oct 2003 12:46:01 GMThttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server4536#commentsAnchorhttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server7792#commentsAnchorWed, 23 Apr 2003 10:39:32 GMT
Hi, I have a application running which writes information to a text file, i want this online text file to be linked with a MS-SQL Table. In other words whatever info is written in the text file, should automatically get updated in to the table. How do i do this ? Regards ]]>Sahana Wed, 23 Apr 2003 10:39:32 GMThttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server7792#commentsAnchorhttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server4536#commentsAnchorMon, 17 Mar 2003 03:52:18 GMT
I am constantly getting "[Microsoft][ODBC Sql Server Driver]Communication Link Failure" while running a PB application whose backend is SQL Server 6.5. How to overcome this ?]]>Sandhya Harikumar Mon, 17 Mar 2003 03:52:18 GMThttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server4536#commentsAnchorhttp://www.sqlmag.com/article/systems-administrator/application-roles-not-as-useful-as-they-could-be#commentsAnchorThu, 13 Feb 2003 15:57:57 GMT
It looks like there is no possibility to prevent users from accessing all records in permited tables through any application using ODBC connections. It’s really frustrating. :(]]>Martin Rohar Thu, 13 Feb 2003 15:57:57 GMThttp://www.sqlmag.com/article/systems-administrator/application-roles-not-as-useful-as-they-could-be#commentsAnchorhttp://www.sqlmag.com/article/oracle/oracle-for-nt#commentsAnchorWed, 11 Dec 2002 22:53:51 GMT
HOW CAN I RUN THE SQL* LOADER ON WIN NT(MS-DOS MODE) VERSION TO IMPORT DATA INTO ORACLE DATABASE.I HAVE CODE FOR WIN 98.BUT ON WIN NT HOW TO PROCEED USING CONTOL FILE.]]>rameshWed, 11 Dec 2002 22:53:51 GMThttp://www.sqlmag.com/article/oracle/oracle-for-nt#commentsAnchorhttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server7309#commentsAnchorMon, 16 Sep 2002 19:08:18 GMT
i have a SP project and within i am trying to insert data into a tbl order by the name, so i use the order by function at the end of the insert command but it will not work do you have an alternative solution? and may i noe whats the problem?]]>wilsonMon, 16 Sep 2002 19:08:18 GMThttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server7309#commentsAnchorhttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server7612#commentsAnchorWed, 03 Apr 2002 08:21:11 GMT
I have a SQL Server and a Sybase Server. I created a DTS Package to copy a table from Sybase to SQL Server. If I run this package twice, a row is duplicated. I want to update the rows contained in the destination table. How can I do this without duplicate data in the destination table?]]>Cesar Rodriguez Wed, 03 Apr 2002 08:21:11 GMThttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server7612#commentsAnchorhttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server4536#commentsAnchorThu, 28 Mar 2002 08:51:43 GMT
Our developers have installed SQL 2000 on each of out overseas servers which are DC. I want them to run the service as an account other than LocalSystem. But the only accounts that don’t give Error " Could not start the MSSQLSERVER service on local computer" are member of domain administrators, and I can’t give them that. Does any body know what I need to give the account to run the SQL services. Thanks, ]]>aidan keogh Thu, 28 Mar 2002 08:51:43 GMThttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server4536#commentsAnchorhttp://www.sqlmag.com/article/ole-db/questions-answers-and-tips-about-sql-server494#commentsAnchorSun, 20 Jan 2002 10:00:09 GMT
How do I import 1 TB of Sybase data into MSSQL? I can you the DTS with no issues, the data is perfect..it just takes forever.... Thanks , Art]]>Art Helmstetter Sun, 20 Jan 2002 10:00:09 GMThttp://www.sqlmag.com/article/ole-db/questions-answers-and-tips-about-sql-server494#commentsAnchorhttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server7309#commentsAnchorThu, 03 Jan 2002 10:05:29 GMT
i was wondering how to enter into a DB table text information present in a text Area(form) especially when the information entered into the text area (say persons resume in text) be stored in a SQL 7.0 Db column..using ASP and visual interdev 6.0... would be greatfull if u can provide me info abt this..]]>Abhinesh Thu, 03 Jan 2002 10:05:29 GMThttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server7309#commentsAnchorhttp://www.sqlmag.com/article/systems-administrator/application-roles-not-as-useful-as-they-could-be#commentsAnchorMon, 17 Dec 2001 19:31:59 GMT
I noticed a Microsoft "Workaround" for the connection problem mentioned in this articel. The link is: http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q229564]]>Robert Ruemer Mon, 17 Dec 2001 19:31:59 GMThttp://www.sqlmag.com/article/systems-administrator/application-roles-not-as-useful-as-they-could-be#commentsAnchorhttp://www.sqlmag.com/article/visual-basic-vb/questions-answers-and-tips-about-sql-server3100#commentsAnchorWed, 05 Dec 2001 22:14:18 GMT
I’ve seen many posts all over the net asking "how do I do a crosstab query using SQL Server?". I’ve needed to do this myself recently, so I made a stored procedure that takes a standard query (and a few other parameters) and turns it into a crosstab. Here it is - I hope you find it useful: create procedure sp_XTabQuery @strSQL varchar(8000), @ColumnHeading varchar(1000), @Value varchar(1000), @RowHeading varchar(1000), @SortField varchar(1000), @ValueOperator varchar(1000) as declare @FieldName varchar(1000), @FieldValue varchar(8000),@RowHeadingValue varchar(1000),@OrderByValue varchar(1000), @XTSQL varchar(8000) set @XTSQL = ’select ’ + @RowHeading + ’, ’ exec(’declare mycursor cursor for select distinct ’ + @ColumnHeading + ’, ’ + @SortField + ’ from (’ + @strSQL + ’) x order by ’ + @SortField) open mycursor fetch next from mycursor into @FieldName, @OrderByValue While @@fetch_status = 0 begin if @XTSQL <> ’select ’ + @RowHeading + ’, ’ set @XTSQL = @XTSQL + ’,’ set @XTSQL = @XTSQL + ’[’ + @FieldName + ’] = ’ + @ValueOperator + ’(case when ’ + @ColumnHeading + ’ = ’’’ + @FieldName + ’’’ then ’ + @Value + ’ else ’’’’ end) ’ fetch next from mycursor into @FieldName, @OrderByValue end set @XTSQL = @XTSQL + ’ from (’ + @strSQL + ’) a’ set @XTSQL = @XTSQL + ’ group by ’ + @RowHeading exec(@XTSQL) close mycursor deallocate mycursor]]>Matthew Eno Wed, 05 Dec 2001 22:14:18 GMThttp://www.sqlmag.com/article/visual-basic-vb/questions-answers-and-tips-about-sql-server3100#commentsAnchorhttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server7792#commentsAnchorFri, 19 Oct 2001 08:53:00 GMT
I have problems to attach a datbase file in mi MSDE 2000. If I try run this script in the Query Analizer the operation run very good, but when I try do it by command line whit a script, appear one error because have problems with the file path. Ei: c:\osql -E -r0 -SDOVERLI -dMaster -n -b -i script.txt script.txt ="EXEC sp_attach_db @dbname=N’prepaga’, @filename1=N’c:\Archivos de Programa\Microsoft SQL Server\Data\prepaga_Data.MDF’, @filename2=N’c:\Archivos de Programa\Microsoft SQL Server\Data\prepaga_log.ldf’" Thaks a lot!]]>Doverli Fri, 19 Oct 2001 08:53:00 GMThttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server7792#commentsAnchorhttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server8492#commentsAnchorThu, 06 Sep 2001 05:06:19 GMT
Iam basically from Oracle background and new to SQL Server. Iam very new to SQL Server Administration. But I gained some valuable concepts from this site. I would suggest everyone should benefit from your service. Hats off to you]]>Manickavinayagam Thu, 06 Sep 2001 05:06:19 GMThttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server8492#commentsAnchorhttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server7114#commentsAnchorWed, 04 Jul 2001 20:35:20 GMT
I am having difficulty using domain aggregate functions in an access data project. If I refer to a form or report control as the criteria in a domain aggregate function, I get an error. If use a number or text expression it works just fine. has anyone else had the same problem?]]>Scott Hall Wed, 04 Jul 2001 20:35:20 GMThttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server7114#commentsAnchorhttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server8492#commentsAnchorThu, 28 Jun 2001 02:24:27 GMT
I am very new SQL administration, but I have to admit that I have already benefitted from this site. Some of he qestions have already been answered.. keep it up]]>Herbert Zimbizi Thu, 28 Jun 2001 02:24:27 GMThttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server8492#commentsAnchorhttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server7114#commentsAnchorSat, 23 Jun 2001 10:13:44 GMT
when i import ms access table to sql server i have an error stating dts wizard error,what is the solution for this problem.]]>rajeshSat, 23 Jun 2001 10:13:44 GMThttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server7114#commentsAnchorhttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server5214#commentsAnchorThu, 03 May 2001 12:39:05 GMT
I would also like to know what the cause and solution to Error 8525 is.]]>DerekThu, 03 May 2001 12:39:05 GMThttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server5214#commentsAnchorhttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server7114#commentsAnchorWed, 02 May 2001 12:48:18 GMT
Hello, I installed win 2000 server in 2 PCs, one of them is win 2000 server for entrpise i made it PDC both computers can see each other .I installed SQL server 2000 at both of them ..but as i tried to register SQL server at any one of them i get connection failed and if i use DTS I got a message " Error source M ole DB provider for sql server .Time out expired.Error during initialization of the provider"

What did i miss and what i m supuse to do for fixing it

Thank u alot]]>AmyWed, 02 May 2001 12:48:18 GMThttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server7114#commentsAnchorhttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server8146#commentsAnchorTue, 03 Apr 2001 09:04:31 GMT
Is there a list of build numbers to service packs for SQL Server 7.0. When I use @@Version, I’m getting 623 for the build number. I’d like to know what service pack I’m at now, and what the build number should be when I go to SP2. Thanks,]]>DaveTue, 03 Apr 2001 09:04:31 GMThttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server8146#commentsAnchorhttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server5214#commentsAnchorThu, 22 Mar 2001 20:33:23 GMT
I too would like to know more about "Error 8525", Distributed transaction completed. Either enlist this session in a new...]]>Tim Reynolds Thu, 22 Mar 2001 20:33:23 GMThttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server5214#commentsAnchorhttp://www.sqlmag.com/article/windows-client/questions-answers-and-tips-about-sql-server#commentsAnchorThu, 22 Feb 2001 11:13:25 GMT
I’m having problems restoring a database from transaction logs. Error message states backup device not recognised by sysdevices and yet when you look in sysdevices the backup device is there. Any ideas?]]>jonathanThu, 22 Feb 2001 11:13:25 GMThttp://www.sqlmag.com/article/windows-client/questions-answers-and-tips-about-sql-server#commentsAnchorhttp://www.sqlmag.com/article/tcpip/questions-answers-and-tips-about-sql-server3929#commentsAnchorMon, 12 Feb 2001 15:11:22 GMT
I don’t know if this is the place but here goes. We are expericning severs crashes on our application servers on only Wednesdays. this happens when SQL performs a database dump. The MPI dump is ok but the application database which runs in size from 500mb to over a gig will start but lock up in the beigning of the dump. We have these dumps perform six times a day seven days aweek. but it only happens on Wednesday at noon. Not on every server and not the same one every week. There are nine servers that this application is running on. Kind of a moving target. we have almost ruled out a hardware error or operating system error. We are running NT 4.0 with SP6a, on Compaq proliant 6500 with 1 gig or ram, with two 450 proccessors. and SQL 6.0 SP3 the application will not run on the newer SQL packages with out redoing the code. Any suggestions that might be of some help please let me know. ]]>Jeff Peepers Kaiser Permanente Mon, 12 Feb 2001 15:11:22 GMThttp://www.sqlmag.com/article/tcpip/questions-answers-and-tips-about-sql-server3929#commentsAnchorhttp://www.sqlmag.com/article/oracle/oracle-for-nt#commentsAnchorSun, 21 Jan 2001 22:01:07 GMT
Bob is right; I presented the original "Optimal Flexible Architecture" paper in Miami in 1991. I had to write a letter requesting that I be excused from jury duty to attend... In response to several discussions about details through the following few years, I wrote a second paper called "The OFA Standard" which identified thirteen OS-independent requirements and then went on to suggest an example set of UNIX standards that would meet these requirements. ]]>Cary Millsap Sun, 21 Jan 2001 22:01:07 GMThttp://www.sqlmag.com/article/oracle/oracle-for-nt#commentsAnchorhttp://www.sqlmag.com/article/sql-server/clustered-indexes-and-swiss-cheese#commentsAnchorTue, 03 Oct 2000 12:08:50 GMT
Does this relate to SQL 7.0 also ? Any guidelines of what determines an index setting other than "I will be searching this column frequently" .]]>Shea Tue, 03 Oct 2000 12:08:50 GMThttp://www.sqlmag.com/article/sql-server/clustered-indexes-and-swiss-cheese#commentsAnchorhttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server5214#commentsAnchorWed, 30 Aug 2000 11:32:59 GMT
Great article. Good info in a nut shell. I wanted to know if there is a fix for the error 8525 in TABLE 2. Please let me know. Thanks. TABLE 2: Error Messages Not Listed in BOL Error Number Error Message 8525 Distributed transaction completed. Either enlist this session in a new transaction or the NULL transaction.]]>kiranWed, 30 Aug 2000 11:32:59 GMThttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server5214#commentsAnchorhttp://www.sqlmag.com/article/dts/locating-dts-packages#commentsAnchorThu, 08 Jun 2000 14:46:24 GMT
Excellent.. However, how do you get a client machine to execute a DTS package without the EM? Everytime we try using DTSRun.exe on the client the process comes back with a parameter error, but we can run the exact same parameters against the server and it runs just fine.]]>Layne Baker-Zimmer Thu, 08 Jun 2000 14:46:24 GMThttp://www.sqlmag.com/article/dts/locating-dts-packages#commentsAnchorhttp://www.sqlmag.com/article/installation2/questions-answers-and-tips-about-sql-server8316#commentsAnchorTue, 25 Apr 2000 14:01:16 GMT
I have been working with relational databases since 1987, and been a reader of and subscriber to Win NT magazine for several years, but I have to say that I find this to be some of the worst advice I have ever seen. To begin with, you are advising someone who is, apparently, fairly new to the world of the RDBMS, to do something that flies directly in the face of the basics of relational theory and principle. One of the major tenets of normalisation of data when designing a database system is to ensure that each field contains one piece of data, and only one piece of data ! The answer here should be that _both_ pieces of data should be stored, and that the designer should ignore any users who say things like "we’ll never need to know how long we took to fulfill orders" !! There should be two columns used - DateOrderPlaces and DateOrderFulfilled. Of course, reading the question carefully, I can see that it is almost certainly a "made-up" one, because beginners at database design would hardly be sure about wanting to use the Repository for things like this ! I feel sure that, given a little time, you could have come up with a far better example of a _good_ use of the extended properties of an SQL_VARIANT type. However, all-in-all, this really looks like an extension that MS have added because they could, rather than because there’s any good reason for it. Perhaps they would be better employed in bringing their system up to full SQL3 compliance and then bragging about _that_ ? ]]>Michael Irwin Tue, 25 Apr 2000 14:01:16 GMThttp://www.sqlmag.com/article/installation2/questions-answers-and-tips-about-sql-server8316#commentsAnchorhttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server7309#commentsAnchorWed, 16 Feb 2000 12:04:11 GMT
In SQL Server Savvy: "Questions, Answers, and Tips About SQL Server" (November 1999), Karen Watterson and Brian Moran describe how to send large email messages as attachments using the xp_sendmail extended stored procedure. Microsoft has confirmed that a bug exists in this process in Microsoft SQL Server 6.5. The xp_sendmail extended stored procedure uses memory, but it doesn’t release that memory when it works with attachments. Eventually, SQL Mail stops responding. You must stop and restart the MSSQL service to get things running again. Microsoft is working on a hotfix. --­Ted Metzler]]>Ted Metzler Wed, 16 Feb 2000 12:04:11 GMThttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server7309#commentsAnchorhttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server7309#commentsAnchorWed, 16 Feb 2000 12:04:11 GMT
John Green’s Lab Comparative: "SMTP Server Roundup" (November 1999) didn’t include Alt-N Technologies’ MDaemon. Why not? I depend on Windows NT Magazine to give me a fair viewpoint. Completely missing affordable and highly respected products is a disservice to your readers that I can’t easily excuse. --­James Gill]]>James Gill Wed, 16 Feb 2000 12:04:11 GMThttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server7309#commentsAnchorhttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server7309#commentsAnchorWed, 16 Feb 2000 12:04:11 GMT
I can understand your disappointment in not seeing a favorite product included in the review. Many good mail servers exist in the marketplace. For this review, I included only products that support Internet Message Access Protocol (IMAP) in addition to POP3 for client mail access. Because MDaemon is a POP3-only product, it didn’t make the cut. --­John Green ]]>John Green Wed, 16 Feb 2000 12:04:11 GMThttp://www.sqlmag.com/article/sql-server/questions-answers-and-tips-about-sql-server7309#commentsAnchorhttp://www.sqlmag.com/article/windows-client/beeline-to-the-repository-honey-pot#commentsAnchorMon, 25 Oct 1999 10:24:25 GMT
Dear Ms. Watterson:

I just saw your April 1999 Features article, "Beeline to the Repository Honey Pot" and noticed one error which managed to slip through your Editors.

Figure 1 listed for Legacy Systems, "DB2, MVS, Visual Storage Access Method and CICS/IMS." I would have listed them as, "MVS, DB2, IMS, CICS and VSAM. Most mainframe legacy people would not know what the acronym VSAM meant, and especially would not know the "V" was for Virtual and not Visual.

I spent many years as a mainframe, operating system, techie, which means my brain is cluttered up with useless and arcane information such as the meanings of dumb and stupid acronyms. Feel free to ask me any mainframe questions.

I have made the switch as it is getting very difficult finding consulting work as a mainframe techie; and PCs are a lot more fun. ]]>Jeff V. Pulver Mon, 25 Oct 1999 10:24:25 GMThttp://www.sqlmag.com/article/windows-client/beeline-to-the-repository-honey-pot#commentsAnchorhttp://www.sqlmag.com/article/oracle/oracle-for-nt#commentsAnchorFri, 13 Aug 1999 11:19:08 GMT
I read Karen Watterson’s September article, “Oracle for NT,” which was very well written. I must disagree, however, about Cary Millsap’s OFA standard. The article states that OFA came about in 1995, which I believe is incorrect. At the 1991 International Oracle User Week, Millsap presented a paper that detailed the use of OFA with Oracle 6. Also, since 1993, Oracle’s UNIX Performance Tuning Guides have included a section on implementing OFA in a UNIX environment. Is there some place on the Web where I can get an electronic copy of the article?
--Bob Manieri

Thanks for the letter, Bob. You can find this article (and the entire September issue) at our Web site (http://www.winntmag.com) three months after the issue date.
--Karen Forster]]>Bob Manieri Fri, 13 Aug 1999 11:19:08 GMThttp://www.sqlmag.com/article/oracle/oracle-for-nt#commentsAnchorhttp://www.sqlmag.com/article/windows-client/exploring-oracle7-server-for-windows-nt#commentsAnchorThu, 12 Aug 1999 15:08:08 GMT
I noticed Karen Watterson’s December 1996 article, “Exploring Oracle7 Server for Windows NT,” on Oracle’s NT Web page. I’m wondering if Watterson has any knowledge of memory leaks associated with using NT and Oracle 7.3.2.2?
--Mark Mueller

Mark, I asked Milton Wan, Oracle’s Group Product Manager for Windows NT Server, about this problem, and he confirmed that “there are no memory leaks in 7.3.2.2, and there aren’t any in 7.3.2.3. I think there were some small leaks in the original SQLNet 2.3.2, but these are fixed now.” According to Wan, if you’re experiencing this problem, you need to call Oracle’s support organization so they can analyze your situation.
--Karen Watterson]]>Mark Mueller Thu, 12 Aug 1999 15:08:08 GMThttp://www.sqlmag.com/article/windows-client/exploring-oracle7-server-for-windows-nt#commentsAnchorhttp://www.sqlmag.com/article/windows-client/exploring-oracle7-server-for-windows-nt#commentsAnchorThu, 12 Aug 1999 14:30:43 GMT
I’m a computer specialist with a federal agency, and we’re looking at Oracle. Our configuration consists of Oracle7 running on NT 3.51 servers. We have Oracle7.3.2.2 and need to upgrade for a new application we’re developing. If I’ve read your December 1996 article correctly, we need to get a different Oracle 7.3.2.2 because we plan to go to NT 4.0 at the same time. Is this interpretation true? Thanks for your help.
—James Wallius,

James, you’re right. You’ll need the newest version of the CD-ROM that supports NT 4.0.
--Karen Watterson]]>James Wallius Thu, 12 Aug 1999 14:30:43 GMThttp://www.sqlmag.com/article/windows-client/exploring-oracle7-server-for-windows-nt#commentsAnchorhttp://www.sqlmag.com/article/windows-client/exploring-oracle7-server-for-windows-nt#commentsAnchorThu, 12 Aug 1999 14:29:02 GMT
I can’t believe I finally found an article (Karen Watterson, “Exploring Oracle7 Server for Windows NT,” December 1996) on Oracle7 running on NT Server. Our organization is operating in four countries and plans to move from a nightmare FoxPro app to a VB/Oracle application. We need to become Oracle7/NT Server experts quickly. We’ll use Oracle and NT Server 3.51 on a Compaq ProLiant 4500 for transaction processing, a data mart, and possibly financials. We have approximately 500 users enterprisewide and about 300 local users. I’m interested in NT 4.0, but I don’t know anyone using it. Database size is currently about 2GB. How do we distribute data and indexes and control file access across multiple drives? Do we need RAID 5 or mirror disk? A combination? What is the most efficient server configuration? I’d appreciate any information and technical resources you can suggest.
--Bryan Millhouse,
JewelWay International

The short answer is to use a combination of RAID 5 and mirrored disks. Set up data and indexes (in different tablespaces) on the RAID drives; put the control files, redo logs, archive logs, system tablespace, and tempspace on mirrored drives. Use as many disk controllers as you can, and distribute the drives to the controllers so that they don’t become a bottleneck. Lots of small drives are usually preferable to a few big drives.
--Karen Watterson]]>Bryan Millhouse Thu, 12 Aug 1999 14:29:02 GMThttp://www.sqlmag.com/article/windows-client/exploring-oracle7-server-for-windows-nt#commentsAnchorhttp://www.sqlmag.com/article/security/questions-answers-and-tips-about-sql-server493#commentsAnchorTue, 10 Aug 1999 13:13:32 GMT
In the November 1997 SQL Server Q&A, a reader asked about Visual SourceSafe (VSS) and SQL Server. True, nothing exists to manage T-SQL code with VSS. But Embarcadero develops TeamSQL/Project, which can do the same thing (with or without PVSC). I’m a beta tester of Embarcadero’s software, and this version is only the first. Their development team is working on a more complete future release of TeamSQL/Project (and I hope it will include SourceSafe support). Check it out at http://www.embarcadero.com.
--Benoit Chailler

TeamSQL/Project ships with the MKS SourceIntegrity version control engine but also supports InterSolve PVCS. Team SQL/Project supports several databases (Oracle, Sybase, Informix, SQL Anywhere, DB2, InterBase, and SQLBase) besides SQL Server.
--Karen Watterson]]>Benoit Chailler Tue, 10 Aug 1999 13:13:32 GMThttp://www.sqlmag.com/article/security/questions-answers-and-tips-about-sql-server493#commentsAnchorhttp://www.sqlmag.com/article/oracle/oracle-for-nt#commentsAnchorTue, 10 Aug 1999 10:41:46 GMT
I’m an avid reader and fan of your magazine. The technical content is both challenging and useful. As a long-time Oracle database administrator (DBA), I want to comment on Karen Watterson’s September 1997 article, “Oracle for NT.” I give the author high marks for including lots of valuable tips in a very readable format. However, I must give a grade of B on the answer about SNAPSHOT TOO OLD messages. When delete and update transactions occur, the data blocks get the new data, and the rollback segments get a copy of the original data blocks. This snapshot is of the original data—the source of that unfortunate term in the error message. An original data block cannot be overwritten in a rollback segment as long as it is active, (i.e., until you have a commit or rollback of the delete or update that sent the data block to the rollback segment). After that, the data block sits unprotected in the rollback segment until it is overwritten. Oracle uses rollback segment space in a round-robin fashion to avoid overwriting original blocks as long as possible. The snapshot data that is no longer active is still important to any queries that began before the transaction started and have not finished by the time the transaction is committed. A fundamental database management system (DBMS) rule dictates that such a query must return data the way it existed when the query started. To accomplish this feat (using a mechanism called System Change Numbers—SCN), a query checks each data block it wants to read to see whether that data block was changed after the query started. If so, the query knows to look in the rollback segments for that data block. If the query cannot find the needed data block with an appropriate SCN in the rollback segments, voila! The SNAPSHOT TOO OLD error message occurs. I question the article’s first bulleted advice on how to avoid this problem. More rollback segment space is needed, but it should probably be allocated in more rollback segments rather than increased segment size. Also, the extent size in rollback segments is a tricky issue. The optimal setting depends on the characteristics of the database in question. In my experience, Oracle does best with rollback segments composed of a lot of fairly small extents. I recommend more in-depth reading on the subject before you make changes in this area.
--Roger Burrows

Your points are well taken, Roger. Thanks for reminding me of the dangers of simplistic generalization. Oracle’s rollback segments do merit database-specific optimization.
--Karen Watterson]]>Roger Burrows Tue, 10 Aug 1999 10:41:46 GMThttp://www.sqlmag.com/article/oracle/oracle-for-nt#commentsAnchorhttp://www.sqlmag.com/article/windows-client/beeline-to-the-repository-honey-pot#commentsAnchorMon, 09 Aug 1999 10:43:23 GMT
I enjoyed Karen Watterson’s “Beeline to the Repository Honey Pot” (April). I attended the Austin Professional Developers Summit (PDS) session about using COM to access the Microsoft Repository. I left the session thinking that the time was right to test-drive the various Repository tools. My experience with using Unified Modeling Language (UML) and Repository to integrate Microsoft Visual Modeler 2.0, Rational Software’s Rational Rose 98i, Microsoft Visual Studio’s (VS’s) Visual Component Manager, Microsoft Visual Basic (VB) 6.0, and Visio Enterprise 5.0 via Repository 2.0 has been a veritable Catch 22 of incompatibilities, unrecoverable application errors (UAEs) and other varied moments of joy. Eventually, I hope Microsoft can force a standard on the tool vendors, but so far, Microsoft hasn’t been able to get its repository-tools act together. For the time being, I’ve stopped trying to integrate off-the-shelf tools via the Repository because trying to use the tools decreases productivity. Most of the tool vendors lack Repository support for some key parts of the UML standard, including stereotypes and tagged values and simplistic Repository import/export functionality. At this point in time, I’d apply the author’s phrase “grandiose and unsuccessful” to the UML tool vendors’ support of the Repository.
--Steve Dadoly

Unfortunately, I think your experiences are fairly typical. Repositories have never sold, and the interest in them continues to be anemic. As of April 25, 1999, only 236 messages (from five or so active individuals) resided in microsoft.public.repository vs. hundreds of messages in almost every microsoft.public.sqlserver newsgroup. The number of repository-related messages might be a crude measure, but that response number combined with the few TechEd ’99 sessions (two or three vs. one last year) that reportedly will be devoted to Repository seem to indicate a lack of interest in repositories within the industry. And now, with Computer Associates’ takeover of PLATINUM Technology (including ERwin), I wonder about the future of Microsoft’s cross-platform initiatives for Repository. On a more positive note, I think Visio 2000 will offer even better Repository support than Visio 5.0 does, and Visio 2000 might start eating into ERwin’s market share for a database modeling tool.
--Karen Watterson]]>Steve Dadoly Mon, 09 Aug 1999 10:43:23 GMThttp://www.sqlmag.com/article/windows-client/beeline-to-the-repository-honey-pot#commentsAnchor