Say you have a big database, and you know from experience it takes 4 minutes to do a complete backup.

the last thing the backup would include would be every commited...

Vic is correct. because there is no single repository for the tables/objects of all databases, you have to query each repository seperately...whether information_schema, sysobjects or sys.objects, you gotta do each...

Ok i think i know what you want;

in SSMS go to tools options.

check the shown checkbox, and when you copy/paste any results, the column names will be included:

{edit}ok, what are "column ?Headers...that's what i'm not understanding.

maybe I'm oversimplifying, but since the table_name exists in information_schema.columns, why not just select directly fromt here?

select * from

INFORMATION_SCHEMA.COLUMNS

where table_name ='mytable'

what...

just to be clear, an UPDATE statement will affect EVERY row in a table, UNLESS you limit it with a WHERe statement; This is one of the cool principals of...

never installed the hotfix, but i found this:

http://support.microsoft.com/kb/934396

Note The file version of the Sqlvdi.dll file in this hotfix is 2000.85.2102.0. The file version of the Sqlvdi.dll file in hotfix 935465...

At least in my DataAccess, which is based on MS application blocks, in .NET, the adapter uses negative numbers for new rows...-1,-2, etc. for any of the typed data sets.

when...

Triggers are just event driven stored procedures. functions are limited versions of stored procedures, right?

for any identical code, all three should perform at the same speed, same execution plan, same...

with an application role, the end users will not know or need the password....the IMS application would login using that instead of passing their Windows credentials...Like Jack said, this depends...

stating the obvious, you've got to disable their access.

Here's how:

from Enterprise Manager, right click on the server, and expand the "Security Folder" so you can see "Logins"

You might see BUILTIN\Administrators...

ok you'd get that eror if there was a weird value in

can you run this and see what the last run date value is?

[font="Courier New"]SELECT @@servername AS [Server],

J.name...

does the stored procedure AxSP_Adhoc_PerformConsistencyCheck exist in the master database, or the default database of the user AOANHSS\sqlnashrep?

if it exists in master, but the default database for AOANHSS\sqlnashrep is "DevDB",...

because the backup came from your supplier, and not from your server, the user "eu\genetica" is "orphaned...that is, every server in the work may have a user named "Bob", bu...

sp_help the table, and find the name of the Foreign key you want to drop.

issue the drop command like this:

sp_help gmact

alter table gmact drop constraint FK__GMACT__AACCOMPLT__66960AE6

You can't automatically do it, some decisions have to be made. Also remember a functionality may exist that would use a table in the database, but just hasn't been used...