I found it table valued functions.

Thanks.

Does anyone has any ideas of updating this value as a number into varchar field by not converting into 7.77888+e009

Thanks.

the data type in source table is float and when I update this info in tableB which has a varchar data type it's converting to 7.77888e+009. I need to update...

They are not running with the same service account.

Can we setup logshipping between two servers which are not part of a single domain.

They are two independent servers.

The service run with same windows login which has sysadmin privileges on both the servers.

It shows 150 MB free space out of 3.1 GB. Can I create any free space on it?

In fact I ran into space issue. Thats why I wanted to create...

When I click the properties of the database I see only 100MB free out of 3.2 GB.

Still Can shrink the mdf file?

Thanks.

I need this because this random number should be concatenated with a string.

I changed the config file and then its working fine.

Thanks for your help.

Its a named instance and got the following error.

Login failed for domain\username.(Microsoft Sql Server ,Error:18456).

The sql server is up and running and being used by others.

I was given admin privileges...

Nope.

I have other time zones as well. But based on your help I was able to convert all the other data.

Thanks.

If the recovery model is simple the transactional log file will be shrinked with each db backup,right?

I don't see anything in sqlserver error log as well.