You should only rebuild/restore master as a last resort, and after ascertaining (or attempting to ascertain) the cause of the failure.  I can't think of any reason to rebuild/restore other than...

If you can't start SQL Server and you want to restore the master database, you will need to rebuild the master database first using the rebuildm utility.  This isn't a...

Curtis

Without PAE/AWE, a 32-bit processor can only access 4GB of RAM.  Normally (and this is slightly simplified), applications have access to the first 2GB of that and the operating system...

Or, if this is a one-off, you can use the Pivot Table feature in Excel to get your worksheet into the same structure as your table.

John

Greg

Check out the first topic on this page:

http://blogs.msdn.com/sqlserverstorageengine/default.aspx

John

Barbara

I think if you want to be able to view your counters in Performance, then you need to save them as a binary file (.blg) when you set them up.

I...

OK, it's possible that the snapshot process involves a large transaction that fills up your log before it gets committed.  You need to expand your transaction log so that it can...

I see what you're saying (and apologies for not reading through the MS article).  Obviously I wasn't advocating messing with system tables.  You can't really legislate for administrators of other...

You seem to have posted twice by accident.  I have answered here:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=7&messageid=288415

As long as any firewalls which may be between the linked servers have the correct ports open, there should be no reason why this won't work.  Obviously if you're using...

Brian

Is there a firewall between the two servers?  If so, you may need to arrange to have port 1433 (or whatever other port you have reconfigured SQL Server to listen...

Shane

Have a look under B for Bristish English, not E for English British.

John

Black

Are you confusing the terms "primary key" and "clustered index"?  The primary key uniquely identifies each row in your table.  If SALEID alone does this, then that should be your...

SR

If you have physical access to the servers, log on to the node you want to shut down.  If you are using Terminal Services or similar, connect to the IP...

It sounds as if this event occurs when Windows can't extract all the information from the event generated by an application, in this case MSSQL SERVER.  I'm sorry but I...