And setting it to 4GB out of the 4.5 GB available is a good idea?

Sorry I wasn't more clear. Everything has been looked at from the routers to the NIC cards.

1. All the databases are on seperate servers. All servers are setup as...

Thanks- I thought I could figure out the whole thing if I was hsown part of it. But I was wrong.

Here is the other piece I need to incorporate...

My SQL 2000 instance is installed on a Windows 2003 server. I don't see the sa account as a system user.

I need to rest or hack the 'sa' password.

I must be missing something. I am using EM. I can restore the full backup and differential but I cannot restore the backup , close out and then restore the...

It seems to audit NT authetication failures but it did not log failed SQL logins?

I just ried it.

Actually, it was the nt admin who requested it. He asked me to turn on auditing in sql server to log failed login attempts. This writes to the sql log...

http://www.datawarehousing.com/papers/MimnoArticle.pdf

I think we have done a good job of beating this one to death 🙂

The reason I did a (select * ) for the view is I was trying to...

Hit a space some where ???

dumb question:

where is this outputing the files to?

exec sp_msforeachtable 'EXEC xp_cmdshell ''bcp pubs.? out ?.dat -S(local) -c -E'''

I figured out where to specify the location but I have no...

I tried that sp_recompile my_view

Didn't work.

So, inserting a lot of data into a table with a clustered index is so slow because inserting new rows hits every column, INCLUDING THE COLUMN WITH THE CLUSTERED INDEX.

...

I am the original poster:

This is really what I need to run but I have no idea what it is doing?

ALTER TABLE dbo.central_fact_Table ADD

MED_COM char(10)DEFAULT 'Commercial'

how? I had to do an alt + print screen