Hi,

In one of our customer's site at the time of saving a
transaction they hve encountered the following error:

[Microsoft][ODBC SQL Server][SQL Server]Transaction
(Process ID 60) was deadlocked on {lock} resources
with another process and been chosen as the deadlock
victim. Rerun the transaction.

Please suggest on what conditions the above error
occurs and how to control the same.

Thanks in advance.

Uma



__________________________________
Do you Yahoo!?
Yahoo! Small Business - Try our new resources site!
http://smallbusiness.yahoo.com/resources/

Hi,

Deadlock occurs when two different connections try to acquire a lock on
the other's resource without releasing a lock on their own resources.

This can be avoided by taking various precautions like
- keeping your transactions small
- try not to cris-cross the objects on which locks are required (this
mean in your programming you should take care to call the objects in a
logical order) etc...

Whatever the precautions taken, you may face the deadlocks at sometime
in your application.  So, your application should be designed to handle
these exceptions.

For any further info, you can look into Books online.

Thanks & Regards,

Mitra

-----Original Message-----
From: Gomathi [mailto:umanilakantan@...]
Sent: Wednesday, March 30, 2005 11:08 AM
To: sqlcon@yahoogroups.com
Subject: [mugh-sqlcon] (Process ID 60) was deadlocked



Hi,

In one of our customer's site at the time of saving a
transaction they hve encountered the following error:

[Microsoft][ODBC SQL Server][SQL Server]Transaction
(Process ID 60) was deadlocked on {lock} resources
with another process and been chosen as the deadlock
victim. Rerun the transaction.

Please suggest on what conditions the above error
occurs and how to control the same.

Thanks in advance.

Uma



__________________________________
Do you Yahoo!?
Yahoo! Small Business - Try our new resources site!
http://smallbusiness.yahoo.com/resources/





SqlCon is a special interests group run under the aegis of MUGH -
http://www.mugh.net
http://www.mugh.net/sql

Visit http://www.mugh.net/dnug to join .NET User Group.

Yahoo! Groups Links

----- Original Message -----

From: s a

To: sqlcon

Sent: Thursday, March 31, 2005 8:47 PM

Subject: [mugh-sqlcon] sql reporting services

Hi frenz

 

could anybody tell me the detailed introduction about Sql Reporting Services.

 

 

take care

 

 

bye

 

 

---

Do you Yahoo!?
Yahoo! Small Business - Try our new resources site!

SqlCon is a special interests group run under the aegis of MUGH - http://www.mugh.net
http://www.mugh.net/sql

Visit http://www.mugh.net/dnug to join NET User Group.

One of the users sent me this mail ..I thought of opening it to group...

He is executing a JOB on SQL SERVER AGENT
and getting following error


Executed as user: HO1-VPDB-NMS01\dashdbnmsadm. sqlmaint.exe failed.
[SQLSTATE 42000] (Error 22029).  The step failed.

----- Original Message -----

From: viswamitra.chevendra@wiprocom

To: sqlcon@yahoogroups.com

Sent: Monday, April 04, 2005 10:53 AM

Subject: RE: [mugh-sqlcon] Can we create Insert statements of existing data

Aaditya,

 

You can write something like this.  (this needs modification, I am just giving an example)

 

For a table with three columns, first two integers and the third character the select would be

 

Select ‘INSERT <TABLENAME> VALUES ‘ + col1 + ‘,’ + col2 + ‘,’’’ + col3 + ‘’’’

FROM table1

 

I don’t have SQL Server on my m/c to test this.  So, there can be some syntax problems

 

Thanks & Regards,

 

Mitra

 

---

From: Aaditya Tarhalkar [mailto:aadityasqldba@...]
Sent: Thursday, March 31, 2005 8:11 PM
To: SQL CON
Subject: [mugh-sqlcon] Can we create Insert statements of existing data

 

Hi,

 

I am trying to create a script file for creating all the database objects and want to include some insert statements of master data along with the those objects. But the data is very large and writing the insert statements is almost impossible.Is it possible to create insert statements of existing data so that I can include those statements into the script file. Please help me on this. Thanks in advance.

 

Aaditya.

---

Do you Yahoo!?
Yahoo! Small Business - Try our new resources site!

SqlCon is a special interests group run under the aegis of MUGH - http://www.mugh.net
http://www.mugh.net/sql

Visit http://www.mugh.net/dnug to join NET User Group.

SqlCon is a special interests group run under the aegis of MUGH - http://www.mugh.net
http://www.mugh.net/sql

Visit http://www.mugh.net/dnug to join NET User Group.

Here is an other way to avoid Deadlocks...as shared sql SErVER
performace people...

Tips for Reducing SQL Server Deadlocks




Deadlocking occurs when two user processes have locks on separate
objects and each process is trying to acquire a lock on the object
that the other process has. When this happens, SQL Server ends the
deadlock by automatically choosing one and aborting the process,
allowing the other process to continue. The aborted transaction is
rolled back and an error message is sent to the user of the aborted
process. Generally, the transaction that requires the least amount of
overhead to rollback is the transaction that is aborted.

As you might imagine, deadlocks can use up a lot of SQL Server's
resources, especially CPU power, wasting it unnecessarily.

Most well-designed applications, after receiving a deadlock message,
will resubmit the aborted transaction, which most likely can now run
successfully. This process, if it happens often on your server, can
drag down performance. If the application has not been written to
trap deadlock errors and to automatically resubmit the aborted
transaction, users may very well become confused as to what is
happening when they receive deadlock error messages on their computer.

Here are some tips on how to avoid deadlocking on your SQL Server:

Ensure the database design is properly normalized.



