Sql Basic Security: access

显示标签为“access”的博文。显示所有博文

2012年3月29日星期四

bcp_init and SQL Native Client

Hi all,
I am having trouble to get the bulk copy operations working in
collaboration with SQL Native Client.
My test program crashed with an access violation in the call to
bcp_init.
I know that the error is probably mine, but I cannot find any
mistakes.
I have include the C++ source below, and I hope that someone can help
me:
#include <windows.h>
#include <oledb.h>
#include <sql.h>
#include <sqlext.h>
#include <sqltypes.h>
#define _SQLNCLI_ODBC_
#include <sqlncli.h>
#include <cassert>
#include <iostream>
namespace
{
HENV createEnvironment()
{
HENV environment;
SQLRETURN result;
result = SQLAllocHandle(SQL_HANDLE_ENV, SQL_NULL_HANDLE,
&environment);
if ((result != SQL_SUCCESS) && (result != SQL_SUCCESS_WITH_INFO))
{
throw std::runtime_error("SQLAllocHandle failed");
}
result = SQLSetEnvAttr(environment, SQL_ATTR_ODBC_VERSION,
reinterpret_cast <SQLPOINTER> (SQL_OV_ODBC3), SQL_IS_INTEGER);
if ((result != SQL_SUCCESS) && (result != SQL_SUCCESS_WITH_INFO))
{
throw std::runtime_error("SQLSetEnvAttr failed");
}
return environment;
}
SQLHDBC createConnection(HENV environment)
{
SQLHDBC connection;
SQLRETURN result;
result = SQLAllocHandle(SQL_HANDLE_DBC, environment, &connection);
if ((result != SQL_SUCCESS) && (result != SQL_SUCCESS_WITH_INFO))
{
throw std::runtime_error("SQLAllocHandle failed");
}
// Need to set this prior to connection.
result = SQLSetConnectAttr(connection, SQL_COPT_SS_BCP, (void*)
SQL_BCP_ON,
SQL_IS_INTEGER);
result = SQLConnect(connection, reinterpret_cast <SQLCHAR*> (
const_cast <char*> ("database")), SQL_NTS, reinterpret_cast
<SQLCHAR*> (
const_cast <char*> ("user")), SQL_NTS, reinterpret_cast <SQLCHAR*>
(
const_cast <char*> ("password")), SQL_NTS);
if ((result != SQL_SUCCESS) && (result != SQL_SUCCESS_WITH_INFO))
{
throw std::runtime_error("SQLConnect failed");
}
return connection;
}
int realMain(int argc, char *argv[])
{
HENV environment = createEnvironment();
SQLHDBC connection = createConnection(environment);
RETCODE result;
result = bcp_init(connection, "testdata", 0, 0, DB_IN);
assert(result != FAIL);
return 0;
}
} // anonymous namespace
int main(int argc, char* argv[])
{
try
{
return realMain(argc, argv);
}
catch (const std::exception& ex)
{
std::cerr << "exception: " << ex.what() << std::endl;
}
return 1;
}There is no error in my side. To enable trobule-shooting, you may add the
following code segment just after bcp_init:
result = bcp_init(connection, "myTable", 0, 0, DB_IN);
char SQLState[6] = "";
char Msg[256] = "";
SQLINTEGER iNativeError = 0;
SQLSMALLINT iMsgLen = 0;
int iRc = SQLGetDiagRec(SQL_HANDLE_DBC, connection, 1,
(SQLCHAR*)SQLState, &iNativeError, (SQLCHAR*)Msg, 256, &iMsgLen);
if (iRc != SQL_NO_DATA) {
printf("SQLState=%s, NativeError=%d, Msg=%s\n", SQLState,
iNativeError, Msg);
}
assert(result != FAIL);
Ming.
MDAC Team, Microsoft.
"Peter" wrote:

> Hi all,
> I am having trouble to get the bulk copy operations working in
> collaboration with SQL Native Client.
> My test program crashed with an access violation in the call to
> bcp_init.
> I know that the error is probably mine, but I cannot find any
> mistakes.
> I have include the C++ source below, and I hope that someone can help
> me:
> #include <windows.h>
> #include <oledb.h>
> #include <sql.h>
> #include <sqlext.h>
> #include <sqltypes.h>
> #define _SQLNCLI_ODBC_
> #include <sqlncli.h>
> #include <cassert>
> #include <iostream>
> namespace
> {
> HENV createEnvironment()
> {
> HENV environment;
> SQLRETURN result;
> result = SQLAllocHandle(SQL_HANDLE_ENV, SQL_NULL_HANDLE,
> &environment);
> if ((result != SQL_SUCCESS) && (result != SQL_SUCCESS_WITH_INFO))
> {
> throw std::runtime_error("SQLAllocHandle failed");
> }
> result = SQLSetEnvAttr(environment, SQL_ATTR_ODBC_VERSION,
> reinterpret_cast <SQLPOINTER> (SQL_OV_ODBC3), SQL_IS_INTEGER);
> if ((result != SQL_SUCCESS) && (result != SQL_SUCCESS_WITH_INFO))
> {
> throw std::runtime_error("SQLSetEnvAttr failed");
> }
> return environment;
> }
> SQLHDBC createConnection(HENV environment)
> {
> SQLHDBC connection;
> SQLRETURN result;
> result = SQLAllocHandle(SQL_HANDLE_DBC, environment, &connection);
> if ((result != SQL_SUCCESS) && (result != SQL_SUCCESS_WITH_INFO))
> {
> throw std::runtime_error("SQLAllocHandle failed");
> }
> // Need to set this prior to connection.
> result = SQLSetConnectAttr(connection, SQL_COPT_SS_BCP, (void*)
> SQL_BCP_ON,
> SQL_IS_INTEGER);
> result = SQLConnect(connection, reinterpret_cast <SQLCHAR*> (
> const_cast <char*> ("database")), SQL_NTS, reinterpret_cast
> <SQLCHAR*> (
> const_cast <char*> ("user")), SQL_NTS, reinterpret_cast <SQLCHAR*>
> (
> const_cast <char*> ("password")), SQL_NTS);
> if ((result != SQL_SUCCESS) && (result != SQL_SUCCESS_WITH_INFO))
> {
> throw std::runtime_error("SQLConnect failed");
> }
> return connection;
> }
> int realMain(int argc, char *argv[])
> {
> HENV environment = createEnvironment();
> SQLHDBC connection = createConnection(environment);
> RETCODE result;
> result = bcp_init(connection, "testdata", 0, 0, DB_IN);
> assert(result != FAIL);
> return 0;
> }
> } // anonymous namespace
> int main(int argc, char* argv[])
> {
> try
> {
> return realMain(argc, argv);
> }
> catch (const std::exception& ex)
> {
> std::cerr << "exception: " << ex.what() << std::endl;
> }
> return 1;
> }
>sql

bcp_init and SQL Native Client

Hi all,
I am having trouble to get the bulk copy operations working in
collaboration with SQL Native Client.
My test program crashed with an access violation in the call to
bcp_init.
I know that the error is probably mine, but I cannot find any
mistakes.
I have include the C++ source below, and I hope that someone can help
me:
#include <windows.h>
#include <oledb.h>
#include <sql.h>
#include <sqlext.h>
#include <sqltypes.h>
#define _SQLNCLI_ODBC_
#include <sqlncli.h>
#include <cassert>
#include <iostream>
namespace
{
HENV createEnvironment()
{
HENV environment;
SQLRETURN result;
result = SQLAllocHandle(SQL_HANDLE_ENV, SQL_NULL_HANDLE,
&environment);
if ((result != SQL_SUCCESS) && (result != SQL_SUCCESS_WITH_INFO))
{
throw std::runtime_error("SQLAllocHandle failed");
}
result = SQLSetEnvAttr(environment, SQL_ATTR_ODBC_VERSION,
reinterpret_cast <SQLPOINTER> (SQL_OV_ODBC3), SQL_IS_INTEGER);
if ((result != SQL_SUCCESS) && (result != SQL_SUCCESS_WITH_INFO))
{
throw std::runtime_error("SQLSetEnvAttr failed");
}
return environment;
}
SQLHDBC createConnection(HENV environment)
{
SQLHDBC connection;
SQLRETURN result;
result = SQLAllocHandle(SQL_HANDLE_DBC, environment, &connection);
if ((result != SQL_SUCCESS) && (result != SQL_SUCCESS_WITH_INFO))
{
throw std::runtime_error("SQLAllocHandle failed");
}
// Need to set this prior to connection.
result = SQLSetConnectAttr(connection, SQL_COPT_SS_BCP, (void*)
SQL_BCP_ON,
SQL_IS_INTEGER);
result = SQLConnect(connection, reinterpret_cast <SQLCHAR*> (
const_cast <char*> ("database")), SQL_NTS, reinterpret_cast
<SQLCHAR*> (
const_cast <char*> ("user")), SQL_NTS, reinterpret_cast <SQLCHAR*>
(
const_cast <char*> ("password")), SQL_NTS);
if ((result != SQL_SUCCESS) && (result != SQL_SUCCESS_WITH_INFO))
{
throw std::runtime_error("SQLConnect failed");
}
return connection;
}
int realMain(int argc, char *argv[])
{
HENV environment = createEnvironment();
SQLHDBC connection = createConnection(environment);
RETCODE result;
result = bcp_init(connection, "testdata", 0, 0, DB_IN);
assert(result != FAIL);
return 0;
}
} // anonymous namespace
int main(int argc, char* argv[])
{
try
{
return realMain(argc, argv);
}
catch (const std::exception& ex)
{
std::cerr << "exception: " << ex.what() << std::endl;
}
return 1;
}
There is no error in my side. To enable trobule-shooting, you may add the
following code segment just after bcp_init:
result = bcp_init(connection, "myTable", 0, 0, DB_IN);
char SQLState[6] = "";
char Msg[256] = "";
SQLINTEGER iNativeError = 0;
SQLSMALLINT iMsgLen = 0;
int iRc = SQLGetDiagRec(SQL_HANDLE_DBC, connection, 1,
(SQLCHAR*)SQLState, &iNativeError, (SQLCHAR*)Msg, 256, &iMsgLen);
if (iRc != SQL_NO_DATA) {
printf("SQLState=%s, NativeError=%d, Msg=%s\n", SQLState,
iNativeError, Msg);
}
assert(result != FAIL);
Ming.
MDAC Team, Microsoft.
"Peter" wrote:

> Hi all,
> I am having trouble to get the bulk copy operations working in
> collaboration with SQL Native Client.
> My test program crashed with an access violation in the call to
> bcp_init.
> I know that the error is probably mine, but I cannot find any
> mistakes.
> I have include the C++ source below, and I hope that someone can help
> me:
> #include <windows.h>
> #include <oledb.h>
> #include <sql.h>
> #include <sqlext.h>
> #include <sqltypes.h>
> #define _SQLNCLI_ODBC_
> #include <sqlncli.h>
> #include <cassert>
> #include <iostream>
> namespace
> {
> HENV createEnvironment()
> {
> HENV environment;
> SQLRETURN result;
> result = SQLAllocHandle(SQL_HANDLE_ENV, SQL_NULL_HANDLE,
> &environment);
> if ((result != SQL_SUCCESS) && (result != SQL_SUCCESS_WITH_INFO))
> {
> throw std::runtime_error("SQLAllocHandle failed");
> }
> result = SQLSetEnvAttr(environment, SQL_ATTR_ODBC_VERSION,
> reinterpret_cast <SQLPOINTER> (SQL_OV_ODBC3), SQL_IS_INTEGER);
> if ((result != SQL_SUCCESS) && (result != SQL_SUCCESS_WITH_INFO))
> {
> throw std::runtime_error("SQLSetEnvAttr failed");
> }
> return environment;
> }
> SQLHDBC createConnection(HENV environment)
> {
> SQLHDBC connection;
> SQLRETURN result;
> result = SQLAllocHandle(SQL_HANDLE_DBC, environment, &connection);
> if ((result != SQL_SUCCESS) && (result != SQL_SUCCESS_WITH_INFO))
> {
> throw std::runtime_error("SQLAllocHandle failed");
> }
> // Need to set this prior to connection.
> result = SQLSetConnectAttr(connection, SQL_COPT_SS_BCP, (void*)
> SQL_BCP_ON,
> SQL_IS_INTEGER);
> result = SQLConnect(connection, reinterpret_cast <SQLCHAR*> (
> const_cast <char*> ("database")), SQL_NTS, reinterpret_cast
> <SQLCHAR*> (
> const_cast <char*> ("user")), SQL_NTS, reinterpret_cast <SQLCHAR*>
> (
> const_cast <char*> ("password")), SQL_NTS);
> if ((result != SQL_SUCCESS) && (result != SQL_SUCCESS_WITH_INFO))
> {
> throw std::runtime_error("SQLConnect failed");
> }
> return connection;
> }
> int realMain(int argc, char *argv[])
> {
> HENV environment = createEnvironment();
> SQLHDBC connection = createConnection(environment);
> RETCODE result;
> result = bcp_init(connection, "testdata", 0, 0, DB_IN);
> assert(result != FAIL);
> return 0;
> }
> } // anonymous namespace
> int main(int argc, char* argv[])
> {
> try
> {
> return realMain(argc, argv);
> }
> catch (const std::exception& ex)
> {
> std::cerr << "exception: " << ex.what() << std::endl;
> }
> return 1;
> }
>

