The problem is, will it be a one way encryption or a two encrypt/decrypt, then you can pretty much use any encryption standard out there that fits that model. Check...

FIELDTERMINATOR [ = 'field_terminator' ]

Specifies the field terminator to be used for char and widechar data files. The default is \t (tab character).

Try FIELDTERMINATOR = '"'

But the format file...

This usually is related to object permissions, for example if I create a tableA on a server where I have given the select permission to an account UserAcctRead that does...

Check out "PRB: Windows NT Error 2140 When Starting SQL Server (Q180738)

" at http://support.microsoft.com/default.aspx?scid=kb;en-us;Q180738

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

I agree with Steve on the trigger on system tables. I don't think they will fire and suggest you look at what he stated.

"Don't roll your eyes at me. I...

Let us know if SP3 reinstall helps.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

First what server pack revision are you running, I believe there was one of the service packs wih something about orphaned connections and I am digging around for.

"Don't roll your...

Check out "INF: How to Troubleshoot Long Recovery on Databases (Q170115)" at http://support.microsoft.com/default.aspx?scid=kb;en-us;Q170115

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Unless the first was a backup and restore of the second you most liekly had differences between machines. Not to mention DLLs that could have corrupted registry entries and type...

Plus if the log is truncated you lose anything that may have been there to help. I suggest get the DDL if you need to compare what changes where made....

To my knowledge no. Is this code in a stored procedure? If so it could be a cached plan causing this, try recompiling. Also can you post the test version...

You can set the collation at the database level in 2000, run sp_sortorder to see what ytour current collation is on the SQL 7 box and make sure your db...

From what I have seen this is a no if the logic does not change. Where your biggest performance gain comes from is being able to use it inline in...

Or just save those to table in trace but you will have filter against them from your results.

"Don't roll your eyes at me. I will tape them in place." (Teacher...

quote:

---

It could possibly be the query that is causing the problem

---

For this I qould suggest...