how to setup the permission of share fold in log shipping ?

when I set up log shipping in SQL SERVER 2000
I got the following error:
'Unable to copy the initialization file to the secondary server '%s' '
I know this is permission question about the share fold to log file.
I want to know the following thing:
one is how to setup permisson about about the share fold to log file?
two is whether log shpping primary and the secondary db must be run
in domin mode or not?
thanks in advance!1. if your logshipping jobs are owned by 'sa', the acct for sqlserver
service needs to have access to the shared.
2. no, they do not have to be running in a same domain. the key here is to
ensure each server can access the shared.
-oj
<lovexueer@.gmail.com> wrote in message
news:1143611950.475014.180370@.i39g2000cwa.googlegroups.com...
> when I set up log shipping in SQL SERVER 2000
> I got the following error:
> 'Unable to copy the initialization file to the secondary server '%s' '
> I know this is permission question about the share fold to log file.
> I want to know the following thing:
> one is how to setup permisson about about the share fold to log file?
> two is whether log shpping primary and the secondary db must be run
> in domin mode or not?
>
> thanks in advance!
>

how to setup the permission of share fold in log shipping ?

when I set up log shipping in SQL SERVER 2000
I got the following error:
'Unable to copy the initialization file to the secondary server '%s' '
I know this is permission question about the share fold to log file.
I want to know the following thing:
one is how to setup permisson about about the share fold to log file?
two is whether log shpping primary and the secondary db must be run
in domin mode or not?
thanks in advance!1. if your logshipping jobs are owned by 'sa', the acct for sqlserver
service needs to have access to the shared.
2. no, they do not have to be running in a same domain. the key here is to
ensure each server can access the shared.
--
-oj
<lovexueer@.gmail.com> wrote in message
news:1143611950.475014.180370@.i39g2000cwa.googlegroups.com...
> when I set up log shipping in SQL SERVER 2000
> I got the following error:
> 'Unable to copy the initialization file to the secondary server '%s' '
> I know this is permission question about the share fold to log file.
> I want to know the following thing:
> one is how to setup permisson about about the share fold to log file?
> two is whether log shpping primary and the secondary db must be run
> in domin mode or not?
>
> thanks in advance!
>|||sorry,I don't understand what you said to the first quesiton?
can you tell furthur detailed information about how to setup the
permisson of shared fold ?sql

HOW TO setup SQL MAIL

hi, I want to receive a mail when SQL Server Agent JOB fail,so I go to setup the SQL MAIL,but it skip an error "xp_get_mapi_profiles: Either there is no default mail client or the current mail client cannot fulfill the messaging request. Please run Microsoft Outlook and set it as the default mail client." Someboby can tell me how to solve it?

thank you!

Hi,

SQL Mail needs a mapi file.

You can create this file either with Outlook or with Outlook Express.

regards matthias

|||

Thank you ! can you tell me the detailed resolvent.

|||

don't forget, if you're using SQL 2005, you should use "Database Mail" instead of "SQL Mail" which is being deprecated

http://www.microsoft.com/sql/prodinfo/features/top30features.mspx

http://www.sql-server-performance.com/da_email_functionality.asp

sql

How to set this parameter AlwaysUseDefaultCodePath="TRUE"

Hello all,
I am trying to migrate date from Oracle 10g to SQL serve 2005 during the data transformation I get the following error

Messages

Warning 0x80202066: Source - SERVICE [1]: Cannot retrieve the column code page info from the OLE DB provider. If the component supports the "DefaultCodePage" property, the code page from that property will be used. Change the value of the property if the current string code page values are incorrect. If the component does not support the property, the code page from the component's locale ID will be used.
(SQL Server Import and Export Wizard)

I searched internet and solution seems to be setting AlwaysUseDefaultCodePath="TRUE"

But where do you do this ?

I found this too: It's on the Properties tab of the OLE DB Source in Custom Properties section.

But still do not know where to go to set this parameter

Please help

The AlwaysUseDefaultCodePath property may be available in the Advanced Editor for the OLE DB Source. This editor has a Component Properties tab, and Input and Output Properties tab.

To open the Advanced Editor, right-click the OLE DB Source component in the package, and then click Advanced Editor.

