We currently have a test server running Windows 2000 that is happily connected to an Oracle box as a Linked Server. I have now tried to configure another server by running the same Oracle Client installation routine. I then copied over the TNSNAMES.ORA file that I know works. I then went into SQL*Net and attempted […]
2001-08-14
14 reads
I am mainly a programmer work as the IT dept. I am not that adept at SQL Server (and database admin) but am learning. My task at hand it to build a one way interface where another company will send records to our database and we process them. I have a question: How will I […]
2001-08-13
5 reads
I did the MS Admin and the MS Design course for SQL 6.5 and although performance tuning was touched on, it wasn't gone into in as much detail as I would have liked. Do you think a Performance Tuning section would be relevant to you site?
2001-08-13
8 reads
2001-08-11
Comments posted to this topic are about the content posted at http://qa.sqlservercentral.com/columnists/achigrik/installationproblemsinsqlserver7.0.asp
2001-08-09
4 reads
Comments posted to this topic are about the content posted at http://qa.sqlservercentral.com/columnists/achigrik/someundocumentedstoredprocedures.asp
2001-08-09
8 reads
Hi all, I need to update my SQL Server 2000 tables with rows from an Oracle table. Using a DTS package, how can I get only rows from the Oracle table that have a date value greater than the maximum date from the SQL Server table? Thanks Henok
2001-08-08
9 reads
Hello, I have a user table with fields : userid varchar(30), password varchar(10) How can I encrypt the password and store in password field? is there any function available or I will have to write my own encryption algorithsm in stored procedure? Thanks.
2001-08-08
3 reads
I have a DTS package in SQL 2000 that uses an Execute process task. Basically, I have a compiled VB app that cleans up data files before they go are loaded into the SQL tables. The job runs fine in the DTS window, but when you schedule it, it seems to get hung up on […]
2001-08-07
3 reads
Since SQL Server 2000 does not have Boolean as datatype, is there a way for me to define boolean datatype in SQL Server 2000? Thanks in advance.
2001-08-06
10 reads
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers