SQL Server 2000 Extended SP Built Using .NET 1.1 (Is It Possible?)

May 20, 2008



Hello Pros,

I have a .NET 1.1 component that I want to use as an extended stored procedure in SQL Server 2000. Is this possible? FYI, I read in many sources (e.g. MSDN blogs) that creating extended stored procedures can only be done using a low level language such as C/C++.

I am wondering if it's possible to expose this component as a COM component using the .NET interop library, then register it with SQL Server 2000, and finally be able to consume it from TSQL?

Help please,

Yousef

View 1 Replies


ADVERTISEMENT

Extended Stored Procedure Using C# For SQL Server 2000

Mar 12, 2007



Can anyone of you help me in finding online - resources to write extended stored procedure for Sql Server 2000 using C#.

Thank you,



Andy Rogers

View 1 Replies View Related

Can I Attach A .NET Assembly Into SQL 2000 Server As An Extended Produce?

Aug 27, 2004

and how can it be done?

View 1 Replies View Related

Extended Memory For SQL7 On Advanced Server 2000

Jan 24, 2002

Could anyone inform me how much the conventional memory SQL7 Enterprise on Advanced Server 2000 can have?
The SQL is on an active/active cluster. Currently each runs at 2GB of memory, with available memory for failover. I am planning to add another 2GB to each SQL node. Is this possible? Are there any configurations I need to do? Do I need to set AWE enabled? and How much?

Your help is greatly appreciate.
Jim

View 4 Replies View Related

Performance Of Extended Stored Procedures In SQL Server 2000

Jul 23, 2005

What is the overhead of using extended stored procedures?I created a table with 500,000 rows.1) I ran a select on two columns and it runs in about 5 seconds.2) I ran a select on one column and called an UDF (it returns aconstant string) and it takes 10 seconds.3) I ran a select on one column and called a UDF that calls an extendedstored procedure that returns a string and it takes 65 seconds.I also tried running test 3 with 4 concurrent clients and each clienttakes about 120 seconds.

View 1 Replies View Related

Help!! SQL Server 2000 Extended Stored Procedure Hangs In Windows 98

Jul 20, 2005

I am trying to run xp_cmdshell from the Query Analyzer using SQLServer 2000 running on Windows 98.It seems like it should be simple - I'm typingxp_cmdshell 'dir *.exe'in the Query Analyzer in the Master db. I'm logged in as sa.The timer starts running and never stops. No error message.Can anyone PLEASE help me with this? Any suggestions would beappreciated. Are SQL Server 2000 extended stored procedures notsupported in Windows 98? I've tried searching the Knowledge Base butcan't find anything.Thanks!

View 1 Replies View Related

Only Functions And Extended Stored Procedures Can Be Executed From Within A Function. Sp_executesql Is A Extended Stored Prod

May 15, 2008

i have created the folowing function but keep geting an error.

Only functions and extended stored procedures can be executed from within a function.

Why am i getting this error!

Create Function myDateAdd
(@buildd nvarchar(4), @avdate as nvarchar(25))
Returns nvarchar(25)
as
Begin
declare @ret nvarchar(25)
declare @sqlval as nvarchar(3000)

set @sqlval = 'select ''@ret'' = max(realday) from (
select top '+ @buildd +' realday from v_caltable where realday >= '''+ @avdate +''' and prod = 1 )a'

execute sp_executesql @sqlval
return @ret
end

View 3 Replies View Related

Enumerate SQL Server Built-in Functions

Oct 4, 2006

Hi

I am trying to build a tree similar to the one in SQL Server Management Studio for the system functions in the SQL language.

I would like to group them by type (e.g. string functions) and display information about the parameters and return types, etc.

Is there a way to get these programmatically? I would like to avoid typing them out by hand.

Thanks

Chris

View 6 Replies View Related

SQL 2012 :: Built A Separate Server Just For SSIS

Mar 18, 2015

Has ever built a separate server just for SSIS and how did you do it?

View 2 Replies View Related

Deploying Applciation Built On SQL Server Express

Nov 3, 2005

hi all,

Can any one clarify me the doubt in deploying the application build with SQL Server Express 2005 as database and Vb.Net 2005 as frontend with the same setup made for delopying application. will the server installation and database creation can be made automatic.

If this is possible then what are the steps in doing so and the files to be included while enbeding with vb.net setup.

thanks

harsh

View 2 Replies View Related

Need Help To Built A Client-server Inventory Software

Oct 23, 2006

Hi everyone,
I am a novice programmer. I want to develop a Inventory software using
C# 2005, which will run on a LAN environment. There will be three machine
which will store and retrive data from a common database. Which version
of SQL server is appropiate for this ? Is it possible to provide the
networking facilily using MS Access ? I don't know how to configure SQL
Server for this. Please help me.
Thank You.

View 4 Replies View Related

Is It Enought To Copy The .MDF File To The Server When I Use The Built-in 2.0 User Management?

Jan 23, 2006

Hello,
Sorry my newbie question, but I didn't find how to install my ready asp2.0 application (VS2005) to the target Win2003 server. I use SQL Express 2005 both in my dev machine and the Win2003 server. I simply copied all the .aspx and .mdf file there and I made a virtual directory in the server's IIS. My application works corretly without the database, but when I try to log-in it says: wrong user name or password. With Management Studio Express I made a SELECT to see my built-in users (I added these users in my dev machine before the deploying), and I found them correctly. But when I try to log-in via my application it seems as if it would be empty. Then I made a simply page with createUserWizard to try adding new users in the server but the SQL said: the database is read-only (in the IIS I enabled all rights (eg. read, write, run)).
Is there a special way to deploy my SQL file or the whole application? Sorry, I am not enough familiar with it

View 3 Replies View Related

SQL Server Admin 2014 :: Get Value Of Global Built-in Field (ReportFolder) In SSRS?

Sep 16, 2015

I need to grab the value of the ReportFolder built-in global filed to a particular report on Report Manager, i.e., the full path to a particular report, when the user runs/executes the particular report, SSRS. Once I get this I need to process the path and get the Parent folder to the report and pass that to a stored procedure to do some business logic.

View 0 Replies View Related

Tutorial And Demos For All SQL Server 2005 Built-in Data Mining Algorithms

May 11, 2007

Hi, all experts here,

Thank you for your kind attention.

Could please any of you give me some advices for if there are tutorials and demos avaiable which cover all the SQL Server 2005 data mining built-in algorithms?

That will be great to hear from any of you shortly. Thanks a lot in advance.

With best regards,

Yours sincerely,

View 8 Replies View Related

Using MatLab Built-in Statistical Functions Inside SQL Server Stored Procedure

May 17, 2007

Hi everybody,



I would like to use MatLab built-in statistical functions (beta, gamma, normal, etc.) from inside a SQLServer stored proceudre. Does anyone know if possible? (Of course, If so, where can I get documentation for doing this?)



Thanks in advance!



JorgeHG.

View 5 Replies View Related

What Advanced Features Can Be Built With Code In SQL Server 2005 Reporting Services?

Apr 16, 2007

Hi, all experts here,

Thank you very much for your kind attention.

As we know the limited features on SQL Server 2005 Reporting Services, but we can build advanced features for it with coding on it. Would please any experts shed me any light on it in a summary like what advanced features could be added with coding on SQL Server 2005 Reporting Services?

Thanks a lot in advance for your kind help and advices. And I am looking forward to hearing from you.

With best regards,

Yours sincerely,

View 3 Replies View Related

Unattended (Silent) Install SQL Server Express How Do I Specify A The Built In System Account???

Aug 15, 2006

When doing a unattended install of Microsoft SQL Server Express, I have a problem specifing the service to installed to be run under the as local system account.

I'm using: SQLACCOUNT & SQLPASSWORD parameters but it just won't work.

As default SQL Server is installed using the NETWORK SERVICE account, this causes the database to be read-only. What I want is to specifiy in the script that the service should run under the LOCAL SYSTEM account instead. This must also be OS-language independent.

I've tried:

SQLACCOUNT=NT AUTHORITYSYSTEM
SQLACCOUNT=NT AUTHORITYLOCAL SYSTEM
SQLACCOUNT=NT AUTHORITYLOCAL SERVICE
SQLACCOUNT=SYSTEM

SQLACCOUNT=BUILT-INSYSTEM


etc.

and even some different SID as:

S-1-5-18
S-1-5-19

All with no password with the SQLPASSWORD parameter:

SQLPASSWORD=

I still getting the same error while validating the service account.

Is there someone else who knows what I'm doing wrong?

Best regards,

Mattias

View 5 Replies View Related

Built Database With SQL Server Management Studio Express, How Can I Quikly Add Test Data?

Apr 13, 2006

I've built my SQL Server Express database with SQL Serevr Management Studio Express, and now I want to enter some seed data to assist in building tha app around it. I cannot find an option to manage the data in SQL SMSX, like I used to with Enterprise Manager.
I don't want to have to write an app just to get test data in. Seems like this should be a common need. Am I missing something obvious here? Can't find any reference to this in a search of the forums.
Please help.
 

View 1 Replies View Related

SQL Server 2008 :: Usage Of Built-in Functions On Columns Ignores / Excludes Indexes On That Column?

May 25, 2015

Somewhere i read..that in SQL Server...usage of Built-in Functions on Columns, makes query optimizer to ignore indexes on that column...!

