How are you passing the date? The safest way is YYYYMMDD. SQL Server will get that right.

I am not aware of a way to default this behavior. If you find a way let me know.

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...