MS SQL Server :: What Is The Memory Footprint Of Enabling Clr In Sql Server 2005?

SQL Server 2005 And DTC Enabling On 2k Server
I
am using SQLServer 2005 and .NET when I use the following
statements:

using (TransactionScope
objTransaccion = new TransactionScope(TransactionScopeOption.Required))

...

objTransaccion.Complete();

I
get the following error:

System.Transactions.TransactionManagerCommunicationException:

Network access for Distributed Transaction
Manager (MSDTC) has been disabled.

Please enable DTC for network access in the
security configuration for MSDTC using the Component Services Administrative
tool. (Exception from HRESULT: 0x8004D024)

I
am trying to enable the DTC on Windows 2000 Server but the references seem to
be to Windows 2003 Server. Any
idea on how to do it on 2k Server?

TIA, Brad.-

View Replies !

Enabling Ssl Encryption For SQL 2005

I have SQL 2005 (v9.0.3042) on Windows Server 2003. The sql server is running under LocalSystem account.

I am trying to enable SSL encryption as described in the article http://support.microsoft.com/kb/316898.
I have logged onto the machine as an administrator when creating a new certificate request in MMC. I have set "Force Encryption" to true on server and restarted the server.

However all my clients (.net code, SQL Server Management Studio) successfully connect to the server without "Encrypt=Yes". I expected to see a ssl error or some kind of error denying connection because the cliend did not request ssl ecnryption.

what am I missing? any help would be greatly appreciated.

thanks

View Replies !

Unattended SQL 2005 Express Install Enabling Ad Hoc Remote Queries
Hi there,

I am trying to create an un-attended SQL 2005 Express install. I have successfully made my own template.ini file to install SQL the way I like but I cannot find a way to make it install with the "Ad hox remote queries" option enabled.

Is there anyway to do this? I can't seem to find any switches in the INI file to allow this.

Thanks

Joseph Beckett

View Replies !

RS Instance Footprint
Hi!
Does anyone know the footprint of an RS instance? Does it increase proportionally with every instance or is there some shared pool? If I have 10 instances of RS is it really like having a full 10 separate RS running or are they all pooling?

Thanks

View Replies !

Enabling TCP/IP Protocol In SQL Server 6.5
I am using SQL Server 6.5. By default TCP/IP protocol is not enabled (1433 port is not opened by the server). How can I enable this so that I can use a JDBC driver to connect to it.

In SQL Server 2000, the "SQL Server Network Utility" helps us to enable the TCP/IP protocol. But not able to figure our how/where this can be done in 6.5.

Thanks for any help

View Replies !

Memory In Sql Server 2005
Hi

I would like to know how much of memory is taken by sql server 2005 entprise edition 64 bit during sql server startup in default configuration.....(4GB RAM being used).

i also want to know about montioring the performance of sql server 2005.Should i continue to use performance monitor (perfmon) or is there any new feature in slq server 2005 which provides performance monitoring.

Thanks in advance

View Replies !

Can't Get SQL Server 2005 To Use More Memory
Here'a a break down of what I've done so far.

* Windows 2003 32bit Enterprise with 10gb RAM
* SQL 2005 32bit Enterprise
* boot.ini - have added /3GB /PAE switches
* Confirmed which account SQL Server is running under and added that account to Local Policies/User Rights Assignment/Lock pages in memory
* Enabled AWE in SQL SERVER
* set minimum and maximum server memory to 9gb
* Rebooted.

Task manager says the following:
sqlservr.exe - 95MB usage * I know this is normal when using AWE right?
The actual physical memory used is 3.13GB and never goes higher. So this leads to believe that SQL is utilizing 3GB because of the /3GB switch, but it's not using the rest like it should be. I tried it without the /3GB switch and it only went up to about 2.1GB usage.

I've turned on performance monitor and SQL server target memory says 8.65 GB while the Total Server Memory says 2.45GB.

