SQL Server 2005 - Save Tran Save Point Name Case Sensitive?

Feb 11, 2006

Hello:

I didn't find any documentation that notes save point names are case
sensitive, but I guess they are...

Stored Proc to reproduce:

/* START CODE SNIPPET */

If Exists (Select * From sysobjects Where Type = 'P' and Name =
'TestSaveTran')
Drop Procedure dbo.TestSaveTran
Go

Create Procedure dbo.TestSaveTran
As
Begin
Declare
@tranCount int

--Transaction Handling
Select @tranCount = @@TRANCOUNT
If (@tranCount=0)
Begin Tran localtran
Else
Save Tran localtran

Begin Try
--Simulate Error While Processing
RAISERROR('Something bad happened', 16, 1)

/*
If this proc started transaction then commit it,
otherwise return and let caller handle transaction
*/
IF (@tranCount=0)
Commit Tran localtran

End Try
Begin Catch
--Rollback to save point
Rollback Tran LOCALTRAN --<< NOTE case change
--Log Error
--Reraise Error
End Catch
End

Go

--Execute Stored Proc
Exec dbo.TestSaveTran

/*
Should receive the following message:

Cannot roll back LOCALTRAN. No transaction or savepoint of that name
was found.
*/

/* END CODE SNIPPET */

What is really strange, if there is a transaction open, then no error
is thrown. So if you execute as so:

/* START CODE SNIPPET */

Begin Tran
--Execute Stored Proc
Exec dbo.TestSaveTran

/* END CODE SNIPPET */

There is no "Cannot roll back LOCALTRAN...." message.

Questions:
1-)Can someone confirm save point names are case sensitve and this is
not happening because of a server setting?
2-)Is this a logic error that I am not seeing in the example code
above?

We have changed our code to store the save point name in a variable,
which will hopefully mitigate this "problem".

Thx.

View 4 Replies


ADVERTISEMENT

Possible To Save Up The Progress At Some Point Of Decision Tree Training?

Aug 24, 2007

Dear All,


If I have a decision tree training work which might last for many days or months. Is it possible to tell the data mining training program to save up the progress at some point? In case the computer hangs or power fail in the middle, the computer can resume the rest of the work at the saving point?

Thanks

Tony Chun Tung Siu

View 1 Replies View Related

How Can I Change The Default Save-As/Save Directory

Jun 26, 2007

I am new to sql sever management studio express, but a long time query analyzer user. This is a very basic question.



I want to change the default directory in sql server management studio express so that when I go to save a query, it is already pointed to the correct one. Where do I change that?



Thanks,

Nanci





View 2 Replies View Related

Can I Save SQL Server 2005 Db As SS 2000?

Dec 21, 2005

    Hi,on my dev-machine i am running SQL Server 2005 Standard Edition.Now i have to do a project for a client who is on a server with ASP.NET 1.1 and SQL Server 2000.Is there a way i can build his database in 2005 and export or whatever it as SQL Server 2000?I don't really like the idea of installing 2000 and 2005 side by side on the same machine.Thank you very much in advance.Tjerk Heringa

View 1 Replies View Related

How To Save Statistics In SQL Server 2005

Jan 1, 2008

hi all

I am working on query performance and tuning.
I want to save current statistics for the latter use. do SQL Server provide any utility or command (like exec dbms_stats in ORACLE and OPTDIAG in sybase) to do this?
thanks

Gourav

View 1 Replies View Related

SQL Server 2005 Mgmt Studio Do You Want To Save Changes...

Feb 7, 2006

No. No I do not want to save changes to that sp_who2 query I just ran. I just want to close the window, and not be bothered with the computer's obsessive compulsive need to save everything I do. Dang it all, it sounds like my computer is working for the NSA leaving a paper trail that even a kitten with Attention Deficit Disorder on catnip could follow.

As you can tell, I am weaning myself off of Query Analyzer, and can not find the checkbox for "Don't bother me when I close a window". Anyone else come across it, yet? It does not appear to be under tools->options or query->query options.

View 1 Replies View Related

How To Make Password Field Case Sensitive In Sql Server 2005

Jan 14, 2007

Hi, 
SELECT     UserID, UserName, Password, PublisherID, CurrencyFROM         [User]WHERE     (Password = 'Anitha') I am using the above mentioned it is working but int the password field i had given it as anitha. Now the querry is retriving the record for anitha, it shouldnot happen. The querry should retrive the record of anitha only for where condition anitha and not for Anitha or ANITHA etc..
 Thanks
Vishwanath

View 4 Replies View Related

In VB Express 2005, I Cant Save Any Record In Database Of Sql Server.

Feb 7, 2006

I was using the msdn tutorial regarding sql database for vb2005 express. In that tutorial, I followed the steps as listed. But the problem is that the save button in my application during run time, it does not work. Furthermore, the code for for saving a record during run time does not work as well.

I have reinstall sql 2005 server and vb2005 express but of no use.

I have winxp with system of pentium 4.

What I should do to solve this dilemma.

Faisal.

View 1 Replies View Related

SQL Server 2005 Mgmt Studio: Save Table Vew Positions

