Given that you only want to do this in one database, this should be simpler:

use YourDB

select name as Object, object_name(uid) as Owner from sysobjects

John

Presumably, since you have tempdb (data and log) on its own drive, your application makes heavy use of tempdb.  Now you need to find out how much of that activity...

Curtis

Yes - just to clarify, the MS docs are right.  You don't need AWE for 4GB and under.  But you do need the /3GB switch for your 2.5GB.  I suppose...

Dinakar

Surely it will work if you restore your database at the subscriber, set up the publication and then start synchronising?  If identity insert is on, then the values in the...

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...