Ok

I have a central database which holds all the member details including a person ID (This is not a live database this is for reporting, live databases are held...

Ok looks like I need to go back to basics. I never thought of transactions coming in during the process. where can I begin to look at marking rows. What's...

Hi, this is what I was going to do, but I've been told not to use triggers.

CREATE

PROCEDURE USP_PAYMENTS

@PERSONID

VARCHAR(20),

@SCHOOLID

INT,

@AMOUNT

MONEY,

@REFERENCE

VARCHAR(50)

AS

CREATE

TABLE TMP_PAYMENTS

(

PERSONID VARCHAR...

Thanks both

I'm a newbie, will that be a right outter join as the only field that the two tables will have in common are the ones I'm searching for.

just to...

Thanxs

in the end I just ran the first line create..........

I'm now going to try and run a modify script to add the filegroup options and cross my fingers.

Hi and Thanx

I am setting it up on my lap top, which I'm administrator on.

this the SQL I'm using:

CREATE DATABASE SQL2008SBS ON PRIMARY

(NAME=N'SQL2008SBS', FILENAME=N'C:\PROGRAM FILES\MICROSOFT SQL SERVER\MSSQL10.SQLEXPRESS\MSSQL\DATA\SQL2008SBS.MDF',

SIZE=3MB,MAXSIZE=UNLIMITED,FILEGROWTH=10%),

FILEGROUP FG1 DEFAULT...