2003-06-04
maintenance
RE: SQL occupied 90% usage and 99% outgoing traffic
I have run the sqldiag.exe. It shows the last three log files are unable to open. Meanwhile, What kind of command should I use to capture the command? Many thanks!
2003-06-04
RE: sql server not available or access is denied
How you are connecting to the server? Terminal server? Remote Desktop? Is the tools installed on the server? Also if yes try changing the protocol
2003-06-03
RE: DTS - Fixed Length File
In my production script (which is considerably longer) I do HAVE to build a temp table to get the result set it need.
2003-06-03
RE: Copy data
This may be simplistic and I may be missing the original concept of what we are talking about, but I think you can update the nulls with <BR><BR> SET <this column> = MAX(<this column>)+1, ... etc<br><br> that would store the next available value to the column for you (just make VERY sure you get the […]
2003-06-02
RE: Copy data
the hard-coded numbers were inserted by me as I added items in the columns. The Spanish column does allow nulls, but the primary key 'ID' certainly does not. The problem is that the insert statement added the values and there werent't any hardcoded 'IDs' for those values. However I am trying to get those values […]
2003-06-02
RE: Copy data
Ah, sorry, the error is on the ID column, not the Spanish column. What eljeffo said should be true. Patrick
2003-06-02
RE: Copy data
Also, just reading the message - your Spanish column has NULL values, but your column in db2 does not allow NULLs. Is that true? If it is, if you set a default of empty instead of allowing NULLs then it should work. Patrick
2003-06-02
RE: Copy data
What generates the hard-coded numbers? Also, give me a little more info please on why you think the numbers have to be updated... I thought you were inserting...
2003-06-02
RE: 16 bit ODBC connection to SQL Server 2000 fails
There were some statements that things had been removed from the MDAC that I don't recall. I would try to get a machine on MDAC 2.1 to see but other than that I have nothing to test with and very little info.
2003-05-31
1 reads
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
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...
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