Viewing 15 posts - 37,081 through 37,095 (of 39,720 total)
Load into a dummy table and then move it for rows that have enough non-NULL values?
Steve Jones
September 16, 2002 at 11:11 am
You could using VB or C++, but sure it's more efficient.
2 thoughts. Parse the file first and "fix" the data, or load it and fix it using SQL.
Steve Jones
September 16, 2002 at 11:08 am
Not a cluster person, but I know there are issues with SQLMail on clusters. If no one responds here, I suspect you will need to call MS.
Steve Jones
September 16, 2002 at 11:05 am
These are the connection "types" that SQL Server uses. They are DLLs and are "loaded" by SQL Server if you have enabled them. So if your client software is set...
September 16, 2002 at 11:02 am
Not sure that will help. Is the database in 2k mode or 65 mode?
I suspect that the application is doing something funny. Can you trace it and replay the trace...
September 16, 2002 at 10:59 am
Those are mostly administrative tasks for a DBA. You should be controlling the server, patching it with MS patches( after testing), as well as what you mentioned.
Performance tuning can be...
September 16, 2002 at 10:45 am
Thanks for the comments and interesting stories. Hopefully things will turn around all over soon.
As far as DBA v Developer/Programmer. In my experience, most developers are ignorant about good database...
September 16, 2002 at 10:42 am
You are welcome. I started to rebuild jobs, but had some time and decided to track this one down. Hopefully this will save some others some time.
Steve Jones
September 16, 2002 at 10:34 am
Are the files completely downloaded? Does the package complete without an error? It might include the file deletion as part of a rollback if there is an error.
Steve Jones
September 6, 2002 at 10:17 am
You should be able to redistribute osql.exe, which uses ODBC or OLEDB and run scripts through that automatically without the whole client tool install.
Steve Jones
September 6, 2002 at 10:15 am
use an Execute SQL task to run xp_cmdshell. In the query, run isql with the parameters needed.
Steve Jones
September 6, 2002 at 10:11 am
Try using the OLEDB for ODBC driver and pointing to a DSN for the dbase file.
Steve Jones
September 6, 2002 at 10:09 am
no. the table will be altered and the contraint must be removed first.
Steve Jones
September 6, 2002 at 10:01 am
There is no good way to do this. Andy has some suggestions that will work, but are a hassle.
Best idea would be to administratively handle this. Use auditing or a...
September 6, 2002 at 9:59 am
Detatch should work.
I used Andy's article to move from one box to another here. Std to Ent are the same versions, more features enabled in Ent.
Steve Jones
September 6, 2002 at 9:56 am
Viewing 15 posts - 37,081 through 37,095 (of 39,720 total)