@serg, thanks for those link which help me to get bearing formula, while when I used those function am not getting the angular movement of flight while it gives only...

Yes its a complete route but need a SP or function or logic to update a table which has current lat and log details

in a time interval at run time...

@steve-2, thanks for those links, that was helpful to be only distance between source and destination. I am looking for all the possible X and Y coordinates between the source...

Thanks for that quick responce.

I think DB will be case insenstive, as I am working on a migration project of oracle to sql, SSMA was not converting

the above Index in...

I think you should use SQL Activity monitor or profiler to get the CLR which is using more memory.

Thanks for the responce Perry!!

I was able to fix it not only by by using instance name without full servername and we need to pass the

sysaccount details in double quote...

SELECT'IF NOT EXISTS (SELECT [name] FROM sys.database_principals WHERE [name] = ' + SPACE(1) + '''' + [name] + '''' + ') BEGIN CREATE USER ' + SPACE(1) + QUOTENAME([name]) +...

You can try to use NET USE command to batch file and try

@john-2 Mitchell-245523 - yes, have tried Deny Delete to Logingen as well, no luck.

@GilaMonster - Yes the login is sysadmin and not a database owner on the database I want

to deny the delete

Thanks Mike for the reply...but one strange thing here in my scenario i canot change the schema to dbo coz the same objects exists on dbo schema as well as...

Ya I have tried putting the database to SIMPLE mode but no luck.

But as i mentioned it's a just a test database am trying to produce for UAT. So do...

Thank you all for the suggestions.

I was able to do my updates in batch, every time detaching the db and deleteing the log file and attaching the mdf file...

Mate..tnx for that link..but i just want to know is there a way i still can run my updates with out logging them on log file?

thanks for the info...can you please help me out with a piece of recursive function for this scenairo

Really appreciate you help on this 🙂