Newbie To CE 3.5 Evaluation Question

Oct 23, 2007



Hello - I'm a CE newbie evaluating 3.5 for use in a desktop app and have sifted thru the documentation, but still looking to find if this is possible:

Insert into server2005_tbl select * from opendatasource (ce3.5 connectiondb.sdf).ce35_tbl


I've tried it with ce3.5 connection as:

('Provider=Microsoft.SQLSERVER.OLEDB.CE.3.5','data source = "C:...db.sdf"').ce35_tbl

...(and several permutations of strings I found via search) but get "invalid object name ce35_tbl". Am I doing something wrong here or is this not supported? Is there a way to accomplish this via t-sql on server2005?

Regards,
skitron

View 4 Replies


ADVERTISEMENT

Newbie Here With A Newbie Error - Getting Database ... Already Exists.

Feb 24, 2007

Hi there
I sorry if I have placed this query in the wrong place.
I'm getting to grips with ASP.net 2, slowly but surely! 
When i try to access my site which uses a Sql Server 2005 express DB i am receiving the following error:

Server Error in '/jarebu/site1' Application.


Database 'd:hostingmemberasangaApp_DataASPNETDB.mdf' already exists.Could not attach file 'd:hostingmemberjarebusite1App_DataASPNETDB.MDF' as database 'ASPNETDB'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: Database 'd:hostingmemberasangaApp_DataASPNETDB.mdf' already exists.Could not attach file 'd:hostingmemberjarebusite1App_DataASPNETDB.MDF' as database 'ASPNETDB'.Source Error:



An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace:



[SqlException (0x80131904): Database 'd:hostingmemberasangaApp_DataASPNETDB.mdf' already exists.
Could not attach file 'd:hostingmemberjarebusite1App_DataASPNETDB.MDF' as database 'ASPNETDB'.]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +735075
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1838
System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +33
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +628
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +170
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +359
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28
System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +496
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
System.Data.SqlClient.SqlConnection.Open() +111
System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +121
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +137
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +83
System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +1770
System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +17
System.Web.UI.WebControls.DataBoundControl.PerformSelect() +149
System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +70
System.Web.UI.WebControls.GridView.DataBind() +4
System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +82
System.Web.UI.WebControls.CompositeDataBoundControl.CreateChildControls() +69
System.Web.UI.Control.EnsureChildControls() +87
System.Web.UI.Control.PreRenderRecursiveInternal() +41
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1360



Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210
 
 This is the connection string that I am using:
 <connectionStrings>
<add name="ConnectionString" connectionString="Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|ASPNETDB.MDF;Integrated Security=True;Initial Catalog=ASPNETDB;User Instance=True" providerName="System.Data.SqlClient"/>
</connectionStrings>
 
The database is definitly in the folder that the error message relates to.
What I'm finding confusing is that the connection string seems to be finding "aranga"s database.
Is it something daft?
 
Many thanks.
James 

View 1 Replies View Related

Dynamic Evaluation

Jul 23, 2005

/* goal: dynamic evaluation of table rowplatform: sql 2000*/use northwind;declare @tbl sysnameset @tbl = 'customers'EXEC('select count(*) from ' +@tbl)/*Why the following dynamic evaluation would failIF EXEC('select count(*) from ' +@tbl) = 0PRINT 'no rows'Its variant,IF exists (EXEC('select count(*) from ' +@tbl)) = 0PRINT 'no rows'*/Do I know more sleep :)TIA.

View 31 Replies View Related

Evaluation Edition

Aug 21, 2006

We're going to set up a demo of an Analysis and Reporting server. Does the Evaluation Edition of 2005 come with things like the BI studio, Management Studio and other client-side tools?

Also, does anyone know if the Eval Analysis Services is the full product (e.g. semi-additive measures, ...?)

Thanks a bunch

View 1 Replies View Related

SQL Server Evaluation Ver. Expiration

Nov 20, 2003

Hello,

Is there a way to find out many days you have left on the trial period or is there a way to find out when it was created. I get the feeling it will just not work one of these days and I'll have to figure out something on the fly.

Thank in advance

View 2 Replies View Related

SQL Server -- Evaluation Edition

Nov 11, 2005

