Stuart

Like this:

CREATE

TABLE #John (John char(10))

INSERT

Jaybee

(1) Check out the system stored procedures that start with sp_trace.

(2) Use Profiler to have a look through the list of columns to see which will provide useful information.  I...

Imke

I imagine it's because the owner of job (or the login that SQL Server Agent uses) doesn't have the same permissions to execute the step as you do.  That's why...

Stuart

Can you post an example of one of the SPs that you run?  If each one always produces the same columns in the result set, then my suggestion will work. ...

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