Viewing 15 posts - 39,241 through 39,255 (of 39,506 total)
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
I avoid putting the actual SQL in the steps because it creates a point of maintenance. I'd rather create a stored proc and change that if needed.
ckempste:
Not sure what you...
October 18, 2001 at 9:27 am
Perhaps it had a security validation issue for a mapped drive? Sometimes MyComputer hangs when searching for a mapped drive before it times out and displays the "x" for not...
October 16, 2001 at 1:07 pm
What I think you will have to do is have separate queries for each round. You would then need to process these to find out which people have not progressed...
October 16, 2001 at 1:00 pm
The total space is the amount used on disk by the mdf/ldf files. The unallocated is the space in the mdf file that is not used.
So, if I create a...
October 16, 2001 at 10:36 am
There is a SQL 2000 version, same limitations. It's a 5 user (roughly) version.
From MSDN:
Microsoft SQL Server Desktop Engine (MSDE)
MSDE is fully compatible with other editions of SQL Server and...
October 16, 2001 at 10:27 am
Viewing 15 posts - 39,241 through 39,255 (of 39,506 total)