Hello all,
I'm having difficulties understanding why something is not going the way I
want it (sounds familiar?). I'm testing SQL injection on my own PC, based on
the article at http://aspalliance.com/articleViewer...Id=385&pId=-1.
when I enter only my credentials in the user field, like
administrator';use master exec xp_cmdshell 'dir c:\*.*'--
I get the resultant string
SELECT strusername, strpassword FROM tUser WHERE strusername = 'beheerder';
use master exec xp_cmdshell 'dir c:\*.*' --' AND strpassword = ''
Now the output of "Response.write objrso.Fields.count" is 2. A closer look
gives me 'administrator' and 'password'. Not the C:\ drive listing, which
does show up in SQL Query Analyzer! Is this by any means possible with the
code
Set objConn = Server.CreateObject("ADODB.Connection")
Set objrso = Server.CreateObject("ADODB.Recordset")
sql = "SELECT strusername, strpassword FROM tUser WHERE strusername = '" +
username & _
"' AND strpassword = '" + password & _
"'"
objConn.Open cn
objrso.open sql, cn
If not, how should I change this code? Any hints would be highly welcome.
Best regards,
Carl.
Hi Carl,
Since you have two different SQL statements, separated by semicolon, then
provider executes them separately and returns two resultsets (recordsets).
When you open objrso recordset, then it points to the first one. To be able
to get information from the subsequent recordsets, you need to call
NextRecordset method of the opened recordset
Set objrso=objrso.NextRecordset
If provider returns another resultset, then you will see it after this call
Val Mazur
Microsoft MVP
"Carl Matthews" <ecvaneersel@.nospam.hotmail.com> wrote in message
news:ecJmrkjIEHA.1140@.tk2msftngp13.phx.gbl...
> Hello all,
> I'm having difficulties understanding why something is not going the way I
> want it (sounds familiar?). I'm testing SQL injection on my own PC, based
> on
> the article at http://aspalliance.com/articleViewer...Id=385&pId=-1.
> when I enter only my credentials in the user field, like
> administrator';use master exec xp_cmdshell 'dir c:\*.*'--
> I get the resultant string
> SELECT strusername, strpassword FROM tUser WHERE strusername =
> 'beheerder';
> use master exec xp_cmdshell 'dir c:\*.*' --' AND strpassword = ''
>
> Now the output of "Response.write objrso.Fields.count" is 2. A closer look
> gives me 'administrator' and 'password'. Not the C:\ drive listing, which
> does show up in SQL Query Analyzer! Is this by any means possible with the
> code
> Set objConn = Server.CreateObject("ADODB.Connection")
> Set objrso = Server.CreateObject("ADODB.Recordset")
> sql = "SELECT strusername, strpassword FROM tUser WHERE strusername = '" +
> username & _
> "' AND strpassword = '" + password & _
> "'"
> objConn.Open cn
> objrso.open sql, cn
> If not, how should I change this code? Any hints would be highly welcome.
> Best regards,
> Carl.
>
Showing posts with label familiar. Show all posts
Showing posts with label familiar. Show all posts
Wednesday, March 21, 2012
Is this default behavior?
Hello all,
I'm having difficulties understanding why something is not going the way I
want it (sounds familiar?). I'm testing SQL injection on my own PC, based on
the article at http://aspalliance.com/articleViewe...aId=385&pId=-1.
when I enter only my credentials in the user field, like
administrator';use master exec xp_cmdshell 'dir c:\*.*'--
I get the resultant string
SELECT strusername, strpassword FROM tUser WHERE strusername = 'beheerder';
use master exec xp_cmdshell 'dir c:\*.*' --' AND strpassword = ''
Now the output of "Response.write objrso.Fields.count" is 2. A closer look
gives me 'administrator' and 'password'. Not the C:\ drive listing, which
does show up in SQL Query Analyzer! Is this by any means possible with the
code
Set objConn = Server.CreateObject("ADODB.Connection")
Set objrso = Server.CreateObject("ADODB.Recordset")
sql = "SELECT strusername, strpassword FROM tUser WHERE strusername = '" +
username & _
"' AND strpassword = '" + password & _
"'"
objConn.Open cn
objrso.open sql, cn
If not, how should I change this code? Any hints would be highly welcome.
Best regards,
Carl.Hi Carl,
Since you have two different SQL statements, separated by semicolon, then
provider executes them separately and returns two resultsets (recordsets).
When you open objrso recordset, then it points to the first one. To be able
to get information from the subsequent recordsets, you need to call
NextRecordset method of the opened recordset
Set objrso=objrso.NextRecordset
If provider returns another resultset, then you will see it after this call
Val Mazur
Microsoft MVP
"Carl Matthews" <ecvaneersel@.nospam.hotmail.com> wrote in message
news:ecJmrkjIEHA.1140@.tk2msftngp13.phx.gbl...
> Hello all,
> I'm having difficulties understanding why something is not going the way I
> want it (sounds familiar?). I'm testing SQL injection on my own PC, based
> on
> the article at http://aspalliance.com/articleViewe...aId=385&pId=-1.
> when I enter only my credentials in the user field, like
> administrator';use master exec xp_cmdshell 'dir c:\*.*'--
> I get the resultant string
> SELECT strusername, strpassword FROM tUser WHERE strusername =
> 'beheerder';
> use master exec xp_cmdshell 'dir c:\*.*' --' AND strpassword = ''
>
> Now the output of "Response.write objrso.Fields.count" is 2. A closer look
> gives me 'administrator' and 'password'. Not the C:\ drive listing, which
> does show up in SQL Query Analyzer! Is this by any means possible with the
> code
> Set objConn = Server.CreateObject("ADODB.Connection")
> Set objrso = Server.CreateObject("ADODB.Recordset")
> sql = "SELECT strusername, strpassword FROM tUser WHERE strusername = '" +
> username & _
> "' AND strpassword = '" + password & _
> "'"
> objConn.Open cn
> objrso.open sql, cn
> If not, how should I change this code? Any hints would be highly welcome.
> Best regards,
> Carl.
>sql
I'm having difficulties understanding why something is not going the way I
want it (sounds familiar?). I'm testing SQL injection on my own PC, based on
the article at http://aspalliance.com/articleViewe...aId=385&pId=-1.
when I enter only my credentials in the user field, like
administrator';use master exec xp_cmdshell 'dir c:\*.*'--
I get the resultant string
SELECT strusername, strpassword FROM tUser WHERE strusername = 'beheerder';
use master exec xp_cmdshell 'dir c:\*.*' --' AND strpassword = ''
Now the output of "Response.write objrso.Fields.count" is 2. A closer look
gives me 'administrator' and 'password'. Not the C:\ drive listing, which
does show up in SQL Query Analyzer! Is this by any means possible with the
code
Set objConn = Server.CreateObject("ADODB.Connection")
Set objrso = Server.CreateObject("ADODB.Recordset")
sql = "SELECT strusername, strpassword FROM tUser WHERE strusername = '" +
username & _
"' AND strpassword = '" + password & _
"'"
objConn.Open cn
objrso.open sql, cn
If not, how should I change this code? Any hints would be highly welcome.
Best regards,
Carl.Hi Carl,
Since you have two different SQL statements, separated by semicolon, then
provider executes them separately and returns two resultsets (recordsets).
When you open objrso recordset, then it points to the first one. To be able
to get information from the subsequent recordsets, you need to call
NextRecordset method of the opened recordset
Set objrso=objrso.NextRecordset
If provider returns another resultset, then you will see it after this call
Val Mazur
Microsoft MVP
"Carl Matthews" <ecvaneersel@.nospam.hotmail.com> wrote in message
news:ecJmrkjIEHA.1140@.tk2msftngp13.phx.gbl...
> Hello all,
> I'm having difficulties understanding why something is not going the way I
> want it (sounds familiar?). I'm testing SQL injection on my own PC, based
> on
> the article at http://aspalliance.com/articleViewe...aId=385&pId=-1.
> when I enter only my credentials in the user field, like
> administrator';use master exec xp_cmdshell 'dir c:\*.*'--
> I get the resultant string
> SELECT strusername, strpassword FROM tUser WHERE strusername =
> 'beheerder';
> use master exec xp_cmdshell 'dir c:\*.*' --' AND strpassword = ''
>
> Now the output of "Response.write objrso.Fields.count" is 2. A closer look
> gives me 'administrator' and 'password'. Not the C:\ drive listing, which
> does show up in SQL Query Analyzer! Is this by any means possible with the
> code
> Set objConn = Server.CreateObject("ADODB.Connection")
> Set objrso = Server.CreateObject("ADODB.Recordset")
> sql = "SELECT strusername, strpassword FROM tUser WHERE strusername = '" +
> username & _
> "' AND strpassword = '" + password & _
> "'"
> objConn.Open cn
> objrso.open sql, cn
> If not, how should I change this code? Any hints would be highly welcome.
> Best regards,
> Carl.
>sql
Monday, March 12, 2012
Is there sth like Direct-Path-Loads in SQL-Server
I'm familiar with direct-path-loads and SQL*Loader on Oracle.
Does anyone know if sth like this is available on SQL-Server?
Hi Franz
"Franz Gross" wrote:
> I'm familiar with direct-path-loads and SQL*Loader on Oracle.
> Does anyone know if sth like this is available on SQL-Server?
>
Tibor replied to this in microsoft.public.sqlserver.datawarehouse please do
not multipost.
John
|||John Bell (jbellnewsposts@.hotmail.com) writes:
> "Franz Gross" wrote:
>
> Tibor replied to this in microsoft.public.sqlserver.datawarehouse please
> do not multipost.
Actually, Franz did have the good taste to cross-post. And set followup
to the group that possibly was the most relevant. (Pity that Tibor
respected that. Now I still don't know what a direct-load-path might be.)
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
|||My bad, I should have read the header closer and not assumed that Tibor's
reply
not being in .server was the OP's error!
AFAIK direct path load is a method of loading data with minimal
checking/processing and therefore faster.
John
"Erland Sommarskog" wrote:
> John Bell (jbellnewsposts@.hotmail.com) writes:
> Actually, Franz did have the good taste to cross-post. And set followup
> to the group that possibly was the most relevant. (Pity that Tibor
> respected that. Now I still don't know what a direct-load-path might be.)
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
>
|||On 14.05.2007 10:12, John Bell wrote:
> My bad, I should have read the header closer and not assumed that Tibor's
> reply
> not being in .server was the OP's error!
> AFAIK direct path load is a method of loading data with minimal
> checking/processing and therefore faster.
Correct. You may even end up with defunct unique indexes if the data is
not unique. AFAIK there is no such thing in SQL Server.
Kind regards
robert
Does anyone know if sth like this is available on SQL-Server?
Hi Franz
"Franz Gross" wrote:
> I'm familiar with direct-path-loads and SQL*Loader on Oracle.
> Does anyone know if sth like this is available on SQL-Server?
>
Tibor replied to this in microsoft.public.sqlserver.datawarehouse please do
not multipost.
John
|||John Bell (jbellnewsposts@.hotmail.com) writes:
> "Franz Gross" wrote:
>
> Tibor replied to this in microsoft.public.sqlserver.datawarehouse please
> do not multipost.
Actually, Franz did have the good taste to cross-post. And set followup
to the group that possibly was the most relevant. (Pity that Tibor
respected that. Now I still don't know what a direct-load-path might be.)
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
|||My bad, I should have read the header closer and not assumed that Tibor's
reply
not being in .server was the OP's error!
AFAIK direct path load is a method of loading data with minimal
checking/processing and therefore faster.
John
"Erland Sommarskog" wrote:
> John Bell (jbellnewsposts@.hotmail.com) writes:
> Actually, Franz did have the good taste to cross-post. And set followup
> to the group that possibly was the most relevant. (Pity that Tibor
> respected that. Now I still don't know what a direct-load-path might be.)
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
>
|||On 14.05.2007 10:12, John Bell wrote:
> My bad, I should have read the header closer and not assumed that Tibor's
> reply
> not being in .server was the OP's error!
> AFAIK direct path load is a method of loading data with minimal
> checking/processing and therefore faster.
Correct. You may even end up with defunct unique indexes if the data is
not unique. AFAIK there is no such thing in SQL Server.
Kind regards
robert
Is there sth like Direct-Path-Loads in SQL-Server
I'm familiar with direct-path-loads and SQL*Loader on Oracle.
Does anyone know if sth like this is available on SQL-Server?
Sounds like you are looking for tools that support bulk loading (a more direct way to import data
than INSERT statements). Such tools include BULK INSERT, BCP.EXE. Also DTS (2000) or SSIS (2005) if
you select the option to do "fast load".
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Franz Gross" <Franz.Gross@.gmx.li> wrote in message
news:46467d32$0$23139$9b4e6d93@.newsspool1.arcor-online.net...
> I'm familiar with direct-path-loads and SQL*Loader on Oracle.
> Does anyone know if sth like this is available on SQL-Server?
|||Hi Franz
"Franz Gross" wrote:
> I'm familiar with direct-path-loads and SQL*Loader on Oracle.
> Does anyone know if sth like this is available on SQL-Server?
>
Tibor replied to this in microsoft.public.sqlserver.datawarehouse please do
not multipost.
John
|||John Bell (jbellnewsposts@.hotmail.com) writes:
> "Franz Gross" wrote:
>
> Tibor replied to this in microsoft.public.sqlserver.datawarehouse please
> do not multipost.
Actually, Franz did have the good taste to cross-post. And set followup
to the group that possibly was the most relevant. (Pity that Tibor
respected that. Now I still don't know what a direct-load-path might be.)
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
|||My bad, I should have read the header closer and not assumed that Tibor's
reply
not being in .server was the OP's error!
AFAIK direct path load is a method of loading data with minimal
checking/processing and therefore faster.
John
"Erland Sommarskog" wrote:
> John Bell (jbellnewsposts@.hotmail.com) writes:
> Actually, Franz did have the good taste to cross-post. And set followup
> to the group that possibly was the most relevant. (Pity that Tibor
> respected that. Now I still don't know what a direct-load-path might be.)
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
>
|||On 14.05.2007 10:12, John Bell wrote:
> My bad, I should have read the header closer and not assumed that Tibor's
> reply
> not being in .server was the OP's error!
> AFAIK direct path load is a method of loading data with minimal
> checking/processing and therefore faster.
Correct. You may even end up with defunct unique indexes if the data is
not unique. AFAIK there is no such thing in SQL Server.
Kind regards
robert
Does anyone know if sth like this is available on SQL-Server?
Sounds like you are looking for tools that support bulk loading (a more direct way to import data
than INSERT statements). Such tools include BULK INSERT, BCP.EXE. Also DTS (2000) or SSIS (2005) if
you select the option to do "fast load".
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Franz Gross" <Franz.Gross@.gmx.li> wrote in message
news:46467d32$0$23139$9b4e6d93@.newsspool1.arcor-online.net...
> I'm familiar with direct-path-loads and SQL*Loader on Oracle.
> Does anyone know if sth like this is available on SQL-Server?
|||Hi Franz
"Franz Gross" wrote:
> I'm familiar with direct-path-loads and SQL*Loader on Oracle.
> Does anyone know if sth like this is available on SQL-Server?
>
Tibor replied to this in microsoft.public.sqlserver.datawarehouse please do
not multipost.
John
|||John Bell (jbellnewsposts@.hotmail.com) writes:
> "Franz Gross" wrote:
>
> Tibor replied to this in microsoft.public.sqlserver.datawarehouse please
> do not multipost.
Actually, Franz did have the good taste to cross-post. And set followup
to the group that possibly was the most relevant. (Pity that Tibor
respected that. Now I still don't know what a direct-load-path might be.)
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
|||My bad, I should have read the header closer and not assumed that Tibor's
reply
not being in .server was the OP's error!
AFAIK direct path load is a method of loading data with minimal
checking/processing and therefore faster.
John
"Erland Sommarskog" wrote:
> John Bell (jbellnewsposts@.hotmail.com) writes:
> Actually, Franz did have the good taste to cross-post. And set followup
> to the group that possibly was the most relevant. (Pity that Tibor
> respected that. Now I still don't know what a direct-load-path might be.)
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
>
|||On 14.05.2007 10:12, John Bell wrote:
> My bad, I should have read the header closer and not assumed that Tibor's
> reply
> not being in .server was the OP's error!
> AFAIK direct path load is a method of loading data with minimal
> checking/processing and therefore faster.
Correct. You may even end up with defunct unique indexes if the data is
not unique. AFAIK there is no such thing in SQL Server.
Kind regards
robert
Is there sth like Direct-Path-Loads in SQL-Server
I'm familiar with direct-path-loads and SQL*Loader on Oracle.
Does anyone know if sth like this is available on SQL-Server?
Hi Franz
"Franz Gross" wrote:
> I'm familiar with direct-path-loads and SQL*Loader on Oracle.
> Does anyone know if sth like this is available on SQL-Server?
>
Tibor replied to this in microsoft.public.sqlserver.datawarehouse please do
not multipost.
John
|||John Bell (jbellnewsposts@.hotmail.com) writes:
> "Franz Gross" wrote:
>
> Tibor replied to this in microsoft.public.sqlserver.datawarehouse please
> do not multipost.
Actually, Franz did have the good taste to cross-post. And set followup
to the group that possibly was the most relevant. (Pity that Tibor
respected that. Now I still don't know what a direct-load-path might be.)
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
|||My bad, I should have read the header closer and not assumed that Tibor's
reply
not being in .server was the OP's error!
AFAIK direct path load is a method of loading data with minimal
checking/processing and therefore faster.
John
"Erland Sommarskog" wrote:
> John Bell (jbellnewsposts@.hotmail.com) writes:
> Actually, Franz did have the good taste to cross-post. And set followup
> to the group that possibly was the most relevant. (Pity that Tibor
> respected that. Now I still don't know what a direct-load-path might be.)
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
>
|||On 14.05.2007 10:12, John Bell wrote:
> My bad, I should have read the header closer and not assumed that Tibor's
> reply
> not being in .server was the OP's error!
> AFAIK direct path load is a method of loading data with minimal
> checking/processing and therefore faster.
Correct. You may even end up with defunct unique indexes if the data is
not unique. AFAIK there is no such thing in SQL Server.
Kind regards
robert
Does anyone know if sth like this is available on SQL-Server?
Hi Franz
"Franz Gross" wrote:
> I'm familiar with direct-path-loads and SQL*Loader on Oracle.
> Does anyone know if sth like this is available on SQL-Server?
>
Tibor replied to this in microsoft.public.sqlserver.datawarehouse please do
not multipost.
John
|||John Bell (jbellnewsposts@.hotmail.com) writes:
> "Franz Gross" wrote:
>
> Tibor replied to this in microsoft.public.sqlserver.datawarehouse please
> do not multipost.
Actually, Franz did have the good taste to cross-post. And set followup
to the group that possibly was the most relevant. (Pity that Tibor
respected that. Now I still don't know what a direct-load-path might be.)
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
|||My bad, I should have read the header closer and not assumed that Tibor's
reply
not being in .server was the OP's error!
AFAIK direct path load is a method of loading data with minimal
checking/processing and therefore faster.
John
"Erland Sommarskog" wrote:
> John Bell (jbellnewsposts@.hotmail.com) writes:
> Actually, Franz did have the good taste to cross-post. And set followup
> to the group that possibly was the most relevant. (Pity that Tibor
> respected that. Now I still don't know what a direct-load-path might be.)
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
>
|||On 14.05.2007 10:12, John Bell wrote:
> My bad, I should have read the header closer and not assumed that Tibor's
> reply
> not being in .server was the OP's error!
> AFAIK direct path load is a method of loading data with minimal
> checking/processing and therefore faster.
Correct. You may even end up with defunct unique indexes if the data is
not unique. AFAIK there is no such thing in SQL Server.
Kind regards
robert
Is there sth like Direct-Path-Loads in SQL-Server
I'm familiar with direct-path-loads and SQL*Loader on Oracle.
Does anyone know if sth like this is available on SQL-Server?Sounds like you are looking for tools that support bulk loading (a more dire
ct way to import data
than INSERT statements). Such tools include BULK INSERT, BCP.EXE. Also DTS (
2000) or SSIS (2005) if
you select the option to do "fast load".
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Franz Gross" <Franz.Gross@.gmx.li> wrote in message
news:46467d32$0$23139$9b4e6d93@.newsspool
1.arcor-online.net...
> I'm familiar with direct-path-loads and SQL*Loader on Oracle.
> Does anyone know if sth like this is available on SQL-Server?|||Hi Franz
"Franz Gross" wrote:
> I'm familiar with direct-path-loads and SQL*Loader on Oracle.
> Does anyone know if sth like this is available on SQL-Server?
>
Tibor replied to this in microsoft.public.sqlserver.datawarehouse please do
not multipost.
John|||John Bell (jbellnewsposts@.hotmail.com) writes:
> "Franz Gross" wrote:
>
> Tibor replied to this in microsoft.public.sqlserver.datawarehouse please
> do not multipost.
Actually, Franz did have the good taste to cross-post. And set followup
to the group that possibly was the most relevant. (Pity that Tibor
respected that. Now I still don't know what a direct-load-path might be.)
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||My bad, I should have read the header closer and not assumed that Tibor's
reply
not being in .server was the OP's error!
AFAIK direct path load is a method of loading data with minimal
checking/processing and therefore faster.
John
"Erland Sommarskog" wrote:
> John Bell (jbellnewsposts@.hotmail.com) writes:
> Actually, Franz did have the good taste to cross-post. And set followup
> to the group that possibly was the most relevant. (Pity that Tibor
> respected that. Now I still don't know what a direct-load-path might be.)
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/pr...oads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodin...ions/books.mspx
>|||On 14.05.2007 10:12, John Bell wrote:
> My bad, I should have read the header closer and not assumed that Tibor's
> reply
> not being in .server was the OP's error!
> AFAIK direct path load is a method of loading data with minimal
> checking/processing and therefore faster.
Correct. You may even end up with defunct unique indexes if the data is
not unique. AFAIK there is no such thing in SQL Server.
Kind regards
robert
Does anyone know if sth like this is available on SQL-Server?Sounds like you are looking for tools that support bulk loading (a more dire
ct way to import data
than INSERT statements). Such tools include BULK INSERT, BCP.EXE. Also DTS (
2000) or SSIS (2005) if
you select the option to do "fast load".
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Franz Gross" <Franz.Gross@.gmx.li> wrote in message
news:46467d32$0$23139$9b4e6d93@.newsspool
1.arcor-online.net...
> I'm familiar with direct-path-loads and SQL*Loader on Oracle.
> Does anyone know if sth like this is available on SQL-Server?|||Hi Franz
"Franz Gross" wrote:
> I'm familiar with direct-path-loads and SQL*Loader on Oracle.
> Does anyone know if sth like this is available on SQL-Server?
>
Tibor replied to this in microsoft.public.sqlserver.datawarehouse please do
not multipost.
John|||John Bell (jbellnewsposts@.hotmail.com) writes:
> "Franz Gross" wrote:
>
> Tibor replied to this in microsoft.public.sqlserver.datawarehouse please
> do not multipost.
Actually, Franz did have the good taste to cross-post. And set followup
to the group that possibly was the most relevant. (Pity that Tibor
respected that. Now I still don't know what a direct-load-path might be.)
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||My bad, I should have read the header closer and not assumed that Tibor's
reply
not being in .server was the OP's error!
AFAIK direct path load is a method of loading data with minimal
checking/processing and therefore faster.
John
"Erland Sommarskog" wrote:
> John Bell (jbellnewsposts@.hotmail.com) writes:
> Actually, Franz did have the good taste to cross-post. And set followup
> to the group that possibly was the most relevant. (Pity that Tibor
> respected that. Now I still don't know what a direct-load-path might be.)
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/pr...oads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodin...ions/books.mspx
>|||On 14.05.2007 10:12, John Bell wrote:
> My bad, I should have read the header closer and not assumed that Tibor's
> reply
> not being in .server was the OP's error!
> AFAIK direct path load is a method of loading data with minimal
> checking/processing and therefore faster.
Correct. You may even end up with defunct unique indexes if the data is
not unique. AFAIK there is no such thing in SQL Server.
Kind regards
robert
Is there sth like Direct-Path-Loads in SQL-Server
I'm familiar with direct-path-loads and SQL*Loader on Oracle.
Does anyone know if sth like this is available on SQL-Server?Hi Franz
"Franz Gross" wrote:
> I'm familiar with direct-path-loads and SQL*Loader on Oracle.
> Does anyone know if sth like this is available on SQL-Server?
>
Tibor replied to this in microsoft.public.sqlserver.datawarehouse please do
not multipost.
John|||John Bell (jbellnewsposts@.hotmail.com) writes:
> "Franz Gross" wrote:
>
> Tibor replied to this in microsoft.public.sqlserver.datawarehouse please
> do not multipost.
Actually, Franz did have the good taste to cross-post. And set followup
to the group that possibly was the most relevant. (Pity that Tibor
respected that. Now I still don't know what a direct-load-path might be.)
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||My bad, I should have read the header closer and not assumed that Tibor's
reply
not being in .server was the OP's error!
AFAIK direct path load is a method of loading data with minimal
checking/processing and therefore faster.
John
"Erland Sommarskog" wrote:
> John Bell (jbellnewsposts@.hotmail.com) writes:
> Actually, Franz did have the good taste to cross-post. And set followup
> to the group that possibly was the most relevant. (Pity that Tibor
> respected that. Now I still don't know what a direct-load-path might be.)
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/pr...oads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodin...ions/books.mspx
>|||On 14.05.2007 10:12, John Bell wrote:
> My bad, I should have read the header closer and not assumed that Tibor's
> reply
> not being in .server was the OP's error!
> AFAIK direct path load is a method of loading data with minimal
> checking/processing and therefore faster.
Correct. You may even end up with defunct unique indexes if the data is
not unique. AFAIK there is no such thing in SQL Server.
Kind regards
robert
Does anyone know if sth like this is available on SQL-Server?Hi Franz
"Franz Gross" wrote:
> I'm familiar with direct-path-loads and SQL*Loader on Oracle.
> Does anyone know if sth like this is available on SQL-Server?
>
Tibor replied to this in microsoft.public.sqlserver.datawarehouse please do
not multipost.
John|||John Bell (jbellnewsposts@.hotmail.com) writes:
> "Franz Gross" wrote:
>
> Tibor replied to this in microsoft.public.sqlserver.datawarehouse please
> do not multipost.
Actually, Franz did have the good taste to cross-post. And set followup
to the group that possibly was the most relevant. (Pity that Tibor
respected that. Now I still don't know what a direct-load-path might be.)
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||My bad, I should have read the header closer and not assumed that Tibor's
reply
not being in .server was the OP's error!
AFAIK direct path load is a method of loading data with minimal
checking/processing and therefore faster.
John
"Erland Sommarskog" wrote:
> John Bell (jbellnewsposts@.hotmail.com) writes:
> Actually, Franz did have the good taste to cross-post. And set followup
> to the group that possibly was the most relevant. (Pity that Tibor
> respected that. Now I still don't know what a direct-load-path might be.)
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/pr...oads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodin...ions/books.mspx
>|||On 14.05.2007 10:12, John Bell wrote:
> My bad, I should have read the header closer and not assumed that Tibor's
> reply
> not being in .server was the OP's error!
> AFAIK direct path load is a method of loading data with minimal
> checking/processing and therefore faster.
Correct. You may even end up with defunct unique indexes if the data is
not unique. AFAIK there is no such thing in SQL Server.
Kind regards
robert
Is there sth like Direct-Path-Loads in SQL-Server
I'm familiar with direct-path-loads and SQL*Loader on Oracle.
Does anyone know if sth like this is available on SQL-Server?Hi Franz
"Franz Gross" wrote:
> I'm familiar with direct-path-loads and SQL*Loader on Oracle.
> Does anyone know if sth like this is available on SQL-Server?
>
Tibor replied to this in microsoft.public.sqlserver.datawarehouse please do
not multipost.
John|||John Bell (jbellnewsposts@.hotmail.com) writes:
> "Franz Gross" wrote:
>> I'm familiar with direct-path-loads and SQL*Loader on Oracle.
>> Does anyone know if sth like this is available on SQL-Server?
> Tibor replied to this in microsoft.public.sqlserver.datawarehouse please
> do not multipost.
Actually, Franz did have the good taste to cross-post. And set followup
to the group that possibly was the most relevant. (Pity that Tibor
respected that. Now I still don't know what a direct-load-path might be.)
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx|||My bad, I should have read the header closer and not assumed that Tibor's
reply
not being in .server was the OP's error!
AFAIK direct path load is a method of loading data with minimal
checking/processing and therefore faster.
John
"Erland Sommarskog" wrote:
> John Bell (jbellnewsposts@.hotmail.com) writes:
> > "Franz Gross" wrote:
> >
> >> I'm familiar with direct-path-loads and SQL*Loader on Oracle.
> >> Does anyone know if sth like this is available on SQL-Server?
> >>
> >
> > Tibor replied to this in microsoft.public.sqlserver.datawarehouse please
> > do not multipost.
> Actually, Franz did have the good taste to cross-post. And set followup
> to the group that possibly was the most relevant. (Pity that Tibor
> respected that. Now I still don't know what a direct-load-path might be.)
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
>|||On 14.05.2007 10:12, John Bell wrote:
> My bad, I should have read the header closer and not assumed that Tibor's
> reply
> not being in .server was the OP's error!
> AFAIK direct path load is a method of loading data with minimal
> checking/processing and therefore faster.
Correct. You may even end up with defunct unique indexes if the data is
not unique. AFAIK there is no such thing in SQL Server.
Kind regards
robert
Does anyone know if sth like this is available on SQL-Server?Hi Franz
"Franz Gross" wrote:
> I'm familiar with direct-path-loads and SQL*Loader on Oracle.
> Does anyone know if sth like this is available on SQL-Server?
>
Tibor replied to this in microsoft.public.sqlserver.datawarehouse please do
not multipost.
John|||John Bell (jbellnewsposts@.hotmail.com) writes:
> "Franz Gross" wrote:
>> I'm familiar with direct-path-loads and SQL*Loader on Oracle.
>> Does anyone know if sth like this is available on SQL-Server?
> Tibor replied to this in microsoft.public.sqlserver.datawarehouse please
> do not multipost.
Actually, Franz did have the good taste to cross-post. And set followup
to the group that possibly was the most relevant. (Pity that Tibor
respected that. Now I still don't know what a direct-load-path might be.)
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx|||My bad, I should have read the header closer and not assumed that Tibor's
reply
not being in .server was the OP's error!
AFAIK direct path load is a method of loading data with minimal
checking/processing and therefore faster.
John
"Erland Sommarskog" wrote:
> John Bell (jbellnewsposts@.hotmail.com) writes:
> > "Franz Gross" wrote:
> >
> >> I'm familiar with direct-path-loads and SQL*Loader on Oracle.
> >> Does anyone know if sth like this is available on SQL-Server?
> >>
> >
> > Tibor replied to this in microsoft.public.sqlserver.datawarehouse please
> > do not multipost.
> Actually, Franz did have the good taste to cross-post. And set followup
> to the group that possibly was the most relevant. (Pity that Tibor
> respected that. Now I still don't know what a direct-load-path might be.)
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
>|||On 14.05.2007 10:12, John Bell wrote:
> My bad, I should have read the header closer and not assumed that Tibor's
> reply
> not being in .server was the OP's error!
> AFAIK direct path load is a method of loading data with minimal
> checking/processing and therefore faster.
Correct. You may even end up with defunct unique indexes if the data is
not unique. AFAIK there is no such thing in SQL Server.
Kind regards
robert
Subscribe to:
Posts (Atom)