Nov 28, 2006

I'm in stage of manually populating a database that requires me to have about a dozen tables open simultaneously. It would be great to be able to save the tables, locations and sizing so that these can be recalled and opened automatically. Currently I do a screen capture, which is pretty lame.

Any suggestions would be welcome.

Config:

Microsoft SQL Server Management Studio 9.00.2047.00
Microsoft Analysis Services Client Tools 2005.090.2047.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 6.0.2900.2180
Microsoft .NET Framework 2.0.50727.42
Operating System 5.1.2600

View 3 Replies View Related

Cannot Save Maintenance Plans (SQL Server 2005 X64, SP2, Patched To KB934458)

Nov 18, 2007

I have a SQL Server 2005 x64 bit with SP2 applied and patched to KB934458-x64-ENU (9.0.3054)
I am unable to create a maintenance plan via Management Studio or save a plan in Management Studio using the wizard.

If I just try and create a new maintenance plan, then I get the following problem:
"An OLE DB error 0x80004005 (Login timeout expired) occurred while enumerating packages. A SQL statement was issued and failed."

If I try and create any maintenance plan via the wizard, I get the following problem:
"The SaveToSQLServer method has encountered OLE DB error code 0x80004005 (Login timeout expired). The SQL statement that was issued has failed."

I've doen a bit of digging on this and had initially thought it was related to the fact that I have two instances installed on 1 server. I've since updated the MsDtsSrvr.ini.xml file to point at both instances, as I thought that might have been causing the problem. That hasn't helped at all. Edited example of xml file is below:

<?xml version="1.0" encoding="utf-8"?><DtsServiceConfiguration xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <StopExecutingPackagesOnShutdown>true</StopExecutingPackagesOnShutdown> <TopLevelFolders> <Folder xsi:type="SqlServerFolder"> <Name>MSDB SQL Server Instance 1</Name> <ServerName>ServerNameInstanceName1</ServerName> </Folder> <Name>MSDB Server Instance 2</Name> <ServerName>ServerNameInstanceName2</ServerName> </Folder> <Folder xsi:type="FileSystemFolder"> <Name>File System</Name> <StorePath>..Packages</StorePath> </Folder> </TopLevelFolders> </DtsServiceConfiguration>

Any suggestions would be most welcome!

View 4 Replies View Related

SQL Server 2008 :: Change Text Format From Case Sensitive To Case Insensitive?

Aug 31, 2015

How can I change my T-SQL text editor from text sensitive to text insensitive?

View 2 Replies View Related

Case Insensitive Searching In Sql Server 2000 When It's Case Sensitive

May 4, 2007

Can someone point me to a tutorial on how to search against a SQL Server 2000 using a case insensitive search when SQL Server 2000 is a case sensitive installation?
 
thanks in advance.

View 3 Replies View Related

HELP! Case Insensitive Database On Case Sensitive Server

Aug 17, 2005

