Thanks for the reply

i dont see anything mentioned in the link that we can change port 1433 as port number for default instance,

i am sure we can change it for...

Thanks for the script demonfox!

It works for me.

is there anyway, we can load data without declaring coulmn names and data types(data type is not the issue for me)

My csv file...

Thanks for the reply ron,

I am expecting a script, not thru GUI

Thanks again 🙂

Perry-Thanks for correcting me 🙂

Hope this link helps you

http://sqlism.blogspot.com/2012/08/finding-port-number-for-particular-sql.html

Finding the Port Number for a particular SQL Server Instance

DECLARE @tcp_port nvarchar(5)

EXEC xp_regread

@rootkey = ‘HKEY_LOCAL_MACHINE’,

@key = ‘SOFTWARE\MICROSOFT\MSSQLSERVER\MSSQLSERVER\SUPERSOCKETNETLIB\TCP’,

@value_name = ‘TcpPort’,

@value = @tcp_port OUTPUT

select @tcp_port

Hope this link helps you

http://www.sqlserverbox.com/ssis-package-in-sql-server-agent-job-fails.html

http://sqlism.blogspot.com/2012/08/ssis-package-in-sql-server-agent-job.html

SSIS Package in SQL Server Agent Job Fails

Error:

Argument "xyz" for option "connection" is not valid. The command line parameters are invalid. The step...

EXEC xp_cmdshell 'net use v: \\ServerName\foldername'

Here we are assigning V as drive letter to the \\ServerName\foldername'

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

BACKUP DATABASE [XYZ] TO

DISK = N'v\xyz.bak'

WITH stats = 10, format

test image

If you dont mind can someone explain this with screen shots?

guess this will be helpful to new bies

Thanks again

i failed to upload.

i cant see preview or image in the post

I tried 'reply'

than 'browse'

select image

'uploaded'

it dindt appeared in the post

Thank you! 🙂

To Everyone who replied on this topic. Thank you so much.

The total scenario is well explained here.

Thanks again!

what is the port number that i have to request to open ?

Thanks a ton!

how come he is able to connect to default instance ? but not the named instance ?

😮

Note: I am not sure that we are in differnet subnets. i will post...

Thanks everyone this topic really really helped me a lot.

I installed management studio on my desktop and my other dba's desktop, we successfully connected to named instance,

so by this, i...