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

why not create a user defined function on the server, ie dbo.mydate()

that returns a specific datetime value; it could return something like the calculated last business day, or a...

Thank you! I consider that very high praise coming from you!

I'll submit both the 2000 and the 2005 scripts to the scripts here;

I had slapped together an article on...

Lynn what browser are you using? is...

i saw that after you posted....i'm embarrassed to offer it now , since STUFF is such a better solution

i think it goes to how much business data would be lost.

if the system crashed half an hour before the next log backup, and you had to restore to the...

first, let me thank you for the CREATE TABLE and INSERT code; it helps enourmously. way to go!

here's one way to do it; here i'm assuming the column is exactly...