It's a security issue with the accounts on Server 3. It could be your SPN isn't correct on that server or there's a timing issue (kerberos is used).

http://www.google.com/url?sa=t&ct=res&cd=1&url=http%3A%2F%2Fsupport.microsoft.com%2Fkb%2F811889&ei=tbtcR5GZG5TiiAGKn-z-Dw&usg=AFQjCNG2tTrJFOIYpo4EZa9v3b4WNAS_6w&sig2=514i745fU9eHOSD4kRnePw

http://www.google.com/url?sa=t&ct=res&cd=2&url=http%3A%2F%2Fwww.sqlservercentral.com%2Farticles%2FInstallation%2Fcannotgeneratesspicontext%2F929%2F&ei=tbtcR5GZG5TiiAGKn-z-Dw&usg=AFQjCNGps3wNFPmXQU-u9vxb-2ULrFnh7A&sig2=oCWspssnEe-b2WSKSogFFA

You need to read up on replication in books online to understand what it is and if it will meet your needs.

With snapshot replication, you'd move the entire database...

You can do a partitioned table or partitioned view that will help here. Look these up in books online and be sure you set the security the same on both...

Which database maintenance script? The maintenance plan wizard? The maintenance plan designer. There is a task (maintenance cleanup) to handle this.

Have you rebooted? I've seen this where the plan gets booted for some reason and then dies. I haven't seen a good way to fix this. Hints can help at...

Lowell has a good idea. You could do a backup /restore (with NORECOVERY), then copy logs, repeat until you're only 1 minute behind. Then backup the tail, restore, detach the...

I think you mean sp_who.

What does the DTS package do? More information would help.

This is a cross tab query.

You need to do something like.

select a.name

, b.name

, c.name

from Mytable a

inner join myTable b

inner...

It really is a slowly changing dimension, but in an OLTP system, I think it fits more as an auditing item as Jeff mentioned.

I'd store it separately as it's entered...

varchar is not Unicode.

You can change the data type, but any unicode data would be lost or cause errors during the conversion. Only the N data types (ntext, nvarchar, nchar)...

I have seen this before and it is frustrating. Try a stored procedure and see if you can get it to behave better. Also, are you executing the same query,...

Very interesting link. Did it help? Are you XP -> XP?

I haven't seen this error, but the guest user makes some sense.

Or let us know what ytou are trying to achieve. Are you looking to admin? develop software? What areas are you thinking you need to learn.

If it's true/false, then don't allow NULLs. confuses things.

I'd still recommend going with tinyint, gives you more options down the road. I've often seen someone define something a boolean, only...

I was thinking that the only way to do this was to query for known user and then strip out the domain name.

There are some AD stored procedures, but they...