Do you mean that the SSIS data type is text or the SQL data type is Text?

Is the source SQL Server 2000 or 2005?

You could use a...

Does the user being used for the report connection have rights to use the linked server and rights to the table(s) on the linked server?

If you have any foreign keys you cannot use truncate nor can you delete any rows that have "child" rows. For example if I have orders and order_details with...

Case

When IS_MEMBER('role') = 1 Then 1 -- is a member

Else 0 -- not a...

Are you rebuilding indexes in the maintenance plan? This will cause the TX log to grow.

Oh and BTW- you should post in an appropriate forum not in...

Go into the table design view, right-click and select Indexes/Keys, click add new and change the Type to unique key.

Please check out the links in my signature line for tips on how to present a question so that it cna be easily understood and answers provided.

Why are you using a datareader source? Could you use a straight ole db source?

Do you want to include "NULL" at all times? Typically when I have parameters I have an ID I use as the value and a name or desc I...

Yeah, but you added some stuff I missed AND...

Nope. In SQL Server 7, 2000 profiler doesn't include anything that includes the word password.

Even without a question I have some comments:

1. In your definition Create procedure usp_getInfo(@sql,@v_dt datetime, @o_company_name varchar(255) you are not giving the @sql parameter a data type...

You could write something in .NET that enumerates the servers and logs in and gets the edition. It shouldn't take too long to have a simple utility that does...

It sounds to me like the vendor is trying to make their product appear to be less expensive than it really should be.

I've had this discussion with my Network/Server Admin...

David NienDuy Nguyen (9/18/2008)

---

Hi All,

I ran into the same situation. I was assigned to identify and remedy poor performing queries on an extremely heavy use production server. First I...