Can we handle ALL errors within a stored proceudre?

Hello, friends,
We call stored procedures from our app (asp.net), and use Try...Catch to
handle any possible DB error. But, can we handle all errors in a stored
proceudre? In another word, all DB errors should be caught within a stored
procedure, and return back to callers gracefully, as if nothing wrong.
We tried IF @.@.ERROR > 0 in sp, but errors such as Unique Constraint
Violation were still caught by our app, not sp.
Any ideas, reference papers, sample source code?
Thanks a lot.http://www.sommarskog.se/error-handling-II.html
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"Andrew" <Andrew@.discussions.microsoft.com> wrote in message
news:59F7E8E6-1477-4A42-9B42-BB34D0136102@.microsoft.com...
> Hello, friends,
> We call stored procedures from our app (asp.net), and use Try...Catch to
> handle any possible DB error. But, can we handle all errors in a stored
> proceudre? In another word, all DB errors should be caught within a stored
> procedure, and return back to callers gracefully, as if nothing wrong.
> We tried IF @.@.ERROR > 0 in sp, but errors such as Unique Constraint
> Violation were still caught by our app, not sp.
> Any ideas, reference papers, sample source code?
> Thanks a lot.

Can we handle all errors within a stored proceudre.

Hello, friends,
We are calling stored procedures (sp) from our web app (asp.net). Since
using Try...Catch... in asp.net with C# or VB.net is very expensive, we are
considering to handle all database error in sp so that web app won't see any
DB error.
Do we have a way to catch all erros in sp and return back to callers
gracefully, as if nothing wrong in DB?
We tried to check IF @.@.ERROR > 0, but web app still get erros, such as
Unique contraint violation, etc.
Any ideas, reference papers, sample source code?
Thanks a lotexamnotes <Andrew@.discussions.microsoft.com> wrote in
news:0F041009-08FF-4FF1-8AC7-D74968D16C05@.microsoft.com:

> We are calling stored procedures (sp) from our web app (asp.net).
> Since using Try...Catch... in asp.net with C# or VB.net is very
> expensive, we are considering to handle all database error in sp so
> that web app won't see any DB error.
> Do we have a way to catch all erros in sp and return back to callers
> gracefully, as if nothing wrong in DB?
> We tried to check IF @.@.ERROR > 0, but web app still get erros, such as
> Unique contraint violation, etc.
> Any ideas, reference papers, sample source code?
In SQL Server 2005 you can, I've used the following code sample to
demonstrate it in my classes (Using the pubs database):
set XACT_ABORT on
begin try
begin transaction
declare @.id int;
insert into jobs values ('Testjobb',10,10)
set @.id = @.@.identity;
insert into employee values ('123456789','Gates',null,'Bill',@.id+
1,10,'0877',GetDate());
commit transaction
end try
begin catch
select error_message();
rollback transaction
end catch
I'll leave it up to you to implement this in a stored procedure.
Ole Kristian Bangs
MCT, MCDBA, MCDST, MCSE:Security, MCSE:Messaging|||What about SQL Server 2000? That is the one we are using.
"Ole Kristian Bang?s" wrote:

> examnotes <Andrew@.discussions.microsoft.com> wrote in
> news:0F041009-08FF-4FF1-8AC7-D74968D16C05@.microsoft.com:
>
> In SQL Server 2005 you can, I've used the following code sample to
> demonstrate it in my classes (Using the pubs database):
> set XACT_ABORT on
> begin try
> begin transaction
> declare @.id int;
> insert into jobs values ('Testjobb',10,10)
> set @.id = @.@.identity;
> insert into employee values ('123456789','Gates',null,'Bill',@.id+
> 1,10,'0877',GetDate());
> commit transaction
> end try
> begin catch
> select error_message();
> rollback transaction
> end catch
> I'll leave it up to you to implement this in a stored procedure.
> --
> Ole Kristian Bang?s
> MCT, MCDBA, MCDST, MCSE:Security, MCSE:Messaging
>|||examnotes <Andrew@.discussions.microsoft.com> wrote in
news:C25DD758-622D-4CB5-A870-F112B1C337C6@.microsoft.com:

> What about SQL Server 2000? That is the one we are using.
Sorry. This feature was introduced in SQL Server 2005. In SQL Server 2000
you have to check for errors after each and every command that may cause an
error (which may happen to be almost everyone)
Ole Kristian Bangs
MCT, MCDBA, MCDST, MCSE:Security, MCSE:Messagingsql

Can t-log size handle large number of deletions?

Hi All,
Im just wondering if there is a way i could find out if the size of my
transaction log will be able to record the number of deletions i will be
performing? Basically i have to delete 325 million rows from a table and my
t-log is, say 20GB. is there a way i can calculate if the t-log is big
enough or will it need to expand?
thx in advance.Well I certainly would not advocate deleting them all in one batch. If you
delete them in smaller batches (say 10K or 100K at a time) it will not only
be faster but you would have the option to backup or truncate the log as you
go along. How many rows in the table do you want to keep. It may be
easier to BCP out the ones to keep, truncate the table and bcp them back in.
--
Andrew J. Kelly
SQL Server MVP
"M Sandico" <msandico@.muchomail.com> wrote in message
news:%23ZDvAlIpDHA.3688@.TK2MSFTNGP11.phx.gbl...
> Hi All,
> Im just wondering if there is a way i could find out if the size of my
> transaction log will be able to record the number of deletions i will be
> performing? Basically i have to delete 325 million rows from a table and
my
> t-log is, say 20GB. is there a way i can calculate if the t-log is big
> enough or will it need to expand?
> thx in advance.
>|||You are correct in that I dont delete them all in one batch. I delete in
batches of 1000 with a BEGIN TRAN and COMMIT TRAN as well. What I am
planning to do is just set the model to SIMPLE during the deletion and have
the COMMIT TRAN force the log to be flushed during the automatic checkpoint
(when log is 70% full).
Just thought there would be a way to guesstimate how big a t-log youd need
for certain operations..
thx.
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:e9rVaHJpDHA.360@.TK2MSFTNGP12.phx.gbl...
> Well I certainly would not advocate deleting them all in one batch. If
you
> delete them in smaller batches (say 10K or 100K at a time) it will not
only
> be faster but you would have the option to backup or truncate the log as
you
> go along. How many rows in the table do you want to keep. It may be
> easier to BCP out the ones to keep, truncate the table and bcp them back
in.
> --
> Andrew J. Kelly
> SQL Server MVP
>
> "M Sandico" <msandico@.muchomail.com> wrote in message
> news:%23ZDvAlIpDHA.3688@.TK2MSFTNGP11.phx.gbl...
> > Hi All,
> >
> > Im just wondering if there is a way i could find out if the size of my
> > transaction log will be able to record the number of deletions i will be
> > performing? Basically i have to delete 325 million rows from a table and
> my
> > t-log is, say 20GB. is there a way i can calculate if the t-log is big
> > enough or will it need to expand?
> >
> > thx in advance.
> >
> >
>|||I don't know of a formula off hand. You would have to account for at least
the amount of data that you are deleting and then some percentage for
overhead etc. What that percentage is I don't really know.
--
Andrew J. Kelly
SQL Server MVP
"M Sandico" <msandico@.muchomail.com> wrote in message
news:ugg192JpDHA.2188@.TK2MSFTNGP11.phx.gbl...
> You are correct in that I dont delete them all in one batch. I delete in
> batches of 1000 with a BEGIN TRAN and COMMIT TRAN as well. What I am
> planning to do is just set the model to SIMPLE during the deletion and
have
> the COMMIT TRAN force the log to be flushed during the automatic
checkpoint
> (when log is 70% full).
> Just thought there would be a way to guesstimate how big a t-log youd need
> for certain operations..
> thx.
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:e9rVaHJpDHA.360@.TK2MSFTNGP12.phx.gbl...
> > Well I certainly would not advocate deleting them all in one batch. If
> you
> > delete them in smaller batches (say 10K or 100K at a time) it will not
> only
> > be faster but you would have the option to backup or truncate the log as
> you
> > go along. How many rows in the table do you want to keep. It may be
> > easier to BCP out the ones to keep, truncate the table and bcp them back
> in.
> >
> > --
> >
> > Andrew J. Kelly
> > SQL Server MVP
> >
> >
> > "M Sandico" <msandico@.muchomail.com> wrote in message
> > news:%23ZDvAlIpDHA.3688@.TK2MSFTNGP11.phx.gbl...
> > > Hi All,
> > >
> > > Im just wondering if there is a way i could find out if the size of my
> > > transaction log will be able to record the number of deletions i will
be
> > > performing? Basically i have to delete 325 million rows from a table
and
> > my
> > > t-log is, say 20GB. is there a way i can calculate if the t-log is big
> > > enough or will it need to expand?
> > >
> > > thx in advance.
> > >
> > >
> >
> >
>

