Whats the significance of the data format, if you could format the same while showing in the front end using convert method?

As magoo says, please declare a variable and assign the values. It just works for me.

Please Try this....

Declare @str varchar(10)

Set @str = '22/12/2010'

Select IsDate(substring(@str,4,2) + '/' + substring(@str,1,2) + '/' + substring(@str,7,10) )

Any update on resolution if there...

The below is the one am using at real time:

select text

query_plan

, requested_memory_kb

, granted_memory_kb

, used_memory_kb ,sql_handle

from sys.dm_exec_query_memory_grants MG

CROSS APPLY sys.dm_exec_sql_text(sql_handle)

CROSS APPLY...

SELECT * FROM [Table]

Where

id=1 and value='y'

What about this?

Refer the below link for the same and vote for it....

Also there is a solution, try with if it suits your req...

http://sqlblogcasts.com/blogs/simons/archive/2009/03/25/Getting-sp_5F00_help-to-work-with-schemas-from-keyboard-shortcuts.aspx

Are you running the query from same server/machine?

Hey, first let us know the logic of generating the end date.

ohhhh....Can you try just close your SSMS window and check it is working?

If you are okei to have a incremental integer value, please go ahead with identity set on the column.

Not many organizations support picassa...Sorry...

Just wanted to know the recovery model of your database.

you write logic to append the same with name. Thats the best way.

However, wonder why did you keep your primary key on this instead you can have only the integer...

Try registering a DLL by running the given command in run window - [regsvr32 "%commonprogramfiles%\microsoft Shared\MSEnv\TextMgrP.dll"].