Forum Replies Created
Viewing 15 posts - 37,126 through 37,140 (of 39,769 total)
-
RE: How to post a pic?
When you hit the button above, you should get "
". In here you need the URL to the image. If it's not on another web server, then email...
-
RE: UnKillable Locks
Crazy. Got a couple bad bugs here myself. Not sure what to tell you. IS the issue an insert/update/delete or a select?
Steve Jones
-
RE: Timeout
Is VB redialing the modem? Sounds like more of a network than a SQL issue or am I missing something?
Steve Jones
-
RE: Counting the number of columns in a row
Load into a dummy table and then move it for rows that have enough non-NULL values?
Steve Jones
-
RE: DTS Function
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
-
RE: SQLMail
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
-
RE: Net-Libraries
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...
-
RE: UnKillable Locks
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...
-
RE: The DBA Dot Com Bust
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...
-
RE: The Dot Com Bust - Part 2
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...
-
RE: Kill That Target!
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
-
RE: FTP Task
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
-
RE: SQL Server Tools
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
-
RE: Exec a .sql file
use an Execute SQL task to run xp_cmdshell. In the query, run isql with the parameters needed.
Steve Jones
Viewing 15 posts - 37,126 through 37,140 (of 39,769 total)