Have you tried re-downloading the report from the Report Server?

You can also open the RDL in a text editor and manually add the missing attribute.

I'd initally suggest running a Profiler trace against the database when you run the report with Territory 1 selected to see what is being passed to the database. Odds...

In SQL Server 2005 and later you should be querying the sys.tables or sys.all_objects views. These views provide the schema_id and you can then join on the sys.schemas. view...

If you are backing up to a network share there are issues with that and it is not recommended. The recommendation is to backup locally and then copy the...

Well, in the example you provide, you state that not passing a value to an Identity based ID column is causing a problem and that is impossible. You would...

I use http://connectionstrings.com/ to find any connection string information I can't remember. You can "replace" the Password and User Id attributes with either Trusted_Connection=True or Integrated Security = SSPI.

Nice article, I especially appreciated how you included the .NET example of passing a table type parameter. Many articles leave this peace out.

I would have appreciated a few more...

To answer the questions Brad poses at the end of the column:

Are DBAs drawn to their work because of their maturity, or do organizations who hire DBAs tend to prefer...

It's never too late to provide a good resource, thanks Markus. Make...

Grant Fritchey (7/27/2009)

---

GilaMonster (7/27/2009)

---

Roy Ernest (7/27/2009)

---

Bill Wunder. He is the co founder of the group. 🙂 So it was easy to get the first speaker. But after 3 months, I...

Dave Ballantyne (7/25/2009)

---

Jack Corbett (7/21/2009)

---

Dave Ballantyne (7/21/2009)

---

Hi ho hi ho , if off to Disney i go , see you all in 4 weeks.

Enjoyed my short time here, more...

For Jeff, PRKCHP

or

BACKUP

or

RSTORE

This site is good, you just need to search for what you need to know like Backups. Some other sites that are good are http://www.sqlserverpedia.com, http://www.mssqltips.com, and http://www.jumpstarttv.com.

Huh, I didn't know that "ColumnName = " was deprecated. I know people who really prefer that method. I NEVER use it, I ALWAYS use the seconf "AS...

If you meant the math division operator then you use "/".