I've run:
EXEC sp_configure 'show advanced options'
RECONFIGURE
GO

EXEC sp_configure 'awe enabled'
RECONFIGURE
GO

And it confirms that the running value for both is 1

Please help.

View Replies !

Memory Configurations For SQL Server 2005 EE X64 With SQL Server 2000 EE X32 On Windows Server EE X64 Server
My server is a dual AMD x64 2.19 GHz with 8 GB RAM running under Windows Server 2003 Enterprise Edition with service pack 1 installed. We have SQL 2000 32-bit Enterprise installed in the default instance. AWE is enabled using Dynamically configured SQL Server memory with 6215 MB minimum memory and 6656 maximum memory settings.

I have now installed, side-by-side, SQL Server 2005 Enterprise Edition in a separate named instance. Everything is running fine but I believe SQL Server2005 could run faster and need to ensure I am giving it plenty of resources. I realize AWE is not needed with SQL Server 2005 and I have seen suggestions to grant the SQL Server account the 'lock pages in memory' rights. This box only runs the SQL 2000 and SQL 2005 server databases and I would like to ensure, if possible, that each is splitting the available memory equally, at least until we can retire SQL Server 2000 next year. Any suggestions?

View Replies !

SQL Server 2005 Memory Management
Hi all,

I needed to load some tables in memory on startup because of performance reasons.
I'm using "select * from <table>", but there are few questions:

1. How to pin already selected data in memory ? (DBCC PINTABLE doesn't work for 2005)

2. How to put index data in memory ? (do you read document(s) for advance memory management - index data caching ?)

3. How to pin index data in memory ? (otherwise sound very bad - table data in fast memory, index data - in slow disks)

Thanks in advance:

Siol En

View Replies !

SQL Server 2005 Memory Management

Hi all,
I needed to load some tables in memory on startup because of performance reasons.
I'm using "select * from <table>", but there are few questions:
1. How to pin already selected data in memory ? (DBCC PINTABLE doesn't work for 2005)
2. How to put index data in memory ? (do you read document(s) for advance memory management - index data caching ?)
3. How to pin index data in memory ? (otherwise sound very bad - table data in fast memory, index data - in slow disks)

Thanks in advance:
Siol En

View Replies !

SQL Server 2005 Std Hogging Way Too Much Memory
Hi:

I'm running Windows Small Business Server 2003 Premium R2. I installed SQL Server 2005 Standard Edition on this PC. I'm using Std Edition instead of the Workgroup Edition that comes with SBS since I like the additional features in the Std Edition.

I'm a kind of a newbie to Windows Server administration and SQL Server administration although I've written lots of SQL queries, stored procedures, etc.

I have 2GB of RAM on this PC. When I looked in Task Manager, I saw that SQL Server was using somewhere over 1GB of RAM. So, I opened up SQL Management Studio, right clicked on the server node, clicked to get to the memory configuration page and saw that SQL Server was set to use all 2GB of RAM on the PC. I changed that to 500MB(500000000, or 476MB) and decided to reboot the server. When the server came back up, I forgot to check SQL Server's new RAM usage. The server ran without interruption for over 24 hours. Now, when I checked SQL Server's memory usage in Task Manager, I can see it's using over 750MB of RAM.

How do I fix this?

I have Exchange Server 2003 running on this PC as well.

Thx.

View Replies !

SQL Server 2005 DTS/Memory Usage
We have an application that we currently run on SQL Server 2000 that works by creating a DTS package that it then executes.

Due to performance reasons, we have been considering switching to 2005, for a few reasons. Can anyone confirm clarify the following?

1) SQL Server 2000 caps RAM usage at 2GB, whereas SQL Server 2005 is only limited by the OS - RAM usage is a big current issue for us, so if upgrading to 2005 would solve this it would help a lot. Can anyone confirm my understanding of this?
2) Would using the legacy DTS in SQL Server 2005 take advantage of this RAM difference, or is it running on the old 2000 engine and only able to use the 2GB?