I am running the SQL server 2000 evaluation edition... and enterprise manager..does anyone know if this really expires....or can I keep playing around with it forever???same for enterprise manager...

View 1 Replies View Related

SQL Server 2005 Evaluation

Apr 4, 2006

Does the evaluation download of SQL Server 2005 come with Enterprise Manager, it just doesn't seem to be installing it?
I was wondering if anyone else had download it and had a look and had hit the same problem?

View 2 Replies View Related

Evaluation Copy W/ Backup

Apr 12, 2000

hello,

I was storing data on sql server with license for 60 days. before license expired I did:

in enterprise man. selected DB, right click, selected All Tasks,
selected Backup. Backed up to MSSQL7BACKUP DIR using same name.

then went to other machine installed sql server and from the enterprise manager did a restore DB with "restore on existing DB" option

the problem is that I try to give a user rights to the DB and I get error message: error 15023 user or role already in DB

any hints,
thanks

View 1 Replies View Related

SQL 7.0 Evaluation To Full Version -- Help!

Jul 14, 1999

I guess this is likely a stupid question, but I have no time for pride riht now...

I installed the evaluation version of SQL Server 7.0 and then installed the full version over top of the evaluation version once I received it.

My problem is that now SQL Server is telling me that the evaluation period has expired! How do I get around this? I assumed that installing a full purchased version would "convert" my installation of the evaluation version to a full version, but it hasn't. Please email with any information as I am trying to track this problem down and may not have time to check back here!

Thanks,

Robin Sarac

View 1 Replies View Related

Sql Enterprise Evaluation 2000

Feb 4, 2007

is there any kind of problem if i continue to use "sql server 2000 enterprise evaluation edition"..the evaluation period is for 120 days and my project will complete by that period..shall i continue using that or there are any problems....

View 1 Replies View Related

What Is The User Evaluation Tool?

Sep 10, 2007

Could someone please tell me what the User evaluation tool is and what it does please

In my case i will be installing SQL Server developer edition on vista
premium, with service pack 2

Kind regards

Rob

View 6 Replies View Related

IsNull Evaluation Within EXEC

Jul 23, 2005

Hi,I seemed to me IsNull Evaluation within EXEC fails. Here's some moredetail of the problem.-- goal: provide one parameter (of various value) to generate a-- reportdeclare @col4 varchar(30)select @col4 = null-- pls note, the @col4 var is default to null but may likely-- have a valueexec ('select col1, col2, col3, -- next dynamic col' + @col4 + ',col5, col6count(*) as totalfrom FACT_TBLwhere 1=1-- THE FOLLOWING CONDITION EVALUATION FAILED-- in the sense that if the parameter is not called query does-- not return any result set, which is wrongand COL4 = IsNull('''+@COL4+''',COL4)group by '+@COL4+', col5')

View 8 Replies View Related

Report Server Is Evaluation??

Jan 17, 2008



We've been running report server 2005 for several years in development and production. I tried to move the database the other day and everything went fine, aside from creating the scheduled reports/sql jobs. Took a look at the log and it said that report server was in evaluation mode. How can I verify this information?

The version number under /ReportServer is 9.00.2047.00

But that is the same number as my development RS, which did a DB migration just fine.

It is also strange that it has continued to function for so long - if it is in fact an eval version.


Here is the log where things began to go wrong.



Code Block