|||For thi styoe of property I normally find it faster and easier to just use the Properties window in the designer, rather than opening the Editor. Select the component, and then hit F4 to bring the properties window into focus if it is not already.|||Thanks, Thats what I was looking for, it resolve my issue

How to set this parameter AlwaysUseDefaultCodePath="TRUE"

Hello all,
I am trying to migrate date from Oracle 10g to SQL serve 2005 during the data transformation I get the following error

Messages

Warning 0x80202066: Source - SERVICE [1]: Cannot retrieve the column code page info from the OLE DB provider. If the component supports the "DefaultCodePage" property, the code page from that property will be used. Change the value of the property if the current string code page values are incorrect. If the component does not support the property, the code page from the component's locale ID will be used.
(SQL Server Import and Export Wizard)

I searched internet and solution seems to be setting AlwaysUseDefaultCodePath="TRUE"

But where do you do this ?

I found this too: It's on the Properties tab of the OLE DB Source in Custom Properties section.

But still do not know where to go to set this parameter

Please help

The AlwaysUseDefaultCodePath property may be available in the Advanced Editor for the OLE DB Source. This editor has a Component Properties tab, and Input and Output Properties tab.

To open the Advanced Editor, right-click the OLE DB Source component in the package, and then click Advanced Editor.

|||For thi styoe of property I normally find it faster and easier to just use the Properties window in the designer, rather than opening the Editor. Select the component, and then hit F4 to bring the properties window into focus if it is not already.|||Thanks, Thats what I was looking for, it resolve my issue

How to set this parameter AlwaysUseDefaultCodePath="TRUE"

Hello all,
I am trying to migrate date from Oracle 10g to SQL serve 2005 during the data transformation I get the following error

Messages

Warning 0x80202066: Source - SERVICE [1]: Cannot retrieve the column code page info from the OLE DB provider. If the component supports the "DefaultCodePage" property, the code page from that property will be used. Change the value of the property if the current string code page values are incorrect. If the component does not support the property, the code page from the component's locale ID will be used.
(SQL Server Import and Export Wizard)

I searched internet and solution seems to be setting AlwaysUseDefaultCodePath="TRUE"

But where do you do this ?

I found this too: It's on the Properties tab of the OLE DB Source in Custom Properties section.

But still do not know where to go to set this parameter

Please help

The AlwaysUseDefaultCodePath property may be available in the Advanced Editor for the OLE DB Source. This editor has a Component Properties tab, and Input and Output Properties tab.

To open the Advanced Editor, right-click the OLE DB Source component in the package, and then click Advanced Editor.

|||For thi styoe of property I normally find it faster and easier to just use the Properties window in the designer, rather than opening the Editor. Select the component, and then hit F4 to bring the properties window into focus if it is not already.|||Thanks, Thats what I was looking for, it resolve my issue

How to set the Timeout and Timeoutspecified property?

Hi all
We are getting a 'Operation Timedout' error when trying to render a report
as pdf. Will setting the Timeout and Timeoutspecified property will help
resolve this issue. Based on some criteria this report can take long time.
Also I cant find how to set the timeout and timeoutspecified property?
Please help
Thanks
RahulI think for a report you can set the timeout in the report
manager.
>--Original Message--
>Hi all
>We are getting a 'Operation Timedout' error when trying
to render a report
>as pdf. Will setting the Timeout and Timeoutspecified
property will help
>resolve this issue. Based on some criteria this report
can take long time.
>Also I cant find how to set the timeout and
timeoutspecified property?
>Please help
>Thanks
>Rahul
>
>.
>

How to set the default value for a datetime culomn?

I try to set a default value (getdate()) for a datetime culomn in sql mobile,
but got error when i insert record:

there was a syntax error in the date format. [expression = getdate()]

may be I can only set a exict date ?

If you want to insert current datetime by calling getdate() method, then it is possible in sql server everywhere. you can do like this;

insert into employee values (4,'John',25, getdate())

This will insert current datetime in the fourth column (in above example).

Please let me know if it answers your question.

Thanks

Sachin

|||

It is just getdate()

Not (getdate())

|||do u mean in sql werver or in asp.net|||Duh ,

He encapsulated it in an expression which started with a ( and so it ended with a ) It is correct. He did not just use the function getdate() as you indicated here.

How to set the default value for a datetime culomn?

