SQL SQLExpress: inside

Showing posts with label inside. Show all posts

Tuesday, March 27, 2012

@@IDENTITY in code

Hi all,

I encountered a problem with SQL server mobile.

I am inserting a row inside a database table through C# code and need to obtain the ID of the last inserted row if successful. I have the following in my code:

SqlCeHelper.ExecuteNonQuery(connectionString, "*INSERT STATEMENT*");

Int64 id = (Int64)SqlCeHelper.ExecuteScalar(connectionString, "SELECT @.@.IDENTITY");

The variable id always ends up NULL. Is this the correct approach to this? Is there anything else I can use to obtain the id of the last inserted row in SQL server mobile?

-- The class SqlCeHelper is a wrapper that I wrote, it works 100%.

Thanks

you should be using Identity_Scope() - its better. I havent worked with SqlCE but this is what I use, and is best used than @.@.Identity, and no idea if this works for SqlCe

My apologies if it does not

I also believe, perhaps I am wrong again, that you are executing 2 different queries, hence why you are receiving null for your last query - again, I may well be totally wrong here. It's a learning curve for me also

|||

Hi,

No...unfortunately SQL mobile doesn't support the function.

I though of the two separate statements as well. Is it possible to run two different SQL statements inside one command?

Thanks

|||

OK,

Fixed the problem. It really was executing these two statements totally separately.

The correct way to fix this is to add a couple lines inside my SQLCeHelper...

I now have something like this inside the SQLCeHelper:

publicstaticobject ExecuteInsert(string connectionString, string command, paramsSqlCeParameter[] commandParameters){

object retval = null;

try{

SqlCeConnection cn = newSqlCeConnection(connectionString);

SqlCeCommand c = newSqlCeCommand(command, cn);

foreach (SqlCeParameter p in commandParameters)

c.Parameters.Add(p);

cn.Open();

c.ExecuteNonQuery();

c = newSqlCeCommand("SELECT @.@.IDENTITY AS [IDENTITY]", cn);

retval = c.ExecuteScalar();

}

catch

{

throw;

}

return retval;

}

sql

Thursday, March 22, 2012

Embed PDF inside of SQL Server Report Servics Report

Hi ...

I posted this same question on the ASP.NET forum and haven't received an answer, so I thought I'ld move the discussion over to this forum. My question has been read several times, so I know I'm not the only one facing this problem, but nobody seems to know how to make it happen.

Anyhow, I'm building a system where we collect a great deal of meta data inside of SQL Server. The meta data is associated wtih files that the users can attach - image files and PDFs. I can get the image files to display properly, however I can find no way to actually display the contents of the PDF file as part of the report.

We want to print out the meta data as a header to the PDF and then print the PDF in it's entirety. As an example, we would print out:

Emergency Plan Name: xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Facility Name: xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Last Review Date: 99/99/9999 Reviewed By: xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

HERE IS WHERE I WOULD WANT TO PRINT OUT THE ASSOCIATED PDF's --

-- Emergency Plan --

-- Evacuation Plan 1 --

-- Evacuation Plan 2 --

I can print the file names - they are fields in the database, but how do I embed the actual PDF in to the report? They can print on different pages - I don't care about that, but I need to get them to be a part of the report.

Thanks ...

David

Any day above ground is a good day!

It's not possible to embed a PDF in a RS report.

If they're single page PDF's then you could try and code something clever that outputs them as images and embed the images.

Other than that I don't see a way of doing this.

|||Ok, so there is no built in functionality to handle embedding and outputting PDF's within reports built via SSRS. Has anyone seen any Custom Report Items that have been built that would allow me to have PDF's print in-line as part of the report?

Thanks ...

David
Any day above ground is a good day!|||

Beyond PDF embedding - where is a good site to review Custom Report Items? Either for purchase or open source?

Thanks ...

David

Any day above ground is a good day!

sql

Sunday, March 11, 2012

.NET Runtime Optimization error on SQL Server 2005

I posted this on the .NET Framework inside Sql Server forum as well. Sorry if the cross-post offends anybody.

I upgraded my primary production server this morning to SQL 2005. Everything went fairly smoothly, but a couple of hours after my installation was complete, I found the following error in my event log:

Source: .NET Runtime Optimization Service

EventID: 1101

.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile: Microsoft.ReportingServices.QueryDesigners, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 . Error code = 0x80070002

I am a little stumped since we did not install Reporting Services. We only installed Database Services, Integration Services and Workstation Components. I'm open to any suggestions on this. This does not seem to be negatively affecting our server, but I do want to resolve it as soon as possible.

Thanks,

Kevin

I'm getting the same message. Now I'm unable to modify or create tables.|||Hi,

try to restart the .NET RuntimeOptimization service. If this does not help you can also work without the service temporary. If you have a maintainance windows and can make a reboot of your server, that would be my next step.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

I have just installed Reporting Services 2005, SP1, and Rollup fix 2153. Also I have rebooted the machine and I am still getting the event log message which was posted at the beginning of this thread. Do we have a status or resolution for this.

Thanks

Steve

|||Have you try to stop/start ".Net Runtime Optimization Server v2.0.50727_X86" yet? This service usually set to "manual" and not started.|||I have the same problem and none of the above works. Any other ideas from anyone?|||

Hello,

I am running my Asp.Net website on IIS5.1 and Sql Server 2005 for about 6 months now, and it works fine on 3 machines.