Have the application access server objects in the same order each
time.



During transactions, don't allow any user input. Collect it before
the transaction begins.



Avoid cursors.



Keep transactions as short as possible. One way to help accomplish
this is to reduce the number of round trips between your application
and SQL Server by using stored procedures or keeping transactions
with a single batch. Another way of reducing the time a transaction
takes to complete is to make sure you are not performing the same
reads over and over again. If you do need to read the same data more
than once, cache it by storing it in a variable or an array, and then
re-reading it from there.



Reduce lock time. Try to develop your application so that it grabs
locks at the latest possible time, and then releases them at the very
earliest time.



If appropriate, reduce lock escalation by using the ROWLOCK or
PAGLOCK.



Consider using the NOLOCK hint to prevent locking if the data being
locked is not modified often.



If appropriate, use as low of an isolation level as possible for the
user connection running the transaction.



Consider using bound connections.

[6.5, 7.0, 2000] Updated 7-14-2003

*****

When a deadlock occurs, by default, SQL Server choose a
deadlock "victim" by identifying which of the two processes will use
the least amount of resources to rollback, and then returns error
message 1205.

But what if you don't like default behavior? Can you change it? Yes,
you can, by using the following command:

SET DEADLOCK_PRIORITY { LOW | NORMAL | @deadlock_var }

WHERE:

Low tells SQL Server that the current session should be the preferred
deadlock victim, not the session that incurs the least amount of
rollback resources. The standard deadlock error message 1205 is
returned.

Normal tells SQL Server to use the default deadlock method.

@deadlock_var is a character variable specifying which deadlock
method you want to use. Specify "3" for low, or "6" for normal.

This command is set a runtime for a specified user connection. [2000]
Added 5-23-2003

*****

To help identify deadlock problems, use the SQL Server Profiler's
Create Trace Wizard to run the "Identify The Cause of a Deadlock"
trace. This will provide you with the raw data you need to help
isolate the causes of deadlocks in your databases.  [7.0]

*****

Consider turning on SQL Server deadlock tracing in order to track
deadlocks, when you are having deadlock-related issues. The overhead
for doing this is minimal.

DBCC TRACEON (3605,1204,-1)

Once this is run, then all deadlocking activity will be written to
the SQL Server log file. [7.0, 2000] Added 11-22-2004

*****

To help identify which tables or stored procedures are causing
deadlock problems, turn on trace flag 1204 (outputs basic trace data)
or trace flag 1205 (outputs more detailed trace data). Be sure to
turn off this trace flag when you are done, as this trace can eat up
SQL Server's resources unnecessarily, hurting performance. [6.5, 7.0,
2000] Updated 10-29-2004

*****

Ideally, deadlocks should be eliminated from your applications. But
if you are unable to eliminate all deadlocks in your application, be
sure to include program logic in your application to deal with killed
transactions in a user-friendly way.

For example, let's say that two transactions are deadlocked and that
SQL Server kills one of the transactions. In this case, SQL Server
will raise an error message that your application needs to respond
to. In most cases, you will want your application to wait a random
amount of time after the deadlock in order to resubmit the killed
transaction to SQL Server.

It is important that there is a random waiting period because it is
possible that another contending transaction could also be waiting,
and you don't want both contending transactions to wait the same
amount of time and then both try to execute at the same time, causing
another deadlock.

If your error-trapping code is good, the end user should never know
that the deadlock even occurred. [6.5, 7.0, 2000] Updated 8-14-2003

*****

One way to help prevent deadlocks is to use the UPDLOCK optimizer
hint. What this hint does is to force SQL Server to use an update
lock instead of a shared lock.

A shared lock occurs when your query wants to read a row, but does
not want to change it. Shared locks can co-exist with other shared
locks, which means that multiple shared locks can exist on the same
row, page, or table. A shared lock prevents the locked resource from
receiving an exclusive lock, so if another user runs a query that
need to UPDATE a row, they will not be able to until all of the
shared locks on the row are gone. Once a shared lock is no longer
needed by a query that is reading it, it is immediately released.

