You cannot create four tempdb databases......are they perhaps talking about four files for the tempdb? And did whoever told you this include any logic for it? I've split out multiple...

Sure...just put a wrapper on it....

Create Proc usp_proc_name As

UPDATE OrdMain

SET

ListTotal = A.SumOfListItem

FROM

(SELECT Order_ID,SUM(ListEach) AS SumOfListItem

FROM OrdItem

GROUP BY Order_ID)

AS A

WHERE OrdMain.Order_ID = A.Order_ID

AND OrdMain.Order_Num = N'11589'

and take the...

Try something more along this route:

UPDATE

OrdMain

SET

ListTotal

= A.SumOfListItem

FROM

(

SELECT...

You will need to accomplish this within whatever GUI you are having them use....it is not a database function.

Of course it's possible.....isn't everything....I'm not sure it would be wise though....

Set up a process that monitors for new objects and schedule it...

feed the results of the monitoring process into...

I did not mean to imply that you were a novice......

Once you create your .sql files for the foreign keys, and another for your indexes......how do you determine the keys...

Script the db, and run script on second server....

One at a time, as the snapshots for each table are generated...

If all I needed was a picture of them, I am sure I would use what you suggest. However, I need a list of fields and tables as my solution...

Use this methodology, and so long as the optionals are null, your good....

SELECT

  PolicyProcedureID,

  IDNumber,

   Title,

  DateUpdated,

   Author,

  ExecutiveSummary,

  Body,

 SupportingDocuments,

 Comment,

 PolicyNumber ,

 PolicyProcedureType,

 PolicyProcedureStatusDescription,

 PolicyDepartName,

 ReviewerName   

FROM

   PolicyProcedures

WHERE 

     Title  LIKE  ISNULL(@SearchTitle+ '%', Title)

  AND   ...

It looks like the schema which the table belongs to

I answered "D" as well, as the syntax was incorrect, throwing an error for the first part and giving the username for the second......for the question, as asked, "D" WAS...

I have a set of scripts that writes the indexes and foreign keys to a table which could then be queried to get what you need on a mass scale......

Here:

if...

Here is a down and dirty way to do it....

Select

SO.NAME,

SI

.Rows

From

Sysobjects SO