bcp_init and SQL Native Client

Hi all,
I am having trouble to get the bulk copy operations working in
collaboration with SQL Native Client.
My test program crashed with an access violation in the call to
bcp_init.
I know that the error is probably mine, but I cannot find any
mistakes.
I have include the C++ source below, and I hope that someone can help
me:
#include <windows.h>
#include <oledb.h>
#include <sql.h>
#include <sqlext.h>
#include <sqltypes.h>
#define _SQLNCLI_ODBC_
#include <sqlncli.h>
#include <cassert>
#include <iostream>
namespace
{
HENV createEnvironment()
{
HENV environment;
SQLRETURN result;
result = SQLAllocHandle(SQL_HANDLE_ENV, SQL_NULL_HANDLE,
&environment);
if ((result != SQL_SUCCESS) && (result != SQL_SUCCESS_WITH_INFO))
{
throw std::runtime_error("SQLAllocHandle failed");
}
result = SQLSetEnvAttr(environment, SQL_ATTR_ODBC_VERSION,
reinterpret_cast <SQLPOINTER> (SQL_OV_ODBC3), SQL_IS_INTEGER);
if ((result != SQL_SUCCESS) && (result != SQL_SUCCESS_WITH_INFO))
{
throw std::runtime_error("SQLSetEnvAttr failed");
}
return environment;
}
SQLHDBC createConnection(HENV environment)
{
SQLHDBC connection;
SQLRETURN result;
result = SQLAllocHandle(SQL_HANDLE_DBC, environment, &connection);
if ((result != SQL_SUCCESS) && (result != SQL_SUCCESS_WITH_INFO))
{
throw std::runtime_error("SQLAllocHandle failed");
}
// Need to set this prior to connection.
result = SQLSetConnectAttr(connection, SQL_COPT_SS_BCP, (void*)
SQL_BCP_ON,
SQL_IS_INTEGER);
result = SQLConnect(connection, reinterpret_cast <SQLCHAR*> (
const_cast <char*> ("database")), SQL_NTS, reinterpret_cast
<SQLCHAR*> (
const_cast <char*> ("user")), SQL_NTS, reinterpret_cast <SQLCHAR*>
(
const_cast <char*> ("password")), SQL_NTS);
if ((result != SQL_SUCCESS) && (result != SQL_SUCCESS_WITH_INFO))
{
throw std::runtime_error("SQLConnect failed");
}
return connection;
}
int realMain(int argc, char *argv[])
{
HENV environment = createEnvironment();
SQLHDBC connection = createConnection(environment);
RETCODE result;
result = bcp_init(connection, "testdata", 0, 0, DB_IN);
assert(result != FAIL);
return 0;
}
} // anonymous namespace
int main(int argc, char* argv[])
{
try
{
return realMain(argc, argv);
}
catch (const std::exception& ex)
{
std::cerr << "exception: " << ex.what() << std::endl;
}
return 1;
}There is no error in my side. To enable trobule-shooting, you may add the
following code segment just after bcp_init:
result = bcp_init(connection, "myTable", 0, 0, DB_IN);
char SQLState[6] = "";
char Msg[256] = "";
SQLINTEGER iNativeError = 0;
SQLSMALLINT iMsgLen = 0;
int iRc = SQLGetDiagRec(SQL_HANDLE_DBC, connection, 1,
(SQLCHAR*)SQLState, &iNativeError, (SQLCHAR*)Msg, 256, &iMsgLen);
if (iRc != SQL_NO_DATA) {
printf("SQLState=%s, NativeError=%d, Msg=%s\n", SQLState,
iNativeError, Msg);
}
assert(result != FAIL);
Ming.
MDAC Team, Microsoft.
"Peter" wrote:
> Hi all,
> I am having trouble to get the bulk copy operations working in
> collaboration with SQL Native Client.
> My test program crashed with an access violation in the call to
> bcp_init.
> I know that the error is probably mine, but I cannot find any
> mistakes.
> I have include the C++ source below, and I hope that someone can help
> me:
> #include <windows.h>
> #include <oledb.h>
> #include <sql.h>
> #include <sqlext.h>
> #include <sqltypes.h>
> #define _SQLNCLI_ODBC_
> #include <sqlncli.h>
> #include <cassert>
> #include <iostream>
> namespace
> {
> HENV createEnvironment()
> {
> HENV environment;
> SQLRETURN result;
> result = SQLAllocHandle(SQL_HANDLE_ENV, SQL_NULL_HANDLE,
> &environment);
> if ((result != SQL_SUCCESS) && (result != SQL_SUCCESS_WITH_INFO))
> {
> throw std::runtime_error("SQLAllocHandle failed");
> }
> result = SQLSetEnvAttr(environment, SQL_ATTR_ODBC_VERSION,
> reinterpret_cast <SQLPOINTER> (SQL_OV_ODBC3), SQL_IS_INTEGER);
> if ((result != SQL_SUCCESS) && (result != SQL_SUCCESS_WITH_INFO))
> {
> throw std::runtime_error("SQLSetEnvAttr failed");
> }
> return environment;
> }
> SQLHDBC createConnection(HENV environment)
> {
> SQLHDBC connection;
> SQLRETURN result;
> result = SQLAllocHandle(SQL_HANDLE_DBC, environment, &connection);
> if ((result != SQL_SUCCESS) && (result != SQL_SUCCESS_WITH_INFO))
> {
> throw std::runtime_error("SQLAllocHandle failed");
> }
> // Need to set this prior to connection.
> result = SQLSetConnectAttr(connection, SQL_COPT_SS_BCP, (void*)
> SQL_BCP_ON,
> SQL_IS_INTEGER);
> result = SQLConnect(connection, reinterpret_cast <SQLCHAR*> (
> const_cast <char*> ("database")), SQL_NTS, reinterpret_cast
> <SQLCHAR*> (
> const_cast <char*> ("user")), SQL_NTS, reinterpret_cast <SQLCHAR*>
> (
> const_cast <char*> ("password")), SQL_NTS);
> if ((result != SQL_SUCCESS) && (result != SQL_SUCCESS_WITH_INFO))
> {
> throw std::runtime_error("SQLConnect failed");
> }
> return connection;
> }
> int realMain(int argc, char *argv[])
> {
> HENV environment = createEnvironment();
> SQLHDBC connection = createConnection(environment);
> RETCODE result;
> result = bcp_init(connection, "testdata", 0, 0, DB_IN);
> assert(result != FAIL);
> return 0;
> }
> } // anonymous namespace
> int main(int argc, char* argv[])
> {
> try
> {
> return realMain(argc, argv);
> }
> catch (const std::exception& ex)
> {
> std::cerr << "exception: " << ex.what() << std::endl;
> }
> return 1;
> }
>

2012年3月22日星期四

BCP server not found failure

