What is bcp?

Well, i was thinking, since Excel spread sheet exposes entire table (instead of one record at a time.) to the user, data entry person data might mess things up...

Mark,

I am using vs.net 2005 server explorer to access sql server 2005. I could not see compatability level 90 in properties of the db. But the SecondDB was created using sql...

AnilKumar,

Yes, table1 and 2 are of exactly same defintion. I tried without table2 too. INTO clause suppose to create the table. Nevertheless, following error message is the same whether I...

Problem solved now.

I had a bad media CD.

A different CD fixed the problem.

Muhammad,

Please see my revised post above.

Munzer

Journeyman, Muhammad and others:

Journeyman, Muhammad and others:

I was successfully able to installing sql server 2005 developer edition all peices except the "Workstation Component, Book Online, Development Tool", the last...

More accurately,  I am able to connect sql server 2005 management studio (client) to the sql server but only within my LAN. Within the LAN obviously, I did not have...

Now it is working.

My clock was set to 2001 instead of 2005.

Now, the question is,

Is there a time limit for the evaluation of sql server 2005 June CTP version? Is...

Yes, my sql server browser is enabled and started.

Following is the error message I am getting:

"Testing the registered server failed. A connection was established but then an error occurred druing...

Can anyone shed light on the following?

If I have single bit column in my table then probably it won't help to declare it as bit unless sql server store things...

Steve,

Is "vawrchar" a typo in your posting?

I will be dealing with English character only.

About bit:

If I have single bit column in my table then probably it won't help to declare it...

Thanks a lot again, Kishore and Kathi:

You folks are great in quickly answering questions.

I love this Forum.

Munzer

Thanks, Kishore.

Is there a miximum limit on number of databses one can create in a single instance of sql server installation?

Munzer

Thanks Kathi.

Is it possible to configure log shipping for more than one db in one shot by checking all db or all user db in log shipping dialog box? As...

Frank,

I think you answered my questions. thanks a lot.

And yes, I was talking about non-cluster index.