Yes you can. You cannot use fast load. You configure error output to redirect row. Then you can output to another destination. Contact me and I will send you a...

Try converting the text column to varchar()

max) in your query. The. Text datatype is stored as binary in SQL Server.

Kenneth Fisher (2/25/2008)

---

Probably the eaiest thing for you to do is to create a trace on create database. But you can create a trigger using

CREATE TRIGGER ddl_Trig_DBCreate

ON ALL...

Is the stored procedure always going to return 1 row?

Are you using a datareader or a dataset?

When the user makes a change to the record how are you going to...

Another option in 2005 is to enable DDL triggers and create one for Create Procedure and insert the datain to a table you can query to see who or what...

Well, you came to the right place for opinions :D. Unfortunately I think most will be complaining about how vague your post is. Without knowing what you are...

Have you checked the Error Logs (Sql Server and Windows)? If it is clustered (you should know this), is it an Active-Active or Active-Passive cluster?

I used to delete this account, but I have started just removing it from the sysadmin group. I know my Network Admin's don't need sysadmin access to my SQL...

No you cannot dynamically format result set text in Query Analyzer or any other direct SQL tool that I am aware of. If this is that important to you...

I actually used this for SQL2000 and SQL 7 (some of the features work) at my last employer. It was actually released before SQL2005.

I personally do not think that the validation you are doing in the example should be done in the UI or business layer. The reason for this is that...

Have you looked at the SQL Server Health and History tool provided by MS for nothing?

http://www.microsoft.com/downloads/details.aspx?FamilyID=eedd10d6-75f7-4763-86de-d2347b8b5f89&displaylang=en

I believe it will gather all the information for you. You can also get...

I don't see anything amiss in that data and I was able to load it without issue. I think the best thing is to manually build a package to...

Have you verified that is it in fact the same clerk? Could it be something like a varchar field where one row has spaces at the end and the...

Are you allowing mixed authentication on the named instance and setting an sa password? It sounds like you are setting up the named instance to use the Domain password...