An update lock is a hybrid between an shared and an exclusive lock.
Update locks are used when a query needs to update one or more
records, but until the WHERE clause is complete, the query doesn't
know which records it needs to UPDATE. So instead of putting an
exclusive lock on every record (which reduces concurrency and your
application's performance) it places a shared lock on the requisite
records, and only when the WHERE clause is completed, are exclusive
locks put on the records that need to be UPDATEDed. The shared locks
created by an update lock are held until the WHERE clause is
completed running, not immediately released after the row is read, as
is normal with a shared lock.

So how does using the UPDLOCK hint help to reduce deadlocks? If you
force the use of an update lock instead of a shared lock when reading
tables, the UPDLOCK hint holds the locks until the end of your
statement or transaction. This allows you to read data without
blocking other users, and to update data later with the knowledge
that the data has not changed since you last read it. This helps to
prevent deadlocks because other users can't sneak in and lock a
record that you will need before you need it. [6.5, 7.0, 2000]
Updated 8-4-2003






--- In sqlcon@yahoogroups.com, <viswamitra.chevendra@w...> wrote:
>
> Hi,
>
> Deadlock occurs when two different connections try to acquire a
lock on
> the other's resource without releasing a lock on their own
resources.
>
> This can be avoided by taking various precautions like
> - keeping your transactions small
> - try not to cris-cross the objects on which locks are required
(this
> mean in your programming you should take care to call the objects
in a
> logical order) etc...
>
> Whatever the precautions taken, you may face the deadlocks at
sometime
> in your application.  So, your application should be designed to
handle
> these exceptions.
>
> For any further info, you can look into Books online.
>
> Thanks & Regards,
>
> Mitra
>
> -----Original Message-----
> From: Gomathi [mailto:umanilakantan@y...]
> Sent: Wednesday, March 30, 2005 11:08 AM
> To: sqlcon@yahoogroups.com
> Subject: [mugh-sqlcon] (Process ID 60) was deadlocked
>
>
>
> Hi,
>
> In one of our customer's site at the time of saving a
> transaction they hve encountered the following error:
>
> [Microsoft][ODBC SQL Server][SQL Server]Transaction
> (Process ID 60) was deadlocked on {lock} resources
> with another process and been chosen as the deadlock
> victim. Rerun the transaction.
>
> Please suggest on what conditions the above error
> occurs and how to control the same.
>
> Thanks in advance.
>
> Uma
>
>
>
> __________________________________
> Do you Yahoo!?
> Yahoo! Small Business - Try our new resources site!
> http://smallbusiness.yahoo.com/resources/
>
>
>
>
>
> SqlCon is a special interests group run under the aegis of MUGH -
> http://www.mugh.net
> http://www.mugh.net/sql
>
> Visit http://www.mugh.net/dnug to join .NET User Group.
>
> Yahoo! Groups Links

----- Original Message -----

From: Gomathi

To: sqlcon@yahoogroups.com

Sent: Wednesday, March 30, 2005 11:08 AM

Subject: [mugh-sqlcon] (Process ID 60) was deadlocked

Hi,

In one of our customer's site at the time of saving a
transaction they hve encountered the following error:

[Microsoft][ODBC SQL Server][SQL Server]Transaction
(Process ID 60) was deadlocked on {lock} resources
with another process and been chosen as the deadlock
victim. Rerun the transaction.

Please suggest on what conditions the above error
occurs and how to control the same.

Thanks in advance.

Uma


           
__________________________________
Do you Yahoo!?
Yahoo! Small Business - Try our new resources site!
http://smallbusiness.yahoo.com/resources/





SqlCon is a special interests group run under the aegis of MUGH - http://www.mugh.net
http://www.mugh.net/sql

Visit http://www.mugh.net/dnug to join NET User Group.

----- Original Message -----

From: veer

To: sqlcon@yahoogroups.com

Sent: Monday, April 04, 2005 11:08 AM

Subject: [mugh-sqlcon] A User facing problem

One of the users sent me this mail ..I thought of opening it to group...

He is executing a JOB on SQL SERVER AGENT
and getting following error


Executed as user: HO1-VPDB-NMS01\dashdbnmsadm. sqlmaint.exe failed.
[SQLSTATE 42000] (Error 22029).  The step failed.









SqlCon is a special interests group run under the aegis of MUGH - http://www.mugh.net
http://www.mugh.net/sql

Visit http://www.mugh.net/dnug to join NET User Group.

Write & Win!

With the MSDN Magazine APAC Series Article Writing Competition



Great software developers help to make great applications. But how
do we foster and build a community of top-notch developers? Now MSDN
Magazine Australia New Zealand, India and Southeast Asia editions
are offering a new way to have your theories and explanations tested
and aired. Send your technical articles of 600-2000 words to
comp@... and we will consider your article for
publication in one of our titles*. And if that's not enough of an
incentive, published writers will receive one of the following great
prizes^. So get your articles in by 29  April; and stay tuned for
our programming competition, to be launched soon!



FIRST PRIZE

One year's hosting on an ICO Microsoft Windows Virtual Dedicated
Server running ASP.NET 2.0 (Whidbey).

Win a year of access to a true, dedicated operating system running
in its own space through ICO, Australia's only high security,
business critical .NET web hosting specialist. Have complete control
through Remote Desktop and do (virtually) anything with the system
that you can do with dedicated hardware. Value: US$3,000.

Adobe Acrobat 7.0 Professional: More Than Creating PDF

The new Adobe Acrobat 7.0 Professional provides users with a raft of
features beyond PDF creation. Manage a range of essential business
activities, create intelligent forms and include virtually anyone in
an electronic review of a PDF document with the commenting tools
function. Value: US$450



SECOND PRIZE

One Year's MSDN Universal Subscription

MSDN Universal Subscription delivers the most comprehensive set of
Microsoft software necessary to build and fully test XML Web
services and applications. With Visual Studio .NET Enterprise
Architect and other software, it provides priority access to
essential resources for developers - including timely delivery of
everything to build XML Web services and applications. Value:
A$5,000**

Xbox Games Ninja Gaiden and the Classic Title Rallisport Challenge

Need to take some time out? Take on the role of powerful ninja Ryu
Hayabusa, who seeks revenge after his clan is massacred by the Vigor
Empire. And platinum hit RalliSport Challenge puts you in the
driver's seat of rally racing excitement. Value: US$70



THIRD PRIZE

Crystal Reports 10 Advanced

Developer

Crystal Reports' intuitive reporting toolkit helps solve the
challenges associated with presenting formated data in applications.
It provides developers with a faster way to easily access data,
transform it into dynamic information and integrate it into web and
windows applications. Visual designer makes it easy to transform
data into dynamic content. Value: US$2000

Sparx Systems' New Enterprise Architect v4.5 and increased MDG Link
Range

EA v4.5 is a flexible, complete and powerful UML modelling tool for
the Windows platform, and provides the competitive edge for system
development, project management and business analysis. Sparx Systems
have also provided access to their increased MDG Link series. Value:
US$320



Terms and conditions: * Articles should be submitted in Microsoft
Word document or HTML format and be less than 2.5 megabytes in file
size. Articles which exceed the body text word count of 2,000 words
will not be considered for publication. ^Prizes are not available to
Microsoft employees and their relatives. Submitted articles much be
in English and will be judged based on their originality, technical
accuracy as well as the quality of English used. Article authors
must currently be residing with the Asia Pacific region, and their
articles must not have been published previously in a print
magazine. Article submission should include the full name of the
author, their title, contact email address and phone number
(including country code) as well as the country from which they have
submitted their article. Charlton Media has the right to refuse
articles submitted by people who do not satisfy these requirements.
The judging panel consists of MSDN Magazine Australia New Zealand
Editor Andrew Parsons, MSDN Magazine India and Southeast Asia Editor
Angela McFeeters, a Microsoft representative and one rotating
independent judge. The independent judge for competition number one
is White Bear Consulting Director Dr Greg Low. At least one prize-
winning article will be published in every alternate edition of MSDN
Magazine APAC series depending on the quality of submissions and
availability of space. **MSDN Universal subscription is available
only to residents of Australia. The prize winner will receive 5
copies of the magazine that their story is published in as well as
the above-stated prize. Articles for the first round of the
competition will be received until 29 April 2005. Submissions beyond
that date will be entered into the next round of the competition.

On Mon, 4 Apr 2005 12:20:02 +0530, "Roji. P. Thomas"
<thomasroji@...> wrote:
> Veer,
>
>     Its hard to suggest a solution without knowing what exactly the job
> does.
>
>     Still a fgew things to try...
>
>     1. copy the SQL statements to Query Analyser and run it there.
>     2. Make sure the user has enough permissions.
>     3. Goto SQL Server Agent->Jobs, right-click it and Select View job
>        history and check the box "Show step details" in the upper-right
> corner,
>        to find what the error actually is.
>     4. also refer to
>
>
> http://support.microsoft.com/default.aspx?scid=kb;en-us;301292&Product=sql
>
>         http://support.microsoft.com/?id=288577
>
>         http://support.microsoft.com/?id=326485
>
> Regards
> Roji. P. Thomas
> NetAssetManagement
>
>   ----- Original Message -----
>   From: veer
>   To: sqlcon@yahoogroups.com
>   Sent: Monday, April 04, 2005 11:08 AM
>   Subject: [mugh-sqlcon] A User facing problem
>
>
>
>
>   One of the users sent me this mail ..I thought of opening it to group...
>
>   He is executing a JOB on SQL SERVER AGENT
>   and getting following error
>
>
>   Executed as user: HO1-VPDB-NMS01\dashdbnmsadm. sqlmaint.exe failed.
>   [SQLSTATE 42000] (Error 22029).  The step failed.
>
>
>
>
>
>
>
>
>
>   SqlCon is a special interests group run under the aegis of MUGH -
> http://www.mugh.net
>   http://www.mugh.net/sql
>
>   Visit http://www.mugh.net/dnug to join .NET User Group.
>
>
>
>
> ------------------------------------------------------------------------------
>   Yahoo! Groups Links
>
>     a.. To visit your group on the web, go to:
>     http://groups.yahoo.com/group/sqlcon/
>
>     b.. To unsubscribe from this group, send an email to:
>     sqlcon-unsubscribe@yahoogroups.com
>
>     c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
>
>
>
>

MUGH (Microsoft User Group Hyderabad) cordially invites you all to
DEVCON 2005.

You can register online at http://www.mugh.net/devcon

This is a Full Day Event Focusing on Various Topics, featuring Dev
Guru's and IT Celebrities in India.

You also will get a chance to ask your Queries and Win Prizes!

Take a Look at Existing and Emerging Microsoft Technologies that
will shape your Career!!!

And of course, it is Free for all the Developers -
(But do not forget to register your name. Entry is restricted to
registrants only, so do not forget your identity like business card
or ID card)



PS: Lunch and Tea would be served. Free Entry. Registration is must.

DEVCON 2005      -  AGENDA

Date: APRIL 10th 2005

Time: 10.00 A.M to 5.30 P.M

Venue:
  CHIP Auditorium, Cyber Towers, Hi-Tech City, Hyderabad.


Session Details:

10.00 A.M – 10.30 A.M
  Registration, MUGH Introduction, Key Note, Cake...

10.30 A.M – 11.00 A.M
  MUGH Anniversary

11.00 A.M - 12.00 P.M
  Session I - Jani M.S.V (VS 2005 - Express Products....)

12.00 P.M - 1.00   P.M
  Session II - Gaurav Khanna - (Indigo - Connected Systems Framework)

1.00 P.M – 2.00 P.M
  Lunch


2.00 P.M - 3.00 P.M
  Session III - Pratap J Ladhani on Testing in VSTS

3.00 P.M – 4.00 P.M
  Session IV - IDC Team on SQL Server 2005 Mobile

4.00 P.M – 5.00 P.M
  Session V - Deepak Gulati on
  Globalization and   Localization with .NET

5.00 P.M – 5.30 P.M
  End Note

Hi

In the SQL Server Backup window (Enterprise Manager/Database/All Tasks/
Backup Database)/Destination section if I decide to back up the
database to a file on the local hard drive, do I have to give any
extension to the file where I'm going to back my database up(ex.
Northwind_Backup.bak) or no extension is required (ex.
Northwind_Backup)?

