Creating SQL Server Database / Tables

Could someone please point me to a tutorial that would show me step by step
how to create a database in SQL 200 / 2005? I have never created any
database but pretty much a power / technical user. Just for example,
something like a contacts database - justfor concepts and starting point.I presume you are using SQL 2005. Here are possible 2 Options
Option # 1 (Programatically)
=====================
Use Query Analyzer, tool that comes with SQL Server
Look for "Create Database", "Create table" command in Books On Line
Option # 2 (Using GUI)
=================
Use Enterprise manager, tool that comes with SQL Server
Connect to SQL Server, by right clicking on the tree node, Connect to
SQL Server...
Keep using RIght-Click opion on the Treee Node, you should see the
options that are self explanatory
JD wrote:
> Could someone please point me to a tutorial that would show me step by ste
p
> how to create a database in SQL 200 / 2005? I have never created any
> database but pretty much a power / technical user. Just for example,
> something like a contacts database - justfor concepts and starting point.

Creating SQL Server Database / Tables

Could someone please point me to a tutorial that would show me step by step
how to create a database in SQL 200 / 2005? I have never created any
database but pretty much a power / technical user. Just for example,
something like a contacts database - justfor concepts and starting point.I presume you are using SQL 2005. Here are possible 2 Options
Option # 1 (Programatically)
=====================Use Query Analyzer, tool that comes with SQL Server
Look for "Create Database", "Create table" command in Books On Line
Option # 2 (Using GUI)
=================Use Enterprise manager, tool that comes with SQL Server
Connect to SQL Server, by right clicking on the tree node, Connect to
SQL Server...
Keep using RIght-Click opion on the Treee Node, you should see the
options that are self explanatory
JD wrote:
> Could someone please point me to a tutorial that would show me step by step
> how to create a database in SQL 200 / 2005? I have never created any
> database but pretty much a power / technical user. Just for example,
> something like a contacts database - justfor concepts and starting point.

Creating Global Temp table in sql 2005 DTS

Hi All,
I want to use temp table created in one step to be used in other
step.
How can i do that ?
I tried this..
One step : Create table ##abc (Fileid Int)
Other Step : Select * from ##abc -- When i Parse the query it is
giving error Invalid object name ##abc
Can anyone help me with this ?
Regards,
Rajeev RajputHi
"Rajeev" wrote:

> Hi All,
> I want to use temp table created in one step to be used in other
> step.
> How can i do that ?
>
> I tried this..
>
> One step : Create table ##abc (Fileid Int)
>
> Other Step : Select * from ##abc -- When i Parse the query it is
> giving error Invalid object name ##abc
>
> Can anyone help me with this ?
>
> Regards,
> Rajeev Rajput
>
Assuming that you have set up the correct presedences and the two tasks are
sharing the same connection, then make the RetainSameConnection property to
true on the connection and it should be ok.
John

Creating Global Temp table in sql 2005 DTS

Hi All,
I want to use temp table created in one step to be used in other
step.
How can i do that ?
I tried this..
One step : Create table ##abc (Fileid Int)
Other Step : Select * from ##abc -- When i Parse the query it is
giving error Invalid object name ##abc
Can anyone help me with this ?
Regards,
Rajeev Rajput
Hi
"Rajeev" wrote:

> Hi All,
> I want to use temp table created in one step to be used in other
> step.
> How can i do that ?
>
> I tried this..
>
> One step : Create table ##abc (Fileid Int)
>
> Other Step : Select * from ##abc -- When i Parse the query it is
> giving error Invalid object name ##abc
>
> Can anyone help me with this ?
>
> Regards,
> Rajeev Rajput
>
Assuming that you have set up the correct presedences and the two tasks are
sharing the same connection, then make the RetainSameConnection property to
true on the connection and it should be ok.
John

Creating Global Temp table in sql 2005 DTS

Hi All,
I want to use temp table created in one step to be used in other
step.
How can i do that ?
I tried this..
One step : Create table ##abc (Fileid Int)
Other Step : Select * from ##abc -- When i Parse the query it is
giving error Invalid object name ##abc
Can anyone help me with this ?
Regards,
Rajeev RajputHi
"Rajeev" wrote:
> Hi All,
> I want to use temp table created in one step to be used in other
> step.
> How can i do that ?
>
> I tried this..
>
> One step : Create table ##abc (Fileid Int)
>
> Other Step : Select * from ##abc -- When i Parse the query it is
> giving error Invalid object name ##abc
>
> Can anyone help me with this ?
>
> Regards,
> Rajeev Rajput
>
Assuming that you have set up the correct presedences and the two tasks are
sharing the same connection, then make the RetainSameConnection property to
true on the connection and it should be ok.
John

creating flat file and SQL Server 2005 hangs...

i m using the hands-on labs for SQL server 2005.

Step 6 age 14 i went thro and it make my SQL server 2005 hangs when i try to use the flat file destination.

You'll have to provide more info. The flat file destination doesn't use SQL Server in any way shape or form.

What does your dataflow do?

What colour are all the components in there (assuming you are running this in BIDS).

Do you get an error message?

-Jamie