Viewing 15 posts - 39,751 through 39,765 (of 39,791 total)
July 18, 2001 at 4:09 pm
I agree with Andy. PK, FK are great choices for non-clustered indexes.
Then look at which queries are run often. It doesn't do much good to index (clustered) for a...
July 18, 2001 at 4:06 pm
I think that based on this, you need separate fields in SQL Server for each extent. Then this
DTSSource("meatcost__1")
Needs to return the correct value.
Will this work to a text or...
July 18, 2001 at 3:55 pm
I'd use a flag to mark when a transfer is complete. either a global variable or a field in a table. then when a task succeeds, mark the variable complete...
July 18, 2001 at 3:53 pm
What is an extent? Apologies, but I am not familiar with Postgress.
Can you transfer from Postgress to varchar() or to a text file?
Steve Jones
July 17, 2001 at 6:04 pm
Is this one time or periodic?
If one time, it's quicker to build each one by hand. (also simpler, KISS).
Steve Jones
July 17, 2001 at 6:02 pm
Never seen this and I restore 2-3 servers every week. Granted, they are the same servers.
I'd call MS. Worth the $250 for an exception to find out.
Steve Jones
July 17, 2001 at 12:50 pm
Gotta love those obscure bugs. Sorry for the post, I didn't read the second page.
Anyway, at least MS support is pretty good.
Steve Jones
July 17, 2001 at 12:46 pm
Try
set statistics io on
You will have to somehow capture and parse this information as it is a print output. In QA , check the Messages tab.
Steve Jones
July 17, 2001 at 12:39 pm
Can you set up an Operator and send a test?
Can you set an alert and then fire it off to get an email?
Reaching here...
Steve Jones
July 17, 2001 at 12:28 pm
Encryption is the only possibility. If you are concerned about the security, once you send data on the wire, it is vulnerable, so it must be encrypted at the client.
Also,...
July 17, 2001 at 12:25 pm
Our server setup is:
1 SQL Server 2000 - Production and live site.
1 SQL Server 2000 - Demo Site (also hosts web)
1 SQL Server 2000 - QA, bug db, release db,...
July 16, 2001 at 4:37 pm
My guess is there is a combination of a couple factors.
1. More Oracle physically installed. That accounts for more jobs in general.
2. Oracle is a more complicated product and...
July 16, 2001 at 2:04 pm
If you can, log into the production boxes iwth the SQL Agent account and verify you can send and recieve mail. something may have been lost.
Then log out and...
July 12, 2001 at 11:54 am
July 12, 2001 at 11:52 am
Viewing 15 posts - 39,751 through 39,765 (of 39,791 total)