I recently installed another machine with identical configuration and created the project from VSS. I get the above error whenever I try to debug. As soon as I start debugging, the .NET Runtime Optimization Service enters stopped state with above error. The following is the exact error in Application Event Viewer:

Any help would be greatly appreciated!!!

|||

We just applied SP1 for SQL Server 2005 on our production server after a successful installation on our test servers and started to get the same error:

.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile

We haven't attempted any type of fix yet, waiting to see if anyone else has fixed it yet.

|||

The problem was fixed when I reinstalled Sql Server. Apparently some error during installation, couldnt figure it out.

I think the sequence of installation matters. When I install an XP machine, I stick to the following installation sequence:

Xp->SP2->IIS->MSOffice->OfficeSP->MS Sql Server 2000->Visual Studio->MSDN->VSS->Enterprise Library

Probably This sequence doesnt work for Sql Server 2005

|||Hi
how do you have reinstalled the SQL Server?
Do you have deinstalled/installed the server or how?
We have 3 Instances with diffrent DB′s and i don′t want to crash them.

Thanks for help|||

Best bet is to identify the instance has to be un-installed. In add-remove programs the instances are shown separately. What I did was to stop the sql server in question and save all the LDF and MDF files in a separate folder.

After uninstalling I made sure that corresponding directories and registry entries were completely removed. Then I verified that I am in the correct order, and initiated the installation. I have mentioned the order of installation in my previous message. No need to uninstall .Net framework 2.0 incase already installed. Also, verify that the latest OS service pack is in place before initiate the install.

Once complete, I copied the LDF and MDF files back into the data folder and re-attached the databases. That worked for me.

Hope I have answered your question