Thank you
Kind Regards
Luca

Hi,

 

I am trying to create a script file for creating all the database objects and want to include some insert statements of master data along with the those objects. But the data is very large and writing the insert statements is almost impossible.Is it possible to create insert statements of existing data so that I can include those statements into the script file. Please help me on this. Thanks in advance.

 

Aaditya.

---

Do you Yahoo!?
Yahoo! Small Business - Try our new resources site!

SqlCon is a special interests group run under the aegis of MUGH - http://www.mugh.net
http://www.mugh.net/sql

Visit http://www.mugh.net/dnug to join .NET User Group.

Hi Raja,

 

Could you please try this...

 

In DTS Wizard after configured your source, target and other stuffs, save it as a DTS package. Open the DTS package, edit your concern DTS Transform Data Task Properties, choose Options tab, there change the oprions (Use fast load and Always commit final batch ) according to your requirement.

 

 

Thank you,

SK Chandra

Raja Sekhar <rajasekhara@...> wrote:

Hi himanshu,

 

 

1>> How many total rec are there

    13

2>> What is the error you are getting ??

Error at Destination for row number 2. Errors encountered so far in this task: 1

Insert Error, column 8 (T_DATE', DBTYPE_DBTIMESTAMP), status 6: Data overflow

regds

raja

-----Original Message-----
From: himanshu sinha [mailto:kr_himanshu@...]
Sent: Tuesday, March 15, 2005 3:58 PM
To: MSDatabase@yahoogroups.com; rajasekhara@...
Subject: Re: [MSDatabase] Fwd: [mugh-sqlcon] FW: Need help

Please let me the follwoing :

 

1>> How many total rec are there

 

2>> What is the error you are getting ??

 

regds

 HImanshu

 

Raja Sekhar <rajasekhara@...> wrote:

To: <sqlcon@yahoogroups.com>
From: "Raja Sekhar" <rajasekhara@...>
Date: Tue, 15 Mar 2005 11:46:24 +0530
Subject: [mugh-sqlcon] FW: Need help

Hi  All ,

 

Need a small information on data migration using  DTS in SQL Server

 

I have used Import/Export wizard of DTS and tried to insert data from Source Table to Target Table. It is observed that, when a particular record insertion is failed, the entire transaction is rolled back without leaving the successfully transformed records. What my questions is, Is there any way to auto commit the successful records and leave the unsuccessful records?

 

I have also tried using a stored Procedure in which INSERT INTO <Target Table > SELECT FROM <Source Table> statement is written , but no use. It is also failing the complete transaction.

 

 

Can you please post to user groups and send me a reply? It will really be a great help.

 

regards
Raja Sekhar 

SqlCon is a special interests group run under the aegis of MUGH - http://www.mugh.net
http://www.mugh.net/sql

Visit http://www.mugh.net/dnug to join .NET User Group.

Regards,
Himanshu Kumar Sinha
MCP
Microsoft Corporation
Office: +91 (40) 5547 3617
Mobile: +91 9440871180
Email: v-hsinha@...

Obstacles are those frightful things you see when you fail to focus on your goal

---

Do you Yahoo!?
Yahoo! Mail - 250MB free storage. Do more. Manage less.

Regards,
Himanshu Kumar Sinha
MCP
Microsoft Corporation
Office: +91 (40) 5547 3617
Mobile: +91 9440871180
Email: v-hsinha@...

Obstacles are those frightful things you see when you fail to focus on your goal

---

Do you Yahoo!?
Yahoo! Small Business - Try our new resources site!

SqlCon is a special interests group run under the aegis of MUGH - http://www.mugh.net
http://www.mugh.net/sql

Visit http://www.mugh.net/dnug to join .NET User Group.

---

Do you Yahoo!?
Yahoo! Small Business - Try our new resources site!

SqlCon is a special interests group run under the aegis of MUGH - http://www.mugh.net
http://www.mugh.net/sql

Visit http://www.mugh.net/dnug to join .NET User Group.

MUGH (Microsoft User Group Hyderabad) cordially invites you all to
DEVCON 2005.

You can register online at http://www.mugh.net/devcon

This is a Full Day Event Focusing on Various Topics, featuring Dev
Guru's and IT Celebrities in India.

You also will get a chance to ask your Queries and Win Prizes!

Take a Look at Existing and Emerging Microsoft Technologies that
will shape your Career!!!

And of course, it is Free for all the Developers -
(But do not forget to register your name. Entry is restricted to
registrants only, so do not forget your identity like business card
or ID card)



PS: Lunch and Tea would be served. Free Entry. Registration is must.

DEVCON 2005      -  AGENDA

Date: APRIL 10th 2005

Time: 10.00 A.M to 5.30 P.M

Venue:
CHIP Auditorium, Cyber Towers, Hi-Tech City, Hyderabad.


Session Details: 

10.00 A.M – 10.30 A.M
Registration, MUGH Introduction, Key Note, Cake...

10.30 A.M – 11.00 A.M
MUGH Anniversary

11.00 A.M - 12.00 P.M
Session I - Jani M.S.V (VS 2005 - Express Products....)

12.00 P.M - 1.00   P.M
Session II - Gaurav Khanna - (Indigo - Connected Systems Framework)

1.00 P.M – 2.00 P.M
Lunch


2.00 P.M - 3.00 P.M
Session III - Pratap J Ladhani on Testing in VSTS

3.00 P.M – 4.00 P.M
Session IV - IDC Team on SQL Server 2005 Mobile

4.00 P.M – 5.00 P.M
Session V - Deepak Gulati on
Globalization and   Localization with .NET

5.00 P.M – 5.30 P.M
End Note








SqlCon is a special interests group run under the aegis of MUGH - http://www.mugh.net
http://www.mugh.net/sql

Visit http://www.mugh.net/dnug to join .NET User Group.

On Mon, 4 Apr 2005 12:20:02 +0530, "Roji. P. Thomas"
<thomasroji@...> wrote:
> Veer,
>
>     Its hard to suggest a solution without knowing what exactly the job
> does.
>
>     Still a fgew things to try...
>
>     1. copy the SQL statements to Query Analyser and run it there.
>     2. Make sure the user has enough permissions.
>     3. Goto SQL Server Agent->Jobs, right-click it and Select View job
>        history and check the box "Show step details" in the upper-right
> corner,
>        to find what the error actually is.
>     4. also refer to
>
>       
> http://support.microsoft.com/default.aspx?scid=kb;en-us;301292&Product=sql
>    
>         http://support.microsoft.com/?id=288577
>
>         http://support.microsoft.com/?id=326485
>
> Regards
> Roji. P. Thomas
> NetAssetManagement
>
>   ----- Original Message -----
>   From: veer
>   To: sqlcon@yahoogroups.com
>   Sent: Monday, April 04, 2005 11:08 AM
>   Subject: [mugh-sqlcon] A User facing problem
>
>
>
>
>   One of the users sent me this mail ..I thought of opening it to group...
>
>   He is executing a JOB on SQL SERVER AGENT
>   and getting following error
>
>
>   Executed as user: HO1-VPDB-NMS01\dashdbnmsadm. sqlmaint.exe failed.
>   [SQLSTATE 42000] (Error 22029).  The step failed.
>
>
>
>
>
>
>
>
>
>   SqlCon is a special interests group run under the aegis of MUGH -
> http://www.mugh.net
>   http://www.mugh.net/sql
>
>   Visit http://www.mugh.net/dnug to join .NET User Group.
>
>
>
>
> ------------------------------------------------------------------------------
>   Yahoo! Groups Links
>
>     a.. To visit your group on the web, go to:
>     http://groups.yahoo.com/group/sqlcon/
>      
>     b.. To unsubscribe from this group, send an email to:
>     sqlcon-unsubscribe@yahoogroups.com
>      
>     c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
>
>
>
>





SqlCon is a special interests group run under the aegis of MUGH - http://www.mugh.net
http://www.mugh.net/sql

Visit http://www.mugh.net/dnug to join .NET User Group.

Hi

In the SQL Server Backup window (Enterprise Manager/Database/All Tasks/
Backup Database)/Destination section if I decide to back up the
database to a file on the local hard drive, do I have to give any
extension to the file where I'm going to back my database up(ex.
Northwind_Backup.bak) or no extension is required (ex.
Northwind_Backup)?

