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...

the top and bottom rows are determined by their order....I'm betting your procedure does not have an ORDER BY clause.

with out that, SQL server does not guarantee the order or...

here is a simple procedure i use all the time;

stick in the master database, and because it starts with "sp_" and uses the catibility views, it will be functional...