Hello
Our application currently is running on IIS machine with Windows 2003 32 bit
OS installed and database server machine with Windows 2000 32 bit OS and SQL
server 2000 installed.
We are thinking to upgrade the database server to Windows 2003 64 bit OS and
SQL server 2005 64 bit.
The IIS machine is still on 32 bit OS and application, We are wondering if
there is any problem for 32 bit application and ODBC to access the 64 bit
database?
Thanks in advance
Lionel
No, there is no problem. I least I have seen dozens of similar applications
accesing 64-bit databases.
Most of the connectivity issues I have seen is connecting SQL Server 64-bit
to Oracle but there is always a solution.
Hope this helps,
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"lionel" wrote:
> Hello
> Our application currently is running on IIS machine with Windows 2003 32 bit
> OS installed and database server machine with Windows 2000 32 bit OS and SQL
> server 2000 installed.
> We are thinking to upgrade the database server to Windows 2003 64 bit OS and
> SQL server 2005 64 bit.
> The IIS machine is still on 32 bit OS and application, We are wondering if
> there is any problem for 32 bit application and ODBC to access the 64 bit
> database?
> Thanks in advance
> Lionel
|||Lionel,
Here is a nice article on migrating to 64 bit SQL Server and the drivers it
takes to connect.
http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1241693,00.html
The only issue when using a 64 bit OS that I have noticed is on the Jet
(Access) connector which doesnt exist on 64 bit.
/*
Warren Brunk - MCITP,MCTS,MCDBA
www.techintsolutions.com
*/
"Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
news:EF862D05-83A0-4F45-A0DE-D12F696E7EE8@.microsoft.com...[vbcol=seagreen]
> No, there is no problem. I least I have seen dozens of similar
> applications
> accesing 64-bit databases.
> Most of the connectivity issues I have seen is connecting SQL Server
> 64-bit
> to Oracle but there is always a solution.
> Hope this helps,
> Ben Nevarez
> Senior Database Administrator
> AIG SunAmerica
>
> "lionel" wrote:
Showing posts with label application. Show all posts
Showing posts with label application. Show all posts
Thursday, March 29, 2012
Tuesday, March 27, 2012
about 32 bit application and odbc to access 64 bit SQL Server 2005
Hello
Our application currently is running on IIS machine with Windows 2003 32 bit
OS installed and database server machine with Windows 2000 32 bit OS and SQL
server 2000 installed.
We are thinking to upgrade the database server to Windows 2003 64 bit OS and
SQL server 2005 64 bit.
The IIS machine is still on 32 bit OS and application, We are wondering if
there is any problem for 32 bit application and ODBC to access the 64 bit
database?
Thanks in advance
LionelNo, there is no problem. I least I have seen dozens of similar applications
accesing 64-bit databases.
Most of the connectivity issues I have seen is connecting SQL Server 64-bit
to Oracle but there is always a solution.
Hope this helps,
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"lionel" wrote:
> Hello
> Our application currently is running on IIS machine with Windows 2003 32 b
it
> OS installed and database server machine with Windows 2000 32 bit OS and S
QL
> server 2000 installed.
> We are thinking to upgrade the database server to Windows 2003 64 bit OS a
nd
> SQL server 2005 64 bit.
> The IIS machine is still on 32 bit OS and application, We are wondering if
> there is any problem for 32 bit application and ODBC to access the 64 bit
> database?
> Thanks in advance
> Lionel|||Lionel,
Here is a nice article on migrating to 64 bit SQL Server and the drivers it
takes to connect.
http://searchsqlserver.techtarget.c...1241693,00.html
The only issue when using a 64 bit OS that I have noticed is on the Jet
(Access) connector which doesnt exist on 64 bit.
/*
Warren Brunk - MCITP,MCTS,MCDBA
www.techintsolutions.com
*/
"Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
news:EF862D05-83A0-4F45-A0DE-D12F696E7EE8@.microsoft.com...[vbcol=seagreen]
> No, there is no problem. I least I have seen dozens of similar
> applications
> accesing 64-bit databases.
> Most of the connectivity issues I have seen is connecting SQL Server
> 64-bit
> to Oracle but there is always a solution.
> Hope this helps,
> Ben Nevarez
> Senior Database Administrator
> AIG SunAmerica
>
> "lionel" wrote:
>
Our application currently is running on IIS machine with Windows 2003 32 bit
OS installed and database server machine with Windows 2000 32 bit OS and SQL
server 2000 installed.
We are thinking to upgrade the database server to Windows 2003 64 bit OS and
SQL server 2005 64 bit.
The IIS machine is still on 32 bit OS and application, We are wondering if
there is any problem for 32 bit application and ODBC to access the 64 bit
database?
Thanks in advance
LionelNo, there is no problem. I least I have seen dozens of similar applications
accesing 64-bit databases.
Most of the connectivity issues I have seen is connecting SQL Server 64-bit
to Oracle but there is always a solution.
Hope this helps,
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"lionel" wrote:
> Hello
> Our application currently is running on IIS machine with Windows 2003 32 b
it
> OS installed and database server machine with Windows 2000 32 bit OS and S
QL
> server 2000 installed.
> We are thinking to upgrade the database server to Windows 2003 64 bit OS a
nd
> SQL server 2005 64 bit.
> The IIS machine is still on 32 bit OS and application, We are wondering if
> there is any problem for 32 bit application and ODBC to access the 64 bit
> database?
> Thanks in advance
> Lionel|||Lionel,
Here is a nice article on migrating to 64 bit SQL Server and the drivers it
takes to connect.
http://searchsqlserver.techtarget.c...1241693,00.html
The only issue when using a 64 bit OS that I have noticed is on the Jet
(Access) connector which doesnt exist on 64 bit.
/*
Warren Brunk - MCITP,MCTS,MCDBA
www.techintsolutions.com
*/
"Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
news:EF862D05-83A0-4F45-A0DE-D12F696E7EE8@.microsoft.com...[vbcol=seagreen]
> No, there is no problem. I least I have seen dozens of similar
> applications
> accesing 64-bit databases.
> Most of the connectivity issues I have seen is connecting SQL Server
> 64-bit
> to Oracle but there is always a solution.
> Hope this helps,
> Ben Nevarez
> Senior Database Administrator
> AIG SunAmerica
>
> "lionel" wrote:
>
about 32 bit application and odbc to access 64 bit SQL Server 2005
Hello
Our application currently is running on IIS machine with Windows 2003 32 bit
OS installed and database server machine with Windows 2000 32 bit OS and SQL
server 2000 installed.
We are thinking to upgrade the database server to Windows 2003 64 bit OS and
SQL server 2005 64 bit.
The IIS machine is still on 32 bit OS and application, We are wondering if
there is any problem for 32 bit application and ODBC to access the 64 bit
database?
Thanks in advance
LionelNo, there is no problem. I least I have seen dozens of similar applications
accesing 64-bit databases.
Most of the connectivity issues I have seen is connecting SQL Server 64-bit
to Oracle but there is always a solution.
Hope this helps,
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"lionel" wrote:
> Hello
> Our application currently is running on IIS machine with Windows 2003 32 bit
> OS installed and database server machine with Windows 2000 32 bit OS and SQL
> server 2000 installed.
> We are thinking to upgrade the database server to Windows 2003 64 bit OS and
> SQL server 2005 64 bit.
> The IIS machine is still on 32 bit OS and application, We are wondering if
> there is any problem for 32 bit application and ODBC to access the 64 bit
> database?
> Thanks in advance
> Lionel|||Lionel,
Here is a nice article on migrating to 64 bit SQL Server and the drivers it
takes to connect.
http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1241693,00.html
The only issue when using a 64 bit OS that I have noticed is on the Jet
(Access) connector which doesnt exist on 64 bit.
--
/*
Warren Brunk - MCITP,MCTS,MCDBA
www.techintsolutions.com
*/
"Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
news:EF862D05-83A0-4F45-A0DE-D12F696E7EE8@.microsoft.com...
> No, there is no problem. I least I have seen dozens of similar
> applications
> accesing 64-bit databases.
> Most of the connectivity issues I have seen is connecting SQL Server
> 64-bit
> to Oracle but there is always a solution.
> Hope this helps,
> Ben Nevarez
> Senior Database Administrator
> AIG SunAmerica
>
> "lionel" wrote:
>> Hello
>> Our application currently is running on IIS machine with Windows 2003 32
>> bit
>> OS installed and database server machine with Windows 2000 32 bit OS and
>> SQL
>> server 2000 installed.
>> We are thinking to upgrade the database server to Windows 2003 64 bit OS
>> and
>> SQL server 2005 64 bit.
>> The IIS machine is still on 32 bit OS and application, We are wondering
>> if
>> there is any problem for 32 bit application and ODBC to access the 64 bit
>> database?
>> Thanks in advance
>> Lionel
Our application currently is running on IIS machine with Windows 2003 32 bit
OS installed and database server machine with Windows 2000 32 bit OS and SQL
server 2000 installed.
We are thinking to upgrade the database server to Windows 2003 64 bit OS and
SQL server 2005 64 bit.
The IIS machine is still on 32 bit OS and application, We are wondering if
there is any problem for 32 bit application and ODBC to access the 64 bit
database?
Thanks in advance
LionelNo, there is no problem. I least I have seen dozens of similar applications
accesing 64-bit databases.
Most of the connectivity issues I have seen is connecting SQL Server 64-bit
to Oracle but there is always a solution.
Hope this helps,
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"lionel" wrote:
> Hello
> Our application currently is running on IIS machine with Windows 2003 32 bit
> OS installed and database server machine with Windows 2000 32 bit OS and SQL
> server 2000 installed.
> We are thinking to upgrade the database server to Windows 2003 64 bit OS and
> SQL server 2005 64 bit.
> The IIS machine is still on 32 bit OS and application, We are wondering if
> there is any problem for 32 bit application and ODBC to access the 64 bit
> database?
> Thanks in advance
> Lionel|||Lionel,
Here is a nice article on migrating to 64 bit SQL Server and the drivers it
takes to connect.
http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1241693,00.html
The only issue when using a 64 bit OS that I have noticed is on the Jet
(Access) connector which doesnt exist on 64 bit.
--
/*
Warren Brunk - MCITP,MCTS,MCDBA
www.techintsolutions.com
*/
"Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
news:EF862D05-83A0-4F45-A0DE-D12F696E7EE8@.microsoft.com...
> No, there is no problem. I least I have seen dozens of similar
> applications
> accesing 64-bit databases.
> Most of the connectivity issues I have seen is connecting SQL Server
> 64-bit
> to Oracle but there is always a solution.
> Hope this helps,
> Ben Nevarez
> Senior Database Administrator
> AIG SunAmerica
>
> "lionel" wrote:
>> Hello
>> Our application currently is running on IIS machine with Windows 2003 32
>> bit
>> OS installed and database server machine with Windows 2000 32 bit OS and
>> SQL
>> server 2000 installed.
>> We are thinking to upgrade the database server to Windows 2003 64 bit OS
>> and
>> SQL server 2005 64 bit.
>> The IIS machine is still on 32 bit OS and application, We are wondering
>> if
>> there is any problem for 32 bit application and ODBC to access the 64 bit
>> database?
>> Thanks in advance
>> Lionel
Sunday, March 25, 2012
Abend info in SQL Log
Is there a way to get application/sql query abends to appear in the SQL error
log?
For example, we have an application that executes a SQL query. The
application will abend because the query failed (invalid object, Foreign key
conflict ...). Can we change a setting in SQL to see these errors in the
error log?Hi
No. If you need to see failed queries, you need to run SQL Server Profiler.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"vtcs212" <vtcs212@.discussions.microsoft.com> wrote in message
news:72A431E7-5581-435D-A6C9-3253A30692BB@.microsoft.com...
> Is there a way to get application/sql query abends to appear in the SQL
> error
> log?
> For example, we have an application that executes a SQL query. The
> application will abend because the query failed (invalid object, Foreign
> key
> conflict ...). Can we change a setting in SQL to see these errors in the
> error log?
log?
For example, we have an application that executes a SQL query. The
application will abend because the query failed (invalid object, Foreign key
conflict ...). Can we change a setting in SQL to see these errors in the
error log?Hi
No. If you need to see failed queries, you need to run SQL Server Profiler.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"vtcs212" <vtcs212@.discussions.microsoft.com> wrote in message
news:72A431E7-5581-435D-A6C9-3253A30692BB@.microsoft.com...
> Is there a way to get application/sql query abends to appear in the SQL
> error
> log?
> For example, we have an application that executes a SQL query. The
> application will abend because the query failed (invalid object, Foreign
> key
> conflict ...). Can we change a setting in SQL to see these errors in the
> error log?
Abend info in SQL Log
Is there a way to get application/sql query abends to appear in the SQL error
log?
For example, we have an application that executes a SQL query. The
application will abend because the query failed (invalid object, Foreign key
conflict ...). Can we change a setting in SQL to see these errors in the
error log?
Hi
No. If you need to see failed queries, you need to run SQL Server Profiler.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"vtcs212" <vtcs212@.discussions.microsoft.com> wrote in message
news:72A431E7-5581-435D-A6C9-3253A30692BB@.microsoft.com...
> Is there a way to get application/sql query abends to appear in the SQL
> error
> log?
> For example, we have an application that executes a SQL query. The
> application will abend because the query failed (invalid object, Foreign
> key
> conflict ...). Can we change a setting in SQL to see these errors in the
> error log?
sql
log?
For example, we have an application that executes a SQL query. The
application will abend because the query failed (invalid object, Foreign key
conflict ...). Can we change a setting in SQL to see these errors in the
error log?
Hi
No. If you need to see failed queries, you need to run SQL Server Profiler.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"vtcs212" <vtcs212@.discussions.microsoft.com> wrote in message
news:72A431E7-5581-435D-A6C9-3253A30692BB@.microsoft.com...
> Is there a way to get application/sql query abends to appear in the SQL
> error
> log?
> For example, we have an application that executes a SQL query. The
> application will abend because the query failed (invalid object, Foreign
> key
> conflict ...). Can we change a setting in SQL to see these errors in the
> error log?
sql
Abend info in SQL Log
Is there a way to get application/sql query abends to appear in the SQL erro
r
log?
For example, we have an application that executes a SQL query. The
application will abend because the query failed (invalid object, Foreign key
conflict ...). Can we change a setting in SQL to see these errors in the
error log?Hi
No. If you need to see failed queries, you need to run SQL Server Profiler.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"vtcs212" <vtcs212@.discussions.microsoft.com> wrote in message
news:72A431E7-5581-435D-A6C9-3253A30692BB@.microsoft.com...
> Is there a way to get application/sql query abends to appear in the SQL
> error
> log?
> For example, we have an application that executes a SQL query. The
> application will abend because the query failed (invalid object, Foreign
> key
> conflict ...). Can we change a setting in SQL to see these errors in the
> error log?
r
log?
For example, we have an application that executes a SQL query. The
application will abend because the query failed (invalid object, Foreign key
conflict ...). Can we change a setting in SQL to see these errors in the
error log?Hi
No. If you need to see failed queries, you need to run SQL Server Profiler.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"vtcs212" <vtcs212@.discussions.microsoft.com> wrote in message
news:72A431E7-5581-435D-A6C9-3253A30692BB@.microsoft.com...
> Is there a way to get application/sql query abends to appear in the SQL
> error
> log?
> For example, we have an application that executes a SQL query. The
> application will abend because the query failed (invalid object, Foreign
> key
> conflict ...). Can we change a setting in SQL to see these errors in the
> error log?
AA_DB is this sql error?
Hi all,
Our version of application is throwing AA_DB error while working on it... at first start. we are using sql 2000 with sp3a on win 2003 platform. with 4 Xenon processors and 8 GB ram.
is this error is related with sql or something else...
I checked this on net and found..(actionapps or something related with authentication of user)
pls help to rectify if possible..
Best Regards,its a new version of application we launched... earlier in old versions this error was not there...|||could you clarify the error in more detail so that someone will be able to help you.
regards,
Harshal.|||i have two server's in domain, with same configuration sql 2000 sp3a same db name, same application package... but while working on one sever application...in one module its showing me aa_db error after 10 to 15 mins randomly... we have tested sql installation, service pack reinstalled, applicaiton installation tested.
though the applicaiton is very well tested by vendor side but here we are confuse that why we are facing it..|||What's the errorlog showing?
Our version of application is throwing AA_DB error while working on it... at first start. we are using sql 2000 with sp3a on win 2003 platform. with 4 Xenon processors and 8 GB ram.
is this error is related with sql or something else...
I checked this on net and found..(actionapps or something related with authentication of user)
pls help to rectify if possible..
Best Regards,its a new version of application we launched... earlier in old versions this error was not there...|||could you clarify the error in more detail so that someone will be able to help you.
regards,
Harshal.|||i have two server's in domain, with same configuration sql 2000 sp3a same db name, same application package... but while working on one sever application...in one module its showing me aa_db error after 10 to 15 mins randomly... we have tested sql installation, service pack reinstalled, applicaiton installation tested.
though the applicaiton is very well tested by vendor side but here we are confuse that why we are facing it..|||What's the errorlog showing?
A weird problem of Reporting Service
My company is using SQL 2000, Reporting Service SP2, Server 2003, .NET framework 1.1.
We have an ASP.NET application, working properly on one of our test machine, but when we test on another test machine, it would have the following problem:
When we want to view the PDF or EXCEL report generated by Reporting Services, we get prompted to download an ASPX file. If we choose [Open], it will use Visual Studio.NET to open it. But if we choose [Save], and change the extenstion name, it's actually the correct report file.
That means, the report is generated correctly, but we can't open it.
We have added the Content-Disposition to indicate a correct extension name, but that machine still have this weird problem. Frustrately, it works perfectly on our another machine, even without Content-Disposition.
So, we are thinking probably it's related some file system security configuration. Could anyone give me a little hint about it?
Thank you very much!
Hi, we have the same problem. Did you get anywhere with this?|||are u still looking for answer of it?that's because the server turns on the http compression, stupid IE doesn't understand it.
one thing to work it around is, turn off the compression for aspx, it might affect too much. If that's a concern, change your report generator file from ASPX to another extension, then that extension file won't have compression on. And you can enable asp.net to handle that new extension, which is only used to generate report.
this just works fine for us
A weird problem of Reporting Service
My company is using SQL 2000, Reporting Service SP2, Server 2003, .NET framework 1.1.
We have an ASP.NET application, working properly on one of our test machine, but when we test on another test machine, it would have the following problem:
When we want to view the PDF or EXCEL report generated by Reporting Services, we get prompted to download an ASPX file. If we choose [Open], it will use Visual Studio.NET to open it. But if we choose [Save], and change the extenstion name, it's actually the correct report file.
That means, the report is generated correctly, but we can't open it.
We have added the Content-Disposition to indicate a correct extension name, but that machine still have this weird problem. Frustrately, it works perfectly on our another machine, even without Content-Disposition.
So, we are thinking probably it's related some file system security configuration. Could anyone give me a little hint about it?
Thank you very much!
Hi, we have the same problem. Did you get anywhere with this?|||are u still looking for answer of it?that's because the server turns on the http compression, stupid IE doesn't understand it.
one thing to work it around is, turn off the compression for aspx, it might affect too much. If that's a concern, change your report generator file from ASPX to another extension, then that extension file won't have compression on. And you can enable asp.net to handle that new extension, which is only used to generate report.
this just works fine for us
A weird problem of Reporting Service
My company is using SQL 2000, Reporting Service SP2, Server 2003, .NET framework 1.1.
We have an ASP.NET application, working properly on one of our test machine, but when we test on another test machine, it would have the following problem:
When we want to view the PDF or EXCEL report generated by Reporting Services, we get prompted to download an ASPX file. If we choose [Open], it will use Visual Studio.NET to open it. But if we choose [Save], and change the extenstion name, it's actually the correct report file.
That means, the report is generated correctly, but we can't open it.
We have added the Content-Disposition to indicate a correct extension name, but that machine still have this weird problem. Frustrately, it works perfectly on our another machine, even without Content-Disposition.
So, we are thinking probably it's related some file system security configuration. Could anyone give me a little hint about it?
Thank you very much!
Hi, we have the same problem. Did you get anywhere with this?|||are u still looking for answer of it?that's because the server turns on the http compression, stupid IE doesn't understand it.
one thing to work it around is, turn off the compression for aspx, it might affect too much. If that's a concern, change your report generator file from ASPX to another extension, then that extension file won't have compression on. And you can enable asp.net to handle that new extension, which is only used to generate report.
this just works fine for us
sql
A weird problem - Need URGENT HELP
Hello All,
Greetings!
I have been using the VS2005/SQL 2005 for over a year to develp an application. This is completly a web application and pretty simple and straight forward.
Here is the situation:
(1) Including myself, one more user is logging on.
(2) We both are querying different departments and adding employees to the department.
For example: I query a dept# 101 and the other users querying dept# 102.
(3) When I commit my changes, I am getting the data saved into the table what other user queried in.(Instead of my dept# 101, I am getting dept#102 saved in the table.). The records that are commited using the stored prodedure, simple insert statement and they are between BEGIN TRAN and COMMIT TRAN.
(4) I trapped the sql command using the SQL profiler but I am in the need of some help to overcome.
Is there any SQL Server agent to be tweaked in? OR anything to do with IIS?
Your help will be highly appreciated.
Regards,
Amritha
Very difficult to say without more info, but my gut instinct is its not SQL server thats the issue here.
Have you tried running the stored procedures outside of the application? Do they give the correct results?
Is it a standard stored procedure or CLR stored procedure?
Post the sql code back here and it might help.
Thank you so much for the response. I figured out the problem. Some of our colleagues declare variables as static and hence the reason. It should have been as session variables.
Again, I appreciate your time.
Regards,
Amritha
A weird problem - Need URGENT HELP
Hello All,
Greetings!
I have been using the VS2005/SQL 2005 for over a year to develp an application. This is completly a web application and pretty simple and straight forward.
Here is the situation:
(1) Including myself, one more user is logging on.
(2) We both are querying different departments and adding employees to the department.
For example: I query a dept# 101 and the other users querying dept# 102.
(3) When I commit my changes, I am getting the data saved into the table what other user queried in.(Instead of my dept# 101, I am getting dept#102 saved in the table.). The records that are commited using the stored prodedure, simple insert statement and they are between BEGIN TRAN and COMMIT TRAN.
(4) I trapped the sql command using the SQL profiler but I am in the need of some help to overcome.
Is there any SQL Server agent to be tweaked in? OR anything to do with IIS?
Your help will be highly appreciated.
Regards,
Amritha
Very difficult to say without more info, but my gut instinct is its not SQL server thats the issue here.
Have you tried running the stored procedures outside of the application? Do they give the correct results?
Is it a standard stored procedure or CLR stored procedure?
Post the sql code back here and it might help.
Thank you so much for the response. I figured out the problem. Some of our colleagues declare variables as static and hence the reason. It should have been as session variables.
Again, I appreciate your time.
Regards,
Amritha
Thursday, March 22, 2012
A way to get Table shema as xml ?
Dear all,
Is there a way to get from SQL table and XML shema file (XSD) that can be
read afterwards from a .NEt application ?
I know that I could read frommy ASP.NET code the whole table structure but
having the local xsd file would be faster for reading
regards
serge
Hello serge,
> Is there a way to get from SQL table and XML shema file (XSD) that can
> be read afterwards from a .NEt application ?
> I know that I could read frommy ASP.NET code the whole table structure
> but having the local xsd file would be faster for reading
AFAIK, not directly. One of the things I've done in the past is generate
information about the schema from the metadata. Something like this:
alter function dbo.GetColumnsForTable(@.TableObjectID int)
returns xml
as begin
declare @.rv xml
set @.rv = (select
c.column_id'@.position'
, c.name'name'
, y.name'dataType'
, c.max_length'maxLength'
, c.precision'precision'
, c.scale'scale'
, c.collation_name'collationName'
, c.is_nullable'nullable'
, c.is_rowguidcol'isRowGUID'
, c.is_identity'isIdentity'
, c.is_computed'isComputed'
, x.name
from sys.columns c
join sys.types y on c.system_type_id = y.system_type_id
left join sys.xml_schema_collections x on c.xml_collection_id = x.xml_collection_id
where c.object_id = @.TableObjectID
for xml path('column'),type)
return @.rv
end
go
select t.name'name',
dbo.GetColumnsForTable(t.object_id) as 'table/columns'
from sys.tables t
for xml path('table'),root('tables')
go
While its not a schema per se, you can get a lot of information doing this
kind of coding.
Thank you,
Kent Tegels
DevelopMentor
http://staff.develop.com/ktegels/
Is there a way to get from SQL table and XML shema file (XSD) that can be
read afterwards from a .NEt application ?
I know that I could read frommy ASP.NET code the whole table structure but
having the local xsd file would be faster for reading
regards
serge
Hello serge,
> Is there a way to get from SQL table and XML shema file (XSD) that can
> be read afterwards from a .NEt application ?
> I know that I could read frommy ASP.NET code the whole table structure
> but having the local xsd file would be faster for reading
AFAIK, not directly. One of the things I've done in the past is generate
information about the schema from the metadata. Something like this:
alter function dbo.GetColumnsForTable(@.TableObjectID int)
returns xml
as begin
declare @.rv xml
set @.rv = (select
c.column_id'@.position'
, c.name'name'
, y.name'dataType'
, c.max_length'maxLength'
, c.precision'precision'
, c.scale'scale'
, c.collation_name'collationName'
, c.is_nullable'nullable'
, c.is_rowguidcol'isRowGUID'
, c.is_identity'isIdentity'
, c.is_computed'isComputed'
, x.name
from sys.columns c
join sys.types y on c.system_type_id = y.system_type_id
left join sys.xml_schema_collections x on c.xml_collection_id = x.xml_collection_id
where c.object_id = @.TableObjectID
for xml path('column'),type)
return @.rv
end
go
select t.name'name',
dbo.GetColumnsForTable(t.object_id) as 'table/columns'
from sys.tables t
for xml path('table'),root('tables')
go
While its not a schema per se, you can get a lot of information doing this
kind of coding.
Thank you,
Kent Tegels
DevelopMentor
http://staff.develop.com/ktegels/
A way to get Table shema as xml ?
Dear all,
Is there a way to get from SQL table and XML shema file (XSD) that can be
read afterwards from a .NEt application ?
I know that I could read frommy ASP.NET code the whole table structure but
having the local xsd file would be faster for reading
regards
sergeHello serge,
> Is there a way to get from SQL table and XML shema file (XSD) that can
> be read afterwards from a .NEt application ?
> I know that I could read frommy ASP.NET code the whole table structure
> but having the local xsd file would be faster for reading
AFAIK, not directly. One of the things I've done in the past is generate
information about the schema from the metadata. Something like this:
alter function dbo.GetColumnsForTable(@.TableObjectID int)
returns xml
as begin
declare @.rv xml
set @.rv = (select
c.column_id '@.position'
, c.name 'name'
, y.name 'dataType'
, c.max_length 'maxLength'
, c.precision 'precision'
, c.scale 'scale'
, c.collation_name 'collationName'
, c.is_nullable 'nullable'
, c.is_rowguidcol 'isRowGUID'
, c.is_identity 'isIdentity'
, c.is_computed 'isComputed'
, x.name
from sys.columns c
join sys.types y on c.system_type_id = y.system_type_id
left join sys.xml_schema_collections x on c.xml_collection_id = x.xml_collec
tion_id
where c.object_id = @.TableObjectID
for xml path('column'),type)
return @.rv
end
go
select t.name 'name',
dbo.GetColumnsForTable(t.object_id) as 'table/columns'
from sys.tables t
for xml path('table'),root('tables')
go
While its not a schema per se, you can get a lot of information doing this
kind of coding.
Thank you,
Kent Tegels
DevelopMentor
http://staff.develop.com/ktegels/
Is there a way to get from SQL table and XML shema file (XSD) that can be
read afterwards from a .NEt application ?
I know that I could read frommy ASP.NET code the whole table structure but
having the local xsd file would be faster for reading
regards
sergeHello serge,
> Is there a way to get from SQL table and XML shema file (XSD) that can
> be read afterwards from a .NEt application ?
> I know that I could read frommy ASP.NET code the whole table structure
> but having the local xsd file would be faster for reading
AFAIK, not directly. One of the things I've done in the past is generate
information about the schema from the metadata. Something like this:
alter function dbo.GetColumnsForTable(@.TableObjectID int)
returns xml
as begin
declare @.rv xml
set @.rv = (select
c.column_id '@.position'
, c.name 'name'
, y.name 'dataType'
, c.max_length 'maxLength'
, c.precision 'precision'
, c.scale 'scale'
, c.collation_name 'collationName'
, c.is_nullable 'nullable'
, c.is_rowguidcol 'isRowGUID'
, c.is_identity 'isIdentity'
, c.is_computed 'isComputed'
, x.name
from sys.columns c
join sys.types y on c.system_type_id = y.system_type_id
left join sys.xml_schema_collections x on c.xml_collection_id = x.xml_collec
tion_id
where c.object_id = @.TableObjectID
for xml path('column'),type)
return @.rv
end
go
select t.name 'name',
dbo.GetColumnsForTable(t.object_id) as 'table/columns'
from sys.tables t
for xml path('table'),root('tables')
go
While its not a schema per se, you can get a lot of information doing this
kind of coding.
Thank you,
Kent Tegels
DevelopMentor
http://staff.develop.com/ktegels/
A way to "SELECT constraints FROM table"
is there any way to get the contraints or indexes of a table doing a SELECT QUERY?
I am using a VC++ application to do some changes on a Access DB and there is a contraint that as a random name... This would help me to find the constraint name automaticaly and change drop it as I want
hope someone knows a way to do thisSELECT * FROM MSysRelationships-PatP|||Thank you very very very much... you don't know how much did you help me :)
Finally someone gave me a good answer to my problem and it WORKS :D
I am using a VC++ application to do some changes on a Access DB and there is a contraint that as a random name... This would help me to find the constraint name automaticaly and change drop it as I want
hope someone knows a way to do thisSELECT * FROM MSysRelationships-PatP|||Thank you very very very much... you don't know how much did you help me :)
Finally someone gave me a good answer to my problem and it WORKS :D
Tuesday, March 20, 2012
A transport-level error has occurred when receiving results from the server.
Hi all,
I am getting the error below:
I would like to also mention that this error is occuring randomly. I am
running a web application under SQL Server 2005 and .NET framework 2.0.
Has anyone encountered this issue.
Error occurred during report data retrieving and binding.
The actual error message is:
A transport-level error has occurred when receiving results from the
server. (provider: TCP Provider, error: 0 - The specified network name
is no longer available.)
at System.Data.SqlClient.SqlConnection.OnError(SqlExc eption exception,
Boolean breakConnection) at
System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateO
bject stateObj) at
System.Data.SqlClient.TdsParserStateObject.ReadSni Error(TdsParserStateOb
ject stateObj, UInt32 error) at
System.Data.SqlClient.TdsParserStateObject.ReadSni (DbAsyncResult
asyncResult, TdsParserStateObject stateObj) at
System.Data.SqlClient.TdsParserStateObject.ReadPac ket(Int32
bytesExpected) at System.Data.SqlClient.TdsParserStateObject.ReadByt e()
at System.Data.SqlClient.TdsParser.GetTokenLength(Byt e token,
TdsParserStateObject stateObj) at
System.Data.SqlClient.TdsParser.GetDataLength(SqlM etaDataPriv colmeta,
TdsParserStateObject stateObj) at
System.Data.SqlClient.TdsParser.ProcessColumnHeade r(SqlMetaDataPriv col,
TdsParserStateObject stateObj, Boolean& isNull) at
System.Data.SqlClient.SqlDataReader.ReadColumnHead er(Int32 i) at
System.Data.SqlClient.SqlDataReader.ReadColumn(Int 32 i, Boolean
setTimeout) at
System.Data.SqlClient.SqlDataReader.GetValueIntern al(Int32 i) at
System.Data.SqlClient.SqlDataReader.GetValues(Obje ct[] values) at
System.Data.ProviderBase.DataReaderContainer.Commo nLanguageSubsetDataRea
der.GetValues(Object[] values) at
System.Data.ProviderBase.SchemaMapping.LoadDataRow () at
System.Data.Common.DataAdapter.FillLoadDataRow(Sch emaMapping mapping) at
System.Data.Common.DataAdapter.FillFromReader(Data Set dataset, DataTable
datatable, String srcTable, DataReaderContainer dataReader, Int32
startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object
parentChapterValue) at System.Data.Common.DataAdapter.Fill(DataTable[]
dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
at System.Data.Common.DbDataAdapter.FillInternal(Data Set dataset,
DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String
srcTable, IDbCommand command, CommandBehavior behavior) at
System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32
startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior
behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
at private_enterprise_report_cmn_RepricingSummary.Pag e_Load(Object
sender, EventArgs e) in
*** Sent via Developersdex http://www.codecomments.com ***
You would want to check the SQL Server error logs to make
sure it's not a refused connection from an issue like full
logs, out of disk space, etc. Those would be in the SQL log.
If you don't have anything there and it's random then you
may be experiencing network burps and dropping connections.
You can following the troubleshooting steps in the following
article:
How to troubleshoot network connectivity problems
http://support.microsoft.com/?id=325487
-Sue
On Mon, 23 Apr 2007 13:27:10 -0700, Audrey Ng
<odd26uk@.yahoo.co.uk> wrote:
>Hi all,
>I am getting the error below:
>I would like to also mention that this error is occuring randomly. I am
>running a web application under SQL Server 2005 and .NET framework 2.0.
>Has anyone encountered this issue.
>Error occurred during report data retrieving and binding.
>The actual error message is:
>A transport-level error has occurred when receiving results from the
>server. (provider: TCP Provider, error: 0 - The specified network name
>is no longer available.)
>at System.Data.SqlClient.SqlConnection.OnError(SqlExc eption exception,
>Boolean breakConnection) at
>System.Data.SqlClient.TdsParser.ThrowExceptionAnd Warning(TdsParserStateO
>bject stateObj) at
>System.Data.SqlClient.TdsParserStateObject.ReadSn iError(TdsParserStateOb
>ject stateObj, UInt32 error) at
>System.Data.SqlClient.TdsParserStateObject.ReadSn i(DbAsyncResult
>asyncResult, TdsParserStateObject stateObj) at
>System.Data.SqlClient.TdsParserStateObject.ReadPa cket(Int32
>bytesExpected) at System.Data.SqlClient.TdsParserStateObject.ReadByt e()
>at System.Data.SqlClient.TdsParser.GetTokenLength(Byt e token,
>TdsParserStateObject stateObj) at
>System.Data.SqlClient.TdsParser.GetDataLength(Sql MetaDataPriv colmeta,
>TdsParserStateObject stateObj) at
>System.Data.SqlClient.TdsParser.ProcessColumnHead er(SqlMetaDataPriv col,
>TdsParserStateObject stateObj, Boolean& isNull) at
>System.Data.SqlClient.SqlDataReader.ReadColumnHea der(Int32 i) at
>System.Data.SqlClient.SqlDataReader.ReadColumn(In t32 i, Boolean
>setTimeout) at
>System.Data.SqlClient.SqlDataReader.GetValueInter nal(Int32 i) at
>System.Data.SqlClient.SqlDataReader.GetValues(Obj ect[] values) at
>System.Data.ProviderBase.DataReaderContainer.Comm onLanguageSubsetDataRea
>der.GetValues(Object[] values) at
>System.Data.ProviderBase.SchemaMapping.LoadDataRo w() at
>System.Data.Common.DataAdapter.FillLoadDataRow(Sc hemaMapping mapping) at
>System.Data.Common.DataAdapter.FillFromReader(Dat aSet dataset, DataTable
>datatable, String srcTable, DataReaderContainer dataReader, Int32
>startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object
>parentChapterValue) at System.Data.Common.DataAdapter.Fill(DataTable[]
>dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
>at System.Data.Common.DbDataAdapter.FillInternal(Data Set dataset,
>DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String
>srcTable, IDbCommand command, CommandBehavior behavior) at
>System.Data.Common.DbDataAdapter.Fill(DataTable [] dataTables, Int32
>startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior
>behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
>at private_enterprise_report_cmn_RepricingSummary.Pag e_Load(Object
>sender, EventArgs e) in
>*** Sent via Developersdex http://www.codecomments.com ***
|||I'm not sure if this is related to the issue but when I do try to
connect to my database server from a Remote Management Studio. I get the
same error
"A transport-level error has occurred when receiving results from the
server..."
Any ideas?
*** Sent via Developersdex http://www.codecomments.com ***
|||You still need to go through the other steps - check the
logs, check the network connectivity, etc.
-Sue
On Tue, 24 Apr 2007 06:32:28 -0700, Audrey Ng
<odd26uk@.yahoo.co.uk> wrote:
>I'm not sure if this is related to the issue but when I do try to
>connect to my database server from a Remote Management Studio. I get the
>same error
>"A transport-level error has occurred when receiving results from the
>server..."
>Any ideas?
>
>*** Sent via Developersdex http://www.codecomments.com ***
sql
I am getting the error below:
I would like to also mention that this error is occuring randomly. I am
running a web application under SQL Server 2005 and .NET framework 2.0.
Has anyone encountered this issue.
Error occurred during report data retrieving and binding.
The actual error message is:
A transport-level error has occurred when receiving results from the
server. (provider: TCP Provider, error: 0 - The specified network name
is no longer available.)
at System.Data.SqlClient.SqlConnection.OnError(SqlExc eption exception,
Boolean breakConnection) at
System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateO
bject stateObj) at
System.Data.SqlClient.TdsParserStateObject.ReadSni Error(TdsParserStateOb
ject stateObj, UInt32 error) at
System.Data.SqlClient.TdsParserStateObject.ReadSni (DbAsyncResult
asyncResult, TdsParserStateObject stateObj) at
System.Data.SqlClient.TdsParserStateObject.ReadPac ket(Int32
bytesExpected) at System.Data.SqlClient.TdsParserStateObject.ReadByt e()
at System.Data.SqlClient.TdsParser.GetTokenLength(Byt e token,
TdsParserStateObject stateObj) at
System.Data.SqlClient.TdsParser.GetDataLength(SqlM etaDataPriv colmeta,
TdsParserStateObject stateObj) at
System.Data.SqlClient.TdsParser.ProcessColumnHeade r(SqlMetaDataPriv col,
TdsParserStateObject stateObj, Boolean& isNull) at
System.Data.SqlClient.SqlDataReader.ReadColumnHead er(Int32 i) at
System.Data.SqlClient.SqlDataReader.ReadColumn(Int 32 i, Boolean
setTimeout) at
System.Data.SqlClient.SqlDataReader.GetValueIntern al(Int32 i) at
System.Data.SqlClient.SqlDataReader.GetValues(Obje ct[] values) at
System.Data.ProviderBase.DataReaderContainer.Commo nLanguageSubsetDataRea
der.GetValues(Object[] values) at
System.Data.ProviderBase.SchemaMapping.LoadDataRow () at
System.Data.Common.DataAdapter.FillLoadDataRow(Sch emaMapping mapping) at
System.Data.Common.DataAdapter.FillFromReader(Data Set dataset, DataTable
datatable, String srcTable, DataReaderContainer dataReader, Int32
startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object
parentChapterValue) at System.Data.Common.DataAdapter.Fill(DataTable[]
dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
at System.Data.Common.DbDataAdapter.FillInternal(Data Set dataset,
DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String
srcTable, IDbCommand command, CommandBehavior behavior) at
System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32
startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior
behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
at private_enterprise_report_cmn_RepricingSummary.Pag e_Load(Object
sender, EventArgs e) in
*** Sent via Developersdex http://www.codecomments.com ***
You would want to check the SQL Server error logs to make
sure it's not a refused connection from an issue like full
logs, out of disk space, etc. Those would be in the SQL log.
If you don't have anything there and it's random then you
may be experiencing network burps and dropping connections.
You can following the troubleshooting steps in the following
article:
How to troubleshoot network connectivity problems
http://support.microsoft.com/?id=325487
-Sue
On Mon, 23 Apr 2007 13:27:10 -0700, Audrey Ng
<odd26uk@.yahoo.co.uk> wrote:
>Hi all,
>I am getting the error below:
>I would like to also mention that this error is occuring randomly. I am
>running a web application under SQL Server 2005 and .NET framework 2.0.
>Has anyone encountered this issue.
>Error occurred during report data retrieving and binding.
>The actual error message is:
>A transport-level error has occurred when receiving results from the
>server. (provider: TCP Provider, error: 0 - The specified network name
>is no longer available.)
>at System.Data.SqlClient.SqlConnection.OnError(SqlExc eption exception,
>Boolean breakConnection) at
>System.Data.SqlClient.TdsParser.ThrowExceptionAnd Warning(TdsParserStateO
>bject stateObj) at
>System.Data.SqlClient.TdsParserStateObject.ReadSn iError(TdsParserStateOb
>ject stateObj, UInt32 error) at
>System.Data.SqlClient.TdsParserStateObject.ReadSn i(DbAsyncResult
>asyncResult, TdsParserStateObject stateObj) at
>System.Data.SqlClient.TdsParserStateObject.ReadPa cket(Int32
>bytesExpected) at System.Data.SqlClient.TdsParserStateObject.ReadByt e()
>at System.Data.SqlClient.TdsParser.GetTokenLength(Byt e token,
>TdsParserStateObject stateObj) at
>System.Data.SqlClient.TdsParser.GetDataLength(Sql MetaDataPriv colmeta,
>TdsParserStateObject stateObj) at
>System.Data.SqlClient.TdsParser.ProcessColumnHead er(SqlMetaDataPriv col,
>TdsParserStateObject stateObj, Boolean& isNull) at
>System.Data.SqlClient.SqlDataReader.ReadColumnHea der(Int32 i) at
>System.Data.SqlClient.SqlDataReader.ReadColumn(In t32 i, Boolean
>setTimeout) at
>System.Data.SqlClient.SqlDataReader.GetValueInter nal(Int32 i) at
>System.Data.SqlClient.SqlDataReader.GetValues(Obj ect[] values) at
>System.Data.ProviderBase.DataReaderContainer.Comm onLanguageSubsetDataRea
>der.GetValues(Object[] values) at
>System.Data.ProviderBase.SchemaMapping.LoadDataRo w() at
>System.Data.Common.DataAdapter.FillLoadDataRow(Sc hemaMapping mapping) at
>System.Data.Common.DataAdapter.FillFromReader(Dat aSet dataset, DataTable
>datatable, String srcTable, DataReaderContainer dataReader, Int32
>startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object
>parentChapterValue) at System.Data.Common.DataAdapter.Fill(DataTable[]
>dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
>at System.Data.Common.DbDataAdapter.FillInternal(Data Set dataset,
>DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String
>srcTable, IDbCommand command, CommandBehavior behavior) at
>System.Data.Common.DbDataAdapter.Fill(DataTable [] dataTables, Int32
>startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior
>behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
>at private_enterprise_report_cmn_RepricingSummary.Pag e_Load(Object
>sender, EventArgs e) in
>*** Sent via Developersdex http://www.codecomments.com ***
|||I'm not sure if this is related to the issue but when I do try to
connect to my database server from a Remote Management Studio. I get the
same error
"A transport-level error has occurred when receiving results from the
server..."
Any ideas?
*** Sent via Developersdex http://www.codecomments.com ***
|||You still need to go through the other steps - check the
logs, check the network connectivity, etc.
-Sue
On Tue, 24 Apr 2007 06:32:28 -0700, Audrey Ng
<odd26uk@.yahoo.co.uk> wrote:
>I'm not sure if this is related to the issue but when I do try to
>connect to my database server from a Remote Management Studio. I get the
>same error
>"A transport-level error has occurred when receiving results from the
>server..."
>Any ideas?
>
>*** Sent via Developersdex http://www.codecomments.com ***
sql
A transport-level error has occurred when receiving results from the server.
Hi all,
I am getting the error below:
I would like to also mention that this error is occuring randomly. I am
running a web application under SQL Server 2005 and .NET framework 2.0.
Has anyone encountered this issue.
Error occurred during report data retrieving and binding.
The actual error message is:
A transport-level error has occurred when receiving results from the
server. (provider: TCP Provider, error: 0 - The specified network name
is no longer available.)
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
Boolean breakConnection) at
System.Data.SqlClient.TdsParser. ThrowExceptionAndWarning(TdsParserStateO
bject stateObj) at
System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateOb
ject stateObj, UInt32 error) at
System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult
asyncResult, TdsParserStateObject stateObj) at
System.Data.SqlClient.TdsParserStateObject.ReadPacket(Int32
bytesExpected) at System.Data.SqlClient.TdsParserStateObject.ReadByte()
at System.Data.SqlClient.TdsParser.GetTokenLength(Byte token,
TdsParserStateObject stateObj) at
System.Data.SqlClient.TdsParser.GetDataLength(SqlMetaDataPriv colmeta,
TdsParserStateObject stateObj) at
System.Data.SqlClient.TdsParser.ProcessColumnHeader(SqlMetaDataPriv col,
TdsParserStateObject stateObj, Boolean& isNull) at
System.Data.SqlClient.SqlDataReader.ReadColumnHeader(Int32 i) at
System.Data.SqlClient.SqlDataReader.ReadColumn(Int32 i, Boolean
setTimeout) at
System.Data.SqlClient.SqlDataReader.GetValueInternal(Int32 i) at
System.Data.SqlClient.SqlDataReader.GetValues(Object[] values) at
System.Data.ProviderBase.DataReaderContainer.CommonLanguageSubsetDataRea
der.GetValues(Object[] values) at
System.Data.ProviderBase.SchemaMapping.LoadDataRow() at
System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping) at
System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable
datatable, String srcTable, DataReaderContainer dataReader, Int32
startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object
parentChapterValue) at System.Data.Common.DataAdapter.Fill(DataTable[]
dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset,
DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String
srcTable, IDbCommand command, CommandBehavior behavior) at
System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32
startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior
behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
at private_enterprise_report_cmn_RepricingS
ummary.Page_Load(Object
sender, EventArgs e) in
*** Sent via Developersdex http://www.codecomments.com ***You would want to check the SQL Server error logs to make
sure it's not a refused connection from an issue like full
logs, out of disk space, etc. Those would be in the SQL log.
If you don't have anything there and it's random then you
may be experiencing network burps and dropping connections.
You can following the troubleshooting steps in the following
article:
How to troubleshoot network connectivity problems
http://support.microsoft.com/?id=325487
-Sue
On Mon, 23 Apr 2007 13:27:10 -0700, Audrey Ng
<odd26uk@.yahoo.co.uk> wrote:
>Hi all,
>I am getting the error below:
>I would like to also mention that this error is occuring randomly. I am
>running a web application under SQL Server 2005 and .NET framework 2.0.
>Has anyone encountered this issue.
>Error occurred during report data retrieving and binding.
>The actual error message is:
>A transport-level error has occurred when receiving results from the
>server. (provider: TCP Provider, error: 0 - The specified network name
>is no longer available.)
>at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
>Boolean breakConnection) at
>System.Data.SqlClient.TdsParser. ThrowExceptionAndWarning(TdsParserStateO
>bject stateObj) at
>System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateOb
>ject stateObj, UInt32 error) at
>System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult
>asyncResult, TdsParserStateObject stateObj) at
>System.Data.SqlClient.TdsParserStateObject.ReadPacket(Int32
>bytesExpected) at System.Data.SqlClient.TdsParserStateObject.ReadByte()
>at System.Data.SqlClient.TdsParser.GetTokenLength(Byte token,
>TdsParserStateObject stateObj) at
>System.Data.SqlClient.TdsParser.GetDataLength(SqlMetaDataPriv colmeta,
>TdsParserStateObject stateObj) at
>System.Data.SqlClient.TdsParser.ProcessColumnHeader(SqlMetaDataPriv col,
>TdsParserStateObject stateObj, Boolean& isNull) at
>System.Data.SqlClient.SqlDataReader.ReadColumnHeader(Int32 i) at
>System.Data.SqlClient.SqlDataReader.ReadColumn(Int32 i, Boolean
>setTimeout) at
>System.Data.SqlClient.SqlDataReader.GetValueInternal(Int32 i) at
>System.Data.SqlClient.SqlDataReader.GetValues(Object[] values) at
>System.Data.ProviderBase.DataReaderContainer.CommonLanguageSubsetDataRea
>der.GetValues(Object[] values) at
>System.Data.ProviderBase.SchemaMapping.LoadDataRow() at
>System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping) at
>System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable
>datatable, String srcTable, DataReaderContainer dataReader, Int32
>startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object
>parentChapterValue) at System.Data.Common.DataAdapter.Fill(DataTable[]
>dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
>at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset,
>DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String
>srcTable, IDbCommand command, CommandBehavior behavior) at
>System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32
>startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior
>behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
>at private_enterprise_report_cmn_RepricingS
ummary.Page_Load(Object
>sender, EventArgs e) in
>*** Sent via Developersdex http://www.codecomments.com ***|||I'm not sure if this is related to the issue but when I do try to
connect to my database server from a Remote Management Studio. I get the
same error
"A transport-level error has occurred when receiving results from the
server..."
Any ideas?
*** Sent via Developersdex http://www.codecomments.com ***|||You still need to go through the other steps - check the
logs, check the network connectivity, etc.
-Sue
On Tue, 24 Apr 2007 06:32:28 -0700, Audrey Ng
<odd26uk@.yahoo.co.uk> wrote:
>I'm not sure if this is related to the issue but when I do try to
>connect to my database server from a Remote Management Studio. I get the
>same error
>"A transport-level error has occurred when receiving results from the
>server..."
>Any ideas?
>
>*** Sent via Developersdex http://www.codecomments.com ***
I am getting the error below:
I would like to also mention that this error is occuring randomly. I am
running a web application under SQL Server 2005 and .NET framework 2.0.
Has anyone encountered this issue.
Error occurred during report data retrieving and binding.
The actual error message is:
A transport-level error has occurred when receiving results from the
server. (provider: TCP Provider, error: 0 - The specified network name
is no longer available.)
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
Boolean breakConnection) at
System.Data.SqlClient.TdsParser. ThrowExceptionAndWarning(TdsParserStateO
bject stateObj) at
System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateOb
ject stateObj, UInt32 error) at
System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult
asyncResult, TdsParserStateObject stateObj) at
System.Data.SqlClient.TdsParserStateObject.ReadPacket(Int32
bytesExpected) at System.Data.SqlClient.TdsParserStateObject.ReadByte()
at System.Data.SqlClient.TdsParser.GetTokenLength(Byte token,
TdsParserStateObject stateObj) at
System.Data.SqlClient.TdsParser.GetDataLength(SqlMetaDataPriv colmeta,
TdsParserStateObject stateObj) at
System.Data.SqlClient.TdsParser.ProcessColumnHeader(SqlMetaDataPriv col,
TdsParserStateObject stateObj, Boolean& isNull) at
System.Data.SqlClient.SqlDataReader.ReadColumnHeader(Int32 i) at
System.Data.SqlClient.SqlDataReader.ReadColumn(Int32 i, Boolean
setTimeout) at
System.Data.SqlClient.SqlDataReader.GetValueInternal(Int32 i) at
System.Data.SqlClient.SqlDataReader.GetValues(Object[] values) at
System.Data.ProviderBase.DataReaderContainer.CommonLanguageSubsetDataRea
der.GetValues(Object[] values) at
System.Data.ProviderBase.SchemaMapping.LoadDataRow() at
System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping) at
System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable
datatable, String srcTable, DataReaderContainer dataReader, Int32
startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object
parentChapterValue) at System.Data.Common.DataAdapter.Fill(DataTable[]
dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset,
DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String
srcTable, IDbCommand command, CommandBehavior behavior) at
System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32
startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior
behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
at private_enterprise_report_cmn_RepricingS
ummary.Page_Load(Object
sender, EventArgs e) in
*** Sent via Developersdex http://www.codecomments.com ***You would want to check the SQL Server error logs to make
sure it's not a refused connection from an issue like full
logs, out of disk space, etc. Those would be in the SQL log.
If you don't have anything there and it's random then you
may be experiencing network burps and dropping connections.
You can following the troubleshooting steps in the following
article:
How to troubleshoot network connectivity problems
http://support.microsoft.com/?id=325487
-Sue
On Mon, 23 Apr 2007 13:27:10 -0700, Audrey Ng
<odd26uk@.yahoo.co.uk> wrote:
>Hi all,
>I am getting the error below:
>I would like to also mention that this error is occuring randomly. I am
>running a web application under SQL Server 2005 and .NET framework 2.0.
>Has anyone encountered this issue.
>Error occurred during report data retrieving and binding.
>The actual error message is:
>A transport-level error has occurred when receiving results from the
>server. (provider: TCP Provider, error: 0 - The specified network name
>is no longer available.)
>at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
>Boolean breakConnection) at
>System.Data.SqlClient.TdsParser. ThrowExceptionAndWarning(TdsParserStateO
>bject stateObj) at
>System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateOb
>ject stateObj, UInt32 error) at
>System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult
>asyncResult, TdsParserStateObject stateObj) at
>System.Data.SqlClient.TdsParserStateObject.ReadPacket(Int32
>bytesExpected) at System.Data.SqlClient.TdsParserStateObject.ReadByte()
>at System.Data.SqlClient.TdsParser.GetTokenLength(Byte token,
>TdsParserStateObject stateObj) at
>System.Data.SqlClient.TdsParser.GetDataLength(SqlMetaDataPriv colmeta,
>TdsParserStateObject stateObj) at
>System.Data.SqlClient.TdsParser.ProcessColumnHeader(SqlMetaDataPriv col,
>TdsParserStateObject stateObj, Boolean& isNull) at
>System.Data.SqlClient.SqlDataReader.ReadColumnHeader(Int32 i) at
>System.Data.SqlClient.SqlDataReader.ReadColumn(Int32 i, Boolean
>setTimeout) at
>System.Data.SqlClient.SqlDataReader.GetValueInternal(Int32 i) at
>System.Data.SqlClient.SqlDataReader.GetValues(Object[] values) at
>System.Data.ProviderBase.DataReaderContainer.CommonLanguageSubsetDataRea
>der.GetValues(Object[] values) at
>System.Data.ProviderBase.SchemaMapping.LoadDataRow() at
>System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping) at
>System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable
>datatable, String srcTable, DataReaderContainer dataReader, Int32
>startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object
>parentChapterValue) at System.Data.Common.DataAdapter.Fill(DataTable[]
>dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
>at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset,
>DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String
>srcTable, IDbCommand command, CommandBehavior behavior) at
>System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32
>startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior
>behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
>at private_enterprise_report_cmn_RepricingS
ummary.Page_Load(Object
>sender, EventArgs e) in
>*** Sent via Developersdex http://www.codecomments.com ***|||I'm not sure if this is related to the issue but when I do try to
connect to my database server from a Remote Management Studio. I get the
same error
"A transport-level error has occurred when receiving results from the
server..."
Any ideas?
*** Sent via Developersdex http://www.codecomments.com ***|||You still need to go through the other steps - check the
logs, check the network connectivity, etc.
-Sue
On Tue, 24 Apr 2007 06:32:28 -0700, Audrey Ng
<odd26uk@.yahoo.co.uk> wrote:
>I'm not sure if this is related to the issue but when I do try to
>connect to my database server from a Remote Management Studio. I get the
>same error
>"A transport-level error has occurred when receiving results from the
>server..."
>Any ideas?
>
>*** Sent via Developersdex http://www.codecomments.com ***
Monday, March 19, 2012
A temporary database
Hi !
I use Sql 2000 Server as a database and an ASP.NET application with VB.NET language.
Now I am working with three pages with one form in every page that allows to register a user. To accomplish the registration the user needs to fill all the three pages, but now I am sending the data to the database in every page, so if a user leaves the process before reaching the third page it will have an invalid user entry into the database that I don t want. To avoid this I was recommended to store the in a temporary database file. I have been searching information about this but I have not found it.
Somebody can help me finding the necessary documentation to achieve it please?
ThanksOriginally posted by cesark29
Hi !
I use Sql 2000 Server as a database and an ASP.NET application with VB.NET language.
Now I am working with three pages with one form in every page that allows to register a user. To accomplish the registration the user needs to fill all the three pages, but now I am sending the data to the database in every page, so if a user leaves the process before reaching the third page it will have an invalid user entry into the database that I don t want. To avoid this I was recommended to store the in a temporary database file. I have been searching information about this but I have not found it.
Somebody can help me finding the necessary documentation to achieve it please?
Thanks
I have not worked on asp or any other front ends but what i feel is, u should hold all the data in these previous pages in some hidden variables or something and pass it when the user completes the whole registration process.|||I know that passing the data from one page to another is an option, but I think that is better to pass the minimum data as you can between pages. Anyway if you think that is a good option explain me in which cases a temporary database is used.
Thanks !|||Originally posted by cesark29
I know that passing the data from one page to another is an option, but I think that is better to pass the minimum data as you can between pages. Anyway if you think that is a good option explain me in which cases a temporary database is used.
Thanks !
using database for storing these values will make the page slower since it will have to go to the database three times.Instead, it is very common to use sessions for such scenarios.
Regarding temperory databases, they are used internally to hold temperory tables and temperory stored procedures.they are used to store any work tables or temperory tables used while processing
to know more about the temp database check out BOL under System databases and data.|||Good harshal, thank you very much.
I use Sql 2000 Server as a database and an ASP.NET application with VB.NET language.
Now I am working with three pages with one form in every page that allows to register a user. To accomplish the registration the user needs to fill all the three pages, but now I am sending the data to the database in every page, so if a user leaves the process before reaching the third page it will have an invalid user entry into the database that I don t want. To avoid this I was recommended to store the in a temporary database file. I have been searching information about this but I have not found it.
Somebody can help me finding the necessary documentation to achieve it please?
ThanksOriginally posted by cesark29
Hi !
I use Sql 2000 Server as a database and an ASP.NET application with VB.NET language.
Now I am working with three pages with one form in every page that allows to register a user. To accomplish the registration the user needs to fill all the three pages, but now I am sending the data to the database in every page, so if a user leaves the process before reaching the third page it will have an invalid user entry into the database that I don t want. To avoid this I was recommended to store the in a temporary database file. I have been searching information about this but I have not found it.
Somebody can help me finding the necessary documentation to achieve it please?
Thanks
I have not worked on asp or any other front ends but what i feel is, u should hold all the data in these previous pages in some hidden variables or something and pass it when the user completes the whole registration process.|||I know that passing the data from one page to another is an option, but I think that is better to pass the minimum data as you can between pages. Anyway if you think that is a good option explain me in which cases a temporary database is used.
Thanks !|||Originally posted by cesark29
I know that passing the data from one page to another is an option, but I think that is better to pass the minimum data as you can between pages. Anyway if you think that is a good option explain me in which cases a temporary database is used.
Thanks !
using database for storing these values will make the page slower since it will have to go to the database three times.Instead, it is very common to use sessions for such scenarios.
Regarding temperory databases, they are used internally to hold temperory tables and temperory stored procedures.they are used to store any work tables or temperory tables used while processing
to know more about the temp database check out BOL under System databases and data.|||Good harshal, thank you very much.
Thursday, March 8, 2012
A severe error occurred on the current command. The results, if any, should be discarded.
Hi,
I am hosting my ASP.NET application on a Host and after some time I get this error
(Don't get it on my development machine):
A severe error occurred on the current command. The results, if any, should be discarded.
And then it says this on the same page:
Exception Details: System.Data.SqlClient.SqlException: A severe error occurred on the current command. The results, if any, should be discarded.
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
[SqlException: A severe error occurred on the current command. The results, if any, should be discarded.]
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +643
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) +9
ASPNetPortal.PortalSettings..ctor(Int32 tabIndex, Int32 tabId)
ASPNetPortal.Global.Application_BeginRequest(Object sender, EventArgs e)
System.Web.SyncEventExecutionStep.Execute() +60
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
I thought this is a problem with max pool size and I did it max pool size = 5000, now application runs ok for some time and then produces this error but some times this comes very soon.
As a solution, I have to copy my dll in bin directory again and application restarts and works properly but then after some time this happenes again.
Please let me know whats the problem.
I checked all of my SqlDataReaders and SqlConnections are closed properly.
Any help would be appreciated.
Thanks.
Rahul.Rahul,
Getting a similar problem. I've narrowed it down to 3 stored procedures I wrote, others work fine. In the win2k server event view you should see a message
Error: 17805, Severity: 18, State: 3
2002-09-05 10:39:41.68 ods Invalid buffer received from client.
I've noticed that the StroProc often hangs when using the 'run stored procedure' function in the Explorer window in the V NET IDE. However the data still gets added. This would suggest the StorProc isn't returning a result to the code in time.
Like you our test server is fine. This runs SQL Server 2000 Developer Edition (SP1)
The production server runs SQL Server 7.0 (SP4)
Do your StroProcs use char or varchar types with a 50+ size or have a large number of parameters?
Regards
Richard|||Hi Richard,
Thanks a lot for your support.
Well! Certainly I am using varchar for 50+ size.
But I think I figured out the problem (still not sure) because since last two days I didn't get this error message, for this success I made some changes to my code.
If you think to discuss these changes would be worth then please let me know.
Thanks a lot again.
Rahul.|||So, did anyone ever figure the answer to this problem? I'm having the same issue, development server works fine (SQL2K), production server craps out (SQL7) with errors "Invalid Buffer received from client"|||If anyone's tracking this thread, here's an update: I moved the database to another production server running SQL2000, and it runs flawlessly. So the root cause is something in the way SQL7 handles SP's from .Net. More updates to come as I find them...|||We are having the same problem (with tables in our .NET Forums database) and found this info on a microsoft newsgroup)
Unfortunately the stricter datatype processing is a side effect of the 031
patch. We're working on a KB article to explain the behavior and scope.
Here is a draft of our work in progress:
KB 827366 – “Error 17805: Invalid Buffer Received from Client? Error
Message in SQL”
-----------------------
--
The information in this article applies to:
- Microsoft .NET Framework 1.0 (Version: 1.0)
- Microsoft .NET Framework 1.1
-----------------------
--
SYMPTOMS
========
When you use the SqlClient .NET Framework classes, the following error
messages may appear in the SQL Server 2000 error log:
Error: 17805, Severity: 20, State: 3
Invalid buffer received from client.
The following corresponding errors may appear in the client .NET
application:
System.Data.SqlClient.SqlException: A severe error occurred on
the current command. The results, if any, should be discarded
-or-
System.Data.SqlClient.SqlException: Procedure or function
spXXXX has too many arguments specified.
Note If you are using the .NET Framework 1.1 you only see the last error
message.
CAUSE
=====
There are three causes for these errors:
- You use SqlClient classes in a Finalize method or C# destructor. Do not
use any managed classes in a Finalize method or C# destructor.
- You do not specify an explicit SQLDbType for the parameters. In this
case, the SqlClient .NET provider tries to select the correct SQLDbType
based on the data that is passed and it will fail.
- If the size of the parameter that is specified explicitly in the .NET
code is more than the maximum allowable size for the data type in the SQL
Server.
- For example: According to SQL Server Books Online, nvarchar is a
Variable-length Unicode character data of n characters. n must be a value
from 1 through 4,000 If you specify a size that is more than 4000 for an
nvarchar parameter, then you will receive the error message that the
"Symptoms" section describes.
The following code also demonstrates how these errors can occur:
Stored Procedure
--------
PROCEDURE spParameterBug @.myText Text AS
Insert Into ParameterBugTable (TextField) Values
(@.myText)
Code
---
static void Main(string[] args)
{
string dummyText=string.Empty;
for (int n=0; n < /*80*/ 3277; n++) // change this to
80 to get the second error above
{
dummyText += "0123456789";
}
// TO DO: Change data source to match your SQL Server:
SqlConnection con= new SqlConnection("data
source=myserver;Initial Catalog=mydb;Integrated Security=SSPI;persist
security info=True;packet size=16384");
SqlCommand cmd = new SqlCommand("SpParameterBug", con);
// Correct invocation:
SqlParameter param =new SqlParameter("@.myText",
SqlDbType.Text);
param.Value = dummyText;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(param);
con.Open();
try
{
cmd.ExecuteNonQuery();
}
catch (Exception err)
{
Console.WriteLine(err.ToString());
}
// Causes error 17805:
SqlParameter param2 =new SqlParameter("@.myText",
dummyText);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(param2);
try
{
cmd.ExecuteNonQuery();
}
catch (Exception err)
{
Console.WriteLine(err.ToString());
}
Console.ReadLine();
}
RESOLUTION
==========
To resolve these errors, make sure that you do the following:
1. Do not use SqlClient classes in a Finalize method or a C# destructor.
2. Specify the SqlDbType for the SqlParameter so that there is no inferred
type.
3. Specify a parameter size that is within the allowable limits of the data
type.
REFERENCES
==========
For more information about the maximum size for different data types, see
these sections of SQL Books Online:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_
na-nop_9msy.asp: nchar and nvarchar
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_
da-db_7msw.asp: Data Types
Shawn Aebi
Microsoft
This posting is provided "AS IS" with no warranties, and confers no rights.|||Actually here is a link to the thread...
http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&threadm=IsYbP1AdDHA.2408%40cpmsftngxa06.phx.gbl&rnum=1&prev=/groups%3Fq%3Dsql%2Bserver%2B17805%26hl%3Den%26lr%3D%26ie%3DUTF-8%26oe%3DUTF-8%26scoring%3Dd%26selm%3DIsYbP1AdDHA.2408%2540cpmsftngxa06.phx.gbl%26rnum%3D1|||i faced the same error, but found that i was executing "return" in the middle of the transaction and thus the bug was fixed by completing the transaction.
Tuesday, March 6, 2012
A script to capture Orphan userids
Hello
We've had problems about orphan userids in Development SQL server. Application DBAs restore databases from Production SQL server a lot of time. So I'd like to set up an automation using a script to catch orphan ids.
Is it possible to use a script to capture(or select) orphan ids?
Thanks in advance,
Do.
Message posted via http://www.sqlmonster.com
Hi do Park,
You can use the stored procedure below to get a report
exec sp_change_users_login 'Report'
Details in the following article:
http://support.microsoft.com/default...b;en-us;314546
Yih-Yoon Lee
Do Park via SQLMonster.com wrote:
> Hello
> We've had problems about orphan userids in Development SQL server. Application DBAs restore databases from Production SQL server a lot of time. So I'd like to set up an automation using a script to catch orphan ids.
> Is it possible to use a script to capture(or select) orphan ids?
> Thanks in advance,
> Do.
>
|||There is a script to do this at www.sqlservercentral.com in their script
library...
Brad Feaker
Ex nihilo, nihil fit
"Do Park via SQLMonster.com" wrote:
> Hello
> We've had problems about orphan userids in Development SQL server. Application DBAs restore databases from Production SQL server a lot of time. So I'd like to set up an automation using a script to catch orphan ids.
> Is it possible to use a script to capture(or select) orphan ids?
> Thanks in advance,
> Do.
> --
> Message posted via http://www.sqlmonster.com
>
|||As Yih-Yoon Lee has posted, the solution is to use sp_change_users_login
I have found this article helpful. It contains a couple of stored
procedures that allow you to script logins and their SID. You can use these
to create logins on "downstream" (non-production) servers. As long as users
are created somewhere and their SIDs are carried forward you should not end
up with orphaned users.
HOW TO: Transfer Logins and Passwords Between Instances of SQL Server
http://www.support.microsoft.com/?id=246133
Keith
"Do Park via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:9ba509aa5f3a4496ba55516802843699@.SQLMonster.c om...
> Hello
> We've had problems about orphan userids in Development SQL server.
Application DBAs restore databases from Production SQL server a lot of time.
So I'd like to set up an automation using a script to catch orphan ids.
> Is it possible to use a script to capture(or select) orphan ids?
> Thanks in advance,
> Do.
> --
> Message posted via http://www.sqlmonster.com
We've had problems about orphan userids in Development SQL server. Application DBAs restore databases from Production SQL server a lot of time. So I'd like to set up an automation using a script to catch orphan ids.
Is it possible to use a script to capture(or select) orphan ids?
Thanks in advance,
Do.
Message posted via http://www.sqlmonster.com
Hi do Park,
You can use the stored procedure below to get a report
exec sp_change_users_login 'Report'
Details in the following article:
http://support.microsoft.com/default...b;en-us;314546
Yih-Yoon Lee
Do Park via SQLMonster.com wrote:
> Hello
> We've had problems about orphan userids in Development SQL server. Application DBAs restore databases from Production SQL server a lot of time. So I'd like to set up an automation using a script to catch orphan ids.
> Is it possible to use a script to capture(or select) orphan ids?
> Thanks in advance,
> Do.
>
|||There is a script to do this at www.sqlservercentral.com in their script
library...
Brad Feaker
Ex nihilo, nihil fit
"Do Park via SQLMonster.com" wrote:
> Hello
> We've had problems about orphan userids in Development SQL server. Application DBAs restore databases from Production SQL server a lot of time. So I'd like to set up an automation using a script to catch orphan ids.
> Is it possible to use a script to capture(or select) orphan ids?
> Thanks in advance,
> Do.
> --
> Message posted via http://www.sqlmonster.com
>
|||As Yih-Yoon Lee has posted, the solution is to use sp_change_users_login
I have found this article helpful. It contains a couple of stored
procedures that allow you to script logins and their SID. You can use these
to create logins on "downstream" (non-production) servers. As long as users
are created somewhere and their SIDs are carried forward you should not end
up with orphaned users.
HOW TO: Transfer Logins and Passwords Between Instances of SQL Server
http://www.support.microsoft.com/?id=246133
Keith
"Do Park via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:9ba509aa5f3a4496ba55516802843699@.SQLMonster.c om...
> Hello
> We've had problems about orphan userids in Development SQL server.
Application DBAs restore databases from Production SQL server a lot of time.
So I'd like to set up an automation using a script to catch orphan ids.
> Is it possible to use a script to capture(or select) orphan ids?
> Thanks in advance,
> Do.
> --
> Message posted via http://www.sqlmonster.com
Subscribe to:
Posts (Atom)