Thanks for any help.

View Replies !

Planning For SQL Server 2005: 64-bit, OS, Processor, Memory
I was browsing Microsoft's SQL Server site, looking forsome details about SQL Server 2005. Didn't find whatI was looking for...I'm thinking about moving an existing SQL Server 2000workload to a new box, using SQL Server 2005, andmaybe the 64-bit version.My questions are:1. What is the current target date for release of SQL Server 2005?Will 64-bit ship when 32-bit ships?2. Will 64-bit SQL Server 2005 require a special versionof Windows Server 2003 (e.g. Windows Server 2003 Enterprise x64)?Will it work with both Intel and AMD processors?3. How many CPUs, and how much memory, will be supported bySQL Server 2005, 32-bit and 64-bit, on each OS that can runSQL Server 2005.I'm looking for a chart here, something like the chart onpage 117 of Kalen Delaney's "Inside SQL Server 2000" book.SQL Server 2005 SQL Server 2005Feature Enterprise 32-bit Enterprise 64-bit------------------- ----------------- -----------------CPUs supportedWin Srvr 2003:Win Srvr 2003 Adv:Win Srvr 2003 Ent x64:Physical memorysupportedWin Srvr 2003:Win Srvr 2003 Adv:Win Srvr 2003 Ent x64:Has Microsoft published this info, and I just can find it?

View Replies !

SQL Server 2005 Doesn't Allocate Available Memory
running Sql Server 2005 SP2 on Windows 2003 Server SP1 with 2GB RAM. After start-up, the sqlservr.exe does only take up around 100 MB of RAM, and it stays roughly there even if the DB is used heavily. This leads to very poor performance, even timeouts on simple querys.

In the task manager, I see that of the 2 GB of RAM, more than 1 GB is still available. I don't understand why SQL Server won't take it?

As a test, I configured the min and max amount of RAM SQL Server should used both to 1024 MB and restarted the service - but it is still the same picture. It won't take more than around 100 MB.

The server has just been restarted, but the problem remains.

BTW there is also an instance of SQL 2000 on the same machine. It shows the same behaviour - I even checked the "reserve phyiscal memory" checkbox there, but it stays on a very low number (50 MB) and doesn't adhere to the supposed size.

thanks and best regards,
- Urs

View Replies !

SQL Server 2005 Hogging Processor And Not Using Memory
Hi,

We have recently tested upgrading our web service from sql 2000 to 2005 sp1. The upgrade went smoothly enough, however we now have the problem of the sqlserver.exe process taking 90-100 % of the processors time, but using only 100 MB of memory.

We have 6GB available and we are running the enterprise editions of Windows 2003 and SQL 2005.

Machine specs,

DL380 G2, 2 X 2.8 Ghz Zeon, 6GB ram, Raid 5, database partition of 140 GB, Log partition of 35 GB.

Db is 25 GB, Log is 12 GB. Largest table has 32 million rows.

Any help would be greatly appreciated.

Rob

View Replies !

Memory Stress Test In SQL Server 2005
I have a Windows 2003 Server running SQL 2005. The server has 32 GB of memory and I have enabled AWE in SQL. I have also configured the min and max SQL memory as 1 GB and 28 GB, respectively. However, this server currently has very low activity so I'm not sure whether my AWE-related changes worked. SQLSERVR.EXE process takes up about 100 MB of memory. Is there any tool or scripts that I can use to memory stress SQL to confirm that AWE is really in effect ?

View Replies !

SQL 2005 Server Performance And Maximum Memory Pro
A query was taking 20 seconds and consuming 70% CPU takes only 1 second after setting Maximum Memory property to 2048 MB - why?

Server:
OS Microsoft(R) Windows(R) Server 2003, Enterprise Edition
Version5.2.3790 Service Pack 1 Build 3790
8 GB memory
Two Dual-core AMD Opteron 285 2.6GHz Processors
Server is not configured for AWE
Fiber channel connection to EMC Clarion - two LUNs - one for MDF, one for LDF

