mak12 (11/22/2011)

---

I script view as CREATE to New Query Editor window .....I got error(property textHeader is not avilable for view '[dbo].[vwxy]'. this property may not exist for this object,...

Joe B-478020 (11/21/2011)

---

I have the following problem...

We have a manufacturing system database that continues to grow. Each day, new manufacturing orders and purchase orders are inserted and new transactions...

sql_er (11/18/2011)

---

I now run SSIS_parent, which is supposed to just take the variable values, pass them to SSIS_child and then run the package. The run fails with the following...

ShawnTherrien (11/18/2011)

---

Ethnicity is also required at a certain step of enrollment, but not before. This means it can also not exist at some point, so if it's part of Student,...

You may want to take a look at document next: http://msdn.microsoft.com/en-us/library/cc966412.aspx ... it describes Microsoft Best Practices for testing I/O subsystem capacity and performance.

ShawnTherrien (11/17/2011)

---

IMO, a student entity is basically the most immediate information about what a student is. Maybe just their name, SSN, birthdate. A lot more can be broken out into...

By dropping the child table FK... dropping/recreating your Parent table PK... recreating...

JakeSA (11/18/2011)

---

I'm sure some of you will agree that virtualization is the wave of the future that's coming fast. However, for someone with some SQL server certs and some...

I'm in agreement with both Grant and Gail.

Your training time would be much better used if focusing on what should be your area of expertise which is to be a...

Try it 🙂

Hello there 🙂

Thanks God you have good manners - anything we can help with?

Jako de Wet (11/18/2011)

---

I have a web application that calls an unscheduled job that in turns runs a SSIS package.

The web application uses a limited user account, but to be...

I'm having a hard time trying to understand the logic... could you please post the expected result as well as how are you planning to match rows on TableA and...

This may be better served in a BIDS discussion, did you try http://bidshelper.codeplex.com/discussions

Posting on SSC "Business Intelligence" section wouldn't hurt either 🙂

I would try adding a mask to to_number function, like...

select * from Openquery([MyOracleDatabase],'select DateCol,...