Hi..im trying to use BCP to transfer data from text file to a SQL table and
give me an error. I have access to the db table with the 'sa' user and both
input and format files are in the directory. This was working well, but
suddenly stop working.
This is the complete command and the error at the prompt:
--COmmand--
C:\>bcp dt..hc990021 in e:\dtracker\dtdata30\33600001032002990.or1
-fe:\dtracker\dtdata30\HC990021.fmt -b5000 -F1 -Usa -P -h
--error--
SQLState = 08001, NativeError = 17
Error = [Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does
not exist or access denied.
SQLState = 01000, NativeError = 2
Warning = [Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen
(Connect()).
Any idea..?
CARLOS BREA
PUERTO RICO
You have NOT specified the "-S server_name[\instance_name]" option.
This specifies the instance of SQL Server to connect to. If no server is
specified, bcp connects to the default instance of SQL Server on the local
computer. If you do not have a default instance and instead have a NAMED
instance, then this option is required. Also, this option is required when
executing bcp from a remote computer on the network.
Reference:
Books Online topic: bcp Utility
Fany Vargas
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their
Microsoft software to better protect against viruses and security
vulnerabilities. The easiest way to do this is to visit the following
websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
|||I have several named instances...the issue is that this bcp command was
working before setup of the DNS entries. Is any relation of this with the
failure.//?
How can I specified a specific default named instances in my SQL server, to
not have to use the -S flag at the command? I have a program that generate
the bcp command and didnt specify the -s flag. What I have to do to use the
bcp withut the -s flag?
Thanks.,..
"Fany Vargas [MSFT]" wrote:

> You have NOT specified the "-S server_name[\instance_name]" option.
> This specifies the instance of SQL Server to connect to. If no server is
> specified, bcp connects to the default instance of SQL Server on the local
> computer. If you do not have a default instance and instead have a NAMED
> instance, then this option is required. Also, this option is required when
> executing bcp from a remote computer on the network.
>
> Reference:
> Books Online topic: bcp Utility
> Fany Vargas
> Microsoft Corporation
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Are you secure? For information about the Strategic Technology Protection
> Program and to order your FREE Security Tool Kit, please visit
> http://www.microsoft.com/security.
> Microsoft highly recommends that users with Internet access update their
> Microsoft software to better protect against viruses and security
> vulnerabilities. The easiest way to do this is to visit the following
> websites:
> http://www.microsoft.com/protect
> http://www.microsoft.com/security/guidance/default.mspx
>
|||You have to specify the -S flag to connect to a named instace. If you have
a default instance which is running (service is not stopped) then excluding
the -S specifies to connect to this default instance. The only possible way
(it may not even work) I can see where you can get the BCP command to work
without the -S command and force it to connect to a named instance is to
create a client alias with name "." and point it your named instance. So
for example:
start->run->cliconfg.exe->alias tab->Add
aliasname = .
servername=sqlservername\instancename
you can also try alias:
aliasname = (local)
servername=sqlservername\instancename
but keep in mind that would force any other applications on this machine
which try to connect using "." notation to now connect to the named
instance you pointed it too instead of the default instance. So the best
option would be to have your application create the bcp command correctly.
Fany Vargas
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their
Microsoft software to better protect against viruses and security
vulnerabilities. The easiest way to do this is to visit the following
websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
sql

BCP server not found failure

Hi..im trying to use BCP to transfer data from text file to a SQL table and
give me an error. I have access to the db table with the 'sa' user and both
input and format files are in the directory. This was working well, but
suddenly stop working.
This is the complete command and the error at the prompt:
--COmmand--
C:\>bcp dt..hc990021 in e:\dtracker\dtdata30\33600001032002990.or1
-fe:\dtracker\dtdata30\HC990021.fmt -b5000 -F1 -Usa -P -h
--error--
SQLState = 08001, NativeError = 17
Error = [Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Se
rver does
not exist or access denied.
SQLState = 01000, NativeError = 2
Warning = [Microsoft][ODBC SQL Server Driver][Shared Memory]Conn
ectionOpen
(Connect()).
Any idea..?
CARLOS BREA
PUERTO RICOYou have NOT specified the "-S server_name[\instance_name]" option.
This specifies the instance of SQL Server to connect to. If no server is
specified, bcp connects to the default instance of SQL Server on the local
computer. If you do not have a default instance and instead have a NAMED
instance, then this option is required. Also, this option is required when
executing bcp from a remote computer on the network.
Reference:
Books Online topic: bcp Utility
Fany Vargas
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their
Microsoft software to better protect against viruses and security
vulnerabilities. The easiest way to do this is to visit the following
websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx|||I have several named instances...the issue is that this bcp command was
working before setup of the DNS entries. Is any relation of this with the
failure.//?
How can I specified a specific default named instances in my SQL server, to
not have to use the -S flag at the command? I have a program that generate
the bcp command and didnt specify the -s flag. What I have to do to use the
bcp withut the -s flag?
Thanks.,..
"Fany Vargas [MSFT]" wrote:

> You have NOT specified the "-S server_name[\instance_name]" option.
> This specifies the instance of SQL Server to connect to. If no server is
> specified, bcp connects to the default instance of SQL Server on the local
> computer. If you do not have a default instance and instead have a NAMED
> instance, then this option is required. Also, this option is required when
> executing bcp from a remote computer on the network.
>
> Reference:
> Books Online topic: bcp Utility
> Fany Vargas
> Microsoft Corporation
> This posting is provided "AS IS" with no warranties, and confers no rights
.
> Are you secure? For information about the Strategic Technology Protection
> Program and to order your FREE Security Tool Kit, please visit
> http://www.microsoft.com/security.
> Microsoft highly recommends that users with Internet access update their
> Microsoft software to better protect against viruses and security
> vulnerabilities. The easiest way to do this is to visit the following
> websites:
> http://www.microsoft.com/protect
> http://www.microsoft.com/security/guidance/default.mspx
>|||You have to specify the -S flag to connect to a named instace. If you have
a default instance which is running (service is not stopped) then excluding
the -S specifies to connect to this default instance. The only possible way
(it may not even work) I can see where you can get the BCP command to work
without the -S command and force it to connect to a named instance is to
create a client alias with name "." and point it your named instance. So
for example:
start->run->cliconfg.exe->alias tab->Add
aliasname = .
servername=sqlservername\instancename
you can also try alias:
aliasname = (local)
servername=sqlservername\instancename
but keep in mind that would force any other applications on this machine
which try to connect using "." notation to now connect to the named
instance you pointed it too instead of the default instance. So the best
option would be to have your application create the bcp command correctly.
Fany Vargas
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their
Microsoft software to better protect against viruses and security
vulnerabilities. The easiest way to do this is to visit the following
websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx

2012年3月20日星期二

bcp out text

what happens to text columns when they get bcp'ed out?

Truncated to 8000?

Going csv

The project from hell...the "developer" knew access...thought text was Access text...painful...

I'll be finding out soon I guess...any comments (sympathy) appreciated...

Cross post!No - you will be ok.|||Well, I'll be doing it today...let you know what happens...

REQ:

Search every column in every table...find reference to keyword "x", then dump those rows out...

painful|||My Sympathies ...

But tell me .. how did this requirement crop up ...
would love to hear the story behind this one :)

BTW ... am working on converting some ABAP code into stored procs ... and believe me ... i am forced to use cursors :(|||Inheritance...like I got the app to support and it's a piece of garbage...

Someone knew Access, and things got out of control...

Isn't that always the case?

2012年3月11日星期日

bcp import help

I am trying to import data thru a bcp call to pull data from an access database. I am having trouble accessing the access database. Below is the bcp I tried, along with an openrowset attempt. Neither of them are working. Any help would be greatly appreciated.

bcp select datetime,groupNumber,lineSubgroupNumber,lineNumber ,lineName,inCall,noCallAnswer,
noOutCall,abandonCall,noCallAD,noCallABT,noHelpcal l,noTxcall,noNtcall,totalInNormalTime,
totalOutNormalTime,totalHoldNormalTime,totalAbando nTime,totalLineBusyTime,totalTransTime,
ansCallBin0,ansCallBin1,ansCallBin2,ansCallBin3,an sCallBin4,ansCallBin5,ansCallBin6,
abnCallBin0,abnCallBin1,abnCallBin2,abnCallBin3,ab nCallBin4,abnCallBin5,abnCallBin6
from Line Report in I:\2007\11\D1107.MDB -q -UXX -PXX

select datetime,groupNumber,lineSubgroupNumber,lineNumber ,lineName,inCall,noCallAnswer,
noOutCall,abandonCall,noCallAD,noCallABT,noHelpcal l,noTxcall,noNtcall,totalInNormalTime,
totalOutNormalTime,totalHoldNormalTime,totalAbando nTime,totalLineBusyTime,totalTransTime,
ansCallBin0,ansCallBin1,ansCallBin2,ansCallBin3,an sCallBin4,ansCallBin5,ansCallBin6,
abnCallBin0,abnCallBin1,abnCallBin2,abnCallBin3,ab nCallBin4,abnCallBin5,abnCallBin6
FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'I:\2007\10\D1007.MDB';'XX';'XX', 'Line Report')Are you able to add the mdb as a linked server - you could then simply run SQL statements irectly on the data? I'm afraid I am unable to test this from my current location so I'm not able to check!|||I can add it as a linked server, but then I cant actually query against any of the access tables.

sp_addlinkedserver 'D1107', 'Access 97', 'Microsoft.Jet.OLEDB.4.0',
'\\ctisvr\stats\2007\11\D1107.MDB'

SELECT *
FROM D1107...Line Report

when I run the select statment I then get:
'OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error.
[OLE/DB provider returned message: Cannot open database ''. It may not be a database that your application recognizes, or the file may be corrupt.]'|||Do you get the same error message for the OPENROWSET query? Also, what version is the Access database created in?

As a side note, you have probably already learned that BCP is used solely for "flat files". Pure ASCII/UNICODE characters.|||Same error. Not sure what version it was created in as I am importing it from a 3rd party vendor.|||Hi.
why not use a DTS package? and test this SELECT *
FROM D1107...[Line Report]|||Did you try the DTS Wizard?

I don't have a full version of Sql Server, only MSDE. So I didn't have the DTS Wizard. Then I looked in an old Office 2000 disk I've got, and found it. I copied over dtswiz.exe and some other .dll and .rll files to my Sql Server\tools\binn folder and it worked.

2012年3月6日星期二

bcp error server not found

bcp error - restricted access datatype violation

I got my bcp in and out to work, and also the format file creation.

Now, when i'm importing some of the more strange tables, I get:

SQLState = 07006, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]Restricted data type attribute violation

I can barely find anything on this by searching on the web - and not anything I can see relevant on MSDN.

I'm guessing the problem is because there are all sorts of float fields in the table, but I don't know, and I don't know how to fix it if it is...

Help!

My code works on smaller, less complicated tables, but not on the bigger monster.

When it fails, does the table have any Text, NText, or Image columns? And are any of these fields Null in 1 or more rows? Is the field type the same in the format file and in the table for these columns?

|||

Nope - but the table is horrendous. There are 500 columns.

SQL Server is creating the format file, I'm using bcp with the format file switches, so I would think that the SQL Server would translate it correctly...The table I'm trying to bcp into is a direct copy of the source table...

Here's the format file:

8.0
504
1 SQLCHAR 2 10 "" 1 LoanNumber SQL_Latin1_General_CP1_CI_AS
2 SQLCHAR 2 4 "" 2 ForecastGroup SQL_Latin1_General_CP1_CI_AS
3 SQLCHAR 2 15 "" 3 ForecastGroupRUSH SQL_Latin1_General_CP1_CI_AS
4 SQLCHAR 2 15 "" 4 SourceOfBusiness SQL_Latin1_General_CP1_CI_AS
5 SQLDATETIM4 1 4 "" 5 AppTakenDate ""
6 SQLDATETIM4 1 4 "" 6 AppDate ""
7 SQLDATETIM4 1 4 "" 7 AppWeek ""
8 SQLDATETIM4 1 4 "" 8 AppMonth ""
9 SQLCHAR 2 4 "" 9 LPO SQL_Latin1_General_CP1_CI_AS
10 SQLCHAR 2 4 "" 10 MAP SQL_Latin1_General_CP1_CI_AS
11 SQLCHAR 2 4 "" 11 Region SQL_Latin1_General_CP1_CI_AS
12 SQLCHAR 2 1 "" 12 Division SQL_Latin1_General_CP1_CI_AS
13 SQLCHAR 2 3 "" 13 FundingCompany SQL_Latin1_General_CP1_CI_AS
14 SQLCHAR 2 6 "" 14 ClientCode SQL_Latin1_General_CP1_CI_AS
15 SQLCHAR 2 30 "" 15 ClientName SQL_Latin1_General_CP1_CI_AS
16 SQLCHAR 2 4 "" 16 MarketingProgram SQL_Latin1_General_CP1_CI_AS
17 SQLCHAR 2 3 "" 17 Team SQL_Latin1_General_CP1_CI_AS
18 SQLCHAR 2 2 "" 18 State SQL_Latin1_General_CP1_CI_AS
19 SQLCHAR 2 5 "" 19 ZipCode SQL_Latin1_General_CP1_CI_AS
20 SQLCHAR 2 30 "" 20 DMNumber SQL_Latin1_General_CP1_CI_AS
21 SQLDATETIM4 1 4 "" 21 FundingDate ""
22 SQLDATETIM4 1 4 "" 22 CODAFundingDate ""
23 SQLDATETIM4 1 4 "" 23 CODAFundingWeek ""
24 SQLDATETIM4 1 4 "" 24 CODAFundingMonth ""
25 SQLDATETIM4 1 4 "" 25 OLDCODAFundingDate ""
26 SQLSMALLINT 1 2 "" 26 Funded ""
27 SQLDATETIM4 1 4 "" 27 CancellationDate ""
28 SQLDATETIM4 1 4 "" 28 DenialDate ""
29 SQLSMALLINT 1 2 "" 29 Fallout ""
30 SQLDATETIM4 1 4 "" 30 FalloutDate ""
31 SQLDATETIM4 1 4 "" 31 FalloutWeek ""
32 SQLDATETIM4 1 4 "" 32 FalloutMonth ""
33 SQLDATETIM4 1 4 "" 33 ApplicationDate ""
34 SQLDATETIM4 1 4 "" 34 CreditApprovedDate ""
35 SQLDATETIM4 1 4 "" 35 CreditOrderedDate ""
36 SQLDATETIM4 1 4 "" 36 CreditReceivedDate ""
37 SQLDATETIM4 1 4 "" 37 CreditRejectedDate ""
38 SQLDATETIM4 1 4 "" 38 AppraisalApprovedDate ""
39 SQLDATETIM4 1 4 "" 39 AppraisalOrderedDate ""
40 SQLDATETIM4 1 4 "" 40 AppraisalReceivedDate ""
41 SQLDATETIM4 1 4 "" 41 AppraisalRejectedDate ""
42 SQLDATETIM4 1 4 "" 42 PriceProtectedDate ""
43 SQLDATETIM4 1 4 "" 43 PriceExpirationDate ""
44 SQLDATETIM4 1 4 "" 44 ProjectedCloseDate ""
45 SQLDATETIM4 1 4 "" 45 PropertyDate ""
46 SQLDATETIM4 1 4 "" 46 PaidOffDate ""
47 SQLDATETIM4 1 4 "" 47 ApplicationInconpleteDate ""
48 SQLDATETIM4 1 4 "" 48 ApplicationIncompleteTime ""
49 SQLDATETIM4 1 4 "" 49 ApplicationCompleteDate ""
50 SQLDATETIM4 1 4 "" 50 ApplicationCompleteTime ""
51 SQLDATETIM4 1 4 "" 51 FirstDecisionDate ""
52 SQLDATETIM4 1 4 "" 52 FirstDecisionTime ""
53 SQLDATETIM4 1 4 "" 53 FundingConfirmedDate ""
54 SQLDATETIM4 1 4 "" 54 FundingConfirmedTime ""
55 SQLDATETIM4 1 4 "" 55 ReferralDate ""
56 SQLCHAR 2 1 "" 56 CancelDenialInd SQL_Latin1_General_CP1_CI_AS
57 SQLCHAR 2 1 "" 57 CreditOnlyInd SQL_Latin1_General_CP1_CI_AS
58 SQLCHAR 2 2 "" 58 CreditScore SQL_Latin1_General_CP1_CI_AS
59 SQLCHAR 2 4 "" 59 DenialReason SQL_Latin1_General_CP1_CI_AS
60 SQLCHAR 2 1 "" 60 DocType SQL_Latin1_General_CP1_CI_AS
61 SQLCHAR 2 1 "" 61 EAP SQL_Latin1_General_CP1_CI_AS
62 SQLCHAR 2 1 "" 62 EscrowWaivedInd SQL_Latin1_General_CP1_CI_AS
63 SQLCHAR 2 1 "" 63 LoanType SQL_Latin1_General_CP1_CI_AS
64 SQLCHAR 2 1 "" 64 LoanTypeSimple SQL_Latin1_General_CP1_CI_AS
65 SQLCHAR 2 1 "" 65 ConformingInd SQL_Latin1_General_CP1_CI_AS
66 SQLCHAR 2 1 "" 66 LPMIInd SQL_Latin1_General_CP1_CI_AS
67 SQLCHAR 2 1 "" 67 NewConstructionInd SQL_Latin1_General_CP1_CI_AS
68 SQLCHAR 2 3 "" 68 OriginationSystem SQL_Latin1_General_CP1_CI_AS
69 SQLCHAR 2 6 "" 69 ProductCode SQL_Latin1_General_CP1_CI_AS
70 SQLCHAR 2 6 "" 70 ProgramCode SQL_Latin1_General_CP1_CI_AS
71 SQLCHAR 2 1 "" 71 LoanPurpose SQL_Latin1_General_CP1_CI_AS
72 SQLCHAR 2 1 "" 72 LoanPurposeSimple SQL_Latin1_General_CP1_CI_AS
73 SQLCHAR 2 1 "" 73 RefiRepeatInd SQL_Latin1_General_CP1_CI_AS
74 SQLCHAR 2 1 "" 74 RepeatBorrowerInd SQL_Latin1_General_CP1_CI_AS
75 SQLCHAR 2 2 "" 75 Status SQL_Latin1_General_CP1_CI_AS
76 SQLCHAR 2 3 "" 76 StatusCode SQL_Latin1_General_CP1_CI_AS
77 SQLCHAR 2 1 "" 77 StreamCode SQL_Latin1_General_CP1_CI_AS
78 SQLCHAR 2 1 "" 78 TimeSaverInd SQL_Latin1_General_CP1_CI_AS
79 SQLCHAR 2 4 "" 79 UndewritingAuthorityLevel SQL_Latin1_General_CP1_CI_AS
80 SQLFLT8 1 8 "" 80 LoanAmount ""
81 SQLFLT8 1 8 "" 81 LTV ""
82 SQLFLT8 1 8 "" 82 Price ""
83 SQLINT 1 4 "" 83 AQIScore ""
84 SQLINT 1 4 "" 84 FICOScore ""
85 SQLCHAR 2 9 "" 85 SalesRepConversion SQL_Latin1_General_CP1_CI_AS
86 SQLCHAR 2 9 "" 86 SalesRepLead SQL_Latin1_General_CP1_CI_AS
87 SQLCHAR 2 4 "" 87 MortgageSpecialistProcessor SQL_Latin1_General_CP1_CI_AS
88 SQLCHAR 2 30 "" 88 Underwriter SQL_Latin1_General_CP1_CI_AS
89 SQLCHAR 2 30 "" 89 Closer SQL_Latin1_General_CP1_CI_AS
90 SQLCHAR 2 3 "" 90 CSRInitials SQL_Latin1_General_CP1_CI_AS
91 SQLCHAR 2 30 "" 91 PrefCommMethod SQL_Latin1_General_CP1_CI_AS
92 SQLFLT4 1 4 "" 92 NoteRate ""
93 SQLCHAR 2 1 "" 93 EquityOut SQL_Latin1_General_CP1_CI_AS
94 SQLCHAR 2 2 "" 94 PricingProgram SQL_Latin1_General_CP1_CI_AS
95 SQLCHAR 2 40 "" 95 BorrEMail SQL_Latin1_General_CP1_CI_AS
96 SQLCHAR 2 4 "" 96 LoanSource SQL_Latin1_General_CP1_CI_AS
97 SQLCHAR 2 3 "" 97 PropertyType SQL_Latin1_General_CP1_CI_AS
98 SQLCHAR 2 1 "" 98 LanguagePreference SQL_Latin1_General_CP1_CI_AS
99 SQLDATETIM4 1 4 "" 99 RePriceDate ""
100 SQLCHAR 2 4 "" 100 PM2 SQL_Latin1_General_CP1_CI_AS
101 SQLCHAR 2 10 "" 101 BankTrackingCode SQL_Latin1_General_CP1_CI_AS
102 SQLCHAR 2 10 "" 102 PreviousLoanNumber SQL_Latin1_General_CP1_CI_AS
103 SQLCHAR 2 31 "" 103 PropertyAddress SQL_Latin1_General_CP1_CI_AS
104 SQLCHAR 2 30 "" 104 PropertyCity SQL_Latin1_General_CP1_CI_AS
105 SQLCHAR 2 20 "" 105 BorrowerJobTitle SQL_Latin1_General_CP1_CI_AS
106 SQLCHAR 2 9 "" 106 HESalesRep SQL_Latin1_General_CP1_CI_AS
107 SQLCHAR 2 6 "" 107 HEAU SQL_Latin1_General_CP1_CI_AS
108 SQLCHAR 2 2 "" 108 HEPricingProgram SQL_Latin1_General_CP1_CI_AS
109 SQLFLT4 1 4 "" 109 SecondaryFinancing ""
110 SQLDATETIM4 1 4 "" 110 ActualClosingDate ""
111 SQLDATETIM4 1 4 "" 111 EstimatedClosingDate ""
112 SQLNUMERIC 1 19 "" 112 AppraisalValue ""
113 SQLDATETIM4 1 4 "" 113 CommitExpDate ""
114 SQLCHAR 2 30 "" 114 BorrowerLastName SQL_Latin1_General_CP1_CI_AS
115 SQLCHAR 2 2 "" 115 IncomeTractCode SQL_Latin1_General_CP1_CI_AS
116 SQLCHAR 2 2 "" 116 IncomeRatioCode SQL_Latin1_General_CP1_CI_AS
117 SQLCHAR 2 5 "" 117 Borrower1RaceCode SQL_Latin1_General_CP1_CI_AS
118 SQLCHAR 2 5 "" 118 Borrower2RaceCode SQL_Latin1_General_CP1_CI_AS
119 SQLCHAR 2 5 "" 119 Borrower3RaceCode SQL_Latin1_General_CP1_CI_AS
120 SQLCHAR 2 5 "" 120 Borrower4RaceCode SQL_Latin1_General_CP1_CI_AS
121 SQLDATETIM4 1 4 "" 121 InterestAccrualDate ""
122 SQLCHAR 2 31 "" 122 BillingAddress SQL_Latin1_General_CP1_CI_AS
123 SQLCHAR 2 31 "" 123 BillingAddress2 SQL_Latin1_General_CP1_CI_AS
124 SQLCHAR 2 30 "" 124 BillingCity SQL_Latin1_General_CP1_CI_AS
125 SQLCHAR 2 2 "" 125 BillingState SQL_Latin1_General_CP1_CI_AS
126 SQLCHAR 2 5 "" 126 BillingZipCode SQL_Latin1_General_CP1_CI_AS
127 SQLCHAR 2 30 "" 127 BorrowerFirstName SQL_Latin1_General_CP1_CI_AS
128 SQLCHAR 2 9 "" 128 DecisionerRep SQL_Latin1_General_CP1_CI_AS
129 SQLCHAR 2 10 "" 129 InvestmentRepNumber SQL_Latin1_General_CP1_CI_AS
130 SQLCHAR 2 40 "" 130 InvestmentRepName SQL_Latin1_General_CP1_CI_AS
131 SQLDATETIM4 1 4 "" 131 StatusCodeDate ""
132 SQLDATETIM4 1 4 "" 132 FundingClearedDate ""
133 SQLDATETIM4 1 4 "" 133 ApprovalCondDate ""
134 SQLDATETIM4 1 4 "" 134 OrigSCLOPackageDate ""
135 SQLDATETIM4 1 4 "" 135 LastSCLOPackageDate ""
136 SQLCHAR 2 1 "" 136 ApprovalCondLatePmtInd SQL_Latin1_General_CP1_CI_AS
137 SQLCHAR 2 1 "" 137 ApprovalCondPmtHistInd SQL_Latin1_General_CP1_CI_AS
138 SQLCHAR 2 1 "" 138 ApprovalCondAlimonyInd SQL_Latin1_General_CP1_CI_AS
139 SQLCHAR 2 1 "" 139 ApprovalCondCAIVR SQL_Latin1_General_CP1_CI_AS
140 SQLCHAR 2 1 "" 140 ApprovalCondLDPGSA SQL_Latin1_General_CP1_CI_AS
141 SQLCHAR 2 8 "" 141 CreditRiskClass SQL_Latin1_General_CP1_CI_AS
142 SQLCHAR 2 15 "" 142 BorrowerHomePhone SQL_Latin1_General_CP1_CI_AS
143 SQLCHAR 2 15 "" 143 BorrowerWorkPhone SQL_Latin1_General_CP1_CI_AS
144 SQLCHAR 2 30 "" 144 SettlementAgent SQL_Latin1_General_CP1_CI_AS
145 SQLCHAR 2 20 "" 145 SettlementAgentAddress SQL_Latin1_General_CP1_CI_AS
146 SQLCHAR 2 20 "" 146 SettlementAgentCity SQL_Latin1_General_CP1_CI_AS
147 SQLCHAR 2 2 "" 147 SettlementAgentState SQL_Latin1_General_CP1_CI_AS
148 SQLCHAR 2 5 "" 148 SettlementAgentZip SQL_Latin1_General_CP1_CI_AS
149 SQLCHAR 2 10 "" 149 SettlementAgentPhone SQL_Latin1_General_CP1_CI_AS
150 SQLCHAR 2 10 "" 150 SettlementAgentFax SQL_Latin1_General_CP1_CI_AS
151 SQLCHAR 2 60 "" 151 SettlementAgentEMail SQL_Latin1_General_CP1_CI_AS
152 SQLCHAR 2 10 "" 152 UnderwriterID SQL_Latin1_General_CP1_CI_AS
153 SQLDATETIM4 1 4 "" 153 ScheduledToSignDate ""
154 SQLDATETIM4 1 4 "" 154 DisbursementDate ""
155 SQLDATETIM4 1 4 "" 155 ClosingHandOffDate ""
156 SQLINT 1 4 "" 156 AmortizationType ""
157 SQLDATETIM4 1 4 "" 157 FundsToArriveDate ""
158 SQLDATETIM4 1 4 "" 158 FirstPreApprovalDate ""
159 SQLDATETIM4 1 4 "" 159 FirstApprovalDate ""
160 SQLDATETIM4 1 4 "" 160 DecisionDate ""
161 SQLDATETIM4 1 4 "" 161 LoanToUnderwriterDate ""
162 SQLDATETIM4 1 4 "" 162 ApprovedWithPropertyDate ""
163 SQLDATETIM4 1 4 "" 163 LoanAtCloserDate ""
164 SQLDATETIM4 1 4 "" 164 LastLoanAtCloserDate ""
165 SQLDATETIM4 1 4 "" 165 LastFundsWiredDate ""
166 SQLDATETIM4 1 4 "" 166 OrigFundingConfirmedDate ""
167 SQLCHAR 2 2 "" 167 PropertyStatus SQL_Latin1_General_CP1_CI_AS
168 SQLCHAR 2 50 "" 168 ListingAgentName SQL_Latin1_General_CP1_CI_AS
169 SQLCHAR 2 40 "" 169 ListingAgentPhone SQL_Latin1_General_CP1_CI_AS
170 SQLCHAR 2 50 "" 170 SellingAgentName SQL_Latin1_General_CP1_CI_AS
171 SQLCHAR 2 40 "" 171 SellingAgentPhone SQL_Latin1_General_CP1_CI_AS
172 SQLCHAR 2 10 "" 172 ContactRealtorInd SQL_Latin1_General_CP1_CI_AS
173 SQLDATETIM4 1 4 "" 173 DisclosurePkgOrderedDate ""
174 SQLDATETIM4 1 4 "" 174 DisclosurePkgRecdDate ""
175 SQLDATETIM4 1 4 "" 175 DisclosurePkgComplianceDate ""
176 SQLCHAR 2 3 "" 176 DisclosurePkgRep SQL_Latin1_General_CP1_CI_AS
177 SQLDATETIM4 1 4 "" 177 CommitmentPktPrintedDate ""
178 SQLDATETIM4 1 4 "" 178 CommitmentPktSentDate ""
179 SQLDATETIM4 1 4 "" 179 CommitmentPktEntryDate ""
180 SQLCHAR 2 3 "" 180 CommitmentPktRep SQL_Latin1_General_CP1_CI_AS
181 SQLDATETIM4 1 4 "" 181 CounterOfferSentDate ""
182 SQLDATETIM4 1 4 "" 182 CounterOfferEntryDate ""
183 SQLCHAR 2 3 "" 183 CounterOfferRep SQL_Latin1_General_CP1_CI_AS
184 SQLCHAR 2 1 "" 184 FNMAJudgement SQL_Latin1_General_CP1_CI_AS
185 SQLCHAR 2 1 "" 185 FNMAForeclosure SQL_Latin1_General_CP1_CI_AS
186 SQLCHAR 2 1 "" 186 FNMAEndorser SQL_Latin1_General_CP1_CI_AS
187 SQLCHAR 2 1 "" 187 FNMAAlimony SQL_Latin1_General_CP1_CI_AS
188 SQLCHAR 2 1 "" 188 FNMADownPayment SQL_Latin1_General_CP1_CI_AS
189 SQLCHAR 2 1 "" 189 FNMALawSuit SQL_Latin1_General_CP1_CI_AS
190 SQLCHAR 2 1 "" 190 FNMABankruptcy SQL_Latin1_General_CP1_CI_AS
191 SQLCHAR 2 1 "" 191 FNMAObligations SQL_Latin1_General_CP1_CI_AS
192 SQLCHAR 2 1 "" 192 FNMADelinquency SQL_Latin1_General_CP1_CI_AS
193 SQLCHAR 2 1 "" 193 FNMAUSCitizen SQL_Latin1_General_CP1_CI_AS
194 SQLCHAR 2 1 "" 194 FNMAPermResAlien SQL_Latin1_General_CP1_CI_AS
195 SQLCHAR 2 1 "" 195 FNMAForeignNational SQL_Latin1_General_CP1_CI_AS
196 SQLCHAR 2 1 "" 196 FNMANonPermResAlien SQL_Latin1_General_CP1_CI_AS
197 SQLCHAR 2 1 "" 197 BorrSelfEmployedInd SQL_Latin1_General_CP1_CI_AS
198 SQLCHAR 2 30 "" 198 EmployerName SQL_Latin1_General_CP1_CI_AS
199 SQLCHAR 2 30 "" 199 EmployerCity SQL_Latin1_General_CP1_CI_AS
200 SQLCHAR 2 10 "" 200 EmployerState SQL_Latin1_General_CP1_CI_AS
201 SQLCHAR 2 10 "" 201 EmployerZipCode SQL_Latin1_General_CP1_CI_AS
202 SQLCHAR 2 10 "" 202 EmployerPhoneNumber SQL_Latin1_General_CP1_CI_AS
203 SQLDATETIM4 1 4 "" 203 PropertyNotificationDate ""
204 SQLDATETIM4 1 4 "" 204 PropertyNotificationEntryDate ""
205 SQLCHAR 2 3 "" 205 PropertyRepConv SQL_Latin1_General_CP1_CI_AS
206 SQLDATETIM4 1 4 "" 206 TitleReviewedDate ""
207 SQLCHAR 2 3 "" 207 TitleReviewedRep SQL_Latin1_General_CP1_CI_AS
208 SQLDATETIM4 1 4 "" 208 NotificationDate ""
209 SQLDATETIM4 1 4 "" 209 DenialCancelLetterPrintedDate ""
210 SQLCHAR 2 3 "" 210 DenialCancelLetterRep SQL_Latin1_General_CP1_CI_AS
211 SQLDATETIM4 1 4 "" 211 ClosingCostsCallDate ""
212 SQLDATETIM4 1 4 "" 212 ClosingCostsCallEntryDate ""
213 SQLCHAR 2 3 "" 213 ClosingCostsCallRep SQL_Latin1_General_CP1_CI_AS
214 SQLTINYINT 1 1 "" 214 PresentAddressYears ""
215 SQLTINYINT 1 1 "" 215 PresentAddressMonths ""
216 SQLDATETIM4 1 4 "" 216 EmployerStartDate ""
217 SQLCHAR 2 20 "" 217 PrevBorrowerAddress SQL_Latin1_General_CP1_CI_AS
218 SQLCHAR 2 18 "" 218 PrevBorrowerCity SQL_Latin1_General_CP1_CI_AS
219 SQLCHAR 2 2 "" 219 PrevBorrowerState SQL_Latin1_General_CP1_CI_AS
220 SQLCHAR 2 9 "" 220 PrevBorrowerZipCode SQL_Latin1_General_CP1_CI_AS
221 SQLTINYINT 1 1 "" 221 PrevAddressYears ""
222 SQLTINYINT 1 1 "" 222 PrevAddressMonths ""
223 SQLCHAR 2 25 "" 223 PrevEmployerName SQL_Latin1_General_CP1_CI_AS
224 SQLCHAR 2 30 "" 224 PrevEmployerCity SQL_Latin1_General_CP1_CI_AS
225 SQLCHAR 2 2 "" 225 PrevEmployerState SQL_Latin1_General_CP1_CI_AS
226 SQLDATETIM4 1 4 "" 226 PrevEmployerStartDate ""
227 SQLDECIMAL 1 19 "" 227 BorrowerIncomeBase ""
228 SQLDECIMAL 1 19 "" 228 BorrowerIncomeOT ""
229 SQLDECIMAL 1 19 "" 229 BorrowerIncomeBonus ""
230 SQLDECIMAL 1 19 "" 230 BorrowerIncomeComm ""
231 SQLDECIMAL 1 19 "" 231 BorrowerIncomeDividend ""
232 SQLCHAR 2 1 "" 232 BorrPrevSelfEmployedInd SQL_Latin1_General_CP1_CI_AS
233 SQLDATETIM4 1 4 "" 233 DocRqstLtrPrintedDate ""
234 SQLDATETIM4 1 4 "" 234 DocRqstLtrEntryDate ""
235 SQLCHAR 2 3 "" 235 DocRqstLtrRep SQL_Latin1_General_CP1_CI_AS
236 SQLDATETIM4 1 4 "" 236 LastCustomerContactDate ""
237 SQLDATETIM4 1 4 "" 237 AuthToCloseReceivedDate ""
238 SQLDATETIM4 1 4 "" 238 AuthToCloseEntryDate ""
239 SQLCHAR 2 3 "" 239 AuthToCloseRep SQL_Latin1_General_CP1_CI_AS
240 SQLDECIMAL 1 19 "" 240 BorrowerTotalAssets ""
241 SQLDECIMAL 1 19 "" 241 BorrowerTotalCashRequired ""
242 SQLCHAR 2 6 "" 242 SalesAU SQL_Latin1_General_CP1_CI_AS
243 SQLCHAR 2 6 "" 243 FulfillmentAU SQL_Latin1_General_CP1_CI_AS
244 SQLCHAR 2 1 "" 244 BusinessLineCode SQL_Latin1_General_CP1_CI_AS
245 SQLCHAR 2 1 "" 245 BusinessStructureCode SQL_Latin1_General_CP1_CI_AS
246 SQLCHAR 2 3 "" 246 BusinessTypeCode SQL_Latin1_General_CP1_CI_AS
247 SQLCHAR 2 3 "" 247 BusinessProgramCode SQL_Latin1_General_CP1_CI_AS
248 SQLDATETIM4 1 4 "" 248 AppTakenTime ""
249 SQLCHAR 2 6 "" 249 AppTakenMonth SQL_Latin1_General_CP1_CI_AS
250 SQLDATETIM4 1 4 "" 250 FundingTime ""
251 SQLCHAR 2 6 "" 251 FundingMonth SQL_Latin1_General_CP1_CI_AS
252 SQLCHAR 2 1 "" 252 CreditOnlyIndRaw SQL_Latin1_General_CP1_CI_AS
253 SQLCHAR 2 9 "" 253 borrower1ssn SQL_Latin1_General_CP1_CI_AS
254 SQLCHAR 2 9 "" 254 borrower2ssn SQL_Latin1_General_CP1_CI_AS
255 SQLCHAR 2 9 "" 255 borrower3ssn SQL_Latin1_General_CP1_CI_AS
256 SQLCHAR 2 9 "" 256 borrower4ssn SQL_Latin1_General_CP1_CI_AS
257 SQLCHAR 2 1 "" 257 ActionTaken SQL_Latin1_General_CP1_CI_AS
258 SQLCHAR 2 4 "" 258 MACode SQL_Latin1_General_CP1_CI_AS
259 SQLDATETIM4 1 4 "" 259 UploadDate ""
260 SQLDATETIM4 1 4 "" 260 UpdateDate ""
261 SQLDATETIM4 1 4 "" 261 FundingDateRaw ""
262 SQLCHAR 2 1 "" 262 Borrower1EthnicityCode SQL_Latin1_General_CP1_CI_AS
263 SQLCHAR 2 1 "" 263 Borrower2EthnicityCode SQL_Latin1_General_CP1_CI_AS
264 SQLCHAR 2 1 "" 264 Borrower3EthnicityCode SQL_Latin1_General_CP1_CI_AS
265 SQLCHAR 2 1 "" 265 Borrower4EthnicityCode SQL_Latin1_General_CP1_CI_AS
266 SQLCHAR 2 1 "" 266 Borrower1RaceCode2 SQL_Latin1_General_CP1_CI_AS
267 SQLCHAR 2 1 "" 267 Borrower2RaceCode2 SQL_Latin1_General_CP1_CI_AS
268 SQLCHAR 2 1 "" 268 Borrower3RaceCode2 SQL_Latin1_General_CP1_CI_AS
269 SQLCHAR 2 1 "" 269 Borrower4RaceCode2 SQL_Latin1_General_CP1_CI_AS
270 SQLCHAR 2 1 "" 270 Borrower1RaceCode3 SQL_Latin1_General_CP1_CI_AS
271 SQLCHAR 2 1 "" 271 Borrower2RaceCode3 SQL_Latin1_General_CP1_CI_AS
272 SQLCHAR 2 1 "" 272 Borrower3RaceCode3 SQL_Latin1_General_CP1_CI_AS
273 SQLCHAR 2 1 "" 273 Borrower4RaceCode3 SQL_Latin1_General_CP1_CI_AS
274 SQLCHAR 2 1 "" 274 Borrower1RaceCode4 SQL_Latin1_General_CP1_CI_AS
275 SQLCHAR 2 1 "" 275 Borrower2RaceCode4 SQL_Latin1_General_CP1_CI_AS
276 SQLCHAR 2 1 "" 276 Borrower3RaceCode4 SQL_Latin1_General_CP1_CI_AS
277 SQLCHAR 2 1 "" 277 Borrower4RaceCode4 SQL_Latin1_General_CP1_CI_AS
278 SQLCHAR 2 1 "" 278 Borrower1RaceCode5 SQL_Latin1_General_CP1_CI_AS
279 SQLCHAR 2 1 "" 279 Borrower2RaceCode5 SQL_Latin1_General_CP1_CI_AS
280 SQLCHAR 2 1 "" 280 Borrower3RaceCode5 SQL_Latin1_General_CP1_CI_AS
281 SQLCHAR 2 1 "" 281 Borrower4RaceCode5 SQL_Latin1_General_CP1_CI_AS
282 SQLCHAR 2 1 "" 282 Borrower1GenderCode SQL_Latin1_General_CP1_CI_AS
283 SQLCHAR 2 1 "" 283 Borrower2GenderCode SQL_Latin1_General_CP1_CI_AS
284 SQLCHAR 2 1 "" 284 Borrower3GenderCode SQL_Latin1_General_CP1_CI_AS
285 SQLCHAR 2 1 "" 285 Borrower4GenderCode SQL_Latin1_General_CP1_CI_AS
286 SQLCHAR 2 4 "" 286 ChannelCode SQL_Latin1_General_CP1_CI_AS
287 SQLCHAR 2 20 "" 287 PresBorrowerAddress SQL_Latin1_General_CP1_CI_AS
288 SQLCHAR 2 18 "" 288 PresBorrowerCity SQL_Latin1_General_CP1_CI_AS
289 SQLCHAR 2 2 "" 289 PresBorrowerState SQL_Latin1_General_CP1_CI_AS
290 SQLCHAR 2 9 "" 290 PresBorrowerZip SQL_Latin1_General_CP1_CI_AS
291 SQLDATETIM4 1 4 "" 291 ClosingPackageSentDate ""
292 SQLCHAR 2 14 "" 292 ReferralAU SQL_Latin1_General_CP1_CI_AS
293 SQLDATETIM4 1 4 "" 293 InterviewDate ""
294 SQLCHAR 2 1 "" 294 UploadInd SQL_Latin1_General_CP1_CI_AS
295 SQLCHAR 2 12 "" 295 FundingNumber SQL_Latin1_General_CP1_CI_AS
296 SQLDATETIM4 1 4 "" 296 EV1Other2RecdDate ""
297 SQLDATETIM4 1 4 "" 297 EV1Other2RqstDate ""
298 SQLCHAR 2 10 "" 298 HOITransferRep SQL_Latin1_General_CP1_CI_AS
299 SQLCHAR 2 10 "" 299 BranchCode SQL_Latin1_General_CP1_CI_AS
300 SQLDATETIM4 1 4 "" 300 FloodDetermineDate ""
301 SQLDATETIM4 1 4 "" 301 FloodDetermineOrderDate ""
302 SQLCHAR 2 1 "" 302 FloodRequiredInd SQL_Latin1_General_CP1_CI_AS
303 SQLDATETIM4 1 4 "" 303 MapRecDate ""
304 SQLDATETIM4 1 4 "" 304 ShippedDate ""
305 SQLDATETIM4 1 4 "" 305 LISUploadDate ""
306 SQLCHAR 2 1 "" 306 InitialStatus SQL_Latin1_General_CP1_CI_AS
307 SQLDATETIM4 1 4 "" 307 CCRCancelDate ""
308 SQLCHAR 2 1 "" 308 OMSInd SQL_Latin1_General_CP1_CI_AS
309 SQLCHAR 2 6 "" 309 OccupancyCode SQL_Latin1_General_CP1_CI_AS
310 SQLFLT8 1 8 "" 310 SalesPrice ""
311 SQLFLT8 1 8 "" 311 Margin ""
312 SQLDATETIM4 1 4 "" 312 ClosedDate ""
313 SQLDATETIM4 1 4 "" 313 OrigRateExpDate ""
314 SQLFLT8 1 8 "" 314 DeskPrice ""
315 SQLFLT8 1 8 "" 315 ChannelPrice ""
316 SQLFLT8 1 8 "" 316 PricingGroupPrice ""
317 SQLFLT8 1 8 "" 317 BusinessUnitPrice ""
318 SQLDATETIM4 1 4 "" 318 ATCReturnedDate ""
319 SQLDATETIM4 1 4 "" 319 ATCSentDate ""
320 SQLCHAR 2 6 "" 320 SalabilityCode SQL_Latin1_General_CP1_CI_AS
321 SQLCHAR 2 6 "" 321 CreditRejectedCode SQL_Latin1_General_CP1_CI_AS
322 SQLDATETIM4 1 4 "" 322 RDUploadDate ""
323 SQLDATETIM4 1 4 "" 323 WelcomeTrackingDate ""
324 SQLDATETIM4 1 4 "" 324 WelcomeDueDate ""
325 SQLDATETIM4 1 4 "" 325 WelcomeContactDate ""
326 SQLDATETIM4 1 4 "" 326 Ev2Other1DateRqstd ""
327 SQLDATETIM4 1 4 "" 327 Ev2Other2DateRqstd ""
328 SQLDATETIM4 1 4 "" 328 Ev2Other3DateRqstd ""
329 SQLCHAR 2 10 "" 329 PricingToolCode SQL_Latin1_General_CP1_CI_AS
330 SQLCHAR 2 10 "" 330 StageCoachPriority SQL_Latin1_General_CP1_CI_AS
331 SQLCHAR 2 25 "" 331 BuilderName SQL_Latin1_General_CP1_CI_AS
332 SQLDATETIM4 1 4 "" 332 SuspendedDate ""
333 SQLCHAR 2 3 "" 333 BankProductsRep SQL_Latin1_General_CP1_CI_AS
334 SQLDATETIM4 1 4 "" 334 HudFundsReceivedDate ""
335 SQLFLT8 1 8 "" 335 QuoteRate ""
336 SQLINT 1 4 "" 336 OrigRateLockPeriod ""
337 SQLDATETIME 1 8 "" 337 OrigRateLockDate ""
338 SQLCHAR 2 1 "" 338 PCAEligInd SQL_Latin1_General_CP1_CI_AS
339 SQLCHAR 2 1 "" 339 POSCode SQL_Latin1_General_CP1_CI_AS
340 SQLCHAR 2 6 "" 340 CentSalesAU SQL_Latin1_General_CP1_CI_AS
341 SQLCHAR 2 3 "" 341 CentSalesEntityNo SQL_Latin1_General_CP1_CI_AS
342 SQLCHAR 2 3 "" 342 FulfillmentEntityNo SQL_Latin1_General_CP1_CI_AS
343 SQLCHAR 2 3 "" 343 SalesEntityNo SQL_Latin1_General_CP1_CI_AS
344 SQLCHAR 2 3 "" 344 ReferralEntityNo SQL_Latin1_General_CP1_CI_AS
345 SQLDECIMAL 1 19 "" 345 BuydownTotalReqFundsAmt ""
346 SQLCHAR 2 6 "" 346 BuydownTypeCode SQL_Latin1_General_CP1_CI_AS
347 SQLCHAR 2 2 "" 347 BuydownPayer1Code SQL_Latin1_General_CP1_CI_AS
348 SQLDECIMAL 1 19 "" 348 BuydownPayer1Amt ""
349 SQLCHAR 2 2 "" 349 BuydownPayer2Code SQL_Latin1_General_CP1_CI_AS
350 SQLDECIMAL 1 19 "" 350 BuydownPayer2Amt ""
351 SQLDATETIME 1 8 "" 351 AIRLDocsRecvDate ""
352 SQLDATETIME 1 8 "" 352 AIRLLetterDate ""
353 SQLCHAR 2 1 "" 353 BrokeredInInd SQL_Latin1_General_CP1_CI_AS
354 SQLCHAR 2 1 "" 354 BrokeredOutInd SQL_Latin1_General_CP1_CI_AS
355 SQLDECIMAL 1 19 "" 355 Buydown1Amt ""
356 SQLDECIMAL 1 19 "" 356 Buydown2Amt ""
357 SQLDECIMAL 1 19 "" 357 Buydown3Amt ""
358 SQLDECIMAL 1 19 "" 358 Buydown4Amt ""
359 SQLDECIMAL 1 19 "" 359 Buydown5Amt ""
360 SQLDECIMAL 1 19 "" 360 Buydown6Amt ""
361 SQLDECIMAL 1 19 "" 361 Buydown7Amt ""
362 SQLDECIMAL 1 19 "" 362 Buydown8Amt ""
363 SQLDECIMAL 1 19 "" 363 Buydown9Amt ""
364 SQLDECIMAL 1 19 "" 364 Buydown10Amt ""
365 SQLINT 1 4 "" 365 Buydown1MonthsQty ""
366 SQLINT 1 4 "" 366 Buydown2MonthsQty ""
367 SQLINT 1 4 "" 367 Buydown3MonthsQty ""
368 SQLINT 1 4 "" 368 Buydown4MonthsQty ""
369 SQLINT 1 4 "" 369 Buydown5MonthsQty ""
370 SQLINT 1 4 "" 370 Buydown6MonthsQty ""
371 SQLINT 1 4 "" 371 Buydown7MonthsQty ""
372 SQLINT 1 4 "" 372 Buydown8MonthsQty ""
373 SQLINT 1 4 "" 373 Buydown9MonthsQty ""
374 SQLINT 1 4 "" 374 Buydown10MonthsQty ""
375 SQLINT 1 4 "" 375 BuildYear ""
376 SQLCHAR 2 3 "" 376 PropertyClassCode SQL_Latin1_General_CP1_CI_AS
377 SQLDECIMAL 1 19 "" 377 BuydownLenderAmtRaw ""
378 SQLCHAR 2 1 "" 378 BuydownLenderAmtTypeCode SQL_Latin1_General_CP1_CI_AS
379 SQLDECIMAL 1 19 "" 379 BuydownSellerAmtRaw ""
380 SQLCHAR 2 1 "" 380 BuydownSellerAmtTypeCode SQL_Latin1_General_CP1_CI_AS
381 SQLDATETIME 1 8 "" 381 Borr1CreditRecvDate ""
382 SQLDATETIME 1 8 "" 382 CommitLetterSentDate ""
383 SQLDATETIME 1 8 "" 383 FSReceiptDate ""
384 SQLDATETIME 1 8 "" 384 RMCPkgRecvDate ""
385 SQLCHAR 2 1 "" 385 CreditRefusedInd SQL_Latin1_General_CP1_CI_AS
386 SQLCHAR 2 1 "" 386 LoanCancelledInd SQL_Latin1_General_CP1_CI_AS
387 SQLCHAR 2 1 "" 387 CounterOfferRejectedInd SQL_Latin1_General_CP1_CI_AS
388 SQLCHAR 2 30 "" 388 Borr2FirstName SQL_Latin1_General_CP1_CI_AS
389 SQLCHAR 2 30 "" 389 Borr2LastName SQL_Latin1_General_CP1_CI_AS
390 SQLCHAR 2 31 "" 390 Borr2Address SQL_Latin1_General_CP1_CI_AS
391 SQLCHAR 2 31 "" 391 Borr2Address2 SQL_Latin1_General_CP1_CI_AS
392 SQLCHAR 2 30 "" 392 Borr2CityName SQL_Latin1_General_CP1_CI_AS
393 SQLCHAR 2 2 "" 393 Borr2StateCode SQL_Latin1_General_CP1_CI_AS
394 SQLCHAR 2 10 "" 394 Borr2ZipCode SQL_Latin1_General_CP1_CI_AS
395 SQLCHAR 2 30 "" 395 Borr3FirstName SQL_Latin1_General_CP1_CI_AS
396 SQLCHAR 2 30 "" 396 Borr3LastName SQL_Latin1_General_CP1_CI_AS
397 SQLCHAR 2 30 "" 397 Borr4FirstName SQL_Latin1_General_CP1_CI_AS
398 SQLCHAR 2 30 "" 398 Borr4LastName SQL_Latin1_General_CP1_CI_AS
399 SQLDATETIME 1 8 "" 399 AdverseActionSentDate ""
400 SQLDATETIME 1 8 "" 400 NOCSentDate ""
401 SQLDATETIME 1 8 "" 401 Borr2CreditReceivedDate ""
402 SQLDATETIME 1 8 "" 402 Borr3CreditReceivedDate ""
403 SQLDATETIME 1 8 "" 403 Borr4CreditReceivedDate ""
404 SQLDATETIME 1 8 "" 404 CDDPkgSentDate ""
405 SQLDATETIME 1 8 "" 405 WelcomeLetterSendDate ""
406 SQLDATETIME 1 8 "" 406 WithdrawalSubmitDate ""
407 SQLCHAR 2 1 "" 407 ReverseInd SQL_Latin1_General_CP1_CI_AS
408 SQLCHAR 2 7 "" 408 ReferringEmployeeID SQL_Latin1_General_CP1_CI_AS
409 SQLDATETIME 1 8 "" 409 OrigAIRLLetterPrintDate ""
410 SQLCHAR 2 1 "" 410 FTHBInd SQL_Latin1_General_CP1_CI_AS
411 SQLCHAR 2 1 "" 411 InvestmentPropertyInd SQL_Latin1_General_CP1_CI_AS
412 SQLCHAR 2 1 "" 412 PrincipalResidenceInd SQL_Latin1_General_CP1_CI_AS
413 SQLCHAR 2 1 "" 413 SecondHomeInd SQL_Latin1_General_CP1_CI_AS
414 SQLCHAR 2 1 "" 414 RentOwnStatusCode SQL_Latin1_General_CP1_CI_AS
415 SQLDECIMAL 1 19 "" 415 CLTV ""
416 SQLDECIMAL 1 19 "" 416 DebtToIncomeRatio ""
417 SQLCHAR 2 25 "" 417 ClosingAgentName SQL_Latin1_General_CP1_CI_AS
418 SQLCHAR 2 3 "" 418 AppraisalVendorName SQL_Latin1_General_CP1_CI_AS
419 SQLCHAR 2 1 "" 419 SLRInitialDecisionCode SQL_Latin1_General_CP1_CI_AS
420 SQLDATETIME 1 8 "" 420 SLRInitialDecisionDate ""
421 SQLCHAR 2 3 "" 421 SLRInitialDecisionRep SQL_Latin1_General_CP1_CI_AS
422 SQLCHAR 2 8 "" 422 SLRInitialDenialReasonCode SQL_Latin1_General_CP1_CI_AS
423 SQLDATETIME 1 8 "" 423 NDSFileSentDate ""
424 SQLDATETIME 1 8 "" 424 NDSFileRecvDate ""
425 SQLCHAR 2 1 "" 425 SLRFinalDecisionCode SQL_Latin1_General_CP1_CI_AS
426 SQLDATETIME 1 8 "" 426 SLRFinalDecisionDate ""
427 SQLCHAR 2 3 "" 427 SLRFinalDecisionRep SQL_Latin1_General_CP1_CI_AS
428 SQLCHAR 2 8 "" 428 SLRFinalDenialReasonCode SQL_Latin1_General_CP1_CI_AS
429 SQLDATETIME 1 8 "" 429 NDSFileReleaseDate ""
430 SQLDATETIME 1 8 "" 430 HazardInsLastCallDate ""
431 SQLDATETIME 1 8 "" 431 HazardInsLastNextDate ""
432 SQLCHAR 2 1 "" 432 HazardInsVerifiedInd SQL_Latin1_General_CP1_CI_AS
433 SQLCHAR 2 1 "" 433 NetFundedInd SQL_Latin1_General_CP1_CI_AS
434 SQLDATETIME 1 8 "" 434 PrelimHUD1OrdDate ""
435 SQLDATETIME 1 8 "" 435 PrelimHUD1RecvDate ""
436 SQLINT 1 4 "" 436 BorrCount ""
437 SQLCHAR 2 50 "" 437 ActionTakenName SQL_Latin1_General_CP1_CI_AS
438 SQLCHAR 2 2 "" 438 Borr1OwnerIntTypeCode SQL_Latin1_General_CP1_CI_AS
439 SQLCHAR 2 2 "" 439 Borr2OwnerIntTypeCode SQL_Latin1_General_CP1_CI_AS
440 SQLCHAR 2 1 "" 440 Borr1PresAddrOwnInd SQL_Latin1_General_CP1_CI_AS
441 SQLCHAR 2 1 "" 441 Borr2PresAddrOwnInd SQL_Latin1_General_CP1_CI_AS
442 SQLCHAR 2 1 "" 442 Borr3PresAddrOwnInd SQL_Latin1_General_CP1_CI_AS
443 SQLCHAR 2 1 "" 443 Borr4PresAddrOwnInd SQL_Latin1_General_CP1_CI_AS
444 SQLCHAR 2 1 "" 444 Borr1PresAddrRentInd SQL_Latin1_General_CP1_CI_AS
445 SQLCHAR 2 1 "" 445 Borr2PresAddrRentInd SQL_Latin1_General_CP1_CI_AS
446 SQLCHAR 2 1 "" 446 Borr3PresAddrRentInd SQL_Latin1_General_CP1_CI_AS
447 SQLCHAR 2 1 "" 447 Borr4PresAddrRentInd SQL_Latin1_General_CP1_CI_AS
448 SQLCHAR 2 1 "" 448 Borr1PrevAddr1OwnInd SQL_Latin1_General_CP1_CI_AS
449 SQLCHAR 2 1 "" 449 Borr2PrevAddr1OwnInd SQL_Latin1_General_CP1_CI_AS
450 SQLCHAR 2 1 "" 450 Borr3PrevAddr1OwnInd SQL_Latin1_General_CP1_CI_AS
451 SQLCHAR 2 1 "" 451 Borr4PrevAddr1OwnInd SQL_Latin1_General_CP1_CI_AS
452 SQLCHAR 2 1 "" 452 Borr1PrevAddr1RentInd SQL_Latin1_General_CP1_CI_AS
453 SQLCHAR 2 1 "" 453 Borr2PrevAddr1RentInd SQL_Latin1_General_CP1_CI_AS
454 SQLCHAR 2 1 "" 454 Borr3PrevAddr1RentInd SQL_Latin1_General_CP1_CI_AS
455 SQLCHAR 2 1 "" 455 Borr4PrevAddr1RentInd SQL_Latin1_General_CP1_CI_AS
456 SQLCHAR 2 1 "" 456 Borr1PrevAddr2OwnInd SQL_Latin1_General_CP1_CI_AS
457 SQLCHAR 2 1 "" 457 Borr2PrevAddr2OwnInd SQL_Latin1_General_CP1_CI_AS
458 SQLCHAR 2 1 "" 458 Borr3PrevAddr2OwnInd SQL_Latin1_General_CP1_CI_AS
459 SQLCHAR 2 1 "" 459 Borr4PrevAddr2OwnInd SQL_Latin1_General_CP1_CI_AS
460 SQLCHAR 2 1 "" 460 Borr1PrevAddr2RentInd SQL_Latin1_General_CP1_CI_AS
461 SQLCHAR 2 1 "" 461 Borr2PrevAddr2RentInd SQL_Latin1_General_CP1_CI_AS
462 SQLCHAR 2 1 "" 462 Borr3PrevAddr2RentInd SQL_Latin1_General_CP1_CI_AS
463 SQLCHAR 2 1 "" 463 Borr4PrevAddr2RentInd SQL_Latin1_General_CP1_CI_AS
464 SQLCHAR 2 1 "" 464 SuspenseReason1Code SQL_Latin1_General_CP1_CI_AS
465 SQLCHAR 2 1 "" 465 SuspenseReason2Code SQL_Latin1_General_CP1_CI_AS
466 SQLCHAR 2 1 "" 466 Borr1PresAddrRentOwnCode SQL_Latin1_General_CP1_CI_AS
467 SQLCHAR 2 1 "" 467 Borr2PresAddrRentOwnCode SQL_Latin1_General_CP1_CI_AS
468 SQLCHAR 2 1 "" 468 Borr3PresAddrRentOwnCode SQL_Latin1_General_CP1_CI_AS
469 SQLCHAR 2 1 "" 469 Borr4PresAddrRentOwnCode SQL_Latin1_General_CP1_CI_AS
470 SQLCHAR 2 1 "" 470 Borr1PrevAddr1RentOwnCode SQL_Latin1_General_CP1_CI_AS
471 SQLCHAR 2 1 "" 471 Borr2PrevAddr1RentOwnCode SQL_Latin1_General_CP1_CI_AS
472 SQLCHAR 2 1 "" 472 Borr3PrevAddr1RentOwnCode SQL_Latin1_General_CP1_CI_AS
473 SQLCHAR 2 1 "" 473 Borr4PrevAddr1RentOwnCode SQL_Latin1_General_CP1_CI_AS
474 SQLCHAR 2 1 "" 474 Borr1PrevAddr2RentOwnCode SQL_Latin1_General_CP1_CI_AS
475 SQLCHAR 2 1 "" 475 Borr2PrevAddr2RentOwnCode SQL_Latin1_General_CP1_CI_AS
476 SQLCHAR 2 1 "" 476 Borr3PrevAddr2RentOwnCode SQL_Latin1_General_CP1_CI_AS
477 SQLCHAR 2 1 "" 477 Borr4PrevAddr2RentOwnCode SQL_Latin1_General_CP1_CI_AS
478 SQLCHAR 2 7 "" 478 CoopProjectID SQL_Latin1_General_CP1_CI_AS
479 SQLCHAR 2 19 "" 479 UWReviewLevelCode SQL_Latin1_General_CP1_CI_AS
480 SQLDATETIME 1 8 "" 480 RMCPkgRequestDate ""
481 SQLDATETIM4 1 4 "" 481 LastRetractedFundingDate ""
482 SQLCHAR 2 14 "" 482 FloodInsCertNbr SQL_Latin1_General_CP1_CI_AS
483 SQLCHAR 2 50 "" 483 ListingAgentCompanyName SQL_Latin1_General_CP1_CI_AS
484 SQLCHAR 2 50 "" 484 SellingAgentCompanyName SQL_Latin1_General_CP1_CI_AS
485 SQLCHAR 2 1 "" 485 ClosingDateGuaranteeInd SQL_Latin1_General_CP1_CI_AS
486 SQLDATETIME 1 8 "" 486 InitialClosingDate ""
487 SQLDECIMAL 1 19 "" 487 OverdisbursedAmt ""
488 SQLDATETIME 1 8 "" 488 ClosingCostsCallRecvDate ""
489 SQLCHAR 2 1 "" 489 DebtConsolidationInd SQL_Latin1_General_CP1_CI_AS
490 SQLSMALLINT 1 2 "" 490 LatePaymentCount ""
491 SQLSMALLINT 1 2 "" 491 LatePaymentDayCount ""
492 SQLINT 1 4 "" 492 LeadRepStaffIndividualID ""
493 SQLINT 1 4 "" 493 ConvRepStaffIndividualID ""
494 SQLDATETIME 1 8 "" 494 CreditExpirationDate ""
495 SQLCHAR 2 30 "" 495 BankRepName SQL_Latin1_General_CP1_CI_AS
496 SQLCHAR 2 1 "" 496 MaritalStatusCode SQL_Latin1_General_CP1_CI_AS
497 SQLDATETIME 1 8 "" 497 POSLetterSentDate ""
498 SQLCHAR 2 60 "" 498 ReferringHMCEmail SQL_Latin1_General_CP1_CI_AS
499 SQLDATETIME 1 8 "" 499 Borr1BirthDate ""
500 SQLDATETIME 1 8 "" 500 Borr2BirthDate ""
501 SQLSMALLINT 1 2 "" 501 PTCOutstandingCondCount ""
502 SQLSMALLINT 1 2 "" 502 ATFOutstandingCondCount ""
503 SQLSMALLINT 1 2 "" 503 ATCOutstandingCondCount ""
504 SQLCHAR 2 60 "" 504 HMCEmailAddress SQL_Latin1_General_CP1_CI_AS

2012年2月18日星期六

BCP

1. When using BCP to copy data into a table, which of the following
statements apply? Choose 2.
A) Database users will not be able to access the table because BCP
will lock it.
B) Database users will see the rows inserted by BCP after each batch
is complete.
C) You must have INSERT permissions on the table.
D) Existing rows are replaced by BCP.> 1. When using BCP to copy data into a table, which of the following
> statements apply? Choose 2.
> A) Database users will not be able to access the table because BCP
> will lock it.
>
The default behavior is row locking so other users can use the table.
However, a TABLOCK hint can also be specified.
> B) Database users will see the rows inserted by BCP after each batch
> is complete.
>
A BCP batch is a transaction so users can see data once committed.
> C) You must have INSERT permissions on the table.
>
Yes.
> D) Existing rows are replaced by BCP.
>
Nope.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"docsql" <docsql@.noemail.nospam> wrote in message
news:eP8VbIl2FHA.3272@.TK2MSFTNGP09.phx.gbl...|||Not sure if this question related to SQL2000 or SQL2005? Some more
information on permissions for BCP in SQL2005. You will note there is now a
requirement to get ALTER table permission if you are doing DDL operations
transparently. This was not the case in SQL2000. However, you will also
require SELECT permission on the traget table both in SQL2000 and SQL2005
A bcp out operation requires SELECT permission on the source table.
A bcp in operation minimally requires SELECT/INSERT permissions on the
target table. In addition, ALTER TABLE permission is required if any of the
following is true:
(1)Constraints are disabled, which is the default behavior. To keep
constraints enabled, use the -h option with the CHECK_CONSTRAINTS hint.
(2) Triggers are disabled, which is the default behavior. To fire triggers,
use the -h option with the FIRE_TRIGGERS hint.
(3) You use the -E option to import identity values from a data file.
Sunil Agarwal (MSFT]
This posting is provided "AS IS" with no warranties, and confers no rights.
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:elgg6Cp2FHA.3592@.TK2MSFTNGP12.phx.gbl...
>> 1. When using BCP to copy data into a table, which of the following
>> statements apply? Choose 2.
>> A) Database users will not be able to access the table because BCP
>> will lock it.
> The default behavior is row locking so other users can use the table.
> However, a TABLOCK hint can also be specified.
>> B) Database users will see the rows inserted by BCP after each
>> batch is complete.
> A BCP batch is a transaction so users can see data once committed.
>
>> C) You must have INSERT permissions on the table.
> Yes.
>> D) Existing rows are replaced by BCP.
>>
> Nope.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "docsql" <docsql@.noemail.nospam> wrote in message
> news:eP8VbIl2FHA.3272@.TK2MSFTNGP09.phx.gbl...
>

