BCP Error 08001, Nativeerror 2
Wed, 3 Jun 2009 09:16:02 -0700
Hello all,
I am trying to import the data in a csv file into my data using the code
below, and I am getting errors.
bcp myDB.dbo.my_Table in c:\File_2009.csv -T -c
The errors are:
SQLState = 08001, NativeError = 2
Error = [Microsoft][SQL Native Client ] Named Pipes Provider: Could not open
a connect ...
|
Writing CustomReports for SSMS
Wed, 03 Jun 2009 16:31:32 +0200
Hello,
I try to write a custom report for SSMS but have the following
difficulty. The report is very simple and has only one table data
region, containing about 10 pages but SSMS will only shown the first
page with no option of seeing the other pages. Has anyone also had this
problem and if so what is ...
|
No management Studio
Tue, 2 Jun 2009 19:33:39 -0500
I installed SQL 2005 Developer on Win2003 quite a while ago in conjunction
with Sharepoint - -
I didn't touch it for a long time, but since my other computer with SQL on
it died, I thought I'd spin it up and do some work on it - - well, I saw the
Configuration tools in the Program list, but no management stud ...
|
"Cannot Create an Editor" in SMSS 2008
Tue, 2 Jun 2009 08:53:01 -0700
Hello,
I am (attempting to use) SMSS, but when I try to look at any table, I get
the error "Cannot create an editor". I can look at the same tables without
an issue in VS2008.
Below is the stack trace about the issue.
Any ideas?
Thanks,
WtS
===================================
Object reference ...
|
Business Intelligence Studio
Fri, 29 May 2009 10:26:01 -0700
how do I do a "merge join" and only select the non-matching records.?
...
|
Any free extended property editors out there?
Thu, 28 May 2009 05:58:01 -0700
Recommendations welcome.
Thanks,
Jim. ...
|
SS Management Studio Issue
Tue, 26 May 2009 16:10:01 -0700
For some reason when I launch the Open or Save As dialog, Management studio
eats 35-45% of each CPU on my dual CPU system (not dual core) system for at
least 15 before the dialog appears. If I'm saving a file it will take
another 15-20 minutes before dialog is dismissed and control returns to the
main windo ...
|
|
|
SQL Server 2005 Error
Fri, 22 May 2009 20:04:46 +0200
While trying to connect to Local or Remote Server on the network I received
the following error, what could be happening? I need help...
It's a SQL SERVER 2005 + SP2
===================================
No se puede conectar a SQLSERVER2005.
===================================
Se produjo una excepción en ...
|
Collation type
Thu, 21 May 2009 17:21:35 -0700
I'm trying to change the collation type of the master database to
SQL_Latin1_General_CP1_CI_AS using RebuildM.exe . I don't see this collation
in the drop down list box. I'm using SQL Server 2000 SP2.
Is there a way I can select the collation I require from rebuildm.exe?
--
Regards
Nick T ...
|
2008 SSMS object explorer
Mon, 18 May 2009 16:14:02 -0700
In SQL Server 2008 Management Studio object explorer you can expand the
"tables" folder of a database to see the list of tables contained in that
database. Occasionally, instead of a list of tables, I see the words "see
object explorer details for objects in this folder". Some times I get tables
in the tab ...
|
