and comma delimited list after the FROM in case the older style join structure is used: FROM TABLE1,TABLE2 , TABLE3

which SQL server are you trying to connect to  from yuor host's web site?

part of your connection string: Data Source=hostsserver****,1433; is not really clear since it is...

If you've created any maintenance plans for those databases, this specific operation would be part of the scheduled job:

Data Base Maintenance>>Integrity Tab>>Checkboxes for Check Database Integrity & Include Indexes

you would...

Google and SQL Server Books On Line are your friends! use them first, and use the forums to clarify anything you didn't understand.

the first link in google for a search...

yes, you can directly restore a SQl 7 or a SQL 2000 database on SQL 2005, without any intermediate steps;

the restore process creates the mdb files in the SQL 2005...

could there be an open transaction on the server that runs indefinately? that or a table lock might lock up the query, even though normally it might be quick.

isn't this just a full outer join where the right table is null?

SELECT

 Spanish

 ,English

FROM

 Tbl1

FULL OUTER JOIN TBL2

ON Tbl1.Spanish = Tbl2.Spanish

     AND Tbl1.English = Tbl2.English

WHERE Tbl2.English IS NULL

could it be the user was denied access to the table, but has execute permissions on a stored proc that actually does the insert of the data?

i'm sure you already read the help that is available for osql; as you identified, there is no way to remove the line dashes separator directly with osql ; you...

this is part of the query analyzer: QA automatically puts the column names and a lineof dashes  to separate the data from column names.

you will not get dashes if you...

how about this:

set nocount on

select @@version

select replace(replace(@@version,char(13),''),char(10),'')

results:

Microsoft SQL Server  2000 - 8.00.760 (Intel X86)  Dec 17 2002 14:22:05  Copyright (c) 1988-2003 Microsoft Corporation Personal Edition on Windows NT 5.0...

"cleanup" is such a broad directive; i think we could help better if you could identify specific subsections of the cleanup;

what does cleanup mean in your situation? normalization? standardizing address...

can you post the udfs here so we can see what they are trying to do?

in some cases, you might be able to replace them, but in other situations, you...

there are also a few contributions in the scripts section that do a decent job for the price(free).

search for "Compare" in the "Scripts" section;

in a nutshell, yes you can, but by disabling constraints, you can insert data that does not adhere to the constraint definitions:

create table test

(testid int identity not null primary...