Viewing 15 posts - 7,441 through 7,455 (of 9,643 total)
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...
September 22, 2008 at 7:55 am
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?
September 22, 2008 at 7:52 am
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...
September 22, 2008 at 7:50 am
Case
When IS_MEMBER('role') = 1 Then 1 -- is a member
Else 0 -- not a...
September 22, 2008 at 7:46 am
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...
September 22, 2008 at 7:37 am
Go into the table design view, right-click and select Indexes/Keys, click add new and change the Type to unique key.
September 22, 2008 at 7:30 am
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.
September 22, 2008 at 7:25 am
Why are you using a datareader source? Could you use a straight ole db source?
September 22, 2008 at 7:12 am
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...
September 22, 2008 at 6:55 am
Chris Harshman (9/18/2008)
oops, i see it took me so long to type all this someone else pretty much said the same stuff.
Yeah, but you added some stuff I missed AND...
September 18, 2008 at 1:15 pm
Nope. In SQL Server 7, 2000 profiler doesn't include anything that includes the word password.
September 18, 2008 at 12:52 pm
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...
September 18, 2008 at 12:48 pm
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...
September 18, 2008 at 12:28 pm
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...
September 18, 2008 at 12:24 pm
David NienDuy Nguyen (9/18/2008)
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...
September 18, 2008 at 10:15 am
Viewing 15 posts - 7,441 through 7,455 (of 9,643 total)