So lets say we have table EMP with Emp_id and Emp_Name....

Also we have Non-Clustered index on Emp_Name.

So following query would NOT use Non-Clustered index on Emp_Name column.

SELECTLEFT(emp_name, 3) as emp3
FROMdbo.EMP

Is this true? i am using SQL Server 2008.

View 4 Replies View Related

SQL Server Is Not Releasing Extended SP DLL

Nov 3, 2006

During a Wise Installation upgrade of our software, we are renaming a
directory that contains our ExtendedSP DLL. We issue a
DBCC TSWSQLXP(Free) call before doing the rename, yet SQL Server,
still "holds on" to that DLL. We install a new version, and the ListDLLs
utility (from sysinternals) lists the new DLL in the correct directory.

However, when trying to remove the renamed directory, it won't let us
remove the old DLL because it says it is in use. We can delete the NEW
DLL in the NEW directory with no problem.

I have run the DBCC call numerous times and SQL Server STILL won't
release the DLL for deletion. The only way to delete the OLD DLL is to
stop the SQL Server, delete the DLL, and then restart SQL Server. We
do NOT want to do this because there may be other processes running in
SQL Server.

Any help here would be greatly appreciated.

View 4 Replies View Related

Sql Server 2005 Extended Procedures

Dec 11, 2006

Hi,

I am trying to run a stored procedure in SQL 2005 which calls a registry value using the RegRead stored procedure which in conjunction executes a line of code. This stored procedure has previously worked in both Sql 7/2000.

However, I am getting the following error when trying to run it in SQL 2005:

Msg 22001, Level 16, State 1, Line 0
xp_regread() returned error 5, 'Access is denied.'

Does anyone know if Extended Stored Procedures are supported in SQL 2005?

Thanks,
V.

View 4 Replies View Related

SQL Server 2012 :: Right Way To Query Extended Events Session?

Jun 4, 2015

I use this code in a utility procedure (for performance testing) but it is really slow.

For example, a session with three events is taking 5 seconds to complete this query:

DECLARE @xml xml=
(
SELECT CAST(xet.target_data AS xml)
FROM sys.dm_xe_session_targets AS xet
JOIN sys.dm_xe_sessions AS xe
ON (xe.address = xet.event_session_address)
WHERE xe.name = @name
);

with data as

