wrap any object name with brackets(or double quotes) if it doesn't follow normal naming conventions, has spaces in it, or are the same as a reserved word:

select * from [170703-test]

or

select...

this is most likely the error:

if the table accountinfo has two or more rows, then you'd get the error you describe...maybe you need a WHERE statement to limit the rate...

Thanks Michael and Robert;

I was stuck thinking I could append the default at the end, like i've done with PK/UQ/FK and check constraints.... instead of still part of the column...

it was just an example so i could get the named default constraint in there somewhere ...i didn't really think it through;

there's a lot of inner joins...which part do you weant to change into a subquery?

formatted for readability...the exisitng SQL made my eyes cross:

SELECT DISTINCT

Auditdata.ID,

ns.ProviderMaster_ID...

note that there are THREE places you can change collation at the server level, for each database, and then again for each column that is of type varchar/nvarchar/char/nchar/text.changing the...

As Far as I Know, there is nothing that has a mapping that says viewname.column1 comes from tablename.somecolumn3;

obviously reading the code itself might help, but remember the column could be...

Trout (7/14/2009)

---

I have tables in one database with a link being user_id field to other tables in another database.

how do you connect two different databases to one query.

ie databaseA and...

its a bit field: the database with status= zero has no flags turned on.

the database with status=16 has one flag turned on: torn page detection.

WHY one is different than the...

here's a SQL i made way back when, base don the bits booksonline tells us for the status:

SELECT 'name: ' + [name] + CHAR(13) +

'autoclose: ...

randomizing data returned doesn't always perform well, so I always have to compromise and select fewer rows.

SET STATISTICS TIME ON

SELECT TOP 3 object_name(object_id) As TBName,* from sys.columns order by NEWID()

...

do all 520 tables have the DateCreated column with a default of getdate(), so that the tables can be queried individually to archive off the data as desired?

if not, you...

I've also seen this error when a column was named to be the keyword "index", and it raises that error.

check syscolumns where name='index' and see if that's the issue.

dayum, i must have tested in a compatibility 90 database....sorry.

that was a bit of work to fix, but i figured out how to update the @Results table witht eh columns...

actually, it has to be installed on the %systemdrive%, which in most cases is the C: drive, but depending on how you built your machine originally, the %systemdrive% could be...