Your logical data model can have many-to-many relationships, but they usually gets resolved with an associative table when you create the physical model.

BTW, I tried using Visio to model a...

You've added the -S in the middle of the -o parameter, try:-

bcp "select fileoutput from [new_db]..[Invoice_Table] order by roworder" queryout c:\invoice\template\customer.html -c -T -SSQLCLUSTER\SSQLSERVER -o c:\invoice\template\bcpOutput.txt

You need to use -S to specify the name of the server/instance you are trying to connect to AND either the -T (if you are using Windows Authentication) or -U...

Yes, the cache is shared for both data and procedures.

Run DBCC FREEPROCCACHE and DBCC DROPCLEANBUFFERS to clear the procedure and data cache between executions.

Precisely... just don't...

Backing up the transaction log effectively truncates it.

TSM can backup the .BAK and/or TRN files generated by maintenance plans or your own scripts. But it can also backup the database/transaction...

You need to use a computed column for what you want, not a constraint:-

CREATE TABLE tbTest

(

[Id] [int] IDENTITY(1,1) NOT NULL,

...

fn_get_sql only works for queries that SQL Server decides to cache.

Check that you are getting a valid handle by selecting @Handle:-

DECLARE @Handle binary(20)

SELECT @Handle = sql_handle FROM sysprocesses WHERE spid...

Look in BOL for fn_get_sql (note, you will need the version of BOL updated with SP3 information) for further information, but this is what you need:-

DECLARE @Handle binary(20)

SELECT @Handle =...

Something else has the BAK file open.

Are you backing the file up to...

Try taking the GO statements out.

They indicate the end of a batch, which is breaking your BEGIN...END blocks

I'm not sure how much of a hand god had in writing any of those books;)

Look at this URL

http://www.microsoft.com/australia/servers/sql/editions/developer/default.mspx

It is specific about Test and Demo servers, so QA and/or UAT boxes are still not Production boxes and therefore it's legitimate to use Developer Edition.

Edited...

Yes...

If you use a domain account for the SQL server service, and that account has permissions to write to the other server then you can back up directly (using...

I have a ldf file that seems to be growing at a rate of 100 meg per day, this is on a test server where we are testing a...