Thank you
Kind Regards
Luca








SqlCon is a special interests group run under the aegis of MUGH - http://www.mugh.net
http://www.mugh.net/sql

Visit http://www.mugh.net/dnug to join .NET User Group.

Veer,

 

Q1) Are you running MSDE 7.0 / MSDE 2000? If Yes than please follow this article:

For MSDE 7.0: http://support.microsoft.com/kb/246815/EN-US/

For MSDE 2K: http://support.microsoft.com/kb/295022/EN-US/

 

If you are not running MSDE edition of SQL Server than try the following:

1] Make sure that you have the latest SQL Service Pack on the box [SQL2KSP3a]

2] Make sure that the user invoking SQL Maintenance Wizard is a part of Local Admin Group on the box and that trusted connections connections are enabled

3] Make sure SQLMAINT.exe and all files related to it are there on the box and properly registered. [I would suggest that instead of doing this just reapply SQL Server Service Pack 3a]

 

Honestly speaking, if this is happening on a regular basis than I would just write a small script that will take care of performing all the tasks that SQLMAINT would do.

 

Gracias.

Saleem Hakani

 

CHK <harishkumar.c@...> wrote:

On Mon, 4 Apr 2005 12:20:02 +0530, "Roji. P. Thomas"
<thomasroji@...> wrote:
> Veer,
>
>     Its hard to suggest a solution without knowing what exactly the job
> does.
>
>     Still a fgew things to try...
>
>     1. copy the SQL statements to Query Analyser and run it there.
>     2. Make sure the user has enough permissions.
>     3. Goto SQL Server Agent->Jobs, right-click it and Select View job
>        history and check the box "Show step details" in the upper-right
> corner,
>        to find what the error actually is.
>     4. also refer to
>
>       
> http://support.microsoft.com/default.aspx?scid=kb;en-us;301292&Product=sql
>    
>         http://support.microsoft.com/?id=288577
>
>         http://support.microsoft.com/?id=326485
>
> Regards
> Roji. P. Thomas
> NetAssetManagement
>
>   ----- Original Message -----
>   From: veer
>   To: sqlcon@yahoogroups.com
>   Sent: Monday, April 04, 2005 11:08 AM
>   Subject: [mugh-sqlcon] A User facing problem
>
>
>
>
>   One of the users sent me this mail ..I thought of opening it to group...
>
>   He is executing a JOB on SQL SERVER AGENT
>   and getting following error
>
>
>   Executed as user: HO1-VPDB-NMS01\dashdbnmsadm. sqlmaint.exe failed.
>   [SQLSTATE 42000] (Error 22029).  The step failed.
>
>
>
>
>
>
>
>
>
>   SqlCon is a special interests group run under the aegis of MUGH -
> http://www.mugh.net
>   http://www.mugh.net/sql
>
>   Visit http://www.mugh.net/dnug to join .NET User Group.
>
>
>
>
> ------------------------------------------------------------------------------
>   Yahoo! Groups Links
>
>     a.. To visit your group on the web, go to:
>     http://groups.yahoo.com/group/sqlcon/
>      
>     b.. To unsubscribe from this group, send an email to:
>     sqlcon-unsubscribe@yahoogroups.com
>      
>     c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
>
>
>
>