We need to install CI database on CS server, and there are some issueswith stored procedures.Database works and have CI collation (Polish_CI_AS). Server hascoresponding CS collation (Polish_CS_AS). Most queries and proceduresworks but some does not :-(We have table Customer which contains field CustomerID.Query "SELECT CUSTOMERID FROM CUSTOMER" works OK regardless ofcharacter case (we have table Customer not CUSTOMER)Following TSQL generate error message that must declare variable @id(in lowercase)DECLARE @ID INT (here @ID in uppercase)SELECT @id=CustomerID FROM Customer WHERE .... (here @id in lowercase)I know @ID is not equal to @id in CS, but database is CI and tablenames Customer and CUSTOMER both works. This does not work forvariables.I suppose it is tempdb collation problem (CS like a server collationis). I tried a property "Identifier Case Sensitivity" for myconnection, but it is read only and have value 8 (Mixed) by default -this is OK I think.DO I MISS SOMETHING ????

View 4 Replies View Related

Save PDF To MS SQL 2005 Using VBA

Jul 16, 2007

I am writing VBA code to save a PDF document to a SQL 2005 database table. Does anyone have any tips on how to do this? I assume the data type in the database will be varbinary(max)??

Thank you,
zzwoodsj

View 7 Replies View Related

How To Create , Save DTS In SQL 2005

May 30, 2007

Can anyone tell me what all steps in creating DTS package , how it saves,

how it re executes... what all steps ... and how it makes??





Thanks

Aravind

View 1 Replies View Related

How To Save Trigger Into Table In Sql 2005

Dec 22, 2007

I have found the node for Triggers in SQL Server 2005's Management Studio and tried to create a 'New Trigger...' but when I save, it saves it to an .sql file but do not attach it to the table.What am I doing wrong here? I can't seem to attach it. And where is this Assisted Editor ...i can't seem to find it anywhere

View 2 Replies View Related

Save File In SQL 2005 Database

Feb 14, 2007

Hello,

I am working on a ASP.NET 2.0 project with an SQL 2005 database.
I created a documents table with various columns including:
DocumentId and DocumentUrl

My documents will always be PDF's of SWF's (Flash Paper Files)

I will need to display this files in my web pages.

My question is:
Should I save the DocumentUrl in the database or should I save the file itself in the database?

And how can I save files in an SQL 2005 database?

Thanks,
Miguel

View 2 Replies View Related

How To Write A Function For MS SQL 2005 To Save Value After Underscore?

Apr 14, 2008

Hi Gurus,

How do I write a T-SQL function for a string before a underscore is found?


Thanks Gurus.

View 2 Replies View Related

How To Save A Query Result In ANSI In SQL 2005?

Feb 28, 2007

Hi

When I was using Enterprise Manager (SQL 2000) and stored my query result (to file), it was stored in Ansi Encoding.

After I upgrade to SQL Server Management Studio (2005), it seams that when I store the query result to file it's Unicode Encoded. This give me a lot of trouble, when I use other program who I must read this file. For small result set, I can open it in Notepad, save it as ANSI, and then use it in my other program. When the result set is so big that Notepad not can help me, I can't use the stored result set.

There must be a way to store my Query result in Ansi encoding, but I don't know how I can do it. Hope some one know, and can help me solve this big problem.

JF

View 1 Replies View Related

Save DTS Package Created In DTS Designer(SQL 2000) On SQL 2005 Under Legacy

May 13, 2008



Hi All,
One of my user was able create DTS package using DTS Wizard, working from his workstation and saved this DTS in Legacy(in Data Transaformation services) on different SQL 2005 EE SP 2(9.0.3042) production server..
At same time he has no access to msdb on this SQL 2005 server(he also not sysadmin for this server).. How this could happen..??

View 2 Replies View Related

Legacy DTS Package On SQL 2005 - Give User Rights To Save DTS Packages...

Oct 4, 2007

We have a SQL server with many legacy DTS packages. sa and Admins can open them and change them then save them but we need to allow the DTS people (Developers) the rights to save the package after they have opened it and modified it.

Thanks

View 6 Replies View Related

SQL Tools :: Unable To Save A Maintenance Plan In 2005 / Class Not Registered

Nov 2, 2015

Unable to save a maintenance plan in sql server 2005, SP3. Error is class not registered.

View 2 Replies View Related

Restore Of Case Insensitive Database To A Case Sensitive Database - SQL Server 2000

Jul 20, 2005

Yesterday I received a response to my CI/CS Collation problem and therecommendation was to try and restore a CI Collation database to a CSCollation database. After creating a blank CS database a full restore(Force restore over existing database) does change the Collation toCI. I'm unsure as to how I can restore without changing theCollation. Any suggestions?

View 2 Replies View Related

Case Sensitive Sql Server

Oct 13, 2006

in sql server 2000 or 2003 how can i tell if a database is case sensitive or not??

View 2 Replies View Related

Sql Server Case Sensitive?????????

Aug 31, 2006

hi friends, is it possible to make sqlserver case sensitive?
i mean is there any options to set while installation?

thank you very much

View 3 Replies View Related

Case-sensitive SQL Server

Feb 14, 2008

Dear SQL Experts,


Can I change an existing 2000 sql server to case-sensative?

Books on-line tell you how to create one during setup, but requirements around here dictate that I chage my existing setup.


Any help would be greatly appreciated.

Thanks

View 6 Replies View Related

SQL Server Case Sensitive Sproc

Mar 5, 2007

I have a Users table with UserName and Password columns, in SQL Server 2005. 
Currently the SQL Server is not set up to use case-sensitive criteria in the sprocs.  How can I write my sproc to be case sensitive when searching on username and password?

View 1 Replies View Related

Make MS SQL Server Case-sensitive

Jul 20, 2005

I have already install my Microsoft SQL server 2000 as not casesensitive, how to I change it to be case sensitive?

View 2 Replies View Related

Save A Images Into SQL Server Using VB.Net

Feb 29, 2008

I am trying to create a website that people can upload an image and have it saved to a database.  Can someone point me in the right direction on this?  What properties need to be saved in the db and how?

View 4 Replies View Related

How To Save A File In SQL Server

Feb 25, 2004

I have the need to allow a user to upload a file via the web and then save it into a database. THen I also need to be able to retrieve the file for download.

Can someone give me guidance as to code or a sample on how to do this.

Thanks.

View 2 Replies View Related

Image Save To SQL Server

Apr 7, 2004

When I am trying to save byte[] of an image to SQL server which is having an image column, I am getting an error like this " A severe error occured on the current command. The results, if any, should be discarded.". I am trying to save through a stored procedure.
In the sp also, the datatype is image.

Can you give a reply to this?

View 4 Replies View Related

How To Save Html In SQL Server

Oct 31, 2004

I am using a Wysiwig editor, FCKeditor, i my CMS. I try to save the html text from the editor in a SQL Server. But noting get stored in the database.

I think the problem is how the tabel in the datebase is setup.

How shall a tabel look like so it can store html?

View 1 Replies View Related

How Save A DTS Package On SQL Server?

May 16, 2002

Hi all,
When I try to save a DTS package on SQL Server(local),I have a error message "refused acces" ,T don't know what's the problem?

Any help will be appreciate?
thanks in advance

View 3 Replies View Related







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