Viewing 15 posts - 39,196 through 39,210 (of 39,466 total)
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
If you need the real time querying, then replication is most likely better. However, in a DR situation, replication can be tricky to set back up. Not only that, what...
October 18, 2001 at 12:43 pm
Whenever you have an "access denied" be sure you check security.
Thanks for the followup.
Steve Jones
October 18, 2001 at 9:32 am
If you are trying to resend the same XLS file, you probably want to "drop " the table and then recreate it using 2 T-SQL tasks.
I do this quite a...
October 18, 2001 at 9:31 am
Viewing 15 posts - 39,196 through 39,210 (of 39,466 total)