Viewing 15 posts - 796 through 810 (of 1,346 total)
when you are creating your package on your pump task it asks you for a table/view or a query. In the query window type in your stored procedure name.
Dts will...
October 13, 2005 at 10:21 am
You'll have to do it in a couple of updates though. And you may have to create an additional update if there are single characters at the beginning of the...
October 13, 2005 at 10:16 am
If you modify any information in your subscriber tables you can cause replication to fail, but you cannot "Push" changes to production .
October 13, 2005 at 9:53 am
Does this happen everytime you run the package?
It is likely that the package is blocking itself, you may have some asyncronous events working on the same table. Use flow control...
October 13, 2005 at 9:52 am
The query will work but reading this article may give you a little more in depth knowledge about self referencing tables.
October 12, 2005 at 5:14 pm
In either case you'll need to use a stored procedure.
and you can structure your stored procedure 2 ways.
1 way is to evaluate the parameters passed in.
If @param1 is null, and...
October 12, 2005 at 11:33 am
In report manager navigate to the report. click on it to run it.
Click the properties tab on top. select data sources on the left and configure your data source for...
October 12, 2005 at 9:50 am
What is the performance issue the customer is experiencing?
is it slow inserts?
is it slow updates?
Slow queries?
you need to be more specific.
the Choice of which column to use as clustered index...
October 12, 2005 at 9:47 am
In reporting services, You going to have to embed your query in a stored procedure and either have if then else logic to decide which query to run, or use...
October 12, 2005 at 9:38 am
Well Like I said please present us with a sample table, some sample data, what your trying to do, and what you want as a result. and Someone can help...
October 12, 2005 at 9:30 am
Because the values of col_c in table a is different than your derived value of '' in col_c in table_b?
your using the union statement which removes duplicates from your 2...
October 12, 2005 at 9:21 am
Have not idea, never noticed it being a problem.
October 12, 2005 at 9:07 am
The key word you use is Ad-Hoc I've seen tons of companys who think they need this, but it boils down to the fact the company just doesn't know what...
October 12, 2005 at 9:06 am
There is no difference. Except a maintenance plan is usually scheduled, so its manual vs automatic.
If your new to sql, and are responsible for production database, then you should definatelly...
October 12, 2005 at 9:01 am
Enterprise manager?
You really should switch to Query Analyzer. That is the Baseline of what you should use.
you can also use visual studio
October 11, 2005 at 4:55 pm
Viewing 15 posts - 796 through 810 (of 1,346 total)