thanks for the correction Vladan; i missed that one since i just winged it and didn't test it in QA. Maybe he can redesign the schema and fix the issue.

really difficult without the schema of the tables...can we assume that the table CitrixApps, with only a single column, is source for the values in the Working table's Application1/2/3... columns?

if...

that's not true; I've created lots of information_schema views in sql 2000;

like Peter outlined, you simply create a view in master and change the owner to INFORMATION_SCHEMA; I've done...

as I understand it, SQL Lite speed uses the updated SQL Server API's to create a standard SQL Server backup, abiet much faster, because the TSQL/Enterprise Manager backup commands use...

what is the defined size of the tempdb? tempdb gets recreated every time you stop and start the server, so if you stoip and start, and it is still 5...

there's no event you can use, but you can check to see if soemthing has been backedup since a certain date, and do your special process from there (i assume...

you didn't explain what you meant by "slowness"... I still suspect the autoclose issue;

you can run this statement to see if anything is set to autoclose=true or not:

SELECT + [name]...

you'll want to dbcc reindex the database now. basically the space that was used by the char fields is still there, and new space was added for the varchars....the system...

You could test how many fields are empty, ie  null/not null, but not how of often they are used.

when SQL inserts or updates a row, no statistics are available wether...

Correct me if I'm wrong, but the blocker script is an example of what happens when you have high volume inserts, right?  I've read that the identity() column can have...

by slow you mean it takes a long time for EM to display the list of databases?

If that is true, then it's a known issue where if each database needs...

here's teh puedocode that I currently use for something similar:

add one more column to your tracking table, a flag or field to signify "NotificationSent' or something.

now create a job that...

there is no change for the users; remember that their logins and permissions are mapped to roles in each of databases on the machine. Esentially their permissions are stored in the...

without more information, I don't believe you can.

is there an identity column in the tabe? is there a datetime field for creation or updated?

if the primary key might be (Accountno,AdmissionReason), then...

i looked at sp_addalias, and it looks like any users that are aliased as dbo would have the sid for sa/dbo (which is always 1):

    -- INSERT SYSUSERS ROW --

   ...