in my table
create table test (
month_year varchar(50))
insert into test values ('06-07')
insert into test values ('05/07')
i want 12 month records from current date.
----- Original Message -----
From: "Edwards Ed " <mssqldba-ezmlmshield-x6222854.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Friday, June 29, 2007 4:09 PM
Subject: RE: Transaction Isolation Level
> Hey Richard,
>
> No, there is no way to change the isolation level at the database level
> in
> SQL 2000.
>
> If you experience locking contentions, please try to analyze which
> transactions, connections, and stored procedures are causing the most
> problem. Then perhaps you can change the isolation level of just a few
> stored procedure. You may also want to look at if lock escalation is a
> problem. Changing every stored procedure to read uncommitted isolation
> level is usually not the right answer. It may cause data consistency
> problems if the application is not designed to work with read
> uncommitted
> isolation level.
>
>
> Just for your information, if you are MSDN subscriber, and you are
> interested in looking into features of SQL 2005 beta 2, there is a
> feature
> called "snapshot isolation", which allows you to set a flag on the
> database
> and make read committed isolation level take no locks while still
> returning
> consistent and committed results.
>
>
> It's Fridayyyyyyyyy! Partyyyyyyyyyyy! Hehe.
>
> Have a great Day and Weekend!
>
>
>
>
>
>
> Please take a few minutes to provide feedback on the quality of service
> you received from our staff. The Department of Education values your
> feedback as a customer. Commissioner of Education Jeanine Blomberg is
> committed to continuously assessing and improving the level and quality of
> services provided to you.Simply use the link below. Thank you in advance
> for completing the survey.
>
>
> http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]
>
>
>
>
> -----Original Message-----
> From: Richard Wadsworth
> [mailto:mssqldba-ezmlmshield-x41729652.[Email address protected]
> Sent: Friday, June 29, 2007 5:16 AM
> To: LazyDBA Discussion
> Subject: Transaction Isolation Level
>
> Hi,
>
>
> Is there a way of setting the transaction isolation level for a DB
> (possibly even at server level). I'd like our reporting DB to be set to
> read uncommitted, but I can't see how to do this without changing this
> for all procs.
>
>
> Any ideas?
>
>
>
> Thanks
> Rick
>
>
>
> Richard Wadsworth
>
> Database Administrator
>
> CARCRAFT
>
>
>
> E: richard.[Email address protected]
>
> T: 07811 341277
>
> Nixon Street, Rochdale OL11 3JW
>
> www.carcraft.co.uk
>
>
>
>
>
> This email and any files transmitted with it are strictly confidential.
> It is for the intended recipient only. If you have received the email in
> error please notify the author by replying to this email. If you are not
> the intended recipient you must not disclose, distribute, copy, print or
> rely on this email in anyway. Any views which are expressed in this
> e-mail are solely the personal opinion of the author and do not
> necessarily represent the views of CC Automotive Group Limited.
> Registered in England and Wales No: 819414. Registered office: Nixon
> Street, Rochdale, Lancashire OL11 3JW. This footnote also confirms this
> email message has been swept for the presence of known computer viruses
> before transmission.
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
MS Sql Server LazyDBA home page