| CLR (view all ...) | Last Post | Replies |
|
| CLR Assemblies - Lifecycle and memory options. Is Singleton possible ? | 18 Aug 2010 22:30 GMT | 1 |
I need a CLR custom type to address a few requirements we have. The class is something like this (extremely simplified to the point) using System; using System.Data;
|
| HELP! | 31 Mar 2010 09:36 GMT | 1 |
Third time for this post. I cannot get SQL server 2005 Developer Edition to load reporting services on my computer. I have tried KB934164, KB938245, installing IIS 6.0 and the 6.0 config manager, ALL of the proposed options for IIS config manager, turning any combination or ...
|
| CLR Causing Server Reboot? | 28 Feb 2010 20:59 GMT | 1 |
I'm running a CLR assembly that was designed to resize images within SQL Server. The assembly is "safe" but uses System.Drawing which is "unsafe". When provided with the PK of the datarow, the CLR assembly will retrieve the image from the database, resize it, and update the ...
|
| A good thing or not? | 02 Jan 2010 17:02 GMT | 9 |
I’m one of those developer, turned DB developer / forced DBA types, and I am intrigued with the idea of managed code (CLR) being stored in the database via assemblies. Our company creates financial software for distribution to outside clients. We have many cases where a lot of ...
|
| CLR function works with Physical Servers but in VM it initially works then through error network-related or instance-specific error occurred while establishing a connection to SQL Server. | 24 Nov 2009 22:29 GMT | 6 |
We developed a CLR function that do some work with database, as the logic is already developed in C# so we are not going to re-write the same code using stored procedure. But due to some business requirement, we are calling this function in a stored procedure from SQL Server ...
|
| Multiple calls to CLR SP results in "Context Connection Is Busy" | 25 Jul 2009 02:16 GMT | 2 |
We have some VS 2008 .Net code which is performing database related queries which has been marked for use as a CLR Stored Procedure and running in SQL 2005 which runs fine for one user. But we are having problems when calling the same stored procedure via multiple clients at the ...
|
|
| Connectivity (view all ...) | Last Post | Replies |
|
| Reminder - Microsoft Responds to the Evolution of Community | 31 Aug 2010 19:27 GMT | - |
What is Happening? This message is to inform you that Microsoft will soon begin discontinuing newsgroups and transitioning users to Microsoft forums. Why?
|
| Error attaching database | 26 Aug 2010 13:04 GMT | 5 |
A database, that attaches to a SQL Server at work (local on a stand alone PC) refuses to be attached to an SQL Server at home (local on a stan alone PC). Both are SQL Server 2008 with Service Pack 1.
|
| dbSeeChanges | 25 Aug 2010 15:29 GMT | 3 |
Access 2002 SQL Server 2000 I cannot run an action query without an error which includes: dbSeeChanges added to the OpenRecordSet command.
|
| tables of view | 16 Aug 2010 17:48 GMT | 1 |
as I can find the tables have a view? that is, if I have "select * from vFacturas" how I can find the fields and tables for each field? thanks
|
| Problem connecting to SQL Server over firewall | 14 Aug 2010 09:27 GMT | 1 |
I am troubleshooting connectivity from client computer to SQL Server 2008 named instance. We have opened 1433 and 1434 ports to allow connectivity. I am able to connect using <SQLServerName>\<InstanceName>,<PortNumber> syntax. But I would like to connect without specifying port ...
|
| MBT shoes will shape up your body everyday | 09 Aug 2010 07:05 GMT | - |
Everyone loves the idea of a workout without an actual workout. In that way muscle activity will increase, but that is because you are doing an actual workout. And now, you can shape up your body just wearing a pair of MBT shoes to walk or stand.These MBT shoes, no
|
|
| SQL (view all ...) | Last Post | Replies |
|
| can TIME values be aggregated? | 03 Sep 2010 03:58 GMT | 5 |
Can time values be aggregated? I'm putting together a summary report that will need to show the sum time that something happened. (Employee breaks, for instance.) If break times for 3 employees were "01:00:00", "00:15:00", and "00:12:30" in length, how do I aggregate
|
| print number of update records through sql job | 03 Sep 2010 03:47 GMT | - |
I have update statement which updates column name (auditor_details) in a churn of 5000 records at a time of auditor table which contain 3.2 millions records. I have schedule this through sqljob. I'm looking over sql example to check for update records and gives a output and quit ...
|
| Update trigger | 02 Sep 2010 23:10 GMT | 3 |
Could somebody show me how to update a trigger. I havent created any trigger but it exists in one of the databases we bought for shopping cart. I have to make some modifications to that.
|
| Query to find all zip4's inside polygon | 02 Sep 2010 23:08 GMT | 1 |
I need to find a way to run a SQL query to find all lat/long points in a table which are within a polygon which is defined by several lat/long points. For example, I have this table which includes ALL ~700,000,000 possible
|
| What is the proper syntax for thsi sql:variable? | 02 Sep 2010 23:05 GMT | 1 |
I'm using SQL Server 2005. I have DECLARE @keyword varchar(4096); SET @keyword = LOWER('abc'); SELECT DISTINCT
|
| SQL Express 2008: Select User Name to Login | 02 Sep 2010 22:59 GMT | 3 |
I am working through the tutorials. I have created user Mary. The next bit is about how she can not access anything yet. Oh, really? I want to see what happens if she does.
|
|
| XML (view all ...) | Last Post | Replies |
|
| Simple export from db1 import to db2 using xml problem | 01 Sep 2010 12:20 GMT | 4 |
I thought this should be simple but it does not seem to work. I was trying to use FOR XML to generate XML data and XSD and SQLXMLBULKLOADLib to import the data. In actual implementation the data will be generated on one SQL server instance and then imported -
|
| XQuery Error - Trying to parse XML column | 31 Aug 2010 14:08 GMT | 2 |
Hi SQL Monsters I am getting the following error when I run my query. The query is supposed to be pulling the waitresource data ("FILE: 5:0") from the XML formatted column name TextData. Do you know what I could be doing wrong? Thanks in
|
| parse xml from column to readable string - need only 1 value for each record | 21 Aug 2010 14:20 GMT | 1 |
I have never done this before and do not know where to start. Do you know how to parse out this TextData column into a readable string showing only the element and value for "waitresource" and "duration" column? This is the xml that was generated per row from a sql profiler test.
|
| Move Node Between Two Different Fields | 23 Jul 2010 01:33 GMT | 2 |
I need to use XQuery to move a node between two XML data type fields... I know I can delete a node like this: SET MyXMLField1.modify ('delete
|
| XQuery Get Attribute List Into A Select | 21 Jul 2010 18:12 GMT | 5 |
This will give me a single line with a list of MyText attributes, recursively, under the node. select FileTreePrivatexml.query('data(//Node[@SomeAttribute="MyKey"]//@MyText)')
|
| Recursively Count Nodes | 19 Jul 2010 18:31 GMT | 2 |
Using SQL Server 2008 XML Data Type For A Column How can I recursively count all the nodes within a node... I have a node that is simply //MyNode[@Item="1"]
|