I try to set a default value (getdate()) for a datetime culomn in sql mobile,
but got error when i insert record:

there was a syntax error in the date format. [expression = getdate()]

may be I can only set a exict date ?

If you want to insert current datetime by calling getdate() method, then it is possible in sql server everywhere. you can do like this;

insert into employee values (4,'John',25, getdate())

This will insert current datetime in the fourth column (in above example).

Please let me know if it answers your question.

Thanks

Sachin

|||

It is just getdate()

Not (getdate())

|||do u mean in sql werver or in asp.net|||Duh ,

He encapsulated it in an expression which started with a ( and so it ended with a ) It is correct. He did not just use the function getdate() as you indicated here.

How to set the default value for a datetime culomn?

I try to set a default value (getdate()) for a datetime culomn in sql mobile,
but got error when i insert record:

there was a syntax error in the date format. [expression = getdate()]

may be I can only set a exict date ?

If you want to insert current datetime by calling getdate() method, then it is possible in sql server everywhere. you can do like this;

insert into employee values (4,'John',25, getdate())

This will insert current datetime in the fourth column (in above example).

Please let me know if it answers your question.

Thanks

Sachin

|||

It is just getdate()

Not (getdate())

|||do u mean in sql werver or in asp.net|||Duh ,

He encapsulated it in an expression which started with a ( and so it ended with a ) It is correct. He did not just use the function getdate() as you indicated here.

How to set the default value for a datetime culomn?

I try to set a default value (getdate()) for a datetime culomn in sql mobile,
but got error when i insert record:

there was a syntax error in the date format. [expression = getdate()]

may be I can only set a exict date ?

If you want to insert current datetime by calling getdate() method, then it is possible in sql server everywhere. you can do like this;

insert into employee values (4,'John',25, getdate())

This will insert current datetime in the fourth column (in above example).

Please let me know if it answers your question.

Thanks

Sachin

|||

It is just getdate()

Not (getdate())

|||do u mean in sql werver or in asp.net|||Duh ,

He encapsulated it in an expression which started with a ( and so it ended with a ) It is correct. He did not just use the function getdate() as you indicated here.

How to set the default value for a datetime culomn?

I try to set a default value (getdate()) for a datetime culomn in sql mobile,
but got error when i insert record:

there was a syntax error in the date format. [expression = getdate()]

may be I can only set a exict date ?

If you want to insert current datetime by calling getdate() method, then it is possible in sql server everywhere. you can do like this;

insert into employee values (4,'John',25, getdate())

This will insert current datetime in the fourth column (in above example).

Please let me know if it answers your question.

Thanks

Sachin

|||

It is just getdate()

Not (getdate())

|||do u mean in sql werver or in asp.net|||Duh ,

He encapsulated it in an expression which started with a ( and so it ended with a ) It is correct. He did not just use the function getdate() as you indicated here.

how to set SQL Server OLE DB provider index option , It gives error ?

All ,

I have created link server and i want to set all appropriate Setting for the Provider option

Provider used : - Microsoft OLE DB provider for SQL server
After setting “Index as Access Path” check box to true I have encountered
Following error

Server: Msg 7319, Level 16, State 1, Procedure Jobs, Line 2OLE DB provider 'SQLOLEDB' returned a 'NON-CLUSTERED and NOT INTEGRATED' index 'IX_T_Jobs' with incorrect bookmark ordinal 0.OLE DB error trace [Non-interface error: OLE/DB provider returned an invalid bookmark ordinal from the index rowset.].

Note :- Remote Query Icon Show 98%

Please let me know how to fix the problem and how to make sure distributed query Uses the proper index on remote Link server

Regards,
RahulB

microsoft ole db provider for sql server is not an index provider. it won't be able use index as access path from the remote sql server.

|||

I am facing the same issue. However, i don't much care which index on the oracle box a query uses...i just want the data. How do i avoid this error?

To test things, i took the table on oracle that was generating this error and duplicated it (with data) but without any indexes, and the data returns successfully.

Obviously the idea of removing indexes from oracle tables so the SQL Server can link-server connect to them is not reasonable. My method of connection is the 4-part method. Open query works even on the table...but i don't want to be forced to use that technique.

Here are the two queries...(Query 1 fails, Query 2 works):

