Viewing 15 posts - 5,671 through 5,685 (of 6,216 total)
Not a simple question! A lot of it depends on what you're going to do with the other server. Both are pretty easy to set up. If you'll tell us...
October 14, 2001 at 6:51 am
Why would EM use tempdb? Keep in mind EM is just an interface, the only reason for it to use a temp table would be if's using a work table...
October 13, 2001 at 2:48 pm
I dont think I'd sweat the nesting level. Its not going to get any simpler by making one big TSQL statement. If you could find a performance advantage then maybe.
I...
October 13, 2001 at 2:43 pm
If the joins are always the same, a view would be the correction solution in my opinion. It think it meets all three of your criteria.
Here's a question for you...
October 13, 2001 at 6:33 am
Possibly this product by BMC does - been a while since I looked, but worth a try.
http://www.bmc.com/webforms/sqlprogrammer/free/introduction.cfm
Andy
October 13, 2001 at 6:30 am
I believe execution of sp_password is limited to members of the sysadmin and security admin roles. Take a look at the source to sp_password.
Andy
October 13, 2001 at 6:27 am
Breaking on execute doesnt help you - you need to be INSIDE the package. Thats different than doing loadpackage followed by execute package.
Andy
October 13, 2001 at 6:22 am
Pretty interesting. I agree that it doesn't make a lot of sense that the DTS task only does one way transfers - I've looked at the API recently and there...
October 12, 2001 at 5:32 pm
Not so far. Anyone else? I don't think it will be too difficult. I like the idea of a custom front end, eliminates a lot of headaches! Probably you need:
1)...
October 12, 2001 at 4:22 pm
You don't have the sa password? Do you have another NT group that does have admin rights in SQL? If all fails, you can rebuild the master, then reattach your...
October 12, 2001 at 3:13 pm
Yes, its either got to be in the path or you must explicitly provide the path. It's executing on the server.
Andy
October 12, 2001 at 1:17 pm
I agree with Jon, I think you have to narrow it down some more. One way would be start by logging each step that gets run, that way you can...
October 12, 2001 at 1:16 pm
Another option would be to split the load across multiple servers, using distributed partitions maybe. Then all data would be live.
Andy
October 12, 2001 at 12:21 pm
Guess it depends on what you call a transaction, but that doesnt seem like too much for replication. Figuring it all happens in 8 hours, that breaks down to an...
October 12, 2001 at 12:20 pm
Show off! That is a simpler solution.
Andy
October 12, 2001 at 11:37 am
Viewing 15 posts - 5,671 through 5,685 (of 6,216 total)