Recent update: 2008-3-21
Hi! I have VS2005 RC1 and SQL Server 2005 September CTP installed on the same machine. I'm writing some pretty simple C# stored procedures and I'd like to be able to debug them with with the VS2005 IDE. However, something's not working. When I set a breakpoint and I run the code (F5), it ...
Most content management systems I've seen have data from a database, and fixed template and background information held in ASP and XML files. Surely it would be easier and more centralised to have everything stored in a database? I've created a simple content management system that does this ...
When I whant the use the new ASP.NET configuration tool (2005) and I want to define a provider I get the following error. You should know that on installation of VS 2005 SQL-Server Express did not install and I installed SQL-Server 2005 (shiped with VS 2005). So now it seems that VS waits for ...
Hi! I have VS2005 RC1 and SQL Server 2005 September CTP installed on the same machine. I'm writing some pretty simple C# stored procedures and I'd like to be able to debug them with with the VS2005 IDE. However, something's not working. When I set a breakpoint and I run the code (F5), it ...
Hey Guys, I am sorry if i am disturbing the sequence of topics posted in this forum, but i dono what exactly i need to post this topic, as i was searching for a Biz Talk Server in this site. so pls xcuse me, anyway, let me come to the point, i am new to this site and as well as new to biztalk ...
I'm wondering if it possible to create a user-defined aggregate that operates on two columns instead of one. Basically, I want to do something like a weighted average where I multiply two columns in each row, sum up the results, and then divide by the sum of one of the fields. For example, if ...
Previously had a 'prototype' (.NET 1.0, SQL Server 2000, CCW to .NET) whereby an update trigger called out to our .NET app. Obvioulsy now SQL Server 2005 is nearly upon us I'd like to explore a better mechanism in order to consider the next phase of deployment (.NET 2, SQL Server 2005).I ...
Most content management systems I've seen have data from a database, and fixed template and background information held in ASP and XML files. Surely it would be easier and more centralised to have everything stored in a database? I've created a simple content management system that does this ...
when I use webrequest to call a url, I got "The server committed a protocol violation", I found out this is because the url returns something 2.0 think is not standard, the solution is turn on useUnsafeHeaderParsing, so I add the below to my ...
4329 byte By
salafa at 2008-2-24
I am trying to write a CLR TVF that will run a query and return the results. I am doing a CLR vs. a TSQL TVF because there will be a great deal of business logic and string manipulation in the actual TVF. In the meantime, I am just trying to get a test one to work.Here is my class:-- Imports ...
I am using Yukon June CTP and VS Beta 2.I have created an assembly containing a number of user defined functions. I have tested them in a database which should cause them to be deployed there.When I look in management studio under the Database/Programmability/Assemblies they are not listed. Nor ...
Is it possible to deploy .NET assemblies and the UDF functions therein from Visual Studio.NET into a particular schema?
When I whant the use the new ASP.NET configuration tool (2005) and I want to define a provider I get the following error. You should know that on installation of VS 2005 SQL-Server Express did not install and I installed SQL-Server 2005 (shiped with VS 2005). So now it seems that VS waits for ...
I don't believe there is a compatible VS.NET release for this CTP so how are folks creating SQLCLR functions/sprocs? Command line? Any pointers to articles? Thanks, Chris
279 byte By
copans at 2008-2-20
I get the message that (CLR) v2.0.50215 not installed properly. The August CTP release of Visual Studio seems to be installed properly. Does this mean that both SQL Server 2005 and VS.NET have to keep versions synchronized? I guess so. I might add that this is under XP 64)
711 byte By
Kobe at 2008-2-20
Hi everyone,I'd like to ask some help. My prob may seem very basic but as a matter of fact i'm a newbie to .net and sql 2005. I'm trying out this product but I encountered an error. After installing sql server express 2005, and using my server instance name (the default name "SQlExpress" ...
4806 byte By
Vinoth at 2008-2-20
Hi, I have created the CLR Trigger Project. In that Project i'm refering one external.dll which is also deployed in the same database. This external.dl uses one method to serialize the data and send it to the server through socket.(The connection for the socket is already established). For ...
Hi, I'm digging through BOL to understand the main reasons the System.Data.Sql namespace is required for CLR. It isn't in the documentation yet as of June CTP (as far as I can find). Anyone have light to shed on this? Thanks, Joe
1299 byte By
Vinoth at 2008-2-18
Hi,I have Created CLR Trigger(SQL Server Project) Project. In that project i have used the Following Code.SqlConnection con = new SqlConnection("context connection = true");con.Open();// Some Proceesing based on the row Inserted.con.Close();After Closing the Connection I want to open a New ...
2349 byte By
Vasile at 2008-2-17
I have installed on one computer Sql Server 2005 Developer Edition (CTP Version) together with a Visual Studio 2005 Beta Edition (July Version) and after configuration some properties by example the Network access, I had a lot of errors from the SQL Server Management Studio received(The most of ...
Hi! How do I upgrade the assemblies in a databases between the Framework that came in VS.NET June CTP and VS.NET July CTP. I've created a fairly extensive database in the former which I'd like to use in the later. All of the non-CLR stuff seems to be accessible just fine. Unfortunately I no ...
Can somebody recoommend me books for sql server 2005. I am interested specially in CLR inside sql and Business Intelligence.
Hello. I got this problem, I am trying to execute a stored procedure DLL from asp.net 2.0 page. It was working friday and it doesnt work anymore, I havent chagned anything on my configuration as far as I remember. .NET Framework error occurred during execution of user defined routine or ...
Hello I just did 2 stored procedures, they dont have errors and they deployed succesfully but after I tried to exec them it doesnt happen anything.I waited for 10 minutes and nothing using System; using System.Data; using System.Data.Sql; using System.Data.SqlClient; using System.Data.SqlTypes; ...
What I am trying to do is in fact the most simple tutorial example of accessing data in SQL Server from embedded .NET code:[Microsoft.SqlServer.Server.SqlProcedure(Name="FillTimeDimension")]public static void FillTimeDimension(DateTime startDate, DateTime endDate) { // Guarantee that we have a ...
I have VS2005 Beta 2 (build 8.0.50215.44) and the June CTP of SQL Server 2005 Developer Edition installed.Within VS2005, when I go to File -> New Project, I don't have the "Database" project type under either VB or C#. Which also means that the "SQL Server Project" template is not being ...
587 byte By
Vinoth at 2008-2-14
Hi, In the SQL Server Project if i register my external dll[which contains Microsoft.Sharepoint.dll] is possible or Not possible. Because its gives the following error Warning: The Microsoft .Net frameworks assembly 'system.web, version=1.0.5000.0, culture=neutral, ...
Hi,I created a SP in C# to write entries to the eventlog.I works fin but I need to put the security level in External_Access.Is there a way to do the same with permission level on save by making use of the System.Diagnostics.EventLogPermission class or is externale_access to only possible way ...
908 byte By
Vinoth at 2008-2-13
Hi, I have created CLR Trigger project using SQL Server Project. In that project i want to add external dll which is located in disk. For that first i have placed the external dll in one folder. Than i have placed all the supporting dlls for the external dll in that folder. Then using Create ...
I am using SQL Server June CTP and I have a CLR stored procedure that is consuming a web service that has 3 methods:1) GetXml - returns xml data as string.2) GetXsd - returns xsd as string.3) GetData - returns a dataset.I am only using the GetData method to retrieve data and do some processing ...
The Project Template Visual C# -> Database -> Sql Server Project isn't available on my Visual Studio 2005 beta 2.I installed Visual Studio 2005 and after that the SQL 2005 lient tools on a desktop with success but no luck, the project type isn't available.Can someone tell me what I need ...
577 byte By
Vinoth at 2008-2-11
Hi, I'm using June CTP Visual studio .NET Framework. I have created SQL Server Project in C# language. In that i want to add external dll's to that Project. But when i click the Add reference in the References, it shows only two Tabs 1. Projects 2. SQL Server. I cant able to add external ...
884 byte By
Tuomas at 2008-2-10
HelloI installed Visual Studio 2005 Beta 2 without SQL Express 2005 because I already had SQL Server 2000 Developer Edition. Now I′m getting errors which says that SQL Express cannot create the needed databases when eg. launching a Web Starter Kit. Timeout expired. The timeout period elapsed ...
I have a situation where I need to use external .NET assemblies, including interop assemblies, from within a SQL CLR stored procedure. I assumed that if my assembly is registered as "unsafe" that I could reference what I need in my SQL Server project. However, VS 2005 will only allow me to add ...
I am encountering a timeout expired error when deploying a .NET assembly in SQL Server 2005 using Visual Studio.NET. I already enabled SQL Server for CLR. Whenever I run the CREATE ASSEMBLY command in SQL Management Studio, my query just ends up executing without stopping. Can anybody help?
159 byte By
gibic at 2008-2-8
Hi after connect to SQL database from .NET the password is removed from connection string, what can i do for stay it in connection string? thank you
1081 byte By
aaa at 2008-2-7
Hi all,I've got a stored procedure that calls a webservice, however when executed I keep getting the following error: A .NET Framework error occurred during execution of user defined routine or aggregate 'xxxxx': System.IO.FileNotFoundException: Could not load file or assembly 'System.Web, ...
Hi, I have created one simple SQL Server 2005 CLR function in Visual Studio 2005 beta 2. It works fine from SQL Server 2005 management studio April CTP. When I try to debug this SQL CLR function from Visual Studio 2005, I am getting the output in Output window along with debug information but ...
1765 byte By
Vinoth at 2008-2-7
Hi, I'm using June CTP Visual Studio 2005. I have Created CLR Object. In my CLR Method i have opened a connection like below public partial class Triggers { //In my CLR Method i have Opened the connection like below [Microsoft.SqlServer.Server.SqlTrigger(Name="ClrTrigger", ...
I am trying to create a set of spatial datatypes for SQL Server 2005. Each datatype inherit from the abstract class "Geometry". ie. public class Point : Geometry public class Line : Geometry public class Polygon : Geometry...and several more.The reason for using the abstract class Geometry, is ...
824 byte By
Dman82 at 2008-2-6
Hi,I'm very new to Yukon and the CLR integration, but I think I understand the basics. I have worked through the CLR tutorial on MS demo servers in which a function was created in vb.net that sql server could call, returning a string.One thing I am wondering is if sql server can call a .net ...
In SQL 2000 for Proceduresthis was done by writing procs in Master db prefixing the name with sp_and using exec sp_MS_marksystemobject procnameIn SQL 2000 for functionswe wrote function in Master dblike so system_function_schemaCreate Function system_function_schema.fn_v_filler (How would one ...
Hello. In reference to my post yesterday which got removed when i edited this one: After trying a few things i realized that the reason i was getting the error "Invalid use of side-effecting or time-dependent operator in 'SET ON/OFF' within a function." was because a CLR function was ...
1723 byte By
Vinoth at 2008-2-5
Hi, I want to call webservice in the Trigger. How to call the webservice from CLR Triggers?.If anybody knows teh detail let me know. And i worked out the following Example code for CLR Trigger. using System.Data; using System.Collections.Generic; using System.Text; using System.Data.Sql; using ...
Hi,I have installed Reporting Services 2000 on my pc. And i've used the report viewer control to view the report on a ASP.NET Page. When i view that .ASPX page, i get a windows authentication window before it opens the actual report.Is there any way to disable this windows authentication ...
Everytime I try to export a report I get a pop up box to RUN/SAVE/CANCEL Reserved.ReportViewWebControl.axd. Cannot seem to find any relevant issues with this on the web. I lower the security settings on IE and still no diffenrence. Seems to happen with every export type except XML. Any help is ...
Hi, I am using SQL Server 2005 b2 and i want to integrate my J# project with SQL Server. .NET Platform compiles it. No problem there. But while i try to create assembly by referencing produced dll file, SQL Server gives that error: "Msg 6581, Level 16, State 1, Line 2 Could not find assembly ...
I have a stored proc which is being called by reporting services. It is written in C# and is a wrapper for executing other procs dynamically.It generates the following error time and again. Any help would be hugely appreciated as this is a production level issue.ThanksShaiError ...
Hi, Does anyone have any links to examples of stored procedures written in C# or VB.Net instead of T-Sql. I'd like to see how it looks and works. Thanks! Ken.
Hi, I watched an on-demand webcast about Offline Data in Smart Client Applications. There was an issue raised in the webcast which wasn't very clear.There is an object named SqlCeReplication in the .net compact framework which is used for a merge replication with sql server ce. My questionis ...