1. SELECT * FROM ORCLPAO..SERVICE.BI_EVENT
2. SELECT TOP 10 * FROM OPENQUERY (orclpao, 'select * from service.bi_event')

Query 1 generates this error:

Server: Msg 7319, Level 16, State 1, Line 1
OLE DB provider 'MSDAORA' returned a 'NON-CLUSTERED and NOT INTEGRATED' index 'EVENT_APTNUM_XS' with incorrect bookmark ordinal 0.
OLE DB error trace [Non-interface error: OLE/DB provider returned an invalid bookmark ordinal from the index rowset.].

how to set SQL Server OLE DB provider index option , It gives error ?

All ,

I have created link server and i want to set all appropriate Setting for the Provider option

Provider used : - Microsoft OLE DB provider for SQL server
After setting “Index as Access Path” check box to true I have encountered
Following error

Server: Msg 7319, Level 16, State 1, Procedure Jobs, Line 2OLE DB provider 'SQLOLEDB' returned a 'NON-CLUSTERED and NOT INTEGRATED' index 'IX_T_Jobs' with incorrect bookmark ordinal 0.OLE DB error trace [Non-interface error: OLE/DB provider returned an invalid bookmark ordinal from the index rowset.].

Note :- Remote Query Icon Show 98%

Please let me know how to fix the problem and how to make sure distributed query Uses the proper index on remote Link server

Regards,
RahulB

microsoft ole db provider for sql server is not an index provider. it won't be able use index as access path from the remote sql server.

|||

I am facing the same issue. However, i don't much care which index on the oracle box a query uses...i just want the data. How do i avoid this error?

To test things, i took the table on oracle that was generating this error and duplicated it (with data) but without any indexes, and the data returns successfully.

Obviously the idea of removing indexes from oracle tables so the SQL Server can link-server connect to them is not reasonable. My method of connection is the 4-part method. Open query works even on the table...but i don't want to be forced to use that technique.

Here are the two queries...(Query 1 fails, Query 2 works):

1. SELECT * FROM ORCLPAO..SERVICE.BI_EVENT
2. SELECT TOP 10 * FROM OPENQUERY (orclpao, 'select * from service.bi_event')

Query 1 generates this error:

Server: Msg 7319, Level 16, State 1, Line 1
OLE DB provider 'MSDAORA' returned a 'NON-CLUSTERED and NOT INTEGRATED' index 'EVENT_APTNUM_XS' with incorrect bookmark ordinal 0.
OLE DB error trace [Non-interface error: OLE/DB provider returned an invalid bookmark ordinal from the index rowset.].

How to set my SQL Server Express to remote?

Hallo all, i get a small problems whit my MS SQL server this problem is i can't get my remote con allow bot how can i doe it? :)

this error i get when i trying to connet from my laptop to my server

TITLE: Connect to Server

Cannot connect to 192.168.47.128\SQLEXPRESS.

ADDITIONAL INFORMATION:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476

BUTTONS:

OK

i hob i can be helpt :)

Hi,

I hope you do the next.

1. Allow SQL Server to pass via you firewall on your server computer.

2. Allow remote connection (using TCP/IP) from “SQL Server 2005 Surface Area Configuration”

So, you must also check “enable” to “yes” for certain IP address.

You can do this from Start button – Programs - Microsoft SQL Server 2005 - Configuration Tools - SQL Server Configuration Manager

Then from left part of appear window you must choose “SQL Server 2005 Network Configuration” – “Protocols for SQLEXPRESS”. From right part of the window with right button of the mouse you must click on “TCP/IP” and choose “properties”. Then from appear popup window click on “IP Addresses”. And then against your IP “192.168.47.128” must choose “Yes” to “enable”.

For connect try to use the next format: IP (or name of the computer), Port or in your case 192.168.47.128, Port

My additional advice => first try to make connection on server computer to him self with 192.168.47.128, Port and if it is ok => try with computers from network. If you can make connection on your server computer, but you can’t make with network computers then the problem is in the firewall.

Regards!

Hristo Markov

|||

I am having the same problem, but with my own computer. I couldn't connect to the server because of the TCP/IP

|||

Hi ive read your problem and i can say that i faced the same problem, i found a solution to my problem, i don't know if this should work for you but try it out. here it is

