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

Chris

I think the answer is "just because".  sa has fixed permissions and therefore you can't add it to or remove it from fixed server roles, hence the error message.

John

Chris

Yes, sa can perform any task that a member of security admin can (and more).  Mind you if your thrid party product requires the sa account, then it's probably time...