Viewing 15 posts - 36,901 through 36,915 (of 39,533 total)
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
I believe it connects to the IPC$ share or to port 445 to poll the server and see if it is running. Not sure if this would result in an...
September 6, 2002 at 9:54 am
I know that the default instance, EM uses 445 to connect as well as 1433, 1434. Are you using some redirection with SSH?
Steve Jones
September 6, 2002 at 9:51 am
be very very careful with this. Like dynamic sql, this is asking for an injection attack.
Is there a reason not to use isql or osql?
Steve Jones
September 4, 2002 at 2:22 pm
the gains from a middle tier come (with a well designed app) from offloading CPU cycles from the web server and the sql server onto another box. Like crunching numbers...
September 4, 2002 at 10:40 am
Not sure you can. I'd suspect this is in the registry or a cfg file if you can. Most likely it's hard coded.
Steve Jones
September 4, 2002 at 10:30 am
Most likely the tape is too full and it's not set to overwrite the tape.
Steve Jones
September 4, 2002 at 10:14 am
You can attach this without shutting down the server.
Steve Jones
September 3, 2002 at 3:59 pm
Viewing 15 posts - 36,901 through 36,915 (of 39,533 total)