BCP

1. When using BCP to copy data into a table, which of the following
statements apply? Choose 2.
A) Database users will not be able to access the table because BCP
will lock it.
B) Database users will see the rows inserted by BCP after each batch
is complete.
C) You must have INSERT permissions on the table.
D) Existing rows are replaced by BCP.
> 1. When using BCP to copy data into a table, which of the following
> statements apply? Choose 2.
> A) Database users will not be able to access the table because BCP
> will lock it.
>
The default behavior is row locking so other users can use the table.
However, a TABLOCK hint can also be specified.

> B) Database users will see the rows inserted by BCP after each batch
> is complete.
>
A BCP batch is a transaction so users can see data once committed.

> C) You must have INSERT permissions on the table.
>
Yes.

> D) Existing rows are replaced by BCP.
>
Nope.
Hope this helps.
Dan Guzman
SQL Server MVP
"docsql" <docsql@.noemail.nospam> wrote in message
news:eP8VbIl2FHA.3272@.TK2MSFTNGP09.phx.gbl...
|||Not sure if this question related to SQL2000 or SQL2005? Some more
information on permissions for BCP in SQL2005. You will note there is now a
requirement to get ALTER table permission if you are doing DDL operations
transparently. This was not the case in SQL2000. However, you will also
require SELECT permission on the traget table both in SQL2000 and SQL2005
A bcp out operation requires SELECT permission on the source table.
A bcp in operation minimally requires SELECT/INSERT permissions on the
target table. In addition, ALTER TABLE permission is required if any of the
following is true:
(1)Constraints are disabled, which is the default behavior. To keep
constraints enabled, use the -h option with the CHECK_CONSTRAINTS hint.
(2) Triggers are disabled, which is the default behavior. To fire triggers,
use the -h option with the FIRE_TRIGGERS hint.
(3) You use the -E option to import identity values from a data file.
Sunil Agarwal (MSFT]
This posting is provided "AS IS" with no warranties, and confers no rights.
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:elgg6Cp2FHA.3592@.TK2MSFTNGP12.phx.gbl...
> The default behavior is row locking so other users can use the table.
> However, a TABLOCK hint can also be specified.
>
> A BCP batch is a transaction so users can see data once committed.
>
> Yes.
>
> Nope.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "docsql" <docsql@.noemail.nospam> wrote in message
> news:eP8VbIl2FHA.3272@.TK2MSFTNGP09.phx.gbl...
>