SQL 2005
SQL 2005 32 bit Standard Edition - SP1 (version 9.0.2047)
Three instances installed on server - only one instance in use
Binaries and system databases on local mirrored disk
Database file (MDF) on one EMC LUN - dedicated physical drives
Log file (LDF) on one EMC LUN - dedicated physical drives

Query in question:

SELECT TOP 10 Address.Address1, Address.Address2, Address.City, Address.County, Address.State, Address.ZIPCode, Address.Country, Client.Name,
Quote.Deleted, Client.PrimaryContact, Client.DBA, Client.Type, Quote.Status, Quote.LOB, Client.ClientID, Quote.QuoteID, Quote.PolicyNumber,
Quote.EffectiveDate, Quote.ExpirationDate, Quote.Description, Quote.Description2, Quote.DateModified, Quote.DateAccessed, Quote.CurrentPremium,
Quote.TransactionDate, Quote.CreationDate, Quote.Producer FROM ((Client INNER JOIN Address ON Client.ClientID = Address.ClientID) INNER JOIN Quote ON
Client.ClientID = Quote.ClientID) WHERE (Quote.Deleted = 0) AND ((Address.AddressType)='Mailing') ORDER BY Client.Name

Address table - 161,075 rows
Client table - 161,634 rows
Quote table - 59,145 rows

With default maximum memory setting (2,147,483,647 MB) - query runs in 20 seconds and consumes over 70 % of the CPU.

After changing maximum memory setting to 2048 MB, query runs in less than 1 second.

Question is:
What is the best practice for setting the minimum and maximum memory settings for SQL 2005?
What can be monitored to identify the cause of these type of issues - using profiler, PerfMon, other tool?

Thanks

View Replies !

Enabling Full Text Search On Existing Sql Server Instance
Hi

I have an existing instance of sql express 2005 w/advanced services installed. When I installed I did not install full text search. Is there a way I can enable full text search on this existing instance?

Thanks

View Replies !

SQL Server 2005 Using All Memory After Installing Cumulative Update 5
Hi,

I have installed cumulative update 5 (version 3215) for SQL Server 2005 SP2, and now SQL service uses 120MB of memory according to task manager. but that's not all, after this install the PF usage went up to 7.5 GB, and now the server has about 400MB of available memory. How do I know this is SQL server? if I turn the service off, the available memory goes up to 7GB and the PF usage down to 500MB

It seems like SQL Server has reserved the whole memory as the process is using 120MB and not 7.5GB... as the PF shows.

The machine has 4 Opteron X2, 8GB of RAM. MS Windows 2003 Server R2 Enterprise, SQL Server AWE option ON

any help will be appreciated.

View Replies !

Memory Settings In SQL Server 2005 Standard Edition
Hi,

I'm having trouble finding the optimum memory settings for SQL Server 2005. I have 4 instances running on a macine with 8 dual-core processors and 18GB of RAM. I have tried the following memory settings so far:

No maximum - one instance used about 12GB of RAM so then the others struggled
Maximum of 4GB each (2GB left for Windows) - meant that 3 instances could be using 1GB each and then another at 4GB and needing more whilst 9GB sat unused.
Minimum of 2GB each - one instance would use up 10GB and then never give any back to the other instances.

I also find that setting a maximum then just causes a high amount of paging. What I would like to do is have each instance use a minimum amount, say 1GB, and then have each instance use a maximum of 13GB (3GB for other 3 instances running at a minimum level and 2GB for Windows). This 13GB should then be released and allocated to another instance when necessary, assuming it is no longer all being used. I do not want paging to occur if an instance reaches 13GB.

How do I go about configuring SQL Server to behave like this? Is it possible?

Thanks.

View Replies !

SQL 2005 Server Performance And Maximum Memory Property
A query was taking 20 seconds and consuming 70% CPU takes only 1 second after setting Maximum Memory property to 2048 MB - why?

