[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


New to SQL Server 2008

Posted on 2011-04-19
Medium Priority
Last Modified: 2012-06-27
What is a good staring point for me and queries in SQL 2008?
we are goin to that now. I have been doing them in VFP 9, MS Access, and Green Screen AS400...

Question by:jaymz69
  • 2

Accepted Solution

sunezapa earned 1000 total points
ID: 35429664

for comparison of Access and MNS-SQL: http://www.databasejournal.com/features/mssql/article.php/1490561/Data-Structure-Differences-between-Access-and-SQL-Server.htm

for migration from Access to SQL2008 there is a great tools especially for this, search for "microsoft sql server migration assistant 2008 fro access" (32bit/64bit versions available)
LVL 10

Assisted Solution

by:Ramesh Babu Vavilla
Ramesh Babu Vavilla earned 1000 total points
ID: 35446555
i sugest you to buy sql server 2008 in action book , which is really grea

Author Closing Comment

ID: 35447704
LVL 10

Expert Comment

by:Ramesh Babu Vavilla
ID: 35458254
1.check the TCP/IP port is open or not
2.try to access the server usng IP address

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

872 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question