I can't remember the solution, but do a search on this site and you should find it.

-SQLBill

Check out RESTORE FILELISTONLY and RESTORE HEADERONLY in the BOL.

-SQLBill

Can't do it. (Not really). The only solution I know of is to restore the database to another instance (or to another name) and then import just that table.

-SQLBill

My table has 194 million rows. But I don't think the size should be causing MIN() and MAX() to act differently.

-SQLBill

If you are getting a syntax error on that, run this and give us the results:

SELECT SERVERPROPERTY('productlevel'),

SERVERPROPERTY('productversion'),

...

The SA account is not a Windows Account so it's also not a Trusted Account. Trusted accounts are Windows logins that are authenticated by a domain controller that the...

To add my two cents.

As everyone else stated, the system databases don't change much. Back them up less frequently. Maybe once a week, but no less than once a month....

What bothers me about the 'page peel' ad? It's too close to the Log Out menu item. Sometimes when I move the mouse to click on Log Out, I...

You don't provide sizes, so it's hard to give you a good answer. If the database/log was 5MB/10MB, my answer would be different than if it was 5GB/10GB.

Bottom line,...

That's great, unless you work for a company/organization that limits what you can load onto your computer. For example, U.S. Government orgs are really strict on what can be...

That's not a SQL Server issue. That's something that has to be done with the coding of the application.

-SQLBill

Sometimes, SQL Server seems to 'misread' the disk when the databases are attached (a reboot really does a hard detach and reattach). I've had this problem and solved it by...

SA and the BUILTIN/Administrator logins ALWAYS have access to every database. As alzdba stated, you can remove the Builtin/administrator login if you want to - test it first as it...

Did you recently reboot the systems or detach/attach the databases? That can reset the database owner and sometimes it will be set to SA. Just change the owner to...

I agree with you.....this site has gotten awfully 'busy' with its advertisements.

-SQLBill