Did you look at BOL? There are a couple of items to check there. 1) Under "Managing DTS Package Programs" there is a section at the bottom titled "Saving and Loading Packages" that looked plausible and probably a bit like your technet advice. 2) There also appears to be a method you might employ, LoadFromSQLServer. […]
2003-06-06
1 reads
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
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
Ah, sorry, the error is on the ID column, not the Spanish column. What eljeffo said should be true. Patrick
2003-06-02
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
I have checked the log file but I didn't find any thing related to jobs venkatesh
2003-05-27
2 reads
The SQL Agent log file might have some clues. That log is can be found in the following default location c:\mssql\log\sqlagent.out, although on your install it might be somewhere else. Gregory Larsen, DBA If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
2003-05-27
1 reads
2003-05-27
1 reads
try right clicking on the job, then selecting "View Job History". Then click the check box to "Show step details", then review the step that failed. Gregory Larsen, DBA If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
2003-05-27
1 reads
There is another thread discussing the same topic. Basically, you'll need to either: 1) Drop the index on any of the computed columns in your database(s). 2) Stop using maintenance plans. Setup the equivalent commands in an Agent job yourself and include the correct settings as detailed in KB 301292. 3) Wait for Microsoft's patch […]
2003-05-19
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
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...
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