|||thanks. but i see that doesn′t work for SQL2k5? We have it :(

regards|||Looks like I am getting this error message after installing service pack 1 on SQL 2005. So uninstall and re-install is the answer? I tried to repair the .NET 2.0 framework, but still get the error. Not sure if this is a show stopper, but this is a new server with fresh install of everything. I would hate to have an error like this cause problems in the future.|||

Hi,

Just come across this after seeing the same error in my event log during standard system reviews. I don't have any noticeable effects, but when reviewing the full sequence of .Net optimisations there are two distinct groupings of compilations, one where the version is clr_optimization_v2.0.50727_32 and one where the version is clr_optimization_v2.0.50727_64 . As I'm running an x64 box might it be that this error is not a problem as it seems to be occuring on the 32bit version of the optimisation and not on the 64bit version?

Would be interesting to know what systems people are running that this error is occuring on, 32bit or 64 bit.

HTH someone else.

Regards

Nick

DBA - United Co-op Ltd

MCDBA

|||

I have the same problem, after Installing SQL 2005 SP1 on Clustermachines.

However my SQL-Cluster has a problem moving groups, which I hold responsible for failing to install the SP1 on the Database Engines.

I have 32 Bit Machines.

I find interesting though that my BTS 2006 Machines that use the SQL Servers have the same Problem too, even they don't have any SQL Server on it themselves.

Is it feasable to believe that the Problem is maybe in some other Patch we installed that affects the SQL Client Components?

I have also installed the Hotfix NDP20-KB918642-X86_bugfix.exe which is supposed to fix the annoying Shim Database Error Message (you know it?).

Any new suggestions, workarounds, patches?

.NET Runtime Optimization error on SQL Server 2005

I posted this on the .NET Framework inside Sql Server forum as well. Sorry if the cross-post offends anybody.

Source: .NET Runtime Optimization Service

EventID: 1101

Thanks,

Kevin

I'm getting the same message. Now I'm unable to modify or create tables.|||Hi,

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
|||

Thanks

Steve

Hello,

I am running my Asp.Net website on IIS5.1 and Sql Server 2005 for about 6 months now, and it works fine on 3 machines.

Any help would be greatly appreciated!!!

|||

We just applied SP1 for SQL Server 2005 on our production server after a successful installation on our test servers and started to get the same error:

.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile

We haven't attempted any type of fix yet, waiting to see if anyone else has fixed it yet.

|||

The problem was fixed when I reinstalled Sql Server. Apparently some error during installation, couldnt figure it out.

I think the sequence of installation matters. When I install an XP machine, I stick to the following installation sequence:

Xp->SP2->IIS->MSOffice->OfficeSP->MS Sql Server 2000->Visual Studio->MSDN->VSS->Enterprise Library

Probably This sequence doesnt work for Sql Server 2005

|||Hi
how do you have reinstalled the SQL Server?
Do you have deinstalled/installed the server or how?
We have 3 Instances with diffrent DB′s and i don′t want to crash them.

Thanks for help
|||

Once complete, I copied the LDF and MDF files back into the data folder and re-attached the databases. That worked for me.

Hope I have answered your question

|||thanks. but i see that doesn′t work for SQL2k5? We have it :(

regards
|||Looks like I am getting this error message after installing service pack 1 on SQL 2005. So uninstall and re-install is the answer? I tried to repair the .NET 2.0 framework, but still get the error. Not sure if this is a show stopper, but this is a new server with fresh install of everything. I would hate to have an error like this cause problems in the future.|||

Hi,

Would be interesting to know what systems people are running that this error is occuring on, 32bit or 64 bit.

HTH someone else.

Regards

Nick

DBA - United Co-op Ltd

MCDBA

|||

I have the same problem, after Installing SQL 2005 SP1 on Clustermachines.

However my SQL-Cluster has a problem moving groups, which I hold responsible for failing to install the SP1 on the Database Engines.

I have 32 Bit Machines.

I find interesting though that my BTS 2006 Machines that use the SQL Servers have the same Problem too, even they don't have any SQL Server on it themselves.

Is it feasable to believe that the Problem is maybe in some other Patch we installed that affects the SQL Client Components?

I have also installed the Hotfix NDP20-KB918642-X86_bugfix.exe which is supposed to fix the annoying Shim Database Error Message (you know it?).

Any new suggestions, workarounds, patches?

.NET Runtime Optimization error on SQL Server 2005

I posted this on the .NET Framework inside Sql Server forum as well. Sorry if the cross-post offends anybody.

Source: .NET Runtime Optimization Service

EventID: 1101

Thanks,

Kevin

I'm getting the same message. Now I'm unable to modify or create tables.|||Hi,

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
|||

Thanks

Steve

Hello,

I am running my Asp.Net website on IIS5.1 and Sql Server 2005 for about 6 months now, and it works fine on 3 machines.

Any help would be greatly appreciated!!!

|||

We just applied SP1 for SQL Server 2005 on our production server after a successful installation on our test servers and started to get the same error:

.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile

We haven't attempted any type of fix yet, waiting to see if anyone else has fixed it yet.

|||

The problem was fixed when I reinstalled Sql Server. Apparently some error during installation, couldnt figure it out.

I think the sequence of installation matters. When I install an XP machine, I stick to the following installation sequence:

Xp->SP2->IIS->MSOffice->OfficeSP->MS Sql Server 2000->Visual Studio->MSDN->VSS->Enterprise Library

Probably This sequence doesnt work for Sql Server 2005

|||Hi
how do you have reinstalled the SQL Server?
Do you have deinstalled/installed the server or how?
We have 3 Instances with diffrent DB′s and i don′t want to crash them.

Thanks for help
|||

Once complete, I copied the LDF and MDF files back into the data folder and re-attached the databases. That worked for me.

Hope I have answered your question

|||thanks. but i see that doesn′t work for SQL2k5? We have it :(

regards
|||Looks like I am getting this error message after installing service pack 1 on SQL 2005. So uninstall and re-install is the answer? I tried to repair the .NET 2.0 framework, but still get the error. Not sure if this is a show stopper, but this is a new server with fresh install of everything. I would hate to have an error like this cause problems in the future.|||

Hi,

Would be interesting to know what systems people are running that this error is occuring on, 32bit or 64 bit.

HTH someone else.

Regards

Nick

DBA - United Co-op Ltd

MCDBA

|||

I have the same problem, after Installing SQL 2005 SP1 on Clustermachines.

However my SQL-Cluster has a problem moving groups, which I hold responsible for failing to install the SP1 on the Database Engines.

I have 32 Bit Machines.

I find interesting though that my BTS 2006 Machines that use the SQL Servers have the same Problem too, even they don't have any SQL Server on it themselves.

Is it feasable to believe that the Problem is maybe in some other Patch we installed that affects the SQL Client Components?

I have also installed the Hotfix NDP20-KB918642-X86_bugfix.exe which is supposed to fix the annoying Shim Database Error Message (you know it?).

Any new suggestions, workarounds, patches?

.NET Runtime Optimization error on SQL Server 2005

I posted this on the .NET Framework inside Sql Server forum as well. Sorry if the cross-post offends anybody.

Source: .NET Runtime Optimization Service

EventID: 1101

Thanks,

Kevin

I'm getting the same message. Now I'm unable to modify or create tables.|||Hi,

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

Thanks

Steve

Hello,

I am running my Asp.Net website on IIS5.1 and Sql Server 2005 for about 6 months now, and it works fine on 3 machines.

Any help would be greatly appreciated!!!

|||

We just applied SP1 for SQL Server 2005 on our production server after a successful installation on our test servers and started to get the same error:

.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile

We haven't attempted any type of fix yet, waiting to see if anyone else has fixed it yet.

|||

The problem was fixed when I reinstalled Sql Server. Apparently some error during installation, couldnt figure it out.

I think the sequence of installation matters. When I install an XP machine, I stick to the following installation sequence:

Xp->SP2->IIS->MSOffice->OfficeSP->MS Sql Server 2000->Visual Studio->MSDN->VSS->Enterprise Library

Probably This sequence doesnt work for Sql Server 2005

|||Hi
how do you have reinstalled the SQL Server?
Do you have deinstalled/installed the server or how?
We have 3 Instances with diffrent DB′s and i don′t want to crash them.

Thanks for help|||

Once complete, I copied the LDF and MDF files back into the data folder and re-attached the databases. That worked for me.

Hope I have answered your question

|||thanks. but i see that doesn′t work for SQL2k5? We have it :(

Hi,

Would be interesting to know what systems people are running that this error is occuring on, 32bit or 64 bit.

HTH someone else.

Regards

Nick

DBA - United Co-op Ltd

MCDBA

|||

I have the same problem, after Installing SQL 2005 SP1 on Clustermachines.

However my SQL-Cluster has a problem moving groups, which I hold responsible for failing to install the SP1 on the Database Engines.

I have 32 Bit Machines.

I find interesting though that my BTS 2006 Machines that use the SQL Servers have the same Problem too, even they don't have any SQL Server on it themselves.

Is it feasable to believe that the Problem is maybe in some other Patch we installed that affects the SQL Client Components?

I have also installed the Hotfix NDP20-KB918642-X86_bugfix.exe which is supposed to fix the annoying Shim Database Error Message (you know it?).

Any new suggestions, workarounds, patches?

.NET Runtime Optimization error on SQL Server 2005

I posted this on the .NET Framework inside Sql Server forum as well. Sorry if the cross-post offends anybody.

Source: .NET Runtime Optimization Service

EventID: 1101

Thanks,

Kevin

I'm getting the same message. Now I'm unable to modify or create tables.|||Hi,

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
|||

Thanks

Steve

Hello,

I am running my Asp.Net website on IIS5.1 and Sql Server 2005 for about 6 months now, and it works fine on 3 machines.

Any help would be greatly appreciated!!!

|||

We just applied SP1 for SQL Server 2005 on our production server after a successful installation on our test servers and started to get the same error:

.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile

We haven't attempted any type of fix yet, waiting to see if anyone else has fixed it yet.

|||

The problem was fixed when I reinstalled Sql Server. Apparently some error during installation, couldnt figure it out.

I think the sequence of installation matters. When I install an XP machine, I stick to the following installation sequence:

Xp->SP2->IIS->MSOffice->OfficeSP->MS Sql Server 2000->Visual Studio->MSDN->VSS->Enterprise Library

Probably This sequence doesnt work for Sql Server 2005

|||Hi
how do you have reinstalled the SQL Server?
Do you have deinstalled/installed the server or how?
We have 3 Instances with diffrent DB′s and i don′t want to crash them.

Thanks for help
|||

Once complete, I copied the LDF and MDF files back into the data folder and re-attached the databases. That worked for me.

Hope I have answered your question

|||thanks. but i see that doesn′t work for SQL2k5? We have it :(

regards
|||Looks like I am getting this error message after installing service pack 1 on SQL 2005. So uninstall and re-install is the answer? I tried to repair the .NET 2.0 framework, but still get the error. Not sure if this is a show stopper, but this is a new server with fresh install of everything. I would hate to have an error like this cause problems in the future.|||

Hi,

Would be interesting to know what systems people are running that this error is occuring on, 32bit or 64 bit.

HTH someone else.

Regards

Nick

DBA - United Co-op Ltd

MCDBA

|||

I have the same problem, after Installing SQL 2005 SP1 on Clustermachines.

However my SQL-Cluster has a problem moving groups, which I hold responsible for failing to install the SP1 on the Database Engines.

I have 32 Bit Machines.

I find interesting though that my BTS 2006 Machines that use the SQL Servers have the same Problem too, even they don't have any SQL Server on it themselves.

Is it feasable to believe that the Problem is maybe in some other Patch we installed that affects the SQL Client Components?

I have also installed the Hotfix NDP20-KB918642-X86_bugfix.exe which is supposed to fix the annoying Shim Database Error Message (you know it?).

Any new suggestions, workarounds, patches?

.NET Runtime Optimization error on SQL Server 2005

I posted this on the .NET Framework inside Sql Server forum as well. Sorry if the cross-post offends anybody.

Source: .NET Runtime Optimization Service

EventID: 1101

Thanks,

Kevin

I'm getting the same message. Now I'm unable to modify or create tables.|||Hi,

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

Thanks

Steve

Hello,

I am running my Asp.Net website on IIS5.1 and Sql Server 2005 for about 6 months now, and it works fine on 3 machines.

Any help would be greatly appreciated!!!

|||

We just applied SP1 for SQL Server 2005 on our production server after a successful installation on our test servers and started to get the same error:

.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile

We haven't attempted any type of fix yet, waiting to see if anyone else has fixed it yet.

|||

The problem was fixed when I reinstalled Sql Server. Apparently some error during installation, couldnt figure it out.

I think the sequence of installation matters. When I install an XP machine, I stick to the following installation sequence:

Xp->SP2->IIS->MSOffice->OfficeSP->MS Sql Server 2000->Visual Studio->MSDN->VSS->Enterprise Library

Probably This sequence doesnt work for Sql Server 2005

|||Hi
how do you have reinstalled the SQL Server?
Do you have deinstalled/installed the server or how?
We have 3 Instances with diffrent DB′s and i don′t want to crash them.

Thanks for help|||

Once complete, I copied the LDF and MDF files back into the data folder and re-attached the databases. That worked for me.

Hope I have answered your question

|||thanks. but i see that doesn′t work for SQL2k5? We have it :(

Hi,

Would be interesting to know what systems people are running that this error is occuring on, 32bit or 64 bit.

HTH someone else.

Regards

Nick

DBA - United Co-op Ltd

MCDBA

|||

I have the same problem, after Installing SQL 2005 SP1 on Clustermachines.

However my SQL-Cluster has a problem moving groups, which I hold responsible for failing to install the SP1 on the Database Engines.

I have 32 Bit Machines.

I find interesting though that my BTS 2006 Machines that use the SQL Servers have the same Problem too, even they don't have any SQL Server on it themselves.

Is it feasable to believe that the Problem is maybe in some other Patch we installed that affects the SQL Client Components?

I have also installed the Hotfix NDP20-KB918642-X86_bugfix.exe which is supposed to fix the annoying Shim Database Error Message (you know it?).

Any new suggestions, workarounds, patches?

.NET Runtime Optimization error on SQL Server 2005

I posted this on the .NET Framework inside Sql Server forum as well. Sorry if the cross-post offends anybody.

Source: .NET Runtime Optimization Service

EventID: 1101

Thanks,

Kevin

I'm getting the same message. Now I'm unable to modify or create tables.|||Hi,

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
|||

Thanks

Steve

Hello,

I am running my Asp.Net website on IIS5.1 and Sql Server 2005 for about 6 months now, and it works fine on 3 machines.

Any help would be greatly appreciated!!!

|||

We just applied SP1 for SQL Server 2005 on our production server after a successful installation on our test servers and started to get the same error:

.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile

We haven't attempted any type of fix yet, waiting to see if anyone else has fixed it yet.

|||

The problem was fixed when I reinstalled Sql Server. Apparently some error during installation, couldnt figure it out.

I think the sequence of installation matters. When I install an XP machine, I stick to the following installation sequence:

Xp->SP2->IIS->MSOffice->OfficeSP->MS Sql Server 2000->Visual Studio->MSDN->VSS->Enterprise Library

Probably This sequence doesnt work for Sql Server 2005

|||Hi
how do you have reinstalled the SQL Server?
Do you have deinstalled/installed the server or how?
We have 3 Instances with diffrent DB′s and i don′t want to crash them.

Thanks for help
|||

Once complete, I copied the LDF and MDF files back into the data folder and re-attached the databases. That worked for me.

Hope I have answered your question

|||thanks. but i see that doesn′t work for SQL2k5? We have it :(

regards
|||Looks like I am getting this error message after installing service pack 1 on SQL 2005. So uninstall and re-install is the answer? I tried to repair the .NET 2.0 framework, but still get the error. Not sure if this is a show stopper, but this is a new server with fresh install of everything. I would hate to have an error like this cause problems in the future.|||

Hi,

Would be interesting to know what systems people are running that this error is occuring on, 32bit or 64 bit.

HTH someone else.

Regards

Nick

DBA - United Co-op Ltd

MCDBA

|||

I have the same problem, after Installing SQL 2005 SP1 on Clustermachines.

However my SQL-Cluster has a problem moving groups, which I hold responsible for failing to install the SP1 on the Database Engines.

I have 32 Bit Machines.

I find interesting though that my BTS 2006 Machines that use the SQL Servers have the same Problem too, even they don't have any SQL Server on it themselves.

Is it feasable to believe that the Problem is maybe in some other Patch we installed that affects the SQL Client Components?

I have also installed the Hotfix NDP20-KB918642-X86_bugfix.exe which is supposed to fix the annoying Shim Database Error Message (you know it?).

Any new suggestions, workarounds, patches?

.NET Runtime Optimization error on SQL Server 2005

I posted this on the .NET Framework inside Sql Server forum as well. Sorry if the cross-post offends anybody.

Source: .NET Runtime Optimization Service

EventID: 1101

Thanks,

Kevin

I'm getting the same message. Now I'm unable to modify or create tables.|||Hi,

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
|||

Thanks

Steve

Hello,

I am running my Asp.Net website on IIS5.1 and Sql Server 2005 for about 6 months now, and it works fine on 3 machines.

Any help would be greatly appreciated!!!

|||

We just applied SP1 for SQL Server 2005 on our production server after a successful installation on our test servers and started to get the same error:

.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile

We haven't attempted any type of fix yet, waiting to see if anyone else has fixed it yet.

|||

The problem was fixed when I reinstalled Sql Server. Apparently some error during installation, couldnt figure it out.

I think the sequence of installation matters. When I install an XP machine, I stick to the following installation sequence:

Xp->SP2->IIS->MSOffice->OfficeSP->MS Sql Server 2000->Visual Studio->MSDN->VSS->Enterprise Library

Probably This sequence doesnt work for Sql Server 2005

|||Hi
how do you have reinstalled the SQL Server?
Do you have deinstalled/installed the server or how?
We have 3 Instances with diffrent DB′s and i don′t want to crash them.

Thanks for help
|||

Once complete, I copied the LDF and MDF files back into the data folder and re-attached the databases. That worked for me.

Hope I have answered your question

|||thanks. but i see that doesn′t work for SQL2k5? We have it :(

regards
|||Looks like I am getting this error message after installing service pack 1 on SQL 2005. So uninstall and re-install is the answer? I tried to repair the .NET 2.0 framework, but still get the error. Not sure if this is a show stopper, but this is a new server with fresh install of everything. I would hate to have an error like this cause problems in the future.|||

Hi,

Would be interesting to know what systems people are running that this error is occuring on, 32bit or 64 bit.

HTH someone else.

Regards

Nick

DBA - United Co-op Ltd

MCDBA

|||

I have the same problem, after Installing SQL 2005 SP1 on Clustermachines.

However my SQL-Cluster has a problem moving groups, which I hold responsible for failing to install the SP1 on the Database Engines.

I have 32 Bit Machines.

I find interesting though that my BTS 2006 Machines that use the SQL Servers have the same Problem too, even they don't have any SQL Server on it themselves.

Is it feasable to believe that the Problem is maybe in some other Patch we installed that affects the SQL Client Components?

I have also installed the Hotfix NDP20-KB918642-X86_bugfix.exe which is supposed to fix the annoying Shim Database Error Message (you know it?).

Any new suggestions, workarounds, patches?

.NET Runtime Optimization error on SQL Server 2005

I posted this on the .NET Framework inside Sql Server forum as well. Sorry if the cross-post offends anybody.

Source: .NET Runtime Optimization Service

EventID: 1101

Thanks,

Kevin

I'm getting the same message. Now I'm unable to modify or create tables.|||Hi,

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
|||

Thanks

Steve

Hello,

I am running my Asp.Net website on IIS5.1 and Sql Server 2005 for about 6 months now, and it works fine on 3 machines.

Any help would be greatly appreciated!!!

|||

We just applied SP1 for SQL Server 2005 on our production server after a successful installation on our test servers and started to get the same error:

.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile

We haven't attempted any type of fix yet, waiting to see if anyone else has fixed it yet.

|||

The problem was fixed when I reinstalled Sql Server. Apparently some error during installation, couldnt figure it out.

I think the sequence of installation matters. When I install an XP machine, I stick to the following installation sequence:

Xp->SP2->IIS->MSOffice->OfficeSP->MS Sql Server 2000->Visual Studio->MSDN->VSS->Enterprise Library

Probably This sequence doesnt work for Sql Server 2005

|||Hi
how do you have reinstalled the SQL Server?
Do you have deinstalled/installed the server or how?
We have 3 Instances with diffrent DB′s and i don′t want to crash them.

Thanks for help
|||

Once complete, I copied the LDF and MDF files back into the data folder and re-attached the databases. That worked for me.

Hope I have answered your question

|||thanks. but i see that doesn′t work for SQL2k5? We have it :(

regards
|||Looks like I am getting this error message after installing service pack 1 on SQL 2005. So uninstall and re-install is the answer? I tried to repair the .NET 2.0 framework, but still get the error. Not sure if this is a show stopper, but this is a new server with fresh install of everything. I would hate to have an error like this cause problems in the future.|||

Hi,

Would be interesting to know what systems people are running that this error is occuring on, 32bit or 64 bit.

HTH someone else.

Regards

Nick

DBA - United Co-op Ltd

MCDBA

|||

I have the same problem, after Installing SQL 2005 SP1 on Clustermachines.

However my SQL-Cluster has a problem moving groups, which I hold responsible for failing to install the SP1 on the Database Engines.

I have 32 Bit Machines.

I find interesting though that my BTS 2006 Machines that use the SQL Servers have the same Problem too, even they don't have any SQL Server on it themselves.

Is it feasable to believe that the Problem is maybe in some other Patch we installed that affects the SQL Client Components?

I have also installed the Hotfix NDP20-KB918642-X86_bugfix.exe which is supposed to fix the annoying Shim Database Error Message (you know it?).

Any new suggestions, workarounds, patches?

.NET Runtime Optimization error on SQL Server 2005

I posted this on the .NET Framework inside Sql Server forum as well. Sorry if the cross-post offends anybody.

Source: .NET Runtime Optimization Service

EventID: 1101

Thanks,

Kevin

I'm getting the same message. Now I'm unable to modify or create tables.|||Hi,

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

Thanks

Steve

Hello,

I am running my Asp.Net website on IIS5.1 and Sql Server 2005 for about 6 months now, and it works fine on 3 machines.

Any help would be greatly appreciated!!!

|||

We just applied SP1 for SQL Server 2005 on our production server after a successful installation on our test servers and started to get the same error:

.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile

We haven't attempted any type of fix yet, waiting to see if anyone else has fixed it yet.

|||

The problem was fixed when I reinstalled Sql Server. Apparently some error during installation, couldnt figure it out.

I think the sequence of installation matters. When I install an XP machine, I stick to the following installation sequence:

Xp->SP2->IIS->MSOffice->OfficeSP->MS Sql Server 2000->Visual Studio->MSDN->VSS->Enterprise Library

Probably This sequence doesnt work for Sql Server 2005

|||Hi
how do you have reinstalled the SQL Server?
Do you have deinstalled/installed the server or how?
We have 3 Instances with diffrent DB′s and i don′t want to crash them.

Thanks for help|||

Once complete, I copied the LDF and MDF files back into the data folder and re-attached the databases. That worked for me.

Hope I have answered your question

|||thanks. but i see that doesn′t work for SQL2k5? We have it :(

Hi,

Would be interesting to know what systems people are running that this error is occuring on, 32bit or 64 bit.

HTH someone else.

Regards

Nick

DBA - United Co-op Ltd

MCDBA

|||

I have the same problem, after Installing SQL 2005 SP1 on Clustermachines.

However my SQL-Cluster has a problem moving groups, which I hold responsible for failing to install the SP1 on the Database Engines.

I have 32 Bit Machines.

I find interesting though that my BTS 2006 Machines that use the SQL Servers have the same Problem too, even they don't have any SQL Server on it themselves.

Is it feasable to believe that the Problem is maybe in some other Patch we installed that affects the SQL Client Components?

I have also installed the Hotfix NDP20-KB918642-X86_bugfix.exe which is supposed to fix the annoying Shim Database Error Message (you know it?).

Any new suggestions, workarounds, patches?

.NET Runtime Optimization error on SQL Server 2005

I posted this on the .NET Framework inside Sql Server forum as well. Sorry if the cross-post offends anybody.

Source: .NET Runtime Optimization Service

EventID: 1101

Thanks,

Kevin

I'm getting the same message. Now I'm unable to modify or create tables.|||Hi,

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
|||

Thanks

Steve

Hello,

I am running my Asp.Net website on IIS5.1 and Sql Server 2005 for about 6 months now, and it works fine on 3 machines.

Any help would be greatly appreciated!!!

|||

We just applied SP1 for SQL Server 2005 on our production server after a successful installation on our test servers and started to get the same error:

.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile

We haven't attempted any type of fix yet, waiting to see if anyone else has fixed it yet.

|||

The problem was fixed when I reinstalled Sql Server. Apparently some error during installation, couldnt figure it out.

I think the sequence of installation matters. When I install an XP machine, I stick to the following installation sequence:

Xp->SP2->IIS->MSOffice->OfficeSP->MS Sql Server 2000->Visual Studio->MSDN->VSS->Enterprise Library

Probably This sequence doesnt work for Sql Server 2005

|||Hi
how do you have reinstalled the SQL Server?
Do you have deinstalled/installed the server or how?
We have 3 Instances with diffrent DB′s and i don′t want to crash them.

Thanks for help
|||

Once complete, I copied the LDF and MDF files back into the data folder and re-attached the databases. That worked for me.

Hope I have answered your question

|||thanks. but i see that doesn′t work for SQL2k5? We have it :(

regards
|||Looks like I am getting this error message after installing service pack 1 on SQL 2005. So uninstall and re-install is the answer? I tried to repair the .NET 2.0 framework, but still get the error. Not sure if this is a show stopper, but this is a new server with fresh install of everything. I would hate to have an error like this cause problems in the future.|||

Hi,

Would be interesting to know what systems people are running that this error is occuring on, 32bit or 64 bit.

HTH someone else.

Regards

Nick

DBA - United Co-op Ltd

MCDBA

|||

I have the same problem, after Installing SQL 2005 SP1 on Clustermachines.

However my SQL-Cluster has a problem moving groups, which I hold responsible for failing to install the SP1 on the Database Engines.

I have 32 Bit Machines.

I find interesting though that my BTS 2006 Machines that use the SQL Servers have the same Problem too, even they don't have any SQL Server on it themselves.

Is it feasable to believe that the Problem is maybe in some other Patch we installed that affects the SQL Client Components?

I have also installed the Hotfix NDP20-KB918642-X86_bugfix.exe which is supposed to fix the annoying Shim Database Error Message (you know it?).

Any new suggestions, workarounds, patches?

.NET Runtime Optimization error on SQL Server 2005

I posted this on the .NET Framework inside Sql Server forum as well. Sorry if the cross-post offends anybody.

Source: .NET Runtime Optimization Service

EventID: 1101

Thanks,

Kevin

I'm getting the same message. Now I'm unable to modify or create tables.|||Hi,

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

Thanks

Steve

Hello,

I am running my Asp.Net website on IIS5.1 and Sql Server 2005 for about 6 months now, and it works fine on 3 machines.

Any help would be greatly appreciated!!!

|||

We just applied SP1 for SQL Server 2005 on our production server after a successful installation on our test servers and started to get the same error:

.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile

We haven't attempted any type of fix yet, waiting to see if anyone else has fixed it yet.

|||

The problem was fixed when I reinstalled Sql Server. Apparently some error during installation, couldnt figure it out.

I think the sequence of installation matters. When I install an XP machine, I stick to the following installation sequence:

Xp->SP2->IIS->MSOffice->OfficeSP->MS Sql Server 2000->Visual Studio->MSDN->VSS->Enterprise Library

Probably This sequence doesnt work for Sql Server 2005

|||Hi
how do you have reinstalled the SQL Server?
Do you have deinstalled/installed the server or how?
We have 3 Instances with diffrent DB′s and i don′t want to crash them.

Thanks for help|||

Once complete, I copied the LDF and MDF files back into the data folder and re-attached the databases. That worked for me.

Hope I have answered your question

|||thanks. but i see that doesn′t work for SQL2k5? We have it :(

Hi,

Would be interesting to know what systems people are running that this error is occuring on, 32bit or 64 bit.

HTH someone else.

Regards

Nick

DBA - United Co-op Ltd

MCDBA

|||

I have the same problem, after Installing SQL 2005 SP1 on Clustermachines.

However my SQL-Cluster has a problem moving groups, which I hold responsible for failing to install the SP1 on the Database Engines.

I have 32 Bit Machines.

I find interesting though that my BTS 2006 Machines that use the SQL Servers have the same Problem too, even they don't have any SQL Server on it themselves.

Is it feasable to believe that the Problem is maybe in some other Patch we installed that affects the SQL Client Components?

I have also installed the Hotfix NDP20-KB918642-X86_bugfix.exe which is supposed to fix the annoying Shim Database Error Message (you know it?).

Any new suggestions, workarounds, patches?

.NET Runtime Optimization error on SQL Server 2005

I posted this on the .NET Framework inside Sql Server forum as well. Sorry if the cross-post offends anybody.

Source: .NET Runtime Optimization Service

EventID: 1101

Thanks,

Kevin

I'm getting the same message. Now I'm unable to modify or create tables.|||Hi,

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

Thanks

Steve

Hello,

I am running my Asp.Net website on IIS5.1 and Sql Server 2005 for about 6 months now, and it works fine on 3 machines.

Any help would be greatly appreciated!!!

|||

We just applied SP1 for SQL Server 2005 on our production server after a successful installation on our test servers and started to get the same error:

.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile

We haven't attempted any type of fix yet, waiting to see if anyone else has fixed it yet.

|||

The problem was fixed when I reinstalled Sql Server. Apparently some error during installation, couldnt figure it out.

I think the sequence of installation matters. When I install an XP machine, I stick to the following installation sequence:

Xp->SP2->IIS->MSOffice->OfficeSP->MS Sql Server 2000->Visual Studio->MSDN->VSS->Enterprise Library

Probably This sequence doesnt work for Sql Server 2005

|||Hi
how do you have reinstalled the SQL Server?
Do you have deinstalled/installed the server or how?
We have 3 Instances with diffrent DB′s and i don′t want to crash them.

Thanks for help|||

Once complete, I copied the LDF and MDF files back into the data folder and re-attached the databases. That worked for me.

Hope I have answered your question

|||thanks. but i see that doesn′t work for SQL2k5? We have it :(

Hi,

Would be interesting to know what systems people are running that this error is occuring on, 32bit or 64 bit.

HTH someone else.

Regards

Nick

DBA - United Co-op Ltd

MCDBA

|||

I have the same problem, after Installing SQL 2005 SP1 on Clustermachines.

However my SQL-Cluster has a problem moving groups, which I hold responsible for failing to install the SP1 on the Database Engines.

I have 32 Bit Machines.

I find interesting though that my BTS 2006 Machines that use the SQL Servers have the same Problem too, even they don't have any SQL Server on it themselves.

Is it feasable to believe that the Problem is maybe in some other Patch we installed that affects the SQL Client Components?

I have also installed the Hotfix NDP20-KB918642-X86_bugfix.exe which is supposed to fix the annoying Shim Database Error Message (you know it?).

Any new suggestions, workarounds, patches?

.NET Runtime Optimization error on SQL Server 2005

I posted this on the .NET Framework inside Sql Server forum as well. Sorry if the cross-post offends anybody.

Source: .NET Runtime Optimization Service

EventID: 1101

Thanks,

Kevin

I'm getting the same message. Now I'm unable to modify or create tables.|||Hi,

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

Thanks

Steve

Hello,

I am running my Asp.Net website on IIS5.1 and Sql Server 2005 for about 6 months now, and it works fine on 3 machines.

Any help would be greatly appreciated!!!

|||

We just applied SP1 for SQL Server 2005 on our production server after a successful installation on our test servers and started to get the same error:

.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile

We haven't attempted any type of fix yet, waiting to see if anyone else has fixed it yet.

|||

The problem was fixed when I reinstalled Sql Server. Apparently some error during installation, couldnt figure it out.

I think the sequence of installation matters. When I install an XP machine, I stick to the following installation sequence:

Xp->SP2->IIS->MSOffice->OfficeSP->MS Sql Server 2000->Visual Studio->MSDN->VSS->Enterprise Library

Probably This sequence doesnt work for Sql Server 2005

|||Hi
how do you have reinstalled the SQL Server?
Do you have deinstalled/installed the server or how?
We have 3 Instances with diffrent DB′s and i don′t want to crash them.

Thanks for help|||

Once complete, I copied the LDF and MDF files back into the data folder and re-attached the databases. That worked for me.

Hope I have answered your question

|||thanks. but i see that doesn′t work for SQL2k5? We have it :(

Hi,

Would be interesting to know what systems people are running that this error is occuring on, 32bit or 64 bit.

HTH someone else.

Regards

Nick

DBA - United Co-op Ltd

MCDBA

|||

I have the same problem, after Installing SQL 2005 SP1 on Clustermachines.

However my SQL-Cluster has a problem moving groups, which I hold responsible for failing to install the SP1 on the Database Engines.

I have 32 Bit Machines.

I find interesting though that my BTS 2006 Machines that use the SQL Servers have the same Problem too, even they don't have any SQL Server on it themselves.

Is it feasable to believe that the Problem is maybe in some other Patch we installed that affects the SQL Client Components?

I have also installed the Hotfix NDP20-KB918642-X86_bugfix.exe which is supposed to fix the annoying Shim Database Error Message (you know it?).

Any new suggestions, workarounds, patches?

Tuesday, March 27, 2012

@@IDENTITY in code

Thursday, March 22, 2012

Embed PDF inside of SQL Server Report Servics Report

Sunday, March 11, 2012

.NET Runtime Optimization error on SQL Server 2005

.NET Runtime Optimization error on SQL Server 2005

.NET Runtime Optimization error on SQL Server 2005

.NET Runtime Optimization error on SQL Server 2005

.NET Runtime Optimization error on SQL Server 2005

.NET Runtime Optimization error on SQL Server 2005

.NET Runtime Optimization error on SQL Server 2005

.NET Runtime Optimization error on SQL Server 2005

.NET Runtime Optimization error on SQL Server 2005

.NET Runtime Optimization error on SQL Server 2005

.NET Runtime Optimization error on SQL Server 2005

.NET Runtime Optimization error on SQL Server 2005

.NET Runtime Optimization error on SQL Server 2005

.NET Runtime Optimization error on SQL Server 2005

SQL SQLExpress

Blog Archive

About Me