1st step - Enable your TCP/IP for remote sql server on the sql server surface area configuration

2nd step - Then open you SQL server configuration manager and browse the protocols for SQL EXPRESS, propeties and go to the IPAdresses

Active Yes

Enable Yes

IP Address 192.168.1.47 ( this is the IP where your sql server resides)

TCP Dynamic ports (do not enter anything keep it blank)

TCP Port 1433 (this is the default SQL server port, you ar recommended to use this)

Then go down where its the IPALL and enter the following

TCP Dynamic ports (do not enter anything keep it blank)

TCP Port 1433 (this is the default SQL server port, you ar recommended to use this)

save your settings and restart your sql server express service

Then use 192.168.1.47\SQLEXPRESS as your connnection string *note that you did not need to enter the port number as you previously use the 1433 default sql port.so that any query will automatically first seach into the default port

lastly if u intent to use the service over a network, u need to enable port 1433 on your firewall if you did not previously perform that, but again as said in the previous post, test if it works first locally on your sql server machine..

let me know if it works.. bye

How to set my SQL Server Express to remote?

Hallo all, i get a small problems whit my MS SQL server this problem is i can't get my remote con allow bot how can i doe it? :)

this error i get when i trying to connet from my laptop to my server

TITLE: Connect to Server

Cannot connect to 192.168.47.128\SQLEXPRESS.

ADDITIONAL INFORMATION:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476

BUTTONS:

OK

i hob i can be helpt :)

Hi,

I hope you do the next.

1. Allow SQL Server to pass via you firewall on your server computer.

2. Allow remote connection (using TCP/IP) from “SQL Server 2005 Surface Area Configuration”

So, you must also check “enable” to “yes” for certain IP address.

You can do this from Start button – Programs - Microsoft SQL Server 2005 - Configuration Tools - SQL Server Configuration Manager

Then from left part of appear window you must choose “SQL Server 2005 Network Configuration” – “Protocols for SQLEXPRESS”. From right part of the window with right button of the mouse you must click on “TCP/IP” and choose “properties”. Then from appear popup window click on “IP Addresses”. And then against your IP “192.168.47.128” must choose “Yes” to “enable”.

For connect try to use the next format: IP (or name of the computer), Port or in your case 192.168.47.128, Port

My additional advice => first try to make connection on server computer to him self with 192.168.47.128, Port and if it is ok => try with computers from network. If you can make connection on your server computer, but you can’t make with network computers then the problem is in the firewall.

Regards!

Hristo Markov

|||

I am having the same problem, but with my own computer. I couldn't connect to the server because of the TCP/IP

|||

Hi ive read your problem and i can say that i faced the same problem, i found a solution to my problem, i don't know if this should work for you but try it out. here it is

1st step - Enable your TCP/IP for remote sql server on the sql server surface area configuration

2nd step - Then open you SQL server configuration manager and browse the protocols for SQL EXPRESS, propeties and go to the IPAdresses

Active Yes

Enable Yes

IP Address 192.168.1.47 ( this is the IP where your sql server resides)

TCP Dynamic ports (do not enter anything keep it blank)

TCP Port 1433 (this is the default SQL server port, you ar recommended to use this)

Then go down where its the IPALL and enter the following

TCP Dynamic ports (do not enter anything keep it blank)

TCP Port 1433 (this is the default SQL server port, you ar recommended to use this)

save your settings and restart your sql server express service

Then use 192.168.1.47\SQLEXPRESS as your connnection string *note that you did not need to enter the port number as you previously use the 1433 default sql port.so that any query will automatically first seach into the default port

lastly if u intent to use the service over a network, u need to enable port 1433 on your firewall if you did not previously perform that, but again as said in the previous post, test if it works first locally on your sql server machine..

let me know if it works.. bye

How to set my SQL Server Express to remote?

Hallo all, i get a small problems whit my MS SQL server this problem is i can't get my remote con allow bot how can i doe it? :)

this error i get when i trying to connet from my laptop to my server

TITLE: Connect to Server

Cannot connect to 192.168.47.128\SQLEXPRESS.

ADDITIONAL INFORMATION:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476

BUTTONS:

OK

i hob i can be helpt :)

Hi,

I hope you do the next.

1. Allow SQL Server to pass via you firewall on your server computer.

