Is it possible to manually run a subscription?

I'm wondering if there's a way through code to manually trigger a timed
subscription to run? The only thing I can see is to create an additional
schedule on the fly set for a few minutes in advance.
Any help would greatly be appriciated.
JoshYou can open Enterprise Manager and find the job with the same
scherduled time, right click and tell it to run.|||holy crap, no wonder sql server agent has to be running. I'm a bit
ashamed I never investigated this before.
I actually need to fire off the subscription through code. I'd imagine
this could be done then through SQLDMO.
Thanks for your response.
Lon wrote:
> You can open Enterprise Manager and find the job with the same
> scherduled time, right click and tell it to run.
>

Is it possible to get MSDE & SQL Server 2005 Express run on the same machine?

Hi guys,

I'm just wondering if the MSDE & SQL Server 2005 Express can run on the same machine(winxp) without conflicts. Because I need both the reporting services & the publication functionality of replication.

Thanks in advance.

Hi,

yes running both instances on the same system is possible.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

Hi,

Yes as said you can run both on same machine without any problem, my machine have both installed on it.

Hemantgiri S. Goswami

|||Thanks guys. I appreciate ur time. :)

Is it possible to design a ReportViewer report at run time?

Is it possible to design the report at run time rather than placing and position the controls on the report at design time. I would like to be able to set the visibility and position columns in a table of the report.There is an 'Expression...' option for visibility. You have to use a number for the position though. You might be able to write an embeded function that can set them.

Is it possible to conditionally skip steps in a job?

Is it possible to conditionally skip or jump steps in a job without failing a
step?
For example I don’t want to run a step if the are no records in a table.
I also need to loop based on a condition.
Sounds like a DTS package is a better choice for this type of work.
Andrew J. Kelly SQL MVP
"Dave" <Dave@.discussions.microsoft.com> wrote in message
news:742CC080-17BE-4885-AFF4-D5769DE1AC0E@.microsoft.com...
> Is it possible to conditionally skip or jump steps in a job without
> failing a
> step?
> For example I don't want to run a step if the are no records in a table.
> I also need to loop based on a condition.
>
|||Yes, you can... select the task. Right click and go to task properties ( I
could be mistaken and it might be in the workflow properties..) but you can
associate a script ( the button is on the lower left side of the dialog
box.)..
The script returns a value which indicates whether the step/task should run
or not...
Sorry I can't remember better details, and I only have Yukon installed on
this box...
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
(Please respond only to the newsgroup.)
I support the Professional Association for SQL Server ( PASS) and it's
community of SQL Professionals.
"Dave" <Dave@.discussions.microsoft.com> wrote in message
news:742CC080-17BE-4885-AFF4-D5769DE1AC0E@.microsoft.com...
> Is it possible to conditionally skip or jump steps in a job without
failing a
> step?
> For example I don't want to run a step if the are no records in a table.
> I also need to loop based on a condition.
>
|||If this is with a job you can generate failure inside that step with
RAISERROR and then on job properties choose on failure go to the next step.
Other way with a job is to combine these 2 steps in one and make
a condition inside.
If this is a DTS go to the sqldts.com - there is a very good example
of skipping steps inside DTS package.
Regards.
"Dave" wrote:

> Is it possible to conditionally skip or jump steps in a job without failing a
> step?
> For example I don’t want to run a step if the are no records in a table.
> I also need to loop based on a condition.
>

Is it possible to conditionally skip steps in a job?

Is it possible to conditionally skip or jump steps in a job without failing
a
step?
For example I don’t want to run a step if the are no records in a table.
I also need to loop based on a condition.Sounds like a DTS package is a better choice for this type of work.
Andrew J. Kelly SQL MVP
"Dave" <Dave@.discussions.microsoft.com> wrote in message
news:742CC080-17BE-4885-AFF4-D5769DE1AC0E@.microsoft.com...
> Is it possible to conditionally skip or jump steps in a job without
> failing a
> step?
> For example I don't want to run a step if the are no records in a table.
> I also need to loop based on a condition.
>|||Yes, you can... select the task. Right click and go to task properties ( I
could be mistaken and it might be in the workflow properties..) but you can
associate a script ( the button is on the lower left side of the dialog
box.)..
The script returns a value which indicates whether the step/task should run
or not...
Sorry I can't remember better details, and I only have Yukon installed on
this box...
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
(Please respond only to the newsgroup.)
I support the Professional Association for SQL Server ( PASS) and it's
community of SQL Professionals.
"Dave" <Dave@.discussions.microsoft.com> wrote in message
news:742CC080-17BE-4885-AFF4-D5769DE1AC0E@.microsoft.com...
> Is it possible to conditionally skip or jump steps in a job without
failing a
> step?
> For example I don't want to run a step if the are no records in a table.
> I also need to loop based on a condition.
>|||If this is with a job you can generate failure inside that step with
RAISERROR and then on job properties choose on failure go to the next step.
Other way with a job is to combine these 2 steps in one and make
a condition inside.
If this is a DTS go to the sqldts.com - there is a very good example
of skipping steps inside DTS package.
Regards.
"Dave" wrote:

> Is it possible to conditionally skip or jump steps in a job without failin
g a
> step?
> For example I don’t want to run a step if the are no records in a table.
> I also need to loop based on a condition.
>

Is it possible to conditionally skip steps in a job?

Is it possible to conditionally skip or jump steps in a job without failing a
step?
For example I donâ't want to run a step if the are no records in a table.
I also need to loop based on a condition.Sounds like a DTS package is a better choice for this type of work.
--
Andrew J. Kelly SQL MVP
"Dave" <Dave@.discussions.microsoft.com> wrote in message
news:742CC080-17BE-4885-AFF4-D5769DE1AC0E@.microsoft.com...
> Is it possible to conditionally skip or jump steps in a job without
> failing a
> step?
> For example I don't want to run a step if the are no records in a table.
> I also need to loop based on a condition.
>|||Yes, you can... select the task. Right click and go to task properties ( I
could be mistaken and it might be in the workflow properties..) but you can
associate a script ( the button is on the lower left side of the dialog
box.)..
The script returns a value which indicates whether the step/task should run
or not...
Sorry I can't remember better details, and I only have Yukon installed on
this box...
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
(Please respond only to the newsgroup.)
I support the Professional Association for SQL Server ( PASS) and it's
community of SQL Professionals.
"Dave" <Dave@.discussions.microsoft.com> wrote in message
news:742CC080-17BE-4885-AFF4-D5769DE1AC0E@.microsoft.com...
> Is it possible to conditionally skip or jump steps in a job without
failing a
> step?
> For example I don't want to run a step if the are no records in a table.
> I also need to loop based on a condition.
>|||If this is with a job you can generate failure inside that step with
RAISERROR and then on job properties choose on failure go to the next step.
Other way with a job is to combine these 2 steps in one and make
a condition inside.
If this is a DTS go to the sqldts.com - there is a very good example
of skipping steps inside DTS package.
Regards.
"Dave" wrote:
> Is it possible to conditionally skip or jump steps in a job without failing a
> step?
> For example I donâ't want to run a step if the are no records in a table.
> I also need to loop based on a condition.
>

Is it possible to change the operator of an expression at run time?

I have a report I have created in local mode, in a Winform ReportViewer using VB.net.

Is it possible to change the operator of an expression at run time? That is, I have a filter on a list that looks like this:

Expression: =Fields!InvNum.Value

Operator: =

Value: =Parameters!InvNum.Value

