I only use the 'magic tables' in my 'PFM' database ...

It's easier if you use DBCC INPUTBUFFER(spid) as stated in an earlier post in the thread.

Try DBCC LOGINFO('your_database_name').

Ditto on "What is 'NS' in this case ?" ... and it's not too late for me, it's only 11:30 AM !

Here's a good thread that might help (look for Randy Petty) ...

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=163479

Now a great article - this is step by step on how to evict a node and join...

You will have a brief outage. For example:

--> 2-3 minutes - Stop replication (I'll cover that last)

--> 1 minute - sp_detachdb

--> 12 minute - copy database (10 Gb mdf &...

DBCC MEMUSAGE will give you the top 20.

In previous versions it used to give more infomation and column headings.

Is the windows firewall on ? If so, turn it off for the installation. And give it another try (there are issues with installing on XP SP2, I cannot recall...

The "fire and forget" process model has been a cornerstone of Information Systems since the 70's. Does anybody remember IMS DB/DC and BMP programs on the IBM mainframe ? How about...

I just started experiencing the errors on 9/13 - about a dozen of them. That's the first time I'd ever seen anything 'abnormal' from this site.

What's the attributes of tempdb ?

data/log size and growth for each.

Maybe you'r getting hung on a tempdb growth issue ? To test this remove the temp table and create...

SET IBM_AND_DB2_MODE ON

This type of storage is generically called "HSM" - Hierarchical Storage Management. Typically everything is on fast disks, then goes to slow disks, then tape or DVD (still...

"Unrestricted file size" ? Do you have "unrestricted disk capacity" ? Need I say more here ?

As for "what happens" whe the log file reaches the maximum size, well, transactions...

 "into a secure network with encryption" ... I mean your network has a firewall, a DMZ, another firewall and then your SQL servers and you are accessing it via a...

fortune 100/500/1000 ... all just rankings by size ... as for what it's like ... well corporate size and corporate b.s. are exponentially proportionate to one another. Presently I'm in...