Server:

OS Microsoft(R) Windows(R) Server 2003, Enterprise Edition

Version 5.2.3790 Service Pack 1 Build 3790

8 GB memory

Two Dual-core AMD Opteron 285 2.6GHz Processors

Server is not configured for AWE

Fiber channel connection to EMC Clarion - two LUNs - one for MDF, one for LDF

SQL 2005

SQL 2005 Standard Edition - SP1 (version 9.0.2047)

Three instances installed on server - only one instance in use

Binaries and system databases on local mirrored disk

Database file (MDF) on one EMC LUN - dedicated physical drives

Log file (LDF) on one EMC LUN - dedicated physical drives

Query in question:

SELECT TOP 10 Address.Address1, Address.Address2, Address.City, Address.County, Address.State, Address.ZIPCode, Address.Country, Client.Name,

Quote.Deleted, Client.PrimaryContact, Client.DBA, Client.Type, Quote.Status, Quote.LOB, Client.ClientID, Quote.QuoteID, Quote.PolicyNumber,

Quote.EffectiveDate, Quote.ExpirationDate, Quote.Description, Quote.Description2, Quote.DateModified, Quote.DateAccessed, Quote.CurrentPremium,

Quote.TransactionDate, Quote.CreationDate, Quote.Producer FROM ((Client INNER JOIN Address ON Client.ClientID = Address.ClientID) INNER JOIN Quote ON

Client.ClientID = Quote.ClientID) WHERE (Quote.Deleted = 0) AND ((Address.AddressType)='Mailing') ORDER BY Client.Name

Address table - 161,075 rows

Client table - 161,634 rows

Quote table - 59,145 rows

With default maximum memory setting (2,147,483,647 MB) - query runs in 20 seconds and consumes over 70 % of the CPU.

After changing maximum memory setting to 2048 MB, query runs in less than 1 second.

Question is:

What is the best practice for setting the minimum and maximum memory settings for SQL 2005?

What can be monitored to identify the cause of these type of issues - using profiler, PerfMon, other tool?

Thanks

View Replies !

Memory Usage Of SQL Server 2005 Mobile Edition
Hi forum readers,

we are working on a release 2.0 mobile solution right now. In our version 1.0 we did not have to worry about memory issues as our application was the only application running on our target devices (e.g. T-Mobile MDA Compact II Pocket PCs, WM2005).
Now we need to share the available memory with others. As our application relies on its SQL Server 2005 Mobile Edition database we are wondering about memory usage of that server.

We know that a Pocket PC divides its memory into Storage and Program. If our application uses a 5 MB database and 1.5 MB for DLLs and it's exe-file. These files reside in the storage space when not loaded. When the application starts up it is loaded in the program memory. What happens to the 5 MB database file? Is is loaded into Program memory as well? Are only portions of that file loaded? Or is nothing loaded at all?

Does anyone have a deeper insight into that server an can answer my questions.

Best regards,
Tobias

View Replies !

Performance Issues Total Server Memory Vs Target Server Memory
Hi

I did a load testing and found the following observations:

1. The Memory:Pages/sec was crossing the limit beyond 20.

2. The Target Server Memory was always greater than Total Server Memory

Seeing the above data it seems to be memory pressure. But I found that AvailableMemory was always above 200 MB. Also Buffer Cache HitRatio was close to 99.99. What could be the reason for the above behavior?

View Replies !

SQL Server 2005 Workgroup Edition In SBS 2003 R2 Max Memory Question
We have only a small busines and haven't got too much experience with servers and now have a proliant server coming in with SBS 2003 R2 Premium with the 4 GB max memory that SBS 2003 can handle according to the specs.

We weren't planning on using the SQL 2005 worlgroup edition up till now, but now we might. According to the specs of SQL server 2005 workgroup edition however, it has a max RAM of 3GB!

Is this going to be a problem and should we keep using our previous DB, or can we migrate toward SQL server with the 4 GB of RAM?