Can the SQL 2005 install upgrade from SQL 2000 handle multiple instances?

Can the SQL 2005 install upgrade from SQL 2000 handle multiple instances?You have to upgrade them one by one.

HTH, jens SUessmeyer.

http://www.sqlserver2005.de

Can SSRS handle an "Invoice" application

Hello,

I am trying to create an invoice-like form in SSRS. I am trying to confirm whether this is possible or not, as when I use a table component to list the items, the total and any other text boxes underneath that table are pushed down as more items are added to the table at run time! I know this is the intended behavior by design, but I need to know if I can have a behavior that will not push the text boxes underneath the table - to support an ivoice-like form?

Your help is appreciated.

TF

Do not use the table control from the toolbox. Set the header and body sections, and use text boxes to build the invoice detail.

Can SSRS break a "large page" into printable pages?

This is a question of strategy. Can SSRS handle this problem, or should I consider another approach?

My problem: I want to print a family tree chart. Imagine starting with the parents at the top center, then their children spread out in the next row, with their spouses, then the third row has the grandchildren, and so on. No problem, provided that you have the ability to position the entries where you want, and a page that has indefinite width and depth. But of course this has to be printed out on normal pages.

1/ Does SSRS give me the ability to create a very large page, and then automatically break this up for me into standard-sized pages that the real printer can handle. For example, the program might first produce a "virtual A1 page", then physically print this as up to 16 A4 pages (which the user might then glue together). It doesn't matter (from the application's point of view) whether the output is HTML, PDF, or something else, although PDF is probably a preference.

2/ Does SSRS allow me to calculate the position of a textbox at execution time. It is not until I read the data that I can work out the dimensions of the chart.

[Editing: I've found the answer: it's "Yes". But that leads to another question: -]

3/ Can I create new controls dynamically? I won't know how many people there are until I read the data. So whereas normal logic is "Read a record, print a detail line", in this case the logic will be "Read a record, create a texbox and place it {here} on the virtual page"

If yes, then I think that I can figure out the logic. What should I read to learn how to do this?

Thanks, Robert.

hi,

first create one rdlc file with existing ds and certain values (which is in working condition)

then open it as an xml file.

now you can see the xml tags in it and before generating the report generate the rdlc file as per your caluclation (these tags has column width..etc)

generate the rdlc and then, while showing it in report viewer select processing mode as local, then give this rdlc file as report and bind the dataset which you want to show in the report.

First, open a working report's rdlc file content in xml viewer, you can understand what to do, by using System.Xml namespace classes.

I will try to find the code, i have worked on it in the past.

and once you have done this, printer will take care of the rest.

( in rdlc xml tags give length and bredth of report as per your needs after calculating the data and space it occupies)

see the following link, its also similar to your problem

http://forums.asp.net/t/1195123.aspx

all the best

|||

Thanks for this, if you can post the code, that would be great!

Perhaps you can help me with the related problem, http://forums.asp.net/p/1192671/2052349.aspx#2052349. This explains the whole problem, which is that I'm trying to produce a family tree chart. My original idea was that I could produce a huge "virtual page", and then break this up into printable (A4) chunks. However, I can't figure out how program logic such as this at the start of the report: -
For each record
Read record
Create textbox at position ...
Next

Until I can figure this out, I'm completely stuck. In fact, if I could write code like this at the start of each page I wouldn't need to create a large virtual page to be broken up later.

Can stored procs run after handle is closed?

I have written a stored proceedure for MSSQL that needs to run for hours at
a time. I need to execute it from C++ code. The current code does:

nRet = SQLDIRECTEXEC(hstmt, "exec stored_proc", SQL_NTS)

followed shortly after by a

Free_Stmt_Handle(hstmt) //roughly

The stored proc currently dies with the statement handle, not fully
populating the table I need it to.

I need to either know when the proc finishes so I can close the handle after
that, or allow the proc to run independently on the server no matter what
the program is doing (is exited, etc), either of these is fine.

Please Help! Thanks in advance!
JosephI know nothing about C++, but if the proc runs for a very long time, it
might be better to implement it as a scheduled job. The client could
set a flag or insert a row into a 'queue' table, then you have a job
which runs every few minutes or whatever, and if the flag is set, it
then starts the stored proc.

Simon|||That is an interesting approach, ideally I would like to stay as far away
from the database as I can but it sounds like this could be the best way...
my stored procedure is running for the exact same number of instructions and
then dying, whereas if I run it via Query Analyzer it runs to completion.

I finally caved and just copy-pasted from Q.Analyzer into code to confirm
this. I will investigate a little further before taking that plunge.

Thanks
Joseph

"Simon Hayes" <sql@.hayes.ch> wrote in message
news:1112950699.762977.19700@.o13g2000cwo.googlegro ups.com...
>I know nothing about C++, but if the proc runs for a very long time, it
> might be better to implement it as a scheduled job. The client could
> set a flag or insert a row into a 'queue' table, then you have a job
> which runs every few minutes or whatever, and if the flag is set, it
> then starts the stored proc.
> Simon

can SQL Server do hot backups?

Can SQL server handle High Availability or does it have to go down
occasionally for a cold backup? Does it support incremental backups?Ryan wrote:
> Can SQL server handle High Availability or does it have to go down
> occasionally for a cold backup? Does it support incremental backups?

Yes,no,yes :-)|||can you do hotbackups with the standard edition? what about incremental
backups?

or do you have to purchase the enterprise edition?
"Trev@.Work" <no.email@.please> wrote in message
news:400c0f09$0$4907$afc38c87@.news.easynet.co.uk.. .
> Ryan wrote:
> > Can SQL server handle High Availability or does it have to go down
> > occasionally for a cold backup? Does it support incremental backups?
> Yes,no,yes :-)|||"Ryan" <rgaffuri@.cox.net> wrote in message
news:a0VOb.4224$_H5.115@.lakeread06...
> can you do hotbackups with the standard edition? what about incremental
> backups?
> or do you have to purchase the enterprise edition?
> "Trev@.Work" <no.email@.please> wrote in message
> news:400c0f09$0$4907$afc38c87@.news.easynet.co.uk.. .
> > Ryan wrote:
> > > Can SQL server handle High Availability or does it have to go down
> > > occasionally for a cold backup? Does it support incremental backups?
> > Yes,no,yes :-)

All backups in MSSQL are 'hot' in the sense that you do not have to stop the
MSSQL service, and you do not have to disconnect users from the database.
This is true in all versions of MSSQL, and all backup types (full, log,
filegroup, differential) are also available in all versions. Other high
availability options (replication, clustering, log shipping) do depend on
the version in terms of what functionality is available.

Simon|||On Mon, 19 Jan 2004 13:06:02 -0500 in comp.databases.ms-sqlserver,
"Ryan" <rgaffuri@.cox.net> wrote:

>can you do hotbackups with the standard edition? what about incremental
>backups?

What part of "yes" don't you understand? :-)

You can do both.

--
A)bort, R)etry, I)nfluence with large hammer.

Can SQL Server 7.0 handle a SQL Server 2000 mdf?

I've got MSDE, SQL Server 7.0, installed. I want to handle an .mdf
developed by someone else so I loaded the .mdf into my /DATA folder.
But, MSDE/ODBC can't see the database. I subsequently discovered that
it was created using SQL Server 2000. Is this the reason that my MSDE
7.0 doesn't see the .mdf? If so, how can I use this database with my
7.0? Backup from 2000, restore to 7.0?

Thanks for any help.Mike Watson (mike@.connectingsoftware.it) writes:
> I've got MSDE, SQL Server 7.0, installed. I want to handle an .mdf
> developed by someone else so I loaded the .mdf into my /DATA folder.
> But, MSDE/ODBC can't see the database. I subsequently discovered that
> it was created using SQL Server 2000. Is this the reason that my MSDE
> 7.0 doesn't see the .mdf? If so, how can I use this database with my
> 7.0? Backup from 2000, restore to 7.0?

Well, there's actually two problems here.

The fact that MSDE/ODBC can't see the database has nothing to do with
the versions of SQL Server. Putting a file into your data directory has
no effect. You would have to do sp_attach_db to make the database available.
And for sp_attach_db the .mdf is not sufficient; you would need the log
file too. There is sp_attach_single_file_db for this situation, but the
database must have been shut down cleanly for this. (Well, this applies
to sp_attach_db as well as I recall.)

But for all this to work, the target server must be the same version or
later than the source server, so you can never do anything with that file
without access to SQL 2000. To restore that database on SQL 7, you would
have to script it and bulk out all data. And if the database makes use
of features not in SQL 7, not even this method would work.

Since MSDE for SQL 2000 is freely available, it appears to be a good idea
to download and install it.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||Erland Sommarskog <esquel@.sommarskog.se> wrote in message news:<Xns9619844A49F0FYazorman@.127.0.0.1>...
> Mike Watson (mike@.connectingsoftware.it) writes:
> > I've got MSDE, SQL Server 7.0, installed. I want to handle an .mdf
> > developed by someone else so I loaded the .mdf into my /DATA folder.
> > But, MSDE/ODBC can't see the database. I subsequently discovered that
> > it was created using SQL Server 2000. Is this the reason that my MSDE
> > 7.0 doesn't see the .mdf? If so, how can I use this database with my
> > 7.0? Backup from 2000, restore to 7.0?
> Well, there's actually two problems here.
> The fact that MSDE/ODBC can't see the database has nothing to do with
> the versions of SQL Server. Putting a file into your data directory has
> no effect. You would have to do sp_attach_db to make the database available.
> And for sp_attach_db the .mdf is not sufficient; you would need the log
> file too. There is sp_attach_single_file_db for this situation, but the
> database must have been shut down cleanly for this. (Well, this applies
> to sp_attach_db as well as I recall.)
> But for all this to work, the target server must be the same version or
> later than the source server, so you can never do anything with that file
> without access to SQL 2000. To restore that database on SQL 7, you would
> have to script it and bulk out all data. And if the database makes use
> of features not in SQL 7, not even this method would work.
> Since MSDE for SQL 2000 is freely available, it appears to be a good idea
> to download and install it.

Thank you Erland, for your answer. We've got the log file. So,
following your advice I will look for and install MSDE 2000. After
that I presume I have to run the 'sp_attach_db' procedure to make the
db available to MSDE 2000 so that I can create an ODBC to see it from
Access 2000. Could you please confirm if that is correct?

Mike Watson|||Mike Watson (mike@.connectingsoftware.it) writes:
> Thank you Erland, for your answer. We've got the log file. So,
> following your advice I will look for and install MSDE 2000. After
> that I presume I have to run the 'sp_attach_db' procedure to make the
> db available to MSDE 2000 so that I can create an ODBC to see it from
> Access 2000. Could you please confirm if that is correct?

That should work just fine.

Once you have MSDE 2000 up, do a SELECT @.@.version, and make sure that
you have at least 8.00.760, so you have SP3 and the fix for the Slammer
worm.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||Erland Sommarskog <esquel@.sommarskog.se> wrote in message news:<Xns961AE57BC3805Yazorman@.127.0.0.1>...
> Mike Watson (mike@.connectingsoftware.it) writes:
> > Thank you Erland, for your answer. We've got the log file. So,
> > following your advice I will look for and install MSDE 2000. After
> > that I presume I have to run the 'sp_attach_db' procedure to make the
> > db available to MSDE 2000 so that I can create an ODBC to see it from
> > Access 2000. Could you please confirm if that is correct?
> That should work just fine.
> Once you have MSDE 2000 up, do a SELECT @.@.version, and make sure that
> you have at least 8.00.760, so you have SP3 and the fix for the Slammer
> worm.

Erland,

I've downloaded MSDE 2000 (Italian version), expanded the zip, read
the readme.txt, checked the things they tell me to check. I started
the setup with:

setup SAPWD="password" SECURITYMODE=SQL

The install fails with roughly 3 - 5 seconds remaining with following
message:

"Impossible to configure the Server. For further information examine
the error logs..."

The last 2 messages in the log are:

Warning: override, autoexec procedures skipped.

and

Closing down SQL Server because of a interruption request from the
Service control handler (my translation)

I can't see what's going wrong. Can you help me?

Mike Watson|||Mike Watson (mike@.connectingsoftware.it) writes:
> I've downloaded MSDE 2000 (Italian version), expanded the zip, read
> the readme.txt, checked the things they tell me to check. I started
> the setup with:
> setup SAPWD="password" SECURITYMODE=SQL
> The install fails with roughly 3 - 5 seconds remaining with following
> message:
> "Impossible to configure the Server. For further information examine
> the error logs..."
> The last 2 messages in the log are:
> Warning: override, autoexec procedures skipped.
> and
> Closing down SQL Server because of a interruption request from the
> Service control handler (my translation)
> I can't see what's going wrong. Can you help me?

Unfortunately, I have no experience of running the MSDE setup, so
there is not much I can assist with.

Do you run the setup on the machine where you already have MSDE 7, or
do you run it on some other machine?

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||Erland Sommarskog <esquel@.sommarskog.se> wrote in message news:<Xns961BF3EFC447BYazorman@.127.0.0.1>...
> Mike Watson (mike@.connectingsoftware.it) writes:
> > I've downloaded MSDE 2000 (Italian version), expanded the zip, read
> > the readme.txt, checked the things they tell me to check. I started
> > the setup with:
> > setup SAPWD="password" SECURITYMODE=SQL
> > The install fails with roughly 3 - 5 seconds remaining with following
> > message:
> > "Impossible to configure the Server. For further information examine
> > the error logs..."
> > The last 2 messages in the log are:
> > Warning: override, autoexec procedures skipped.
> > and
> > Closing down SQL Server because of a interruption request from the
> > Service control handler (my translation)
> > I can't see what's going wrong. Can you help me?
> Unfortunately, I have no experience of running the MSDE setup, so
> there is not much I can assist with.
> Do you run the setup on the machine where you already have MSDE 7, or
> do you run it on some other machine?

Erland,

I'm doing the install on another machine where there is no previous
copy of SQL or MSDE. It's Windows XP.

Mike Watson|||Mike Watson (mike@.connectingsoftware.it) writes:
> I'm doing the install on another machine where there is no previous
> copy of SQL or MSDE. It's Windows XP.

Darn! Then I can't even suggest that as a remedy. I believe that there
is a newsgroup microsoft.public.sqlserver.msde.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

Can SQL Express handle database size up to 9 GB?

Hi everyone,

Kindly tell me the size of database that SQL Express can handle.

Tks for your cooperation.

Brgds,

Adien

The express system can only handle db sizes of 4gb. Note that you can have multiple databases on the one server each being 4gb in size.

|||If I have 9 gb database, can it convert to sql express 4 gb? 2 or 3 database each.|||

If you do wish to break it up into different databases you are going to have to look at your application design and how it connects to the database. You will not be able to have it configured as the one database over multiple files like you do in the full system, they will have to be different databases.

Can replication handle existing database?

Hello:
I have the following situatioin. A few months ago, I setup a secondary SQL
server with the same schema and data as the primary. But that server was
shut down for a few months.
Currently, I am thinking to set up replication (transaction). Since the
database is rather huge, I think I will try transaction replication. Do you
think it will work so that the secondary server will be in sync with the
primary server? This is the first time I am doing it.
Thanks,
Q
If the data is now out of sync, this'll need attending to first. You could
use Redgate's DataCompare to synchronize the subscriber with the publisher
then after that do a nosync initialization.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Can Query Designer Handle Subqueries`

When a subquery is part of an insert, update or just a from or where clause, it doesn't seem to have a way to structure it. Is there a procedure for that?

Thanks,

DavidHi David -
The only structuring functionality for your scenario is to use the block indent/unident function. You can find these menu items/shortcuts under the Edit menu.

Michael Raheem
Program Manager
SQL Server Tools Team|||Hi David,
One other alternative starting with the APril CTP is to use the query designer within the Query Editor to design each sub-query by selecting the text to design and then issuing the Design Query in Editor command.
Thank you,
Bill Ramos