SqlCon is a special interests group run under the aegis of MUGH - http://www.mugh.net
http://www.mugh.net/sql

Visit http://www.mugh.net/dnug to join .NET User Group.

---

Do you Yahoo!?
Yahoo! Small Business - Try our new resources site!

SqlCon is a special interests group run under the aegis of MUGH - http://www.mugh.net
http://www.mugh.net/sql

Visit http://www.mugh.net/dnug to join .NET User Group.

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

Hi group,


Im n a deep trouble, one of my  db user has deleted some records
from the database  since there was a cascading delete enabled on the
table we have lost some records in other tables also. luckily  my
scheduled job was running stable i had a backup i have replaced the
latest backup with minimal record lost.
  Now my  query is i need to find

1.which login has deleted the records how can we chek this

2. I have simple recovery model for my database.


  i guess by having  full or bulk logged  model we can read the
transaction from  ldf files.   can any one help me to finding this
and  do i face any problem from changing the recovery model as its a
production Db.

so in short   how to read a log file if i have full/bulk logged model
  is there any issues changing from simple to full/bulk logged model


thanks for the help
basha

Hi Luca,

Extension is not mandatory. You can give your
extensions .bkp or .dat, its up to you. MS recommends
.bak extension. Here is my example, may be helpful for
you:

I am taking pubs backup and restoring using Query
Analyzer.

Backup database pubs to disk = ‘c:\backup\pubbkp.bak’

While restoring I have to give .bak extension,
otherwise it wouldn’t work

Correct syntax:
Restore database pubs from disk =
‘c:\backup\pubbkp.bak’

Incorrect syntax:
Restore database pubs from disk =
‘c:\backup\pubbkp.bak’

Similarly if you have taken backup without extension:

Backup database pubs to disk = ‘c:\backup\pubbkp’

Correct syntax:
Restore database pubs from disk =
‘c:\backup\pubbkp.bak’

Incorrect syntax:
Restore database pubs from disk =
‘c:\backup\pubbkp.bak’


Does this stuff satisfy your answer?

Regards,
Jagan

--- Saleem Hakani <hakani_saleem@...> wrote:
> It's okay if you don't give an extention to the
> backup file as when restoring SQL Server understands
> that it's the backup file just by reading the header
> information.
>
> On the other hand if you specify an extension than
> you are sure that the file with .bak is your
> database backup file...  You can distinguish the
> differences between other files with the same name
> when you have an extension.
>
> Thank you,
> Saleem Hakani
>
> ciaofromluca <ciaofromluca@...> wrote:
>
>
>
> Hi
>
> In the SQL Server Backup window (Enterprise
> Manager/Database/All Tasks/
> Backup Database)/Destination section if I decide to
> back up the
> database to a file on the local hard drive, do I
> have to give any
> extension to the file where I'm going to back my
> database up(ex.
> Northwind_Backup.bak) or no extension is required
> (ex.
> Northwind_Backup)?
>
> Thank you
> Kind Regards
> Luca
>
>
>
>
>
>
>
>
> SqlCon is a special interests group run under the
> aegis of MUGH - http://www.mugh.net
> http://www.mugh.net/sql
>
> Visit http://www.mugh.net/dnug to join .NET User
> Group.
>
>
>
>
> ---------------------------------
> Yahoo! Groups Links
>
>    To visit your group on the web, go to:
> http://groups.yahoo.com/group/sqlcon/
>
>    To unsubscribe from this group, send an email to:
> sqlcon-unsubscribe@yahoogroups.com
>
>    Your use of Yahoo! Groups is subject to the
> Yahoo! Terms of Service.
>
>
>
> ---------------------------------
> Do you Yahoo!?
>  Yahoo! Small Business - Try our new resources site!

Hi Uma,

Hope this article helps you more understanding of how
detect and resolve deadlocks:

http://support.microsoft.com/default.aspx?scid=kb;en-us;832524

Regards,
Jagan


--- "Roji. P. Thomas" <thomasroji@...> wrote:
> http://www.sql-server-performance.com/deadlocks.asp
>
> Regards
> Roji. P. Thomas
>   ----- Original Message -----
>   From: Gomathi
>   To: sqlcon@yahoogroups.com
>   Sent: Wednesday, March 30, 2005 11:08 AM
>   Subject: [mugh-sqlcon] (Process ID 60) was
> deadlocked
>
>
>
>   Hi,
>
>   In one of our customer's site at the time of
> saving a
>   transaction they hve encountered the following
> error:
>
>   [Microsoft][ODBC SQL Server][SQL
> Server]Transaction
>   (Process ID 60) was deadlocked on {lock} resources
>   with another process and been chosen as the
> deadlock
>   victim. Rerun the transaction.
>
>   Please suggest on what conditions the above error
>   occurs and how to control the same.
>
>   Thanks in advance.
>
>   Uma
>
>
>
>   __________________________________
>   Do you Yahoo!?
>   Yahoo! Small Business - Try our new resources
> site!
>   http://smallbusiness.yahoo.com/resources/
>
>
>
>
>
>   SqlCon is a special interests group run under the
> aegis of MUGH - http://www.mugh.net
>   http://www.mugh.net/sql
>
>   Visit http://www.mugh.net/dnug to join .NET User
> Group.
>
>
>
>
>
------------------------------------------------------------------------------
>   Yahoo! Groups Links
>
>     a.. To visit your group on the web, go to:
>     http://groups.yahoo.com/group/sqlcon/
>
>     b.. To unsubscribe from this group, send an
> email to:
>     sqlcon-unsubscribe@yahoogroups.com
>
>     c.. Your use of Yahoo! Groups is subject to the
> Yahoo! Terms of Service.
>
>

