This is a good article!

Question: the stored procedure LogginProc is doing the endless loop waiting for the logon event description to be queued and when it finds one it pulls...

I don't know why everyone is so upset? What is new?

Did not we hear about Boston Globe using printouts with personal information to wrap papers? Did not we hear about...

I did try it for some other reason a couple of weeks ago. I created a new user database named CopyMaster and restored Master backup over it as a database...

Tim,

It all may depend on a lot of things but take a look at this article:

Troubleshooting Kerberos Delegation

http://www.microsoft.com/technet/prodtechnol/windowsserver2003/technologies/security/tkerbdel.mspx

This is sort of a White Papaer on delegation. Once on the...

You may want to check the size of Tempdb. If the query uses Tempdb (implicitly) and Tempdb is on Primary filegroup than this may be the reason for this behavor

I did find DISABLE TRIGGER in ALTER TABLE in BOL but on the second try. I knew it was there, but the thing was that if you search the index...

Hi,

Try This: you have to modify your field names accordingly. I also had both tables in one database, maybe you have to copy a linked server table first locally. Here are...

See discussion at

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

there are several suggestions including ones using sp_MSforeachtable

I am not sure what will be the performance with the linked server and if my approach is better than yours. I like your solution. Other than that I would...

Hello,

Check if the port 1433 is already in use by something else.Use from the command prompt:

netstat -b

to see what is using what port. There may be some other application or...

Kids,

"All Of Above" has a dynamic scope. Certainly, "All of Above" can not go after "none of Above" unless the category is Humor

You said "disconnected from the domain" so I got it that the computer was still on the network just not a member of the domain. I do have servers that...

What are the error messages in the Windows Event Log for the time that the package did not run

This host may not be in the domain but still on the network and the application is installed on this host, so users do go through this server

Good point