I guess NO. Two instances should be on two different ports.

Please try ssms or ssms.exe on command prompt.

That's why I provided the link. SSMS is part of Express Edition.

Not very sure but password reset / expire or OS upgrade (service packs / patches) may cause this problem. Did you notice anything similar on the server?

SQL Server Performance Tuning is a big chapter / book in itself. There is no straight answer for your question because it depends on various factors (hardware/software/OS/networking etc.). If you...

I believe you unchecked the client components while installation. You can re-run the installation & modify / update the existing instance.

For More: http://www.microsoft.com/sqlserver/en/us/product-info/compare.aspx

If you don’t have audits / policies / alerts in place it’s hard to figure out. I would suggest you to take actions on it ASAP before *someone* just drops...

Agree with Sean. It’s not like regular requirements that we get from management. For instance, if a table has 2 rows and one of the columns have 123456789 and 12345678...

If you can afford, many trainers / training institutes provide data modelling tutorials & samples etc. Please google for it & search for a trainer in your area. Else online...

I understood you don’t have access to another server except read / execute. But my question is still unanswered. Can someone verify that the job runs successfully on the Another...

As a side note, you should avoid external applications to hit to your database as sysadmin user. It could invite major security breach in future.

Also, please verify if it’s the...

Any reasons for executing a job on Linked Server? Does the job work per expectations on Local Server (where it is created)?

If a public server means a server where anybody can login and do whatever then answer is NO.

And you don’t need any Server like it. You can install SQL Server...

I read the completer thread (now). I believe you are not able to generate the resultset (data dictionary) as the first step. If your query gives the output you are...

Nice Pointer but it might not help OP because backup file won't have the indicators (prefix/suffix) he might be interested in.