Hi aaditya

 

 

why you dont try bcp commnad.

is the data in the text format.if then try to use bcp commnad

 

it automatically transfer the data from txt to the database

 

Aaditya Tarhalkar <aadityasqldba@...> wrote:

Hi,

 

I am trying to create a script file for creating all the database objects and want to include some insert statements of master data along with the those objects. But the data is very large and writing the insert statements is almost impossible.Is it possible to create insert statements of existing data so that I can include those statements into the script file. Please help me on this. Thanks in advance.

 

Aaditya.

---

Do you Yahoo!?
Yahoo! Small Business - Try our new resources site!

SqlCon is a special interests group run under the aegis of MUGH - http://www.mugh.net
http://www.mugh.net/sql

Visit http://www.mugh.net/dnug to join .NET User Group.

---

Do you Yahoo!?
Take Yahoo! Mail with you! Get it on your mobile phone.

SqlCon is a special interests group run under the aegis of MUGH - http://www.mugh.net
http://www.mugh.net/sql

Visit http://www.mugh.net/dnug to join .NET User Group.

Is it correct to assign the extension bak (*.bak) to a SQL Server
backup? Is this the right extension for a SQL Server backup file?

Thank you

Luca

--- In sqlcon@yahoogroups.com, Saleem Hakani <hakani_saleem@y...>
wrote:
> It's okay if you don't give an extention to the backup file as when
restoring SQL Server understands that it's the backup file just by
reading the header information.
>
> On the other hand if you specify an extension than you are sure
that the file with .bak is your database backup file...  You can
distinguish the differences between other files with the same name
when you have an extension.
>
> Thank you,
> Saleem Hakani
>
> ciaofromluca <ciaofromluca@y...> wrote:
>
>
>
> Hi
>
> In the SQL Server Backup window (Enterprise Manager/Database/All
Tasks/
> Backup Database)/Destination section if I decide to back up the
> database to a file on the local hard drive, do I have to give any
> extension to the file where I'm going to back my database up(ex.
> Northwind_Backup.bak) or no extension is required (ex.
> Northwind_Backup)?
>
> Thank you
> Kind Regards
> Luca
>
>
>
>
>
>
>
>
> SqlCon is a special interests group run under the aegis of MUGH -
http://www.mugh.net
> http://www.mugh.net/sql
>
> Visit http://www.mugh.net/dnug to join .NET User Group.
>
>
>
>
> ---------------------------------
> Yahoo! Groups Links
>
>    To visit your group on the web, go to:
> http://groups.yahoo.com/group/sqlcon/
>
>    To unsubscribe from this group, send an email to:
> sqlcon-unsubscribe@yahoogroups.com
>
>    Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.
>
>
>
> ---------------------------------
> Do you Yahoo!?
>  Yahoo! Small Business - Try our new resources site!

Hi aaditya,
try this sneaky procedure out...run this procedure and
it will print the results in the query analyser u can
copy and use it..

the table structure is like
empno int 4,empname varchar 50,location varchar 10


DECLARE curUsers CURSOR READ_ONLY FOR  SELECT
empno,empname,loc from emp

DECLARE @col1 as varchar(5)
DECLARE @col2 as varchar(50)
DECLARE @col3 as varchar(10)
DECLARE @strQuery as varchar(1000)

OPEN curUsers
	 FETCH NEXT FROM curUsers INTO @col1,@col2,@col3
	 WHILE @@FETCH_STATUS = 0
	 BEGIN
	 set @strQuery = 'insert into
table1(empno,empname,loc) values (' + @col1 + ',''' +
@col2 + ''',''' + @col3 + ''')'
	 print @strQuery
	 -- this will print the insert statement in the query
analyser you can copy tht
	 FETCH NEXT FROM curUsers INTO  @col1,@col2,@col3
	 END
	 CLOSE curUsers
	 DEALLOCATE curUsers


with smiles
santhose

--- Biswajit Das <radhye@...> wrote:
> Hi aaditya
>
>
> why you dont try bcp commnad.
> is the data in the text format.if then try to use
> bcp commnad
>
> it automatically transfer the data from txt to the
> database
>
>
>
> Aaditya Tarhalkar <aadityasqldba@...> wrote:
> Hi,
>
> I am trying to create a script file for creating all
> the database objects and want to include some insert
> statements of master data along with the those
> objects. But the data is very large and writing the
> insert statements is almost impossible.Is it
> possible to create insert statements of existing
> data so that I can include those statements into the
> script file. Please help me on this. Thanks in
> advance.
>
> Aaditya.
>
>
> ---------------------------------
> Do you Yahoo!?
> Yahoo! Small Business - Try our new resources site!
>
> SqlCon is a special interests group run under the
> aegis of MUGH - http://www.mugh.net
> http://www.mugh.net/sql
>
> Visit http://www.mugh.net/dnug to join .NET User
> Group.
>
>
>
>
> ---------------------------------
> Yahoo! Groups Links
>
>    To visit your group on the web, go to:
> http://groups.yahoo.com/group/sqlcon/
>
>    To unsubscribe from this group, send an email to:
> sqlcon-unsubscribe@yahoogroups.com
>
>    Your use of Yahoo! Groups is subject to the
> Yahoo! Terms of Service.
>
>
>
> ---------------------------------
> Do you Yahoo!?
>  Take Yahoo! Mail with you! Get it on your mobile phone.

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

We have a situation where someone created multiple MDF files for a
database and we'd like to combine them into one large MDF file.

Has anyone been able to do this or can someone point me in a direction
where I might be able to do some research and figure it out?

Thanks

Ed

Yahoo! India Matrimony: Find your life partner online.