Alright here's my situation.
I have two servers both running Eval copies of SQL Server 2005 Enterprise. This is only because I had the promise that I would be getting a shiney new server with a fully licensed copy of the server soon so I wasn't worried when I setup these two programs to use these. Now they are dragging their feet to approve the server and software so I'm scared.
First question - What will happen when the eval period runs out?
Second question - Can I tell what the date was when I installed the server?
These both will help me push management to approve atleast the purchase of an SQL license if I can't get the server.
I'm using an olap cube in a report (dash board). The last "actual" period should be viewed when the user opens the report. I'm using the MDX tail function for that. Once the report is opened the users want to select another period. Then I want to put period as a parameter. But that is not possible since the parameter check box is no longer available when using a MDX filter expression.
Hi Guys, Im having trouble stopping a transaction once the result on one or more of my sql statements rolls back the transaction. Take a look at one my first 'IF' statement (below). If the parameter '@Return' is 'False' i want the transaction rolleback and all sql execution to stop. But my problem is the rest of the sql gets executed and i end up getting rubbish data. Im still new to transactions so i think im doing something really wrong. Please take a look at my sql and help me out in what ever way you think is best. thanks in advance. MattBEGIN TRY SET TRANSACTION ISOLATION LEVEL SERIALIZABLE BEGIN TRANSACTION; BEGIN DECLARE @Return BIT; SELECT @Return = (SELECT IsReturnable FROM INVENTORY WHERE InventoryID = 6) IF (@Return = 'False') ROLLBACK TRANSACTION; DECLARE @Already_In INT; SELECT @Already_In = (SELECT ReturnedBy FROM InventoryInUse WHERE (CheckOutNumber = 375)) IF (@Already_In IS NOT NULL) ROLLBACK TRANSACTION; DECLARE @Outstanding As INT; SELECT @Outstanding = (SELECT (QtyTaken - 40) AS Outstanding FROM InventoryInUse WHERE (CheckOutNumber = 375)); DECLARE @OutstandingReason As VARCHAR(200); DECLARE @Get_Person_ID INT; Select @Get_Person_ID = (SELECT PersonID From [User] WHERE Username = 'matthewsk'); IF (@Outstanding < 0) ROLLBACK TRANSACTION; ELSE IF (@Outstanding > 0)BEGIN IF (@OutstandingReason = '') SELECT @RollBack = @RollBack + 1; UPDATE InventoryInUse SET ReturnedBy = @Get_Person_ID, ReturnDate = GETDATE(), QtyReturned = 40, QtyOutstanding = @Outstanding, WriteOffReason = 'Testing This' WHERE (CheckOutNumber = 375); UPDATE Inventory SET TotalQty = TotalQty - @Outstanding, QuantityInUse = QuantityInUse - (40 + @Outstanding) WHERE InventoryID = 6; END;ELSE IF (@Outstanding = 0) BEGIN UPDATE InventoryInUse SET ReturnedBy = @Get_Person_ID, ReturnDate = GETDATE(), QtyReturned = 50 WHERE CheckOutNumber = 375; UPDATE Inventory SET QuantityInUse = QuantityInUse - 50 WHERE InventoryID = 6; END; COMMIT TRANSACTION; END;END TRY BEGIN CATCH IF (XACT_STATE()) = -1 BEGIN ROLLBACK TRANSACTION;
Thanks for your help in my date problem. It worked perfectly. I was away and could not answer back promptly.
yesterday, i was inserting data from a data file into a SQL table. 1 record had a name field as varchar. But it accidently, ended with a &. For example, "New Construction &". when I am inserting, its taking all records except this record that ends with a &. Is there any way to include this one Or should I tell my client that this is an error. If its an error, what is the expalnation(Like string char does not end with a & and & is a ------). Thanks others in the forum.
I am sorry. "New Construction &". Its not a column name. Its just a record. The table has a column called Name and it accidently, got a record that has "New Construction &" for the Name column.
Its not inserting that record with "New Construction &" in the Name field. Other records are fine.
I am attempting to learn Service Broker from Bob Beauchemin's book "A Developer's Guide to SQL Server" - Chapter 11. I'm finding it to be very good but I'm confused over the concept of closing a conversation. Could someone answer the following questions for me?
When a conversation is ended, can the conversation handle that was created when the conversation was created still be used? (I assume not) Beauchemin says, on page 511, that when a conversation ends, "Any messages still in the queue from the other end of the conversation are deleted with no warning." Does this mean that if I send a message that expects a reply, but I end the conversation, the message is still sent, it is still received by the other endpoint, the other endpoint processes it, but I'll never receive the reply? Beauchemin says that if no lifetime is specified, the conversation is active for the number of seconds which can be represented by the maximum size of an integer. Does this mean that if I don't specify a lifetime, a conversation is active for many, many years?
I'm using SQL SERVER 2000 and in the process of establishing recoveryguide.Tried to rebuild master using rebuildm.exe but the "Configuring Server"never ending. Then I tried to copy original databases from SQLServerInstallation CD to hard disk as the "Browse for folder", but gave thesame problem. Need advice what need to be done.
I have a process that seems to leave many orphaned sessions over a period of time. The software is by a 3rd party vendor and they can't seem to fix it. It is safe to end the orphaned sessions and I do that on a regular basis. My questions is: What is the best way to do this via T-SQL?
I can select the orphaned sessions by using a simple query on the sys.dm_exec_sessions table. How do I then run a kill command for each session_id from that query?
What i have tried has'nt even been close to a solution. UPDATE dbo.t_Work_Hours SET WeekEnding = DATETIME ( ??? , StartTime) . I have no idea where to go!
I've read Remus' article on Fire and Forget tactics when it comes to ending conversations, and I have to admit I am guilty of sending a message to a service and immediately ending the conversation. I've set up a stored procedure to end the conversation on the initiator queue, but I'm guessing it's never being fired because I am not ending the conversation in the target activated stored proc, which is a CLR stored proc.
Can you tell me how to end the conversation from a CLR stored proc?
Now that I think of it none of the code I use in my TSQL activated stored procs to handle different message types and error-checking is done in the CLR stored proc.
I have a job in SQL Server agent with 199 SSIS steps and growing. In the job log only 99 steps are shown, which is a problem if a step higher than 99 fails to run. I need the steps to run in sequence and preferable would like to split the job into several jobs each containing no more than 99 steps. The only thing I don't know is if it is possible to have the next job in sequence start only when the previous job has finished.
Does anyone know if this is possible, and if so how it is done?
Hi, I have a simple web application which calls a stored procedure. The stored procedure operates as a transaction and runs for several minutes. I've created a partial class to set the SQLcommand timeout property to avoid any timeouts, which works fine. Unfortunately though, when the application is run in the production environment, it ends in an error after a certain amount of time (maybe a couple of minutes - not exactly sure), which seems to be the same each run. It doesn't appear to end the stored procedure though, which results in locking the tables. It runs fine in the development environment, and it doesn't appear as though any error information is provided when the application crashes. I'm assuming that the ASP.NET application is timing out for some reason, but the stored procedure itself is fine. I can run it directly from SQL server without any dramas. In the Virtual Directory configuration within IIS, I have the script timeout period set to 1200 seconds. The Default Web-Site timeout property is set to 120 seconds, but I'm assuming that this is only for internet connection timeout, not database transaction timeouts. Any information as to what may be causing this is appreciated. Thanks
Morning Guys, I have a database where I need to kill a remote connection. If I was manually logged into the box i would you a netstat command to stop the service. I would like to end a process from another machine before starting a restore process
I need to write VS2005 C# code using SQL OLE DB to access SQL Server 2005. I have no choice in that matter. I can create a database user with a password like COMPANY", which is a string of uppercase characters ending in an unmatched double-quote mark.
Using Microsoft SQL Server Server Management Studio I login using Windows Authentication, create an account with the password, COMPANY", check the "Enforce password policy", click "OK", and then exit.
Setup
I launch Microsoft SQL Server Server Management Studio again, select "SQL Server Authentication", type in the account name and the COMPANY" password, click the Connect button, and I'm in.
Problem
Now, I need to connect programmatically and run a stored procedure. The password is stored in clear text in hte Registry€”not my choice, it's a legacy application, and changing that is not an option open to me. (We have probably all seen company safes where the combination is scribbled on the wall in case you forget it!)
If I set the connection string in the registry to COMPANY", I get an error like this:
Server Error in '/' Application.
Response is not available in this context. 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.Web.HttpException: Response is not available in this context.
Source Error:
Line 60: catch (System.Exception e) Line 61: { Line 62: Response.Write(e.Message.ToString()); Line 63: } Line 64: Source File: C:sourceProductNameDataCenterAdm&ReportsWebPagesProductNameWebCommonCodeCommon.cs Line: 62
Stack Trace:
[HttpException (0x80004005): Response is not available in this context.] System.Web.UI.Page.get_Response() +2077605 SiteIQWeb.CommonCode.Common..ctor() in C:ProductNameDataCenterAdm&ReportsWebPagesProductNameWebCommonCodeCommon.cs:62 SiteIQWeb.MasterPage..ctor() in C:ProductNameDataCenterAdm&ReportsWebPagesProductNameWebMasterPage.master.cs:21 ASP.masterpage_master..ctor() in c:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files oot 255b545c8a400c7App_Web_hfj8popy.0.cs:0 __ASP.FastObjectFactory_app_web_hfj8popy.Create_ASP_masterpage_master() in c:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files oot 255b545c8a400c7App_Web_hfj8popy.3.cs:0 System.Web.Compilation.BuildResultCompiledType.CreateInstance() +49 System.Web.UI.MasterPage.CreateMaster(TemplateControl owner, HttpContext context, VirtualPath masterPageFile, IDictionary contentTemplateCollection) +250 System.Web.UI.Page.get_Master() +48 System.Web.UI.Page.ApplyMasterPage() +18 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +685
Version Information: Microsoft .NET Framework Version:2.0.50727.1433; ASP.NET Version:2.0.50727.1433
The closes to success I have been able to come is to set the password to "COMPANYNAME""" or 'COMPANYNAME"', which results in a System.Data.OleDb.OleDbConection Exception with a HResult of 0x80040e4d, and the message Login failed for user 'username'.
Questions
Can the password be formatted differently in the registry, or somehow processed after retrieving it, so that SQL Server 2005 will accept it?
Is this a bug in .NET Framework or SQL OleDb?
Is this simply a case of "Is it hurts, don't do it"?
Thanks in advance. As with all postings, my job, promotion, product success, company future, or some combination thereof is on the line.
I'm new to sql 2005 and recently installed the 180 day 2005 Enterprise Eval Product, when i click Help About in the SQL Mgnt Screen it says i have 25 days untill it expires.
The system has been setup by a freelance SQL contractor and its now live and fully working.
So i now have bought SQL 2005 Standard software and need to activate the eval product but cant figure out how to do this.
Can someone please explain my best solution here on how i can activate/license this system without loosing my data.
Hi All, I've just downloaded and installed the evaluation version of msql2005, it all seemed to go ok apart from a message towards the end of the install saying the event log was full. I cleared it an the install finished. Problem is I don't have the server manager on my menu, nor kind I find any way to run it
I had SQL Server 2005 Express originally installed and then I installed the 2005 Enterpsie 180 day Eval and for some reason I cannot get the Management Console that lets me schedule tasks to show up and the ability to do imports. The only Management console I can get to show up is that useless Management Console Express to show up. I have tried reinstalling countless times, how can I get the Management console included with the Enterprise 180 eval to show up, it seems to have been included in the install, but there are no links in the start menu for it, just the configuration tools anybody...please!
I can't get the following SQL to compile/run: ----- DECLARE @strTableName varchar(50) DECLARE @strFieldName varchar(50) DECLARE @intCount int
SET @strTableName = 'Customer' SET @strFieldName = 'AddDate'
SET @intCount = (SELECT Count(DISTINCT '+@strFieldName+' FROM '+@strTableName+') ----- I receive the the following error: Incorrect syntax near '+@strTableName+'
But why? It works if I hard-code the tablename & fieldname strings into the SELECT statement, but not when I replace them with the variables. Any help will be greatly appreciated. Thanks! Jeff
We had a evaluation copy of SQL 6.5 loaded on a server. The eval has expired and I need the server back. We have plenty of SQLServer fully licensed versions available. How do I upgrade this without losing my existing server.
I have a database running on what transpires to be an evaluation copy of SQL 6.5 which has expired. How can I install a full licenced copy of 6.5 whilst retaining databases, users etc. Note:when starting the SQL server service it immediately shuts down due to the eval expiry. Any help is greatly appreciated.
OK.. I've got a stored procedure I'm writing, which accepts an argument called @statfield... let's say I want to use this variable as a literal part of a SQL statement, example:
select * from table1 where @statfield = @value
I want to do basically an eval(@statfield) so if @statfield is "key_id", then the select statement comes out:
We've got a SQL 2000 Server running the Enterprise 120-day trial.Normally you can retain the information by upgrading it to the full-blown version of Enterprise edition. However, we have decided to gowith the Standard version instead. Will I need to BACKUP the data anddo a complete install then RESTORE or can I "upgrade" it to Standard?Has anybody actually done this?
Since it's been about a week and I haven't gotten a response for my last question, I will restate my question here.
Should I uninstall my Visual Studio, Student Version? I had installed Visual Studio 2005, student edition, prior to installing the SQL 2005 eval. I've read that there can be a conflict with MSSQL Express which may have been installed along with my Visual Studio install as there was a SQL Configuration program on my computer before I installed the SQL 2005 trial version.
I have a 32-bit evaluation edition installed on my 64-bit server. I have purchased a license for 64-bit enterprise edition. Can I upgrade from the 32-bit eval edition to the 64-bit enterprise edition? If I can - should I? Is the better approach to install a new named instance of the 64-bit enterprise edition - the 32-bit eval edition is an unnamed instance. All guidance is appreciated.
We are currently running with Eval 120day limit SQL6.5 SP4 and now wish to upgrade to the full version. We have now purchased the full version but whenever we try to "upgrade" the server all we get told is that we should "Use control panel to add or remove components" or we are told that we should "use service pack 3 to update". I can only assume that this message is refering to Add/Remove programs in the control panel but there is no reference to SQL here.
Any ideas how we can upgrade to the full legal version without loosing our SMS data?
Anywhere I can download sql 2000 server enterprise edition eval? I have a database running 2000 standard, wanted to test on 2000 enterprise to see if increased memory and enterprise edtion will help. With the intro of 2005, I can not find 2000 enterprise eval.
I downloaded the 800 mb file (32bit) on my XP (SP2) box and it comes up with a message that I do not have enough disk space on c: drive. Well I have 180GB of space, so that cant be it. Is it because it requires an NTSF drive ad not a FAT32 drive?
