and here's another method that i use myself; i need to find all trigers and their trigger body if it exists:

select parent_objects.name,  

  trigger_sysobjects.name,  

  syscomments.text  

  FROM sysobjects trigger_sysobjects  ...

if you need to know the maximum possible length of all the text fields, you could use this, whihc does not use a cursor:

select sysobjects.name as TableName,

sum(syscolumns.length) as LenOfTextFields

from sysobjects

inner...

views ,functions and procs are easy:

sp_helptext viewname

sp_helptext functionname

sp_helptext procedurename

gives you the DDL for the view, or the text of the function/proc:

He didn't specifically mention any errors, so i jumped to the conclusion tha that it must be a hardware issue;Kory is right, are you getting any errors back before we...

this copies the basic structure, but it doesn't copy foreign keys, column defaults, check constraints, etc.

there are several scripts here on SSC that can programatically export the structure of a...

could this be related to an index with a high fill factor? if an index is created with a high fill factor, say 90%, but you have a lot of...

am i wrong, or is this just a simple file does not exist error?

i realize you probably changed some values for the example, but is there really a \\server1?

in...

i bet he wants the column in a specific location for this reason:

in our shop, business rules state the PK columns are always the first columns of the table;

if the...

this might help you out:

replace NTDomain** with your real domain name, otherwise domain users will not be fixed, only SQL login users.

the sid for sa /dbo on all machines everywhere...

paste the exact error you are getting; there's way to many possibilities to diagnose it at this point;

there's a huge difference between connecting directly from a laptop to your SQL...

i'd have to agree with you, with the exception of referencing PK's:

select * from sysobjects where xtype <> type

XTYPE of 'PK' <> TYPE of 'K' was the only difference i...

this will create the delete/truncate statements to be used  in Foreign key hierarchy order, so it never fails: note that it screws with every table, so any lookup tables or...

oops i hadn't thought of that aspect;

i'll look at it again; in your case, is the RTF stored in a TEXT or an IMAGE field?

OK I've created a complete solution for this:

I created a vb6 executable which takes command line paramters for RTF_File_In and TXT_File_Out.

it takes the RTF file contents and sends the plain...

The Public role that every login has read rights to all tables in master; you cannot remove the public role from master either,as i remember.

brian kelly cited some specific resources...