Viewing 15 posts - 8,941 through 8,955 (of 9,720 total)
You're saying you got it to work finally?
February 27, 2008 at 4:32 am
Yes, that is correct.
And yes, a customer can have more than one contract.
February 27, 2008 at 4:21 am
Lynn,
That's the problem. The OLTP doesn't have a Customers or Address table. All the customer info is stored in the OLTPContract table.
If I had separate tables in the...
February 26, 2008 at 10:26 am
I should mention, I don't keep AddressKey in the fact table since people can have multiple addresses. Mailing address, street address, etc.
February 26, 2008 at 9:19 am
Lynn,
Here are the create statements (sanitzed). The OLTP table does contain more columns but I'm only concerned with a small few.
Create Table OLTPContracts (ContractID int identity(1,1), FirstName varchar(25), LastName...
February 26, 2008 at 9:16 am
The easiest way to find errors is while you're in BIDS. When you execute a package in BIDS, it throws you into Debug Mode. When you're in Debug...
February 26, 2008 at 8:37 am
That one is pretty simple. You're trying to create something on the 2000 db that 2000 doesn't support. It could be a data type of a column...
February 26, 2008 at 7:40 am
Thanks, Guys.
One of my coworkers found the issue by pulling the fields into a XML datatype variable. It was a hidden character with some bizarre value that...
February 25, 2008 at 7:25 am
And that might be true, but the OP might have meant something different too. So, I'd like to hear from him regarding what he's trying to accomplish to make...
February 22, 2008 at 4:23 am
Ed,
Let me guess. Readers were asking him how much the resource cost. @=)
February 22, 2008 at 4:20 am
I'm glad I started this thread. I've been enjoying everyone's quotes. @=)
February 21, 2008 at 11:09 am
You don't need to make the login owner of the database in order to view the database. Not unless you're wanting that user to be able to alter database...
February 21, 2008 at 11:08 am
Practice, practice, practice with SSMS. Explore the GUI and figure out how to do everything. Right click every menu item, examine every available option, test every possible thing...
February 21, 2008 at 6:22 am
John,
Have you checked your desktop for bits of wings, legs, antenna? Sounds like there's a 'bug' in the system to me. @=)
Configuration Manager sets encryption so you can use...
February 14, 2008 at 10:16 am
And if your System Admin try to request DB access, you need to point out to your boss the concept of "Separation of duties" and all those wonderful data breaches...
February 14, 2008 at 7:54 am
Viewing 15 posts - 8,941 through 8,955 (of 9,720 total)