(
select
convert(varchar(128),convert(varbinary(128),'0x'+n.value('(action[@name="context_info"]/value/text())[1]','varchar(128)'),1)) context
, n.value('(data[@name="duration"]/value/text())[1]','int')/1000.0 duration
, n.value('(data[@name="cpu_time"]/value/text())[1]','bigint')/1000.0 cpu_time
, n.value('(data[@name="physical_reads"]/value/text())[1]','bigint') physical_reads

[code].....

So, I was wondering (considering the buffer is usually only holding a few hundred events)

1. Is this the wrong way to query data from a ring buffer?

2. Is there any way to make this code quicker?

3. Is it better to target a file store rather than a ring buffer for this?

select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003D
D8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000

[Code] .....

View 6 Replies View Related

SQL Server Admin 2014 :: Duration In Extended Events

Jun 11, 2015

I am wanting to get/filter on all queries and procs that take longer than 2 seconds to run (I'll balance real values later) but I'm not sure which Action out of the XE that I need.

I am using SQL Server 2014 and thought I had used sqlserver.sql_statement_completed.duration > 2000 in a previous version.

View 5 Replies View Related

DB Engine :: Cannot Stop Extended Event Session On Server

Jan 25, 2012

I have two extended events sessions running on a server. I do have sql jobs that automatically stop the XE sessions and import the results to working tables. I see two "ALTER EVENT SESSION XXXX ON SERVER STATE = STOP" statements that are being executed for more than 2 days, the wait types are XE_SERVICES_MUTEX and PREEMPTIVE_XE_SESSIONCOMMIT. This is not the first time I see this behavior.I do not want to kill the sessions (I guess the sessions won't die anyway) neither restart the sql service

View 7 Replies View Related

An Extended Stored Procedure Problem With SQL Server Express

Jun 5, 2007







I have created an extended stored procedure (that executes a DLL file) in SQL Server 2005 Express. When I execute this procedure the execution enters an infinite loop and hangs there. When I execute the same procedure on SQL Server 2000 it executes correctly. I wonder if the problem relates to SQL Server 2005, since no problem occurs with SQL Sever 2000. And if so, how could I repair it?



Best Regards,

Ramy

View 2 Replies View Related

SQL Server 2012 :: Using Xquery To Get Event Data Back From Extended Events?

Feb 25, 2014

I am trying to use xquery to get event data back from extended events. I am trying to use some sample data from Grant Fritchey but I am getting null records back. Below is the xml - I just want to retrieve a distinct list of the client_hostname and client_app_name.

<event name="login" package="sqlserver" timestamp="2014-02-19T23:53:54.299Z">
<data name="is_cached"><value>true</value></data><data name="is_dac">
<value>false</value></data><data name="database_id"><value>7</value>
</data><data name="packet_size"><value>8000</value></data><data name="options">

[Code] ....

The query I have that doesn't work is :

WITH xEvents AS
(SELECT object_name AS xEventName,
CAST (event_data AS xml) AS xEventData
FROM sys.fn_xe_file_target_read_file
('C:LoginTraceShared_0*.xel', NULL, NULL, NULL))
SELECT distinct top 1000 xEventName,
xEventData.value('(/event/data[@action_name=''Client_APP_Name'']/value)[1]','varchar') Client_APP_Name,
xEventData.value('(/event/data[@action_name=''Client_Host_Name'']/value)[1]','varchar') Client_Host_Name
FROM xEvents

View 3 Replies View Related

SQL Server 2008 :: Extended Events Capture A Specific Proc Parameter

Feb 19, 2015

I know very little about Extended Events, but I know it is supposed to be more powerful than Profiler. The SQL Instance involved is 2008R2. I was asked whether we could capture when a stored proc was called with a certain parameter. So for example, if dbo.usp_mystoredproc is called and is passed a value of '12345a' for @customer, can that be captured? I would want to know the time it was called, the parameter and parameter value. Probably would be interested in the SPID or LoginName as well.

View 4 Replies View Related

SQL Server Admin 2014 :: Gathering Results From Extended Events Trace

Jun 16, 2015

I need to find any stored procedures that have not been used over a certain time period.

I have set up an extended events session to gather sp_statement_starting and _completed.

The trace returns the object_id's of many stored procedures. I then query the sys.procedures and plug in the object_id to return the stored proc name.

Do I have to repeat this process for every different object_id or is there a way I can query the trace results, using the object_id as my search criteria as one query ?

View 9 Replies View Related

SQL Server Admin 2014 :: How To Read And Load Extended Events Into A Table For Querying

Jun 19, 2015

I am setting up extended events more or less just fine, however I am a bit confused as to how to read and load them into a table for querying. In particular the offset part - is there a way to load just a given dates worth in?

I've got the files configured to be 20MB before rolling over, the XE is running all the time.

So if i load in the full file now, say that covers 2.5 days worth, when I load it again tomorrow to get the updated data I'm also reloading today, which is a waste?

I presume I am going about this wrong, but lack an example that really goes into detail of practicalities of loading this data.

View 0 Replies View Related

SQL Server 2008 :: Add Target Specific Extended Properties To Replication Subscriber Tables

Oct 6, 2015

I have documentation in the form of extended properties for tables which are subscribers in a replication scheme. The documentation describes the tables in reference to their replication scheme. I don't want to apply them to the source and have them published.I can't apply the extended properties receiving the error, 'don't have permission' yet I am DB creator on all systems. The theory is that I can't modify the subscription. Which makes sense.Can I turn off the replication, apply the extended properties, then turn on replication without causing harm?

View 0 Replies View Related

Transact SQL :: Convert Or Change All Existing Traces To Extended Events In Server 2012

May 27, 2015

We are planning to convert or change all existing Traces to Extended Events in SQL server 2012. What is the procedure to convert custom traces. We have already created some below custom traces: like this we are planning to convert for all servers.

exec sp_trace_setevent @TraceID, 20, 23, @on
exec sp_trace_setevent @TraceID, 20, 8, @on
exec sp_trace_setevent @TraceID, 20, 12, @on
exec sp_trace_setevent @TraceID, 20, 64, @on
exec sp_trace_setevent @TraceID, 20, 1, @on
exec sp_trace_setevent @TraceID, 20, 21, @on

[code]...

View 6 Replies View Related

Installing SQL Server 2005 Developer Edition 64-bit Extended On Windows 2003 SP2 Cluster

Jun 14, 2007

Hello



I've installed Windows 2003 SP2 in a stand-alone cluster (will be adding a second node later). I'm now installing SQL Server 2005 Developer Edition 64-bit extended and would like to have the "Create a SQL Server Failover Cluster" box to not be grayed out. Even when I check the "SQL Server Database Services" box, it still has the cluster box grayed out.



Any idea's?

TIA!

View 2 Replies View Related

Built-In TargetServerRole

Jul 26, 2001

I recently came across this built-in role in MSDB. It is not documented anywhere except sp_create role stuff. Does anyone know what this role is used for? Is this what gives users that are not dbo or sa access to see jobs?

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved