Did you read the link that Grant posted?

John

The owner of the database is always mapped to the dbo user in the database.

ALTER AUTHORIZATION ON SCHEMA::MySchema TO dbo

John

Loop through the table and execute the statements one by one. Either that or write a query to build one set of INSERT statements and execute that in one...

(1) No.

(2) Recover from what?

(3) Yes.

By the way, there's no need to post the same question in more than one forum.

John

That means that that table doesn't exist. Please will you post the statement that you used to create the table?

John

arrjay (11/27/2013)

---

Thanks John - This is the issue. I created a default instance for SQL2012 and a named instance for SQL2008. Whenever I connect to my (local) instance...

Shrink performance on the file? I don't know what you mean, I'm afraid. But, unless it's a problem that your transaction log is 2GB (perhaps you're running out...

SSMS will remember the last instance you connected to. So if you run SSMS 2008 and connect to your 20008 instance, that's what it'll default to the same time....

Also, some third-party backup utilities, such as Litespeed, include object-level restore. I've never used that feature so I don't know how well it works.

John

What date would you like 0 converted to?

John

You need a DDL trigger, not a DML trigger. But I would recommend looking at service broker or extended events if you are looking at setting up some sort...

Type "move maintenance plans" into your favourite search engine. When I tried that, I got quite a few links that looked as if they were just what you're looking...

I recommend you search the internet for "Transaction Log Management". There is a very comprehensive series of articles by Gail Shaw. I'm not sure whether they're available on...

This is a SQL Server forum. Are you sure you're not using Oracle?

John

Yes, and it's not just explicit use of temp tables and temp variables that use tempdb. Maybe the query optimizer will decide that it needs to materialise a part...