Thanks fot your quick reply.

But i will not be able to access that config file on another system in same domain;that why i am.looking for some t sql command.

I have checked it but problem is

NT 6.3 :=> Windows 8.1

NT 6.2 :> Windows 8

http://en.wikipedia.org/wiki/List_of_Microsoft_Windows_versions

Check this post

handling-null-values-in-sql-server

First Check weather SQL Server Instance is running and exists.

to see list of intances use

Go to command prompt and type in “osql -L” or “sqlcmd -L”.

or

use

http://www.queryingsql.com/2013/02/search-all-running-sql-server-instances.html

If instance is...

I am using Full Recovery Model.

I tried to backup and shrink.But reduces only 1 GB space from 23 GB.

I also tried these steps

http://levicorp.com/2011/01/17/how-to-purge-vcenter-sql-server-transaction-log/[/url]

Thanks for your quick reply.

I dont want to use SQL Profiler.

I think ,Profile does not show system ip or system name on which query run.

Can i use any thing else...

Yes,

It requires .Net 2.0+.Net 3.5 to install.

Use your windows CD => add & remove windows Feature=>check .net2.0+.net 3.5

I hope it will works.

I think you need to install .NET 3.5 SP1.

See prerequisite sql server 2008 R2

http://msdn.microsoft.com/en-IN/library/ms143506.aspx

download and install it.then Try

See various ways to export data from excel to sql server

http://support.microsoft.com/kb/321686

Thank you so much.........

I have tried this one

http://queryingsql.blogspot.in/2012/10/linked-server-setup-with-oracle.html?utm_source=BP_recent

Hope this link helps you.

Thanks for your quick reply.

I am using SQL server 2008 r2

more information:

Microsoft SQL Server Management Studio10.50.1600.1

Microsoft Analysis Services Client Tools10.50.1600.1

Microsoft Data Access Components (MDAC)6.1.7601.17514

Microsoft MSXML3.0 5.0 6.0

Microsoft Internet Explorer8.0.7601.17514

Microsoft...

Real Data in Oracle database

PRINT_DATE

---------------

29-DEC-2009

09-MAR-2010

12-MAR-2010

11-MAY-2011

You need to select query as

select * from @NumberTable

order by Convert(numeric,REPLACE(REPLACE(ItemNumber,'ABC-',''),'-xyz','')) asc