2. Allow remote connection (using TCP/IP) from “SQL Server 2005 Surface Area Configuration”

So, you must also check “enable” to “yes” for certain IP address.

You can do this from Start button – Programs - Microsoft SQL Server 2005 - Configuration Tools - SQL Server Configuration Manager

Then from left part of appear window you must choose “SQL Server 2005 Network Configuration” – “Protocols for SQLEXPRESS”. From right part of the window with right button of the mouse you must click on “TCP/IP” and choose “properties”. Then from appear popup window click on “IP Addresses”. And then against your IP “192.168.47.128” must choose “Yes” to “enable”.

For connect try to use the next format: IP (or name of the computer), Port or in your case 192.168.47.128, Port

My additional advice => first try to make connection on server computer to him self with 192.168.47.128, Port and if it is ok => try with computers from network. If you can make connection on your server computer, but you can’t make with network computers then the problem is in the firewall.

Regards!

Hristo Markov

|||

I am having the same problem, but with my own computer. I couldn't connect to the server because of the TCP/IP

|||

Hi ive read your problem and i can say that i faced the same problem, i found a solution to my problem, i don't know if this should work for you but try it out. here it is

1st step - Enable your TCP/IP for remote sql server on the sql server surface area configuration

2nd step - Then open you SQL server configuration manager and browse the protocols for SQL EXPRESS, propeties and go to the IPAdresses

Active Yes

Enable Yes

IP Address 192.168.1.47 ( this is the IP where your sql server resides)

TCP Dynamic ports (do not enter anything keep it blank)

TCP Port 1433 (this is the default SQL server port, you ar recommended to use this)

Then go down where its the IPALL and enter the following

TCP Dynamic ports (do not enter anything keep it blank)

TCP Port 1433 (this is the default SQL server port, you ar recommended to use this)

save your settings and restart your sql server express service

Then use 192.168.1.47\SQLEXPRESS as your connnection string *note that you did not need to enter the port number as you previously use the 1433 default sql port.so that any query will automatically first seach into the default port

lastly if u intent to use the service over a network, u need to enable port 1433 on your firewall if you did not previously perform that, but again as said in the previous post, test if it works first locally on your sql server machine..

let me know if it works.. bye

How to set IDENTITY_INSERT to ON?

