I disagree with Michael's suggestion, although he is correct in all that he says, there is one key point he didn't mention, security. If you put all the data...

Duplicate post please reply here: http://www.sqlservercentral.com/Forums/Topic633268-148-1.aspx

If you are in simple recovery you can restore the last full backup to another database and then copy the deleted rows (if they exist in the last backup) to...

Can you provide the DDL for your source tables?

You would need to create something custom in order to do this, that either runs the report and zips it, or you could have the subscription place it in folder...

knausk (1/12/2009)

---

After this priming discussion, I think from now on if I interview somewhere I will always take a bit of time to chit chat and ask those present how...

There should be a property on the text box for Hide Duplicates. This should be set to false.

Can you post your connection string, SQL code being executed and asp code? Without all these details we don't know if it is the rendering that is timing out...

Based on the error I would say that SSIS does handle SQL Variant, but gives a warning to let you know it is handling it using a unicode string data...

To add to what Drew said, please see the links in my signature line.

Gupreet,

Please continue to post on this thread, I am subscribed to it so I will be notified when you post on it. In order to give accurate help...

RBarryYoung (1/11/2009)

---

Stephanie J Brown (1/11/2009)

---

mtucker (1/11/2009)

---

The sad reality is that people make judgements about you based on appearance and other things that have no relation to how good an employee...

Attached is a report with this query:

[font="Courier New"]SELECT

            S.schema_id,

            S.name AS schema_name,

            COUNT(O.OBJECT_ID) AS objects_in_schema

    FROM

            sys.schemas S JOIN

            sys.all_objects O ON

            S.schema_id = O.schema_id

    GROUP BY

            S.schema_id,

            S.name

            [/font]

The report has a list control with a group on schema_id and...

Steve Jones - Editor (1/10/2009)

---

I don't think 2005 has any advantages over 2008. 2008 is essentially a 2nd version of 2005 with features bolted on. Now I wouldn't necessarily use...

Master is not more important than the resource database, as the instance will not start without the resource database. The fact that it is hidden should tip you off...