You may want to check the data types involved.

I suggest that you narrow down the columns transfered to a few columns to isolate the problem.

MCDBA, MCITP, MCSE, OCP

I sounds like you are filtering on the wrong column within the trace? NTUserName vs LoginName...

Is NTUserName populated?

bijarcity (5/15/2011)

---

Hello

Thanks for your website.

I have a question about distributed system.

we have a project about distributed systems but the problems that we have is about how we can design this...

rajeevmehr (5/16/2011)

---

I have two instances of SQL Server 2005 SP3 'Test' and 'Prod' on same server.

In the 'test', duplicates are deleted where in 'prod' instance it was not. when i...

How did you correct the problem?

My guess is that you did what Ron suggested.

Please post the problem and the...

rajeevmehr (5/16/2011)

---

Jobs are executed successfully in both the instances. In the 'test', duplicates are deleted where in 'prod' instance it was not. when i execute the procedure manually, instead of...

Is the article listed below any use to you?

http://social.msdn.microsoft.com/Forums/en/sqlsecurity/thread/086159da-9580-4ed1-aaba-8fdd4c861f17

Coolganny (5/11/2011)

---

I have a production move tomo. I have to drop 4 columns in a table. The table has 250036240 rows and 160 columns. The time to complete this activity...

Are you getting any errors?

Have you checked permissions? 😉

Tara-1044200 (5/16/2011)

---

When i run the below qry..

SELECT top 10 empid,empno,jdate FROM OBBEAVER.Rev_Staff.dbo.employee

I get this error

Msg 7313, Level 16, State 1, Line 2

An invalid schema or catalog was specified for the...

martynjreid (5/16/2011)

---

Hi all,

I have developed a process which takes a non-SQL database, extracts data, loads it into a SQL database in a temp storage area before it generates a reporting...

Kenneth Fisher-475792 (5/16/2011)

---

SQL Server 2008 Administration: Real-World Skills for MCITP Certification and Beyond (Exams 70-432 and 70-450) and MCTS Self-Paced Training Kit (Exam 70-432): Microsoft® SQL Server® 2008 Implementation and...

Is this any help?

http://msdn.microsoft.com/en-us/library/ms189797.aspx

Please refer to the following article by Jeff Moden:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

I found this article interesting:

http://sqlblog.com/blogs/aaron_bertrand/archive/2010/10/25/fun-with-software-uninstalling-sql-server-2008-r2-evaluation-edition.aspx