Hi,
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert explicit value
for identity column in table 'tblCustomers' when IDENTITY_INSERT is set to
OFF.
/checkout.asp, line 112
Is this a database setting error? Can anyone instruct us on how to set the
IDENTITY_INSERT to ON for the ID column in our table?
Thanks.
nath.
Hi,
thats a session thing, llok in the BOL for more information:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/a5dd49f2-45c7-44a8-b182-e0a5e5c373ee.htm
SET IDENTITY_INSERT [ database_name . [ schema_name ] . ] table { ON |
OFF }
HTH, Jens Suessmeyer.
|||Hi,
thats a session thing, llok in the BOL for more information:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/a5dd49f2-45c7-44a8-b182-e0a5e5c373ee.htm
SET IDENTITY_INSERT [ database_name . [ schema_name ] . ] table { ON |
OFF }
HTH, Jens Suessmeyer.
|||The BOL? :o(
Total newbie here Jens...hope you can bear with me! :o)
Where/What is the BOL?
Thanks
Nath.
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1141478203.215944.156110@.i40g2000cwc.googlegr oups.com...
> Hi,
> thats a session thing, llok in the BOL for more information:
>
> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/a5dd49f2-45c7-44a8-b182-e0a5e5c373ee.htm
>
> SET IDENTITY_INSERT [ database_name . [ schema_name ] . ] table { ON |
> OFF }
>
> HTH, Jens Suessmeyer.
>
|||BOL is Books Online. The documentation that comes with SQL Server.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Nathon Jones" <sales@.NOSHPAMtradmusic.com> wrote in message
news:Om%23WVY5PGHA.5592@.TK2MSFTNGP11.phx.gbl...
> The BOL? :o(
> Total newbie here Jens...hope you can bear with me! :o)
> Where/What is the BOL?
> Thanks
> Nath.
> "Jens" <Jens@.sqlserver2005.de> wrote in message
> news:1141478203.215944.156110@.i40g2000cwc.googlegr oups.com...
>
|||Hi,
Doh!
Nath.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OpLMjd5PGHA.5152@.TK2MSFTNGP10.phx.gbl...
> BOL is Books Online. The documentation that comes with SQL Server.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Nathon Jones" <sales@.NOSHPAMtradmusic.com> wrote in message
> news:Om%23WVY5PGHA.5592@.TK2MSFTNGP11.phx.gbl...
>
|||Are you certain you want to set IDENTITY_INSERT ON? There are special
situations where you may need to turn on this option but in most cases you
want to omit the column from your insert statement so that SQL Server will
assign the value automatically.
Hope this helps.
Dan Guzman
SQL Server MVP
"Nathon Jones" <sales@.NOSHPAMtradmusic.com> wrote in message
news:ONykDn4PGHA.2828@.TK2MSFTNGP12.phx.gbl...
> Hi,
> Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
> [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert explicit
> value
> for identity column in table 'tblCustomers' when IDENTITY_INSERT is set to
> OFF.
> /checkout.asp, line 112
> Is this a database setting error? Can anyone instruct us on how to set
> the
> IDENTITY_INSERT to ON for the ID column in our table?
> Thanks.
> nath.
>

How to set IDENTITY_INSERT to ON?

Hi,
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert exp
licit value
for identity column in table 'tblCustomers' when IDENTITY_INSERT is set to
OFF.
/checkout.asp, line 112
Is this a database setting error? Can anyone instruct us on how to set the
IDENTITY_INSERT to ON for the ID column in our table?
Thanks.
nath.Hi,
thats a session thing, llok in the BOL for more information:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/a5dd49f2-45c7-44a8-b182-
e0a5e5c373ee.htm
SET IDENTITY_INSERT [ database_name . [ schema_name ] . ] table 
3; ON |
OFF }
HTH, Jens Suessmeyer.|||Hi,
thats a session thing, llok in the BOL for more information:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/a5dd49f2-45c7-44a8-b182-
e0a5e5c373ee.htm
SET IDENTITY_INSERT [ database_name . [ schema_name ] . ] table 
3; ON |
OFF }
HTH, Jens Suessmeyer.|||The BOL? :o(
Total newbie here Jens...hope you can bear with me! :o)
Where/What is the BOL?
Thanks
Nath.
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1141478203.215944.156110@.i40g2000cwc.googlegroups.com...
> Hi,
> thats a session thing, llok in the BOL for more information:
>
> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/a5dd49f2-45c7-44a8-b18
2-e0a5e5c373ee.htm
>
> SET IDENTITY_INSERT [ database_name . [ schema_name ] . ] table &#
123; ON |
> OFF }
>
> HTH, Jens Suessmeyer.
>|||BOL is Books Online. The documentation that comes with SQL Server.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Nathon Jones" <sales@.NOSHPAMtradmusic.com> wrote in message
news:Om%23WVY5PGHA.5592@.TK2MSFTNGP11.phx.gbl...
> The BOL? :o(
> Total newbie here Jens...hope you can bear with me! :o)
> Where/What is the BOL?
> Thanks
> Nath.
> "Jens" <Jens@.sqlserver2005.de> wrote in message
> news:1141478203.215944.156110@.i40g2000cwc.googlegroups.com...
>|||Hi,
Doh!
Nath.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OpLMjd5PGHA.5152@.TK2MSFTNGP10.phx.gbl...
> BOL is Books Online. The documentation that comes with SQL Server.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Nathon Jones" <sales@.NOSHPAMtradmusic.com> wrote in message
> news:Om%23WVY5PGHA.5592@.TK2MSFTNGP11.phx.gbl...
>|||Are you certain you want to set IDENTITY_INSERT ON? There are special
situations where you may need to turn on this option but in most cases you
want to omit the column from your insert statement so that SQL Server will
assign the value automatically.
Hope this helps.
Dan Guzman
SQL Server MVP
"Nathon Jones" <sales@.NOSHPAMtradmusic.com> wrote in message
news:ONykDn4PGHA.2828@.TK2MSFTNGP12.phx.gbl...
> Hi,
> Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
> [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert e
xplicit
> value
> for identity column in table 'tblCustomers' when IDENTITY_INSERT is set to
> OFF.
> /checkout.asp, line 112
> Is this a database setting error? Can anyone instruct us on how to set
> the
> IDENTITY_INSERT to ON for the ID column in our table?
> Thanks.
> nath.
>

How to set IDENTITY_INSERT to ON?

Hi,
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert explicit value
for identity column in table 'tblCustomers' when IDENTITY_INSERT is set to
OFF.
/checkout.asp, line 112
Is this a database setting error? Can anyone instruct us on how to set the
IDENTITY_INSERT to ON for the ID column in our table?
Thanks.
nath.Hi,
thats a session thing, llok in the BOL for more information:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/a5dd49f2-45c7-44a8-b182-e0a5e5c373ee.htm
SET IDENTITY_INSERT [ database_name . [ schema_name ] . ] table { ON |
OFF }
HTH, Jens Suessmeyer.|||Hi,
thats a session thing, llok in the BOL for more information:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/a5dd49f2-45c7-44a8-b182-e0a5e5c373ee.htm
SET IDENTITY_INSERT [ database_name . [ schema_name ] . ] table { ON |
OFF }
HTH, Jens Suessmeyer.|||The BOL? :o(
Total newbie here Jens...hope you can bear with me! :o)
Where/What is the BOL?
Thanks
Nath.
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1141478203.215944.156110@.i40g2000cwc.googlegroups.com...
> Hi,
> thats a session thing, llok in the BOL for more information:
>
> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/a5dd49f2-45c7-44a8-b182-e0a5e5c373ee.htm
>
> SET IDENTITY_INSERT [ database_name . [ schema_name ] . ] table { ON |
> OFF }
>
> HTH, Jens Suessmeyer.
>|||BOL is Books Online. The documentation that comes with SQL Server.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Nathon Jones" <sales@.NOSHPAMtradmusic.com> wrote in message
news:Om%23WVY5PGHA.5592@.TK2MSFTNGP11.phx.gbl...
> The BOL? :o(
> Total newbie here Jens...hope you can bear with me! :o)
> Where/What is the BOL?
> Thanks
> Nath.
> "Jens" <Jens@.sqlserver2005.de> wrote in message
> news:1141478203.215944.156110@.i40g2000cwc.googlegroups.com...
>> Hi,
>> thats a session thing, llok in the BOL for more information:
>>
>> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/a5dd49f2-45c7-44a8-b182-e0a5e5c373ee.htm
>>
>> SET IDENTITY_INSERT [ database_name . [ schema_name ] . ] table { ON |
>> OFF }
>>
>> HTH, Jens Suessmeyer.
>|||Hi,
Doh!
Nath.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OpLMjd5PGHA.5152@.TK2MSFTNGP10.phx.gbl...
> BOL is Books Online. The documentation that comes with SQL Server.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Nathon Jones" <sales@.NOSHPAMtradmusic.com> wrote in message
> news:Om%23WVY5PGHA.5592@.TK2MSFTNGP11.phx.gbl...
>> The BOL? :o(
>> Total newbie here Jens...hope you can bear with me! :o)
>> Where/What is the BOL?
>> Thanks
>> Nath.
>> "Jens" <Jens@.sqlserver2005.de> wrote in message
>> news:1141478203.215944.156110@.i40g2000cwc.googlegroups.com...
>> Hi,
>> thats a session thing, llok in the BOL for more information:
>>
>> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/a5dd49f2-45c7-44a8-b182-e0a5e5c373ee.htm
>>
>> SET IDENTITY_INSERT [ database_name . [ schema_name ] . ] table { ON |
>> OFF }
>>
>> HTH, Jens Suessmeyer.
>>
>|||Are you certain you want to set IDENTITY_INSERT ON? There are special
situations where you may need to turn on this option but in most cases you
want to omit the column from your insert statement so that SQL Server will
assign the value automatically.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Nathon Jones" <sales@.NOSHPAMtradmusic.com> wrote in message
news:ONykDn4PGHA.2828@.TK2MSFTNGP12.phx.gbl...
> Hi,
> Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
> [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert explicit
> value
> for identity column in table 'tblCustomers' when IDENTITY_INSERT is set to
> OFF.
> /checkout.asp, line 112
> Is this a database setting error? Can anyone instruct us on how to set
> the
> IDENTITY_INSERT to ON for the ID column in our table?
> Thanks.
> nath.
>