It is possible in code to change the operator from = to >= at the time I run the report? If so, what is the syntax? What I would like to do (don't know it is possible) is to have the operator set to >= at the time the the report is run and then set it back to = when a user selects a specific value for a Parameter for the report. Is this possible?

I suppose I can set it in the load event of the form that contains the ReportViewer, but if this is possible I have not been able to discover the syntax.

Anyone?

You can't change the filter operator at run-time. But you can change the filter expression to =IIF(<your condition>, Fields!InvNum.Value=Parameters!InvNum.Value, Fields!InvNum.Value>=Parameters!InvNum.Value), and the filter value to =true.|||

Thank you for responding.

It's not clear to me what you're saying. I mean I understand that you can change the filter expression as a whole (and not the filter operator) and I understand that you can do that with an Immediate IF statement, but where?

Are you saying that you can change the expression in code, at run time? If so, how and Where, specifically?

Or, are you saying that in the Filter tab of the List component that you can enter an IIF there? If so, what kind of value would I put in <your condition>?

It may be that I am asking a question that seems illogical to you, like "How is time?". But to me, what I am trying to do is pretty common. I am trying to figure out a way to bring lots of information into a report and then give the user the ability to whittle it down if he wants to.

|||

OK. I think I understand some of this. I created an additional string parameter for the report called IWantToSeeAllRows. I set the default value to Y. Then in the filter tab of the list, in the expression column I typed the following:

=IIF(Parameters!IWantAllRows.Value = "Y", Fields!InvNum.Value>=Parameters!InvNum.Value, Fields!InvNum.Value=Parameters!InvNum.Value)

After typing the above RS put an = character in the Operator column and <Blank> in the Value column of the grid in the filter tab.

When running the report I get an error of "Cannot compare data of types system boolean and system string. Please check the data type returned by the filter expression.

I am really guessing here as to where just exactly to place the code etc., but the documentation that I've found on the matter is not explicit for this particular issue. What am I missing?

|||

Most likely you changed the filter value expression to a constant value like TRUE (which is interpreted as string - hence the type mismatch).

Change the filter value expression to =True (which evalutes to a boolean)

-- Robert

Is it possible run C# .net Standard against SQL Server 2000?

Hi all!

I keep getting an error when I try and create a new data connection. This is the error I'm getting:

Unable to connect to database.
It is only possible to connect to SQL Server Desktop Engine databases and Microsoft Access with this version of Visual Studio.

I can connect to Access without any problems. Is there anyway around this?
I'm using C# .net Standard with SQL Server 2000.

Thanks for any help.>>It is only possible to connect to SQL Server Desktop Engine databases and Microsoft Access with this version of Visual Studio.

What version?? "C#.net standard" ??

What version of the .NET framework are you using? What IDE are you using?|||Thanks ehorn for reply

I'd like to runVisual C#.net 2003 Standard IDE against SQL Server 2000

I'm using Framework 1.1|||Given that you say this is the error:

Unable to connect to database.
It is only possible to connect to SQL Server Desktop Engine databases and Microsoft Access with this version of Visual Studio.

I imagine that the problem is exactly what it says. That is, the version you are using will NOT allow you to access SQL Server. However, if you install the MSDE on your machine (which is binary compatible with SQL Server) you will be able to access that.|||Thanks Douglas for reply!

It was exactly what I did but now trying to install MSDE I'm getting the error:
'The instance name specified is invalid.'

Will I have to remove SQL Server first then try again?|||I expect so, or alternately, specify an instance name while installing MSDE.

Is it ok to run DBCC Checkdb on msdb and master?

Will I encounter any issues running DBCC CHECKDB on either msdb or master?

Thanks!

I just wouldn't recommend using any of the [REPAIR_...] options.

It is a good idea to do so before a backup to have confidence that the backup is ok. (About the backup if there is a problem - and alert the DBA.

Is it necessary to add a GO ?

We have to run two update statements:
update pthdbo.table14
set name = t3.sortname
from pthdbo.table14 as t1,
xxxxxx
AND
update pthdbo.table14
set streetname = t7.streetname
from pthdbo.table as t1,
yyyyyy
Can I run these 2 update statements together ? Is it
necessary for me to add a GO statement after running the
first UPDATE statement ? If YES, would you mind to let me
know why ?
Thanks
Jason
GO is a batch "breaker" and it is not TSQL command
If you run it on QA you may want to consider putting GO between an UPDATE
statements
"Jason" <anonymous@.discussions.microsoft.com> wrote in message
news:01e301c5b9bd$ab182150$a601280a@.phx.gbl...
> We have to run two update statements:
> update pthdbo.table14
> set name = t3.sortname
> from pthdbo.table14 as t1,
> xxxxxx
> AND
> update pthdbo.table14
> set streetname = t7.streetname
> from pthdbo.table as t1,
> yyyyyy
> Can I run these 2 update statements together ? Is it
> necessary for me to add a GO statement after running the
> first UPDATE statement ? If YES, would you mind to let me
> know why ?
> Thanks
|||Additional information:
For the concept of batch, assume there are 10 statements in a batch. If the
fifth statement has a syntax error, none of the statements in the batch are
executed. If the batch is compiled, and the second statement then fails
while executing, the results of the first statement are not affected because
it has already executed.
Read the online help for more information and detailed explanation.
"Uri Dimant" <urid@.iscar.co.il> glsD:OLbGPKcuFHA.3660@.tk2msftngp13.phx.g bl...
> Jason
> GO is a batch "breaker" and it is not TSQL command
> If you run it on QA you may want to consider putting GO between an UPDATE
> statements
>
> "Jason" <anonymous@.discussions.microsoft.com> wrote in message
> news:01e301c5b9bd$ab182150$a601280a@.phx.gbl...
>
|||Dear all,
Thank you for your advice.
In this way, I can add GO after both Update Statement. However, it seems
that the one after the 2nd Update Statement is optional AS there is nothing
behind it ?
use database1
GO
update pthdbo.table14
set name = t3.sortname
from pthdbo.table14 as t1,
xxxxxx
GO
update pthdbo.table14
set streetname = t7.streetname
from pthdbo.table as t1,
yyyyyy
GO
Thanks
"Lau Lei Cheong" <leu_lc@.yehoo.com.hk> wrote in message
news:edEK12cuFHA.3896@.TK2MSFTNGP15.phx.gbl...
> Additional information:
> For the concept of batch, assume there are 10 statements in a batch. If
> the fifth statement has a syntax error, none of the statements in the
> batch are executed. If the batch is compiled, and the second statement
> then fails while executing, the results of the first statement are not
> affected because it has already executed.
> Read the online help for more information and detailed explanation.
> "Uri Dimant" <urid@.iscar.co.il>
> glsD:OLbGPKcuFHA.3660@.tk2msftngp13.phx.g bl...
>
|||No. The first GO signals begining of a batch process(i.e. put it in batch
processing mode), and the second GO signal that's the end of it so it gets
executed.
"Jason" <anonymous@.discussions.microsoft.com> glsD:OVvXrNeuFHA.3596@.TK2MSFTNGP15.phx.g bl...
> Dear all,
> Thank you for your advice.
> In this way, I can add GO after both Update Statement. However, it seems
> that the one after the 2nd Update Statement is optional AS there is
> nothing behind it ?
> use database1
> GO
> update pthdbo.table14
> set name = t3.sortname
> from pthdbo.table14 as t1,
> xxxxxx
> GO
> update pthdbo.table14
> set streetname = t7.streetname
> from pthdbo.table as t1,
> yyyyyy
> GO
> Thanks
> "Lau Lei Cheong" <leu_lc@.yehoo.com.hk> wrote in message
> news:edEK12cuFHA.3896@.TK2MSFTNGP15.phx.gbl...
>

Is it necessary to add a GO ?

We have to run two update statements:
update pthdbo.table14
set name = t3.sortname
from pthdbo.table14 as t1,
xxxxxx
AND
update pthdbo.table14
set streetname = t7.streetname
from pthdbo.table as t1,
yyyyyy
Can I run these 2 update statements together ? Is it
necessary for me to add a GO statement after running the
first UPDATE statement ? If YES, would you mind to let me
know why ?
ThanksJason
GO is a batch "breaker" and it is not TSQL command
If you run it on QA you may want to consider putting GO between an UPDATE
statements
"Jason" <anonymous@.discussions.microsoft.com> wrote in message
news:01e301c5b9bd$ab182150$a601280a@.phx.gbl...
> We have to run two update statements:
> update pthdbo.table14
> set name = t3.sortname
> from pthdbo.table14 as t1,
> xxxxxx
> AND
> update pthdbo.table14
> set streetname = t7.streetname
> from pthdbo.table as t1,
> yyyyyy
> Can I run these 2 update statements together ? Is it
> necessary for me to add a GO statement after running the
> first UPDATE statement ? If YES, would you mind to let me
> know why ?
> Thanks|||Additional information:
For the concept of batch, assume there are 10 statements in a batch. If the
fifth statement has a syntax error, none of the statements in the batch are
executed. If the batch is compiled, and the second statement then fails
while executing, the results of the first statement are not affected because
it has already executed.
Read the online help for more information and detailed explanation.
"Uri Dimant" <urid@.iscar.co.il> ¼¶¼g©ó¶l¥ó·s»D:OLbGPKcuFHA.3660@.tk2msftngp13.phx.gbl...
> Jason
> GO is a batch "breaker" and it is not TSQL command
> If you run it on QA you may want to consider putting GO between an UPDATE
> statements
>
> "Jason" <anonymous@.discussions.microsoft.com> wrote in message
> news:01e301c5b9bd$ab182150$a601280a@.phx.gbl...
>> We have to run two update statements:
>> update pthdbo.table14
>> set name = t3.sortname
>> from pthdbo.table14 as t1,
>> xxxxxx
>> AND
>> update pthdbo.table14
>> set streetname = t7.streetname
>> from pthdbo.table as t1,
>> yyyyyy
>> Can I run these 2 update statements together ? Is it
>> necessary for me to add a GO statement after running the
>> first UPDATE statement ? If YES, would you mind to let me
>> know why ?
>> Thanks
>|||Dear all,
Thank you for your advice.
In this way, I can add GO after both Update Statement. However, it seems
that the one after the 2nd Update Statement is optional AS there is nothing
behind it ?
use database1
GO
update pthdbo.table14
set name = t3.sortname
from pthdbo.table14 as t1,
xxxxxx
GO
update pthdbo.table14
set streetname = t7.streetname
from pthdbo.table as t1,
yyyyyy
GO
Thanks
"Lau Lei Cheong" <leu_lc@.yehoo.com.hk> wrote in message
news:edEK12cuFHA.3896@.TK2MSFTNGP15.phx.gbl...
> Additional information:
> For the concept of batch, assume there are 10 statements in a batch. If
> the fifth statement has a syntax error, none of the statements in the
> batch are executed. If the batch is compiled, and the second statement
> then fails while executing, the results of the first statement are not
> affected because it has already executed.
> Read the online help for more information and detailed explanation.
> "Uri Dimant" <urid@.iscar.co.il>
> ¼¶¼g©ó¶l¥ó·s»D:OLbGPKcuFHA.3660@.tk2msftngp13.phx.gbl...
>> Jason
>> GO is a batch "breaker" and it is not TSQL command
>> If you run it on QA you may want to consider putting GO between an
>> UPDATE statements
>>
>> "Jason" <anonymous@.discussions.microsoft.com> wrote in message
>> news:01e301c5b9bd$ab182150$a601280a@.phx.gbl...
>> We have to run two update statements:
>> update pthdbo.table14
>> set name = t3.sortname
>> from pthdbo.table14 as t1,
>> xxxxxx
>> AND
>> update pthdbo.table14
>> set streetname = t7.streetname
>> from pthdbo.table as t1,
>> yyyyyy
>> Can I run these 2 update statements together ? Is it
>> necessary for me to add a GO statement after running the
>> first UPDATE statement ? If YES, would you mind to let me
>> know why ?
>> Thanks
>>
>|||No. The first GO signals begining of a batch process(i.e. put it in batch
processing mode), and the second GO signal that's the end of it so it gets
executed.
"Jason" <anonymous@.discussions.microsoft.com> ¼¶¼g©ó¶l¥ó·s»D:OVvXrNeuFHA.3596@.TK2MSFTNGP15.phx.gbl...
> Dear all,
> Thank you for your advice.
> In this way, I can add GO after both Update Statement. However, it seems
> that the one after the 2nd Update Statement is optional AS there is
> nothing behind it ?
> use database1
> GO
> update pthdbo.table14
> set name = t3.sortname
> from pthdbo.table14 as t1,
> xxxxxx
> GO
> update pthdbo.table14
> set streetname = t7.streetname
> from pthdbo.table as t1,
> yyyyyy
> GO
> Thanks
> "Lau Lei Cheong" <leu_lc@.yehoo.com.hk> wrote in message
> news:edEK12cuFHA.3896@.TK2MSFTNGP15.phx.gbl...
>> Additional information:
>> For the concept of batch, assume there are 10 statements in a batch. If
>> the fifth statement has a syntax error, none of the statements in the
>> batch are executed. If the batch is compiled, and the second statement
>> then fails while executing, the results of the first statement are not
>> affected because it has already executed.
>> Read the online help for more information and detailed explanation.
>> "Uri Dimant" <urid@.iscar.co.il> ¼¶¼g©ó¶l¥ó·s»D:OLbGPKcuFHA.3660@.tk2msftngp13.phx.gbl...
>> Jason
>> GO is a batch "breaker" and it is not TSQL command
>> If you run it on QA you may want to consider putting GO between an
>> UPDATE statements
>>
>> "Jason" <anonymous@.discussions.microsoft.com> wrote in message
>> news:01e301c5b9bd$ab182150$a601280a@.phx.gbl...
>> We have to run two update statements:
>> update pthdbo.table14
>> set name = t3.sortname
>> from pthdbo.table14 as t1,
>> xxxxxx
>> AND
>> update pthdbo.table14
>> set streetname = t7.streetname
>> from pthdbo.table as t1,
>> yyyyyy
>> Can I run these 2 update statements together ? Is it
>> necessary for me to add a GO statement after running the
>> first UPDATE statement ? If YES, would you mind to let me
>> know why ?
>> Thanks
>>
>>
>

Is it necessary to add a GO ?

We have to run two update statements:
update pthdbo.table14
set name = t3.sortname
from pthdbo.table14 as t1,
xxxxxx
AND
update pthdbo.table14
set streetname = t7.streetname
from pthdbo.table as t1,
yyyyyy
Can I run these 2 update statements together ? Is it
necessary for me to add a GO statement after running the
first UPDATE statement ? If YES, would you mind to let me
know why ?
ThanksJason
GO is a batch "breaker" and it is not TSQL command
If you run it on QA you may want to consider putting GO between an UPDATE
statements
"Jason" <anonymous@.discussions.microsoft.com> wrote in message
news:01e301c5b9bd$ab182150$a601280a@.phx.gbl...
> We have to run two update statements:
> update pthdbo.table14
> set name = t3.sortname
> from pthdbo.table14 as t1,
> xxxxxx
> AND
> update pthdbo.table14
> set streetname = t7.streetname
> from pthdbo.table as t1,
> yyyyyy
> Can I run these 2 update statements together ? Is it
> necessary for me to add a GO statement after running the
> first UPDATE statement ? If YES, would you mind to let me
> know why ?
> Thanks|||Additional information:
For the concept of batch, assume there are 10 statements in a batch. If the
fifth statement has a syntax error, none of the statements in the batch are
executed. If the batch is compiled, and the second statement then fails
while executing, the results of the first statement are not affected because
it has already executed.
Read the online help for more information and detailed explanation.
"Uri Dimant" <urid@.iscar.co.il> glsD:OLbGPKcuFHA.3660@.tk2msftngp13.phx.gbl...[vbco
l=seagreen]
> Jason
> GO is a batch "breaker" and it is not TSQL command
> If you run it on QA you may want to consider putting GO between an UPDATE
> statements
>
> "Jason" <anonymous@.discussions.microsoft.com> wrote in message
> news:01e301c5b9bd$ab182150$a601280a@.phx.gbl...
>[/vbcol]|||Dear all,
Thank you for your advice.
In this way, I can add GO after both Update Statement. However, it seems
that the one after the 2nd Update Statement is optional AS there is nothing
behind it ?
use database1
GO
update pthdbo.table14
set name = t3.sortname
from pthdbo.table14 as t1,
xxxxxx
GO
update pthdbo.table14
set streetname = t7.streetname
from pthdbo.table as t1,
yyyyyy
GO
Thanks
"Lau Lei Cheong" <leu_lc@.yehoo.com.hk> wrote in message
news:edEK12cuFHA.3896@.TK2MSFTNGP15.phx.gbl...
> Additional information:
> For the concept of batch, assume there are 10 statements in a batch. If
> the fifth statement has a syntax error, none of the statements in the
> batch are executed. If the batch is compiled, and the second statement
> then fails while executing, the results of the first statement are not
> affected because it has already executed.
> Read the online help for more information and detailed explanation.
> "Uri Dimant" <urid@.iscar.co.il>
> glsD:OLbGPKcuFHA.3660@.tk2msftngp13.phx.gbl...
>|||No. The first GO signals begining of a batch process(i.e. put it in batch
processing mode), and the second GO signal that's the end of it so it gets
executed.
"Jason" <anonymous@.discussions.microsoft.com> glsD:OVvXrNeuFHA.3596@.TK2MSFTNGP15.p
hx.gbl...
> Dear all,
> Thank you for your advice.
> In this way, I can add GO after both Update Statement. However, it seems
> that the one after the 2nd Update Statement is optional AS there is
> nothing behind it ?
> use database1
> GO
> update pthdbo.table14
> set name = t3.sortname
> from pthdbo.table14 as t1,
> xxxxxx
> GO
> update pthdbo.table14
> set streetname = t7.streetname
> from pthdbo.table as t1,
> yyyyyy
> GO
> Thanks
> "Lau Lei Cheong" <leu_lc@.yehoo.com.hk> wrote in message
> news:edEK12cuFHA.3896@.TK2MSFTNGP15.phx.gbl...
>

is it maintenance plan bug?

When I run Integrity check with option attempt to repair
minor problem seems like there is no integrity checking on
databases whic are not in single user mode.
If I disable that option seems that integrity checking is
running.
Also Inegrity Check jobs doesn't report any error but when
I run dbcc checkdb from analyzer I can see 2-3 2511 errors.
Is the Maintenance plan realy reliable or I should
schedule job to run dbcc checkdb. We are running SQL7 sp3
on W2000.
ThanksWe are running dbcc dbreindex on every table in the
database, after Integrity Checks, Is it possible that
index corruption is generated from reindexing command?
Thanks
>--Original Message--
>It is advisable not to have the attempt to repair minor
problems option set
>in the maintenance paln and this issue with it having to
be in single user
>mode is one of the main reasons. Generally it either
can't get it into
>single user mode and fails or leaves it in single user
mode after it
>finishes, neither of which is desirable. With regard to
your specific
>errors, have your tried dropping and creating the indexes
affected
>--
>HTH
>Jasper Smith (SQL Server MVP)
>I support PASS - the definitive, global
>community for SQL Server professionals -
>http://www.sqlpass.org
>"milan" <mmirce01@.yahoo.ca> wrote in message
>news:034201c3507b$2a92a940$a101280a@.phx.gbl...
>When I run Integrity check with option attempt to repair
>minor problem seems like there is no integrity checking on
>databases whic are not in single user mode.
>If I disable that option seems that integrity checking is
>running.
>Also Inegrity Check jobs doesn't report any error but when
>I run dbcc checkdb from analyzer I can see 2-3 2511
errors.
>Is the Maintenance plan realy reliable or I should
>schedule job to run dbcc checkdb. We are running SQL7 sp3
>on W2000.
>Thanks
>
>.
>

Is it better to run maintenance sequentially or pralell

we have a maintenance process which does various dbcc maintenance tasks such
as dbreindex, indexdefrag and updateusage. This process can take over 4
hours for some of the databases.
Is there any drawback to running these maintenance processes parallel on all
databases or is it better to run them sequentially?
Hi
There is no issue with running them in parallel, but, can your disk
subsystem keep up? These taks are very IO intensive.
If they run in parallel, the sum of all the jobs might decrease, but each
individual job will take longer to complete.
Regards
Mike
"DBA72" wrote:

> we have a maintenance process which does various dbcc maintenance tasks such
> as dbreindex, indexdefrag and updateusage. This process can take over 4
> hours for some of the databases.
> Is there any drawback to running these maintenance processes parallel on all
> databases or is it better to run them sequentially?

Is it better to run maintenance sequentially or pralell

we have a maintenance process which does various dbcc maintenance tasks such
as dbreindex, indexdefrag and updateusage. This process can take over 4
hours for some of the databases.
Is there any drawback to running these maintenance processes parallel on all
databases or is it better to run them sequentially?Hi
There is no issue with running them in parallel, but, can your disk
subsystem keep up? These taks are very IO intensive.
If they run in parallel, the sum of all the jobs might decrease, but each
individual job will take longer to complete.
Regards
Mike
"DBA72" wrote:

> we have a maintenance process which does various dbcc maintenance tasks su
ch
> as dbreindex, indexdefrag and updateusage. This process can take over 4
> hours for some of the databases.
> Is there any drawback to running these maintenance processes parallel on a
ll
> databases or is it better to run them sequentially?

Is it better to run maintenance sequentially or pralell

we have a maintenance process which does various dbcc maintenance tasks such
as dbreindex, indexdefrag and updateusage. This process can take over 4
hours for some of the databases.
Is there any drawback to running these maintenance processes parallel on all
databases or is it better to run them sequentially?Hi
There is no issue with running them in parallel, but, can your disk
subsystem keep up? These taks are very IO intensive.
If they run in parallel, the sum of all the jobs might decrease, but each
individual job will take longer to complete.
Regards
Mike
"DBA72" wrote:
> we have a maintenance process which does various dbcc maintenance tasks such
> as dbreindex, indexdefrag and updateusage. This process can take over 4
> hours for some of the databases.
> Is there any drawback to running these maintenance processes parallel on all
> databases or is it better to run them sequentially?

Is it a bug?

Hi,

I'm running SQL 2K5 with SP1.

Whenever I try to run an import from Oracle linked server to my sql server (of course, there are no problems with the import), and if I try to expand any of the folders like Tables, Programmability -> Stored procedures, functions...............I'm not able to see any tables and SPs etc.

It times out and displays error message "Lock request time out period exceeded. (Microsoft SQL Server, Error: 1222).

The linked server (Oracle) import takes 30 to 40 mins and each time it only touches a single table and I don't think this should cause that kind of error but it is.

I'm running this import from Management Studio.

Anybody has any thoughts?

Thanks,

Siva.

SQL Server Management Studio needs some locks to provide the listings. Certain types of data import processes can block other access to the database.

If you can use another method to import data that doesn't lock so much, you can eliminate this problem. I don't know any specific solutions, unfortunately.

-Ryan / Kardax

|||

Hi Ryan,

Thanks for the info.

I did couple of tests on this. It looks like this problem is happening only when importing data but not when querying the linked server inspite of querying also takes lot of time.

Then I tried this import using SSIS and I'm not getting those problems mentioned earlier.

But to be frank, getting data from linked server is very straight forward (when you don't have to do any manipulations with data) and easy compared to SSIS (in my case).

Hopefully, Microsoft will look into this.

Thanks,
Siva.

|||Yes, but linked servers were primarily designed to allow you to offload a query to a remote destination, have it execute it, and then get the results back. It wasn't designed as a data import mechanism. SSIS was designed as a data import mechanism so it is optimized for that type of activity with as low of an overhead as possible.

Is Full Text Struggling...

H there,
We have a query that is taking too long to run, which uses Full Text
(MSSQL2000).
The query below, when using this clause takes between 11 seconds and 10
minutes! QA thnks that the full text search will cost 70% of the query cost.
CONTAINS( Article_text, '("Food" AND "Supermarkets") OR ("CITIZEN CARD") OR
("CJD") OR ("E Coli") OR ("E-Coli") OR ("Food Additives") OR ("Food Safety")
OR ("Genetically Modified Foods") OR ("Kwik Save") OR ("Proof of age card")
OR ("Somerfield") OR ("Supermarkets") OR ("Wine Reviews") AND NOT ("Ahold")
AND NOT ("Beth Israel") AND NOT ("European equity preview") AND NOT
("European stocks may decline") AND NOT ("European stocks may rise") AND NOT
("mediaplex") AND NOT ("UK Stocks Factors")'))
The query below, when using this clause, takes only between 0.02 secs and 2
secs. QA thnks that the full text search will cost 50% of the query cost.
CONTAINS( Article_text, '("alcopops" AND "advertising") OR ("alcopops" AND
"culture") OR ("alcopops" AND "designated driver initiative") OR ("alcopops"
AND "drink driving") OR ("alcopops" AND "legislation") OR ("alcopops" AND
"price") OR ("alcopops" AND "pricing") OR ("alcopops" AND "underage
driving")')
Why is the second query instant and the first taking ages?
Sometimes, the longer queries such as the first one here can take *much*
longer to run (like, 5 minutes). We're hoping that we can get even the
queries with more expressions to run inside a few seconds. In fact, they did
when we had < 400,000 rows.
Is it possible that our full text indexing is just set up wrong, or that our
hardware isn't sufficient?
Some additional facts that may help...
The table (and FT index) only have 800,000 rows
We run 116 of these queries in a row, directly after each other.
We've cleared out all stop words, since we want to index on anything.
The server has 1GB RAM, single P4 processor, 8GB free space across 2 raid
disks.
Whilst the queries are running, I'm not seeing massive memory use.
Any help much appreciated. Please let me know if you need more info.
Tobes
I would suspect its all the search arguments and Boolean logic you have
which is causing the problems especially the AND NOTs.
Note that this
CONTAINS( Article_text, '("alcopops" AND "advertising") OR ("alcopops" AND
"culture") OR ("alcopops" AND "designated driver initiative") OR
("alcopops"
AND "drink driving") OR ("alcopops" AND "legislation") OR ("alcopops" AND
"price") OR ("alcopops" AND "pricing") OR ("alcopops" AND "underage
driving")')
is equivalent to the simpler
CONTAINS( Article_text, '"alcopops" AND ("advertising" OR "culture" OR
"designated driver initiative" OR "drink driving" OR "legislation" OR
"price" OR "pricing" OR "underage driving")')
Revisting the AND NOTs, basically the way this is processed is all matches
are returned for the first part
("Food" AND "Supermarkets") OR ("CITIZEN CARD") OR ("CJD") OR ("E Coli") OR
("E-Coli") OR ("Food Additives") OR ("Food Safety") OR ("Genetically
Modified Foods") OR ("Kwik Save") OR ("Proof of age card") OR
("Somerfield") OR ("Supermarkets") OR ("Wine Reviews")
and then you trim rows which contain
AND NOT ("Ahold") AND NOT ("Beth Israel") AND NOT ("European equity
preview") AND NOT ("European stocks may decline") AND NOT ("European stocks
may rise") AND NOT
("mediaplex") AND NOT ("UK Stocks Factors")'))
This trimming is very expensive.
One thing you might do is sp_fulltext_service 'resource_usage' to 5. This
might help slightly.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Tobin Harris" <tobin@._do_not_spam_tobinharris.com> wrote in message
news:42af07ca$0$2588$da0feed9@.news.zen.co.uk...
> H there,
> We have a query that is taking too long to run, which uses Full Text
> (MSSQL2000).
> The query below, when using this clause takes between 11 seconds and 10
> minutes! QA thnks that the full text search will cost 70% of the query
cost.
> CONTAINS( Article_text, '("Food" AND "Supermarkets") OR ("CITIZEN CARD")
OR
> ("CJD") OR ("E Coli") OR ("E-Coli") OR ("Food Additives") OR ("Food
Safety")
> OR ("Genetically Modified Foods") OR ("Kwik Save") OR ("Proof of age
card")
> OR ("Somerfield") OR ("Supermarkets") OR ("Wine Reviews") AND NOT
("Ahold")
> AND NOT ("Beth Israel") AND NOT ("European equity preview") AND NOT
> ("European stocks may decline") AND NOT ("European stocks may rise") AND
NOT
> ("mediaplex") AND NOT ("UK Stocks Factors")'))
> The query below, when using this clause, takes only between 0.02 secs and
2
> secs. QA thnks that the full text search will cost 50% of the query cost.
> CONTAINS( Article_text, '("alcopops" AND "advertising") OR ("alcopops" AND
> "culture") OR ("alcopops" AND "designated driver initiative") OR
("alcopops"
> AND "drink driving") OR ("alcopops" AND "legislation") OR ("alcopops" AND
> "price") OR ("alcopops" AND "pricing") OR ("alcopops" AND "underage
> driving")')
> Why is the second query instant and the first taking ages?
> Sometimes, the longer queries such as the first one here can take *much*
> longer to run (like, 5 minutes). We're hoping that we can get even the
> queries with more expressions to run inside a few seconds. In fact, they
did
> when we had < 400,000 rows.
> Is it possible that our full text indexing is just set up wrong, or that
our
> hardware isn't sufficient?
> Some additional facts that may help...
> The table (and FT index) only have 800,000 rows
> We run 116 of these queries in a row, directly after each other.
> We've cleared out all stop words, since we want to index on anything.
> The server has 1GB RAM, single P4 processor, 8GB free space across 2 raid
> disks.
> Whilst the queries are running, I'm not seeing massive memory use.
> Any help much appreciated. Please let me know if you need more info.
> Tobes
>
>
|||Hi Hilary,
Thank you for the reply. Yes, the queries run significantly quicker without
the NOTs. I had tried the other boolen expressions in a more compact form,
but that made little difference unfortunately. I guess the full text search
engine may do it's own optimising to clean up our verbose queries!
In two weeks we'll be throwing more hardware at the program (doubling ram,
increasing disk capacity, and introducing dual Xeon processors), so
hopefully that will make the situation better.
Our main problem is that we want scalability. At the moment we have 116
"projects", each with their own queries that run one by one. These are
taking hours to run (some queries quick, some looooong!). Do you think we
may benefit from running more than one query in parrallel? For example, have
two processes executing 58 queries each?
Thanks again for your help.
Tobes
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:ex7e8bQcFHA.720@.TK2MSFTNGP15.phx.gbl...
>I would suspect its all the search arguments and Boolean logic you have
> which is causing the problems especially the AND NOTs.
> Note that this
> CONTAINS( Article_text, '("alcopops" AND "advertising") OR ("alcopops" AND
> "culture") OR ("alcopops" AND "designated driver initiative") OR
> ("alcopops"
> AND "drink driving") OR ("alcopops" AND "legislation") OR ("alcopops" AND
> "price") OR ("alcopops" AND "pricing") OR ("alcopops" AND "underage
> driving")')
> is equivalent to the simpler
> CONTAINS( Article_text, '"alcopops" AND ("advertising" OR "culture" OR
> "designated driver initiative" OR "drink driving" OR "legislation" OR
> "price" OR "pricing" OR "underage driving")')
> Revisting the AND NOTs, basically the way this is processed is all matches
> are returned for the first part
> ("Food" AND "Supermarkets") OR ("CITIZEN CARD") OR ("CJD") OR ("E Coli")
> OR
> ("E-Coli") OR ("Food Additives") OR ("Food Safety") OR ("Genetically
> Modified Foods") OR ("Kwik Save") OR ("Proof of age card") OR
> ("Somerfield") OR ("Supermarkets") OR ("Wine Reviews")
> and then you trim rows which contain
> AND NOT ("Ahold") AND NOT ("Beth Israel") AND NOT ("European equity
> preview") AND NOT ("European stocks may decline") AND NOT ("European
> stocks
> may rise") AND NOT
> ("mediaplex") AND NOT ("UK Stocks Factors")'))
> This trimming is very expensive.
> One thing you might do is sp_fulltext_service 'resource_usage' to 5. This
> might help slightly.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Tobin Harris" <tobin@._do_not_spam_tobinharris.com> wrote in message
> news:42af07ca$0$2588$da0feed9@.news.zen.co.uk...
> cost.
> OR
> Safety")
> card")
> ("Ahold")
> NOT
> 2
> ("alcopops"
> did
> our
>