ReportingServicesService!resourceutilities!9!12/27/2007-19:51:51:: i INFO: Reporting Services starting SKU: Enterprise
ReportingServicesService!resourceutilities!9!12/27/2007-19:51:51:: i INFO: Evaluation copy: 0 days left
ReportingServicesService!runningjobs!9!12/27/2007-19:51:51:: i INFO: Database Cleanup (NT Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds
ReportingServicesService!runningjobs!9!12/27/2007-19:51:51:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
ReportingServicesService!runningjobs!9!12/27/2007-19:51:51:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
ReportingServicesService!runningjobs!9!12/27/2007-19:51:51:: i INFO: Execution Log Entry Expiration timer enabled: Next Event: 22088 seconds. Cycle: 86400 seconds
ReportingServicesService!runningjobs!9!12/27/2007-19:51:51:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
ReportingServicesService!runningjobs!9!12/27/2007-19:51:51:: i INFO: SQM timer timer enabled: Next Event: 25688 seconds. Cycle: 86400 seconds
ReportingServicesService!library!11!12/27/2007-19:51:51:: i INFO: Catalog SQL Server Edition = Enterprise
ReportingServicesService!crypto!11!12/27/2007-19:51:52:: i INFO: Initializing crypto as user: NT AUTHORITYNETWORK SERVICE
ReportingServicesService!crypto!11!12/27/2007-19:51:52:: i INFO: Exporting public key
ReportingServicesService!crypto!11!12/27/2007-19:51:52:: i INFO: Performing sku validation
ReportingServicesService!crypto!11!12/27/2007-19:51:52:: i INFO: Importing existing encryption key
ReportingServicesService!dbpolling!11!12/27/2007-19:51:52:: EventPolling polling service started
ReportingServicesService!dbpolling!11!12/27/2007-19:51:52:: NotificationPolling polling service started
ReportingServicesService!dbpolling!11!12/27/2007-19:51:52:: SchedulePolling polling service started
ReportingServicesService!dbpolling!11!12/27/2007-19:51:52:: UpgradePolling polling service started
ReportingServicesService!dbpolling!e!12/27/2007-19:51:52:: EventPolling heartbeat thread started.
ReportingServicesService!dbpolling!d!12/27/2007-19:51:52:: NotificationPolling heartbeat thread started.
ReportingServicesService!dbpolling!c!12/27/2007-19:51:52:: Polling started
ReportingServicesService!schedule!f!12/27/2007-19:51:52:: Unhandled exception caught in Scheduling maintenance thread: System.Data.SqlClient.SqlException: The EXECUTE permission was denied on the object 'sp_help_jobschedule', database 'msdb', schema 'dbo'.
at Microsoft.ReportingServices.Library.SchedulePollWorker.CheckScheduleConsistancy(Object state)
ReportingServicesService!library!f!12/27/2007-20:01:51:: i INFO: Cleaned 0 batch records, 0 policies, 1 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
ReportingServicesService!dbpolling!10!12/27/2007-20:02:48:: EventPolling polling service stopped
ReportingServicesService!dbpolling!e!12/27/2007-20:02:48:: EventPolling heartbeat thread exiting for stop.
ReportingServicesService!dbpolling!10!12/27/2007-20:02:48:: NotificationPolling polling service stopped
ReportingServicesService!dbpolling!d!12/27/2007-20:02:48:: NotificationPolling heartbeat thread exiting for stop.
ReportingServicesService!dbpolling!10!12/27/2007-20:02:48:: SchedulePolling polling service stopped
ReportingServicesService!dbpolling!10!12/27/2007-20:02:48:: UpgradePolling polling service stopped
ReportingServicesService!servicecontroller!10!12/27/2007-20:02:48:: Service controller exiting.




I didn't notice this line in the log until now:
ReportingServicesService!schedule!f!12/27/2007-19:51:52:: Unhandled exception caught in Scheduling maintenance thread: System.Data.SqlClient.SqlException: The EXECUTE permission was denied on the object 'sp_help_jobschedule', database 'msdb', schema 'dbo'.
at Microsoft.ReportingServices.Library.SchedulePollWorker.CheckScheduleConsistancy(Object state)

Looks like that is the reason for the failed schedule recreation.

Thanks for any help.

View 7 Replies View Related

SQL Express Evaluation Expired - Help !

Apr 20, 2007

Hi All>

I need to save the work I did during my SL Server 2005 Express evaluation which has now expired. I am afraid, very afraid of losing the databases if I uninstall the eval version and upgrade to the newest Express version. Am I ok, or am i toast ? lease clue me in- thanks!

View 6 Replies View Related

How Can We Put More Than One Evaluation In The For Loop Containter?

Apr 18, 2008



Hi, experts,

I found it annoying that I have not being able to put more than one conditions in the Evaluation Expression within the For Loop Containter? e.g. iCounter<N , also I want to put another condition there like IsHoliday=1. How can I achieve that?

I have tried to used the LOGICAL AND operator && to combine more than one condition, but it did not work.

Please shed me some light on that.

Thank you very much and I am looking forward to hearing from you shortly.

WIth best regards,
Yours sincerely,

View 5 Replies View Related

Left To Right Evaluation Question

Nov 26, 2007



I am trying to rewrite a stored procedure that right now works by string concatination.

I would like to mimic that in sql, and have therefore made something that looks like this:





Code Block
declare @guard varchar(20)
set @guard = ''

select *
from Table1
where @guard = '' or
pk in (select pk from Table2)







What I really would have liked was that the guard worked, and Table2 therefore never was searched (because of left to right evaluation), but when I look in the execution plan then I can see that Table2 is getting it's clustered index scan every time.

Does anyone have a good explanation for this, and mabye a good idea on how I can achive what I want?

I work in mssql server 2000.

View 9 Replies View Related

Evaluation Period Expired

Aug 31, 2006

Hi, I am runnig a system with SQL Server 2000, where I get the message (17502): SQL Server evaluation period has expired.

I have valid key for this product, can anybody tell me how to updgrade the SQL Server lisence without a new installation of SQL Server?

Cheers

Kim

View 1 Replies View Related

Can/should I Put SP1 On SQl 2005 Evaluation Version?

Aug 1, 2006

This will become a recommendation for my customer; we are struggling with performance on this new install which is temporarily done with the Evaluation version and I see a Service Pack has been published. Please advise?

View 4 Replies View Related

Access Database Evaluation

Apr 3, 2008

Hi

I'm trying to create a database for an organization for managing contact lists, and mettings with access 2007.

I've 4 tables, organization, person, meeting, participant (contains fields of person and meeting).

the PK for person is, "Fname" and "Lname", and the PK for meeting is "name of meeting" and "date of meeting".
How should I link these two tables with "participant" which has no PK, in order to avoid people to insert fields for partcipand before filling out data tables of person and meeting.

Thanks in advance

Ali

View 1 Replies View Related

2000 Evaluation Edition On A Server

Sep 4, 2006

For testing purposes only, I'd like to install SQL Server 2000 Evaluation Edition on a server. From what I've read, this edition is a full Enterprise Edition, but it will expire after 160 days. But is it a full edition in the sense that users can connect to it when it's installed on a server, like if it was the Enterprise Edition? So far, I've only had it installed at local computers outside any network.

View 6 Replies View Related

Evaluation Period Expired And Need To Get At Datab

Aug 16, 2005

Hi- I let my sql server evaluation expire and I have no access to the database now. Is there anyway I can create a new server on my old sql server 7 software and import the data? I have stored procedures that I really need to access. I see where the data files are but is there a way to get them opened by SQL Server 7 when I created it all in the latest version?
Thanks
Nicki

View 9 Replies View Related

Sql Server 2005 Evaluation Version

Feb 1, 2008

Hi everyone
I've just installed the microsoft's evaluation version of sql 2005 at my home computer.
Now i'm trying to connect ("sql sever management studio") but i dont know the server's name nor user name. I dont rememeber ever asked to produce any during the installation.
Bottom line- the evaluation version of sql server 2005 is installed but i cannot log in. How do i get to know my user name ? server name ? What ever i try i'm announced that the present version is not working for remote connections. I try to connect from the same very machine of the sql server. What is wrong ?
Thanks

View 1 Replies View Related

SQL SERVER STOPPED AFTER EVALUATION PERIOD

Feb 15, 2008

Hi,

I have inherited a nice problem when starting a new role.

My SQL server has stopped and i get the 17051 error when i try to start the services, It is the evaluation copy. I do have a registered full copy on another box.

I really want to keep some of the databases i have been using in the test environment. They have not been backing up as the msdb DB became corrupt some time ago.

Is there any way i can get them moved to my other box.

CAn i reinstall SQL server (another eval copy) onto the duff box (keeping the db's) back them up and then move them

in a pickle

Cheers

Allan.

View 5 Replies View Related

Dynamics GP Evaluation Copy Installation

Sep 1, 2006

Hi,



I am trying to install an evaluation copy of Dynamics GP on my laptop but it keeps giving me the following error:

msde failed to install. Return code 1603

Any idea what I need to do. I am not a techy so you'll have to be gentle with me.



Thanks

Raju

View 1 Replies View Related

SQL Server Evaluation Period Has Expired??!

Aug 15, 2006

Hi,

Today my SQL Server Express suddenly stopped working. After a few hours troubleshooting I finaly found something in the Event Viewer/Application Errors: SQL Server evaluation period has expired...Isn´t the express edition supposed to be free?.

By the way: Windows did 27 automatic updates just before this happened. Might have something to do with it.

Is there a easy way to deal with this or do I have to reinstall and just hoping that I can restore my database?

Most greateful for any answers!

Johan

View 8 Replies View Related

Multiple Text Docs Evaluation

Sep 7, 2007






hey everbody,
i'm absolutely new to any sort of data management
here it goes: suppose we store 100 .txt or .doc files in sql server and we want that none of the files data should match more than 60%: the question which arises are

1. how do we store files in ms-sql (binary format or normal text)?
2. how do we match the files?
3. what code we write in c# for this purpose?
4. has this nething to do with pattern recognition?

My request to all new n active experienced user's to participate because Plzzzzz help me?

View 6 Replies View Related

Transact SQL :: CASE Order Of Evaluation

Sep 24, 2015

I have the following query in a user-defined function. It accepts a single string parameter, but for the sake of simplicity, I have substituted actual strings in the query. It basically checks the passed string. If it ends with "Id", it strips off the "Id" and returns the resulting string. If it ends with "Id" followed by a digit, it strips that off and returns the string.

SELECT CASE
WHEN LEN('IncidentViolationId') > 2 AND RIGHT('IncidentViolationId', 2) = 'Id' THEN LEFT('IncidentViolationId', LEN('IncidentViolationId') - 2)
WHEN PATINDEX('%Id[0-9]', 'IncidentViolationId') > 1 THEN LEFT('IncidentViolationId', PATINDEX('%Id[0-9]', 'IncidentViolationId') - 1)
ELSE 'IncidentViolationId' END

This code has worked flawlessly for quite some time and all of a sudden I get "Invalid length parameter passed to left function". I understand why LEFT() would normally fail if I passed it a -1 for the second parameter, but in this scenario, asI understand it, it never should have reached the second WHEN condition since the first one evaluates to true. Why and why all of a sudden?

View 10 Replies View Related

A Truncation Occurred During Evaluation Of The Expression

Aug 22, 2007


First of all, I get the following error message for one of my packages which uses user variables:

SSIS package "UsageAnalysis.dtsx" starting.
Information: 0x4004300A at Perform xmlState Shredding, DTS.Pipeline: Validation phase is beginning.
Information: 0x4004300A at Update Analysis Table, DTS.Pipeline: Validation phase is beginning.
Information: 0x4004300A at Update Analysis Table, DTS.Pipeline: Validation phase is beginning.
Error: 0xC001700E at UsageAnalysis: A truncation occurred during evaluation of the expression.
Error: 0xC0019004 at UsageAnalysis: The expression for variable "GetAnalysisData" failed evaluation. There was an error in the expression.
Error: 0xC02020E9 at Update Analysis Table, UsageAnalysis Source [1]: Accessing variable "User::GetAnalysisData" failed with error code 0xC001700E.
Error: 0xC0024107 at Update Analysis Table: There were errors during task validation.
Warning: 0x80019002 at Usage Analysis Process: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (5) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
SSIS package "UsageAnalysis.dtsx" finished: Failure.




Now my package has the following variables:
GetMaxUsageID: scope package level, type string, statement SELECT MAX(UsageID) AS MaxUsageID FROM XX.XXX
MaxUsageID: scope package level, type int32, default value 0, value get assigned from the following statement executed from sql task that runs GetMaxUsageID variable as above
GetAnalysisData: scope package level, type string, Evaluate as Expression
"SELECT * FROM dbo.UsageAnalysis WHERE UsageID > " + (DT_STR, 8, 1252) @[User::MaxUsageID]

The package has worked fine until MaxUsageID value reached to 10,00,000 and since then I have been getting above mentioned error message. The problematic step is related to Data Flow task where I use GetAnalysisData. I have tried replacing user variable with literal as follows

"SELECT * FROM dbo.UsageAnalysis WHERE UsageID > 1000000"

the error message stays the same. Please note that package has worked fine before and it still works ok if I don't use user variables. Obviously, some of you would see eliminating user variables as workaround but I would appreciate if cause of that error message could be investigated.

Thanks,
Asaf

View 7 Replies View Related

IF...ELSE's Evaluation Of NULL Varchar Values

Nov 16, 2007



I have a stored procedure that accepts a parameter of type varchar(32). This parameter gets tested against NULL as part of an IF statement. The behavior I'm seeing is that this test never evaluates to TRUE, even in cases where NULL has been passed in as the value of the parameter.


CREATE PROCEDURE uspNewVital
@Description varchar(32),
@Type tinyint,
@DeviceType varchar(32),
@Dimension varchar(32),
@Unit varchar(32)
AS
IF (@Dimension != NULL AND @Unit != NULL)
BEGIN
RAISERROR ('You must specify either a dimension or a unit.', 15, 1) ;
RETURN 0 ;
END
IF NULL = @Dimension
BEGIN
DECLARE @UnitID AS int ;
SELECT @UnitID = ID FROM tblUnit WHERE Description=@Unit ;
IF @@ROWCOUNT = 0
BEGIN
RAISERROR ('Unit not found.', 15, 1) ;
RETURN 0 ;
END
INSERT INTO tblVitalType VALUES (@DeviceTypeID, @DatumID, NULL, @UnitID) ;
END
ELSE
BEGIN
DECLARE @DimensionID AS int ;
SELECT @DimensionID = ID FROM tblDimension WHERE Description=@Dimension ;
IF @@ROWCOUNT = 0
BEGIN
RAISERROR ('Dimension not found.', 15, 1) ;
RETURN 0 ;
END
INSERT INTO tblVitalType VALUES (@DeviceTypeID, @DatumID, @DimensionID, NULL) ;
END
GO


When I pass in a NULL for @Dimension, code execution still goes to the ELSE block.

At first I thought this might have something to do with the ANSI_NULLS option, but the database has this defaulting to OFF.


Any insights would be greatly appreciated. Thank you.

View 4 Replies View Related

Installing SQL Server 2005 Evaluation

Nov 14, 2006

After unzipping the download I have run the splash.hta file. I then chose run the sql native client installation wizard. I then receive the installation package is not supported by this processor type. Contact your product vendor. I am installing this for a class I am taking on a test station. It is a PIII 863 with 512 MB or Ram, running windows 2003 enterprise server SP1. I have looked at the hardware guidelines and it seems this is enough to run it. Any ideas?

View 9 Replies View Related

Sudden Expiration Of Evaluation Version

Feb 23, 2006

I have had SQL2005 on a server for a very short period of time. Today I found that I am not able to execute an SSIS package in debug. It give me an error stating that the evaluation period has expired for data transformation services. I went to check the version by querying, but nothing happens when I click on the Server Management Studio link.

Has anyone seen this before or how long the trial version should last?

Does anyone know what version may have been installed on my server?

Thanks,



View 1 Replies View Related

MSSQL Not Coming Up Thinking It Is Evaluation Copy

Nov 1, 1999

Hi,


Our front-end GUI person changed the system date one month back to avoid the expiration of the Servelet Exec software. After rebooting the system, MSSQL refuses to come up and the errorlog has the following message: "The evaluation period has expired". The version we had was never an evaluation version!


What's making it think that and is there a way to correct the situation?


Any help/suggestions would be greatly appreciated.


Thanks in advance,

Nishi

View 1 Replies View Related

Dynamic Evaluation Of Expression Operator (was Substitution)

Jan 27, 2005

Hi I am trying to do something like the following:

DECLARE @Operator varchar(1)
DECLARE @Rate float
DECLARE @Quantity float
DECLARE @Converted float

SET @Quantity = 6
SET @Operator = '/'
SET @Rate = 2
SET @Converted = 0

@Converted = (@Quantity substituteTheValueOfThis(@Operator) @Rate)

PRINT @Converted

so that the output would be 3

The reason I need to do it like this is that @Operator will change at runtime...

Any suggestions appreciated, I have looked at EXEC sp_execsql but somehow can't get the syntax right.

View 5 Replies View Related







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