Kick-off Meeting - that's the one important meeting in any project. It is where all the parties gauge their expectations.

and you said this:

Sometimes I think the problems in software development...

Same for me. There is a lot about SQL Server that I want to learn. The learning process is the easiest part because I have access to tools and resources....

sorry, this is not a direct response to your question, but there's a good section about your question in the Red Gate book "SQL Server Transaction Log Management"

Happy 4th!

You need the "Microsoft SQL Server 2005 Backward Compatibility Components" Feature Pack, you can find it here. I can't tell you which package to download because I don't know...

I suggest that you rebuild all the packages from the ground up. Trust me on this one. I am currently migrating SQL Server 2000 DTS packages to SQL Server 2008...

Try SQL Server Profiler, and see what the apps are doing.

You can either query the Object Catalog View or the Information Schema View.

to return user tables and their columns:

-- Object Catalog

SELECT T.NAME AS

, C.NAME AS [COLUMN NAME],...

You don't really want to "import" all the SQL Server Instances in your *laptop*. You probably just want to register the sql servers in the SSMS installed on your laptop.

Try...

What are you trying to import now? Please clarify.

You can start from here: http://www.microsoft.com/learning/mcp/mcts/sql/2008/default.mspx

Using the Report Manager, you can Upload the .rdl file. Make sure that you set the data source correctly.

seenu_61281 (10/23/2008)

---

is there any best book or site to learn for DBA profession.

my ultimate aim is to become stronger in sql...i need step by step process to improve my knowledge..

pls...

#1 Lesson Learned from this:

When it's boiling inside your head because you cannot solve a problem, stay away from the keyboard and from the people around you...

thanks for the help...

Mea Culpa....

My Bad, did not mean to be sarcastic.

Let's go back to business guys...let's forgive and forget....

I am trying to do something like the extended procedure xp_dirscan. Is there...