Graeme

Please will you post DDL for your table and your trigger.

Thanks

John

Stuart

That's right - you need to create the table first.

Probably the most elegant way of achieving your goal would be to edit your stored procedures so that they automatically write...

Jaybee

I think you need to add 'OurDomain\OurNTLocalGroup' as a login before you can make it the owner of the database.  I'm guessing that what happened is that the login used...

Please will you post DDL for your log table so that we can see, for example, what data type your timecreated column is.  It's difficult to see why you're using...

Jaybee

Try removing OurNTLocalGroup as a user from the database.  Then execute sp_changedbowner 'OurDomain\OurNTLocalGroup' and that should change the owner for you.

John

Subu

Plenty of things it could be.  Search this site for "tempdb size increasing" and you'll find a lot of them.

John

Mark

Check your CONCAT_NULL_YIELDS_NULL setting.  The default is ON, so if one of the values you are concatenating is null, you will end up with a null whatever the other strings...

Sudheesh

Please will you provide some DDL for your tables and let us know what you have tried so far.

Thanks

John

Edit:- Looks like Ken has spared you the trouble!

But now you're using @tg-2 without having declared it.  Look up CREATE PROCEDURE in Books Online.  Your code will look something like this:

CREATE PROCEDURE dbo.MyProc @tg-2 varchar(10)

AS

.......

GO

John

Ezhilan

Since you are dropping the table at the end, is there any reason why you can't just use a temporary table (#MyTable)?

John

Steven

Just write it as a stored procedure with @tg-2 as your input parameter.

John

As far as I know, that isn't allowed.  Something like this should work:

DECLARE

@name SYSNAME

SELECT

 @name

Truncate a table, or truncate the transaction log?  There's information about both of these in Books Online.

John

Does your stored procedure have parameters, and if so, are you passing different parameters in the second time?  It's always helpful if you post your code, by the way.

John

http://www.sql-server-performance.com/tips/all_main.aspx