View Replies !

Setting Memory Values For SQL 2005 Standard (32 Bit) On Windows 2003 Server 64 Bit.
Hi,

I am testing SQL 2005 Standard (32 bit) on a Windows 2003 Server 64 bit with 8GB of RAM? Should I enable the AWP Setting or not and should I change the maximum server memory (currently saying 2GB)?

Thanks!
Tom

View Replies !

How To Make Use Of 4 GB Memory For SQL Server 2005 Standard + Windows 2003 Stardard
We just upgraded the memory of our database server from 2GB to 4GB. And its OS is windows 2003 standard and sql is 2005 standard edition. According to microsoft(http://msdn2.microsoft.com/en-us/library/ms143685.aspx and http://msdn2.microsoft.com/en-us/library/aa366778.aspx#physical_memory_limits_windows_server_2003), this configuration should allow database use up to 4 GB memory. My question is : Do I need to do anything(such as: adjust the maximum memory in management studio) to let our server be able to consume this extra 2 GB memory?

Does this solution http://support.microsoft.com/kb/274750 apply for SQL server 2005?

View Replies !

SQL SERVER EXPRESS BETA1 (2005) IS NOT RUNNING :SHARED MEMORY Provider Error
I'm facing several problems that I tryied to short out by msdn but could not get solution
I'm using visual studio .NET 2005 Beta(WHIDBEY),and
problem:1 sql server2005 Express edition is not running on My stand alone machine(AMD Athlon Xp 2000+,512 MB DDR Ram,CPU Clock speed 1.67 GHz)
Whenever I try to connect to SqlExpress using the server explorer in the VisualStudio.NET 2005 using follwing option in connection properties Dialog Box :
1.server name: the name of my computer(I'm using the Default Instance of SQLEXPRESS 2005) 2.Enter Information to log on to the server:usewindowsNt Integrated Security3.when I go to select the inuilt data base like masters it gives following Error message:-
"Shared memory provider:Specifed Module could not be Found"
problem:2In the process of making of Data Access component,I made an assembly named "TNB.DataLayer.CSharp.dll" and putted it at two place one in the ..in folder and another in the folder having the solution file .Now I want this asssenbly to put in Global Assembly cache so that parts of my project (a window Application and a Web Application) can access the database using this TNB.DataLayer.CSharp.dll Now i need to make my assembly a strong name so I used following at the .NET command Prompt sn.exe -k TNBKeyPair.snkand put this file in the folder where My solotion .sln file exist.now as I have the keypair file,I tryied to sign the assembly TNB.DataLayer.CSharp.dll with this key for this when I added the following in to the AssemblyInfo.cs file[assembly: AssemblyKeyFileAttribute("TNBKeyPair.snk")]
warning on bulding the solution is
Warning 1: Use command line option '/keyfile' or appropriate project settings instead of 'AssemblyKeyFileAttribute' D:gopaldot net newTNBTNBPropertiesAssemblyInfo.cs 19 11
and when I use the /keyfile:TNBKeyfile at the command prompt I got another Error message:The file name, directory name, or volume lable syntax is incorrect.
and finally I'm not able to sign the Dll and to put it in global assembly to use from different envioronments.
so please help me in solving this problem.

Thanks!
ur faithfully

View Replies !

SQL Server 2005 Service Broker - Activation Stored Procedure Memory Usuage
We are looking for some guidance with an issue we have picked up with our implementation of Service Broker here on the ABSA Capital project and I am hoping you can help or point us in the direction of someone.

The architecture we have implemented for service broker is to make use of an Activation stored procedure on two queues (1 SP per queue) to process the messages received. What we have found is that the activation stored procedure runs on a background session and its CPU time and memory just grows to the point where it brought one of our UAT servers to a grinding halt.

Is there anyway we can reduce the memory consumption of the activation stored procedure or is this one of those things that still need to be ironed out in Service Broker?

View Replies !

Sql Server 2000 Using Less Memory After More Memory Added
sql server 2000 is running on windows server 2003 ... 4gb of memory on server .... 2003 was allocated 2.3gb nd sql server was allocated (and using all of it) 1.6gb for total of approx 4gb based on idera monitor software ... all memory allocated betweeen the OS and sql server .... then 4 more gb of memory added for total now of 8g ... now idera monitor shows 1.7gb for OS and 1.0 gb for sql server ..... 'system' info shows 8gb memory with PAE ... so I assume that the full 8gb can now be addressed .... why are less resources being used now with more total memory .... especially sql server ..... i thought about specifying a minimum memmry for sql server but i amnot convinced that would even work since it seems that this 1gb limit is artificial .... it it used 1.6 gb before why would it not use at least that much now ??

thank you

View Replies !

&&"Not Enough Memory For Operation&&" - Sql Server 2005
My Microsoft Visual Basic 6.0 application uses Crystal Reports 8.0 as the
reporting development tool. After the application is distributed to a client computer, when the application attempts to load a report the following error message appears:

"Not enough memory for operation"
NOTE :
The report file uses Stored procedure to process the query and display data. And the client computer is using SQL Server 2005. However, if we install SQL Server 2000, the report generates without any problem.
Moreover in client computer niether MsDtsSrvr is not seen in Running process list (Task manager) nor I am unable to start MsDtsSrvr.Kindly help me on this issue.

Thanks in advance,
Nethesh Kannan

View Replies !

Enabling MSSQLServerADHelper
I was installing application software that was trying to install SQL Server 2005 and received the following error message.

"Setup failed because Service MSSQLServerADHelper is disabled for the current hardware profile. Services must be set with the current Hardware Profile logon property profile enabled."

Simple fix for most but I do not know how to do what it asks.

Thanks, Bruce

View Replies !

Enabling CLR Integration
Hi All,

    I'm new to SQL Server Express. But I need to find out how easy it is to create custom types with SQL Server Express because we have to represent house numbers as a custom type in the database. After enabling the CLR integration with the SQL Server Surface Area Configuration tool, I created an SQL Server Project with VS 2005 Pro., created a custom type called HouseNo, deployed it to a database and finally created a table with a column of that custom type. But when I tried to use the option 'Show Table Data' for that table, the following errors always appeared

SQL Execution Error

Executed SQL statement SELECT NP.ToString() AS NP From Table1
Error Source : .NET SqlClient Data Provider
Error Message : Execution of user code in the .NET Framework is disabled. Enable "CLR Enabled" configuration Option. -- I think I've already enabled it.

   Does anyone know how to solve the problem? Just one more question, for a custom type implementing the IComparable interface, would SQL Server Express uses the CompareTo method to perform sorting?

   Thanks!

Regards,
Nathan
----------------------------------------------------------------------------------------------
   The SQL Server Epxress is newest and the following is code for the custom type.

---------------------------------------------------------------------------------------------
using System;
using System.Data;
using System.Data.SqlClient;
using System.Data.SqlTypes;
using Microsoft.SqlServer.Server;

[Serializable]
[Microsoft.SqlServer.Server.SqlUserDefinedType(Format.UserDefined, IsByteOrdered = true, MaxByteSize = 8000)]
public class HouseNo : INullable, IComparable, IBinarySerialize
{
    // Private member

    private String number;
    private String letter;
    private bool m_Null;

    public HouseNo()
    {
        Number = "0";
        Letter = "0";
    }

    public HouseNo(String number, String letter)
    {
            Number = number;
            Letter = letter;
    }

    public string Number
    {
       get { return number; }
       set { number = value; }
    }

    public string Letter
    {
       get { return letter; }
       set { letter = value; }
    }

    public int CompareTo(Object obj)
    {
       if (obj is HouseNo)
       {
           HouseNo hno = (HouseNo) obj;
           int numCompare = Number.CompareTo(hno.Number);

           return (numCompare == 0 ? Letter.CompareTo(hno.Letter) : numCompare);
       }
       else throw new Exception("Obj is not a HouseNo");

    }

    public override string ToString()
    {
        // Replace the following code with your code
        return Number+Letter;
    }

    public bool IsNull
    {
        get
        {
            // Put your code here
            return m_Null;
        }
    }

    public static HouseNo Null
    {
        get
        {
            HouseNo h = new HouseNo();
            h.m_Null = true;
            return h;
        }
    }

    public static HouseNo Parse(SqlString s)
    {
        if (s.IsNull)
            return Null;
        HouseNo u = new HouseNo();
        // Put your code here
        return u;
    }

    #region IBinarySerialize Members

    public void Read(System.IO.BinaryReader r)
    {
        Number = r.ReadString();
        Letter = r.ReadString();
    }

    public void Write(System.IO.BinaryWriter w)
    {
        w.Write(Number);
        w.Write(Letter);
    }

    #endregion

}

View Replies !

Problems With Enabling Subscription.
I am trying to add a subscription using the GUI or sp_addsubscriptionand keep getting the following error: Subscriber cannot subscribe tothis publication. It cannot create a named subscription because thepublication does not allow named pull subscriptions or because it isnot a registered Subscriber at Publisher.Does anyone have any idea of what is wrong here I have tried manythings without success?Thanks in advance for any help in this.Alan

View Replies !

Enabling The Service Broker
I'm trying to enable the Service Broker for Sql Server 2005 because I want to be able to use a SqlDependency object.

I ran the following query to see if my local sql server service broker was enabled:
SELECT is_broker_enabled FROM sys.databases WHERE name = 'dbname';

It came back with a value of 0 (which means it is not enabled).

I tried executing the following sql command to enable it:
ALTER DATABASE dbname SET ENABLE_BROKER;

The query has been running for over 5 mins and just keeps spinning (should it take this long to enable the Service brfoker), so I cancel it.

I even try to issue the command to see if the service broker is enabled after I cancel the query and it is not enabled.

How can I properly enable the Service Broker?

View Replies !

Help Enabling FTS In Multiple Database

Hi all,
We have a remote server which runs SQL server 2000 DEV edition. We have 4 databases running in it. Our application needs the feature of Full Text Search in all the four databases. We have installed the necessary services. The problem is that we are able to create FTS on one database but when we try to run FTS on other databases the MSSearch service stops. on restarting it mssql stops. we are not able to do FTS on more than one database.
We had tried the same in our local server but it is working fine. The only difference between the two is that the local machine are member server. Has this to do anything with the FTS? Meanwhile the eventviewer doent help much, it just tells that the mssearch engine has stopped unexpectedly and it has done this 'n' time.

Please help

Thanks
Smitha

View Replies !

64 Bit SQL 2005 Memory
Hello,I have two servers running SQL 2005.1. Windows Server 2003 x32 with SQL 2005 Enterprise x32 with 3GB memory2. Windows Enterpise 2003 x64 with SQL 2005 Enterprise x64 with 8GBmemoryUsing taskmgr.exe my 32 bit machine shows 700mb being used bysqlservr.exe, which I expect.However, my 64 bit machine shows sqlservr.exe using 27 mb, which seemsreally low. After I build my data warehouse, I see memory usage at1.5GB on my SQL 2000 machine, so I'd expect more than 27mb used on SQL2005 after I build my warehouse.Additionally, taskmgr says PF Usage is 8.33 GB. Where is the missingmemory, why is SQL 2005 x64 using so little memory??The memory configuration for the x64 server is 0 minimum and 2147483647max KB (defaults)Any thoughts?TIARob

View Replies !

What Is The Memory Footprint Of Enabling Clr In Sql Server 2005?

we wonder about the tradeoffs of t-sql vs clr in sql server 2005 especially from a memory perspective. Is there documentation available on this subject?