im assuming your ID column is an identity...using the code below, if you repeat the update several times until no rows are affected, this will work:

[font="Courier New"]

CREATE TABLE EXAMPLE(

ID    INT IDENTITY(1,1)...

if you sp_helptext procedurename, it returns the text of the procedure, including all its comments, in the same format as wehn last created/altered.

if you do this in gridmode in SSMS,...

if openrowset is disabled, then most likely xp_cmdshell and sp_OACreate are disabled as well, which were your other options...

I think in this case, the solution is to NOT do it...

well, the web page itself would run the query, and stick the results in either an ADODB.Recordset, or a .NET DataTable or DataReader, right?

both of those have access to teh...

the same as any other table...after you create it, you'd need to create an index on the table, even if it is in tempdb. that's the only way to improve...

I think what you are talking about is CONTEXT_INFO;

you can store some information in there, and it is specific to the connection; typical examples might be the username from...

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