BCP

1. When using BCP to copy data into a table, which of the following
statements apply? Choose 2.
A) Database users will not be able to access the table because BCP
will lock it.
B) Database users will see the rows inserted by BCP after each batch
is complete.
C) You must have INSERT permissions on the table.
D) Existing rows are replaced by BCP.> 1. When using BCP to copy data into a table, which of the following
> statements apply? Choose 2.
> A) Database users will not be able to access the table because BCP
> will lock it.
>
The default behavior is row locking so other users can use the table.
However, a TABLOCK hint can also be specified.

> B) Database users will see the rows inserted by BCP after each batch
> is complete.
>
A BCP batch is a transaction so users can see data once committed.

> C) You must have INSERT permissions on the table.
>
Yes.

> D) Existing rows are replaced by BCP.
>
Nope.
Hope this helps.
Dan Guzman
SQL Server MVP
"docsql" <docsql@.noemail.nospam> wrote in message
news:eP8VbIl2FHA.3272@.TK2MSFTNGP09.phx.gbl...|||Not sure if this question related to SQL2000 or SQL2005? Some more
information on permissions for BCP in SQL2005. You will note there is now a
requirement to get ALTER table permission if you are doing DDL operations
transparently. This was not the case in SQL2000. However, you will also
require SELECT permission on the traget table both in SQL2000 and SQL2005
A bcp out operation requires SELECT permission on the source table.
A bcp in operation minimally requires SELECT/INSERT permissions on the
target table. In addition, ALTER TABLE permission is required if any of the
following is true:
(1)Constraints are disabled, which is the default behavior. To keep
constraints enabled, use the -h option with the CHECK_CONSTRAINTS hint.
(2) Triggers are disabled, which is the default behavior. To fire triggers,
use the -h option with the FIRE_TRIGGERS hint.
(3) You use the -E option to import identity values from a data file.
Sunil Agarwal (MSFT]
This posting is provided "AS IS" with no warranties, and confers no rights.
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:elgg6Cp2FHA.3592@.TK2MSFTNGP12.phx.gbl...
> The default behavior is row locking so other users can use the table.
> However, a TABLOCK hint can also be specified.
>
> A BCP batch is a transaction so users can see data once committed.
>
> Yes.
>
> Nope.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "docsql" <docsql@.noemail.nospam> wrote in message
> news:eP8VbIl2FHA.3272@.TK2MSFTNGP09.phx.gbl...
>

