Thanks, I also thought that this is a very good resource and it helped me in the past when I worked with linked servers. Although I didn’t write it,...

Paul (12/9/2008)

---

So "yyyy-mm-dd hh:mm:ss" isnt universally recognised, but "yyyymmdd hh:mm:ss.nnn" is?

Weird

Also, when you say refer to the users language, I take it you mean the SQL Server user? I've looked...

There is a good explanation about it in this URL - http://blogs.msdn.com/sql_protocols/archive/2006/08/10/694657.aspx

Adi

The date’s format in SQL Server is determined according to the user’s default language, so if 2 different users execute this line:

INSERT INTO table1(id, datefield) VALUES(1, '2008-12-09 11:00:00')

They could have...

select table_name

from information_schema.views

where view_definition like '%FunctionName%'

Instead of FunctionName write the real function's name

laubenth (12/8/2008)

---

ishaan99 (12/8/2008)

---

Has anyone tried calling a stored procdure from a user defined function. I have a procedure as Proc_XXX with 7 parameters if i do exec Proc_XXX(null,null,null,null,null,'1/1/1998','1/1/2007') i am...

As I wrote you before, default language setting will only change the default date format that you'll see and the error message's language. If you want you can try...

You can use both ascii and unicode on the same database and even on the same table. When you create the table the data type that you use for...

It should change the date format and error messages' language.

As others already recommended - don't reuse the delete primary key. It will only lead to integrity problems, but I am curios to know why you want to reuse...

I've had the same issue few times a while ago. I don't remember the exact numbers but it was similar to your case (the QA shows few hundreds logical...

You can't send parameters into a trigger, but I think that you have anything that you need. You know which table was modified, you have both versions of the...

lav (12/3/2008)

---

Soory Sir,

Actualy i m developing one web application When user login in my web application i do anything i want to sotre in a table for eg, he...

Jeff's answer will work...

I'm sorry, but I couldn't understand what you want. Can you try to post your question again with a better description of what you want to achieve?