can you post table definitions and sample data?

inserting new customers should not be a problem, except you need something in table "A" that uniquely identifies the customer that you can...

EXEC master..xp_cmdshell @s-2

Another think to check is that you do not have any foreign key constraints on this table, because referencing tables need to be checked prior to delete. if you do...

Any Errors?

We need more information to help figure out.

Other than a design problem, looks good

Depends what your trying to do.

You can use osql

from BOL

osql Utility

The osql utility allows you to enter Transact-SQL statements, system procedures, and script files. This utility uses...

Not sure,

but once sql server has grown the files it will not shrink them unless you tell it to.

look up dbcc shrinkfile in BOL, or use enterprise manager to...

The one thing I see is

a value does not = null

you have to check if it is null

So  if (@GeoID is null)

as to why it works in one place not the...

you can visually check db settings in Enterprise manager.

Right Click Database, Properties, Options tab.

You'll need to set RECURSIVE_TRIGGERS  off

By definition this would be a recursive trigger, so it will not work if you require recursive triggers to be set to...

The trigger will not fire twice, it will only fire once.

create trigger foo

on mytable

after update

as

update A

set A.modified_date = getdate()

from mytable A

join Inserted I on A.id = I.ID

GO

NOT TESTED

What do you mean the "tables modified_date".

is this a data value in a different table?

or are you talking the create date shown in enterprise manager?

or is this a field that...

You need to check to make sure your log is allowed to autogrow.

(Enterprise manager Properties on database, Transaction log Tab, Make sure Autogrow is checked.)

If this is okay, then make...

http://servername/reports is the consumtion website, (Where people run reports)

http://Servername/reportserver is the engine this url goes in the projects setting that tells visual studio where to push the reports

you...

Try using the wizard.

What exactly are you having difficulty with?

http://msdn2.microsoft.com/en-us/library/ms159267.aspx