2012年2月16日星期四

BC30451 Name 'whatever' is not declared

I'm migrating a report from access to RS. What I want to do is for each
group header, have a formula that shows that group's total as a % of
the grand total. Example:
Name Sales % of total
Tom 5 25%
Joe 15 75%
so, in my table, I have a table footer with a textbox "textbox1" with
the formula
=SUM(Fields!SALES.Value )
and in the group1 header, i have a textbox "textbox2". For the formula,
i put:
=Fields!SALES.Value / textbox1.value
This works in access, but apparently not in RS (?). I get an error
message that textbox1 is not declared. It seems like I must be missing
something simple here. Any Ideas? I could put subqueries in my dataset
I suppose, but that seems like an awfully long way around to do what I
need. Thanks in advance...
EricWill ReportItems!Textbox1.Value work?
Steve MunLeeuw
<c-eric.geil@.mci.com> wrote in message
news:1161292630.251749.186250@.k70g2000cwa.googlegroups.com...
> I'm migrating a report from access to RS. What I want to do is for each
> group header, have a formula that shows that group's total as a % of
> the grand total. Example:
> Name Sales % of total
> Tom 5 25%
> Joe 15 75%
> so, in my table, I have a table footer with a textbox "textbox1" with
> the formula
> =SUM(Fields!SALES.Value )
> and in the group1 header, i have a textbox "textbox2". For the formula,
> i put:
> =Fields!SALES.Value / textbox1.value
> This works in access, but apparently not in RS (?). I get an error
> message that textbox1 is not declared. It seems like I must be missing
> something simple here. Any Ideas? I could put subqueries in my dataset
> I suppose, but that seems like an awfully long way around to do what I
> need. Thanks in advance...
>
> Eric
>|||that worked...thanks!
What's the deal with the expression builder? It seems like it would
have some functions and/or controls listed in there to give the user
some clue as to their verbiage...
thanks again..
eric

2012年2月11日星期六

Basic Windows Authentication Question

Hi there,
I want to give access to a database to all users in a domain
using Windows Authentication. I thought that this would be as simple as
adding a login which specifies the domain only, but this does not seem to be
possible. I can't believe that you have to enter every single domain user
as a login in SQL Server. Someone please tell me this is not the case!Hi,
Not required, Create OS Group and all the domain users to that group. After
that give the previlages to
that domain group to SQL Server.
Thanks
Hari
MCDBA
"Gorge Bush" <bill.gates@.microcock.cum> wrote in message
news:#FwxRFFVEHA.2320@.TK2MSFTNGP10.phx.gbl...
> Hi there,
> I want to give access to a database to all users in a
domain
> using Windows Authentication. I thought that this would be as simple as
> adding a login which specifies the domain only, but this does not seem to
be
> possible. I can't believe that you have to enter every single domain user
> as a login in SQL Server. Someone please tell me this is not the case!
>|||"Hari" <hari_prasad_k@.hotmail.com> wrote in message
news:e0rMaRFVEHA.2484@.TK2MSFTNGP11.phx.gbl...

> Not required, Create OS Group and all the domain users to that group.
After
> that give the previlages to
> that domain group to SQL Server.
O.K. Thanks, but the whole point of this exercise is to be able to identify
the user at the database level. Will the system_user or current_user
variables be set to the individual or the group?|||> O.K. Thanks, but the whole point of this exercise is to be able to
identify
> the user at the database level. Will the system_user or current_user
> variables be set to the individual or the group?
I answered that myself. It works!|||Hi,
Yes, you are correct.

Thanks
Hari
MCDBA
"Gorge Bush" <bill.gates@.microcock.cum> wrote in message
news:OpwBIeFVEHA.3788@.TK2MSFTNGP12.phx.gbl...
> identify
> I answered that myself. It works!
>|||Refer to information about the predefined Domain Users group at
http://www.microsoft.com/windows200...sp?url=/windows
2000/en/server/help/sag_SEconceptsImpGroups.htm
Then, just grant access to this group.
-Mark Shlimovich

2012年2月9日星期四

Basic Server Roles (security) question

I want to add a consulting firm of ours to have full access to a
database on my SQL 2000 SP3 server (so DBOWNER is ok with me).
But I also need them to be able to schedule a job against that database
AND create various DB maintenance plans. I've scoured the BOL but
nothing I can find talks about this kind of granularity in security.
Is there a role that will allow this?
Many thanks.cy
Are you member of sysadmin server role as well?
"cy" <cyrus.kapadia@.us.pm.com> wrote in message
news:1105036907.387257.286720@.f14g2000cwb.googlegroups.com...
> I want to add a consulting firm of ours to have full access to a
> database on my SQL 2000 SP3 server (so DBOWNER is ok with me).
>
> But I also need them to be able to schedule a job against that database
> AND create various DB maintenance plans. I've scoured the BOL but
> nothing I can find talks about this kind of granularity in security.
> Is there a role that will allow this?
>
> Many thanks.
>|||Yes, I am top dog on the server - I have all keys to all kingdoms. But
they aren't, of course.
Cy.
Uri Dimant wrote:[vbcol=seagreen]
> cy
> Are you member of sysadmin server role as well?
>
> "cy" <cyrus.kapadia@.us.pm.com> wrote in message
> news:1105036907.387257.286720@.f14g2000cwb.googlegroups.com...
database[vbcol=seagreen]
security.[vbcol=seagreen]

订阅：博文 (Atom)

2012年3月29日星期四

bcp_init and SQL Native Client

bcp_init and SQL Native Client

bcp_init and SQL Native Client

2012年3月22日星期四

BCP server not found failure

BCP server not found failure

2012年3月20日星期二

bcp out text

2012年3月11日星期日

bcp import help

2012年3月6日星期二

bcp error server not found

bcp error server not found

bcp error server not found

bcp error - restricted access datatype violation

2012年2月18日星期六

BCP

BCP

BCP

2012年2月16日星期四

BC30451 Name 'whatever' is not declared

2012年2月11日星期六

Basic Windows Authentication Question

2012年2月9日星期四

Basic Server Roles (security) question

Sql Basic Security

Blog Archive

About Me