Viewing 15 posts - 39,481 through 39,495 (of 39,754 total)
You can have multiple data transform tasks between the connections. You need a separate "query" for each to get different data.
Steve Jones
October 22, 2001 at 10:37 am
Does it work from the local server? If it does, then this doesn't make sense.
Steve Jones
October 22, 2001 at 10:35 am
Yes. With v7., the query engine was substantially enhanced. Some more improvement in 2000. At this point, you should run 2000. You can set a db to run as...
October 22, 2001 at 10:34 am
October 22, 2001 at 10:31 am
October 22, 2001 at 10:31 am
There is a script here that will do this.
http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=90
Also another:
Steve Jones
October 22, 2001 at 10:04 am
you can setup telnet (security risk). There is also a remote command server (like telnet). See the resource kit.
Don't know of any SSH, but there probably are some.
Steve Jones
October 20, 2001 at 1:17 pm
Do you have this installed on the remote machine?
It is installed as part of the SQL Server client tools.
Steve Jones
October 19, 2001 at 1:35 pm
That's an interesting idea. If these are not VLDBs, then that might work. I assume that if you log ship from one db to another, that the recipient db can...
October 19, 2001 at 9:48 am
October 19, 2001 at 8:13 am
You probably need a JDBC-ODBC bridge or maybe some of the Java vendors have native ones. Never seen one that was free, however.
Steve Jones
October 19, 2001 at 8:11 am
Interesting. I never tried this. Can you post some code from your DTS package? I'll take a look tomorrow.
Steve Jones
October 18, 2001 at 6:26 pm
You have a few options.
1. Trigger - Can run more SQL statements. However, the transaction does not complete until the statement comepletes. Be careful with this.
2. Replicate the record
3. Use...
October 18, 2001 at 6:24 pm
October 18, 2001 at 12:58 pm
The files used for SQL are the .mdf/.ldf/.ndf files. These are open and locked while the mssql service is running.
For OS level backups: two choices:
If you get backup software to...
October 18, 2001 at 12:53 pm
Viewing 15 posts - 39,481 through 39,495 (of 39,754 total)