Styjun

Existence of a Hölder-free space

I won a car in a poker game

How could a planet have one hemisphere way warmer than the other without the planet being tidally locked?

Draw the ☣ (Biohazard Symbol)

What quests do you need to stop at before you make an enemy of a faction for each faction?

How do I anonymously report the Establishment Clause being broken?

Are language and thought the same?

How do I use NEC PC-6001 .p6 or .cas files?

Prove that a function is bijective and show that G is a group

Undefined Hamiltonian for this particular Lagrangian

What drugs were used in England during the High Middle Ages?

Types of tablet... a tablet secretion

Why is a pressure canner needed when canning?

Why did Boris Johnson call for new elections?

What's this constructed number's starter?

What is the justification for Dirac's large numbers hypothesis?

Does the Commodore CDTV-CR contain a 65C02 for some reason?

What are some countries where you can be imprisoned for reading or owning a Bible?

Was Rosie the Riveter sourced from a Michelangelo painting?

What exactly is Apple Cider

Infinitely many Primes

Fantasy Military Arms and Armor: the Dwarven Grand Armory

SQL Always On COPY ONLY backups - what's the point if I cant restore the AG from these backups?

Did the US Climate Reference Network Show No New Warming Since 2005 in the US?

How to lock when creating table in sql server?

Add a column with a default value to an existing table in SQL ServerHow to return only the Date from a SQL Server DateTime datatypeHow to check if a column exists in a SQL Server table?Check if table exists in SQL ServerHow to concatenate text from multiple rows into a single text string in SQL server?LEFT JOIN vs. LEFT OUTER JOIN in SQL ServerHow can I create an executable JAR with dependencies using Maven?How do I UPDATE from a SELECT in SQL Server?Get all table names of a particular database by SQL query?Find all tables containing column with specified name - MS SQL Server

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

0

I'm trying to run this query on a multiple instances (on a server) of the same application

I tried to run the query but would get deadlocks.

set transaction isolation level serializable
go
begin transaction
if not exists (select name from sys.sysobjects where name like 'xyp')
begin
 CREATE TABLE xyp( id varchar(1), name varchar(5));
end
commit transaction go

Is there anything that I can do?

java sql-server jdbctemplate

share|improve this question

edited Mar 28 at 4:56

Dale Burrell

4,69155 gold badges2828 silver badges5757 bronze badges

asked Mar 28 at 4:45

Joseph MoralesJoseph Morales

6

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  This DBA Stack Exchange question basically answers your concerns. You may try creating a lock on the entire create operation.
  
  – Tim Biegeleisen
  Mar 28 at 4:58
  

  
  
  
  

add a comment | 

0

I'm trying to run this query on a multiple instances (on a server) of the same application

I tried to run the query but would get deadlocks.

set transaction isolation level serializable
go
begin transaction
if not exists (select name from sys.sysobjects where name like 'xyp')
begin
 CREATE TABLE xyp( id varchar(1), name varchar(5));
end
commit transaction go

Is there anything that I can do?

java sql-server jdbctemplate

share|improve this question

edited Mar 28 at 4:56

Dale Burrell

4,69155 gold badges2828 silver badges5757 bronze badges

asked Mar 28 at 4:45

Joseph MoralesJoseph Morales

6

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  This DBA Stack Exchange question basically answers your concerns. You may try creating a lock on the entire create operation.
  
  – Tim Biegeleisen
  Mar 28 at 4:58
  

  
  
  
  

add a comment | 

I'm trying to run this query on a multiple instances (on a server) of the same application

I tried to run the query but would get deadlocks.

set transaction isolation level serializable
go
begin transaction
if not exists (select name from sys.sysobjects where name like 'xyp')
begin
 CREATE TABLE xyp( id varchar(1), name varchar(5));
end
commit transaction go

Is there anything that I can do?

java sql-server jdbctemplate

share|improve this question

edited Mar 28 at 4:56

Dale Burrell

4,69155 gold badges2828 silver badges5757 bronze badges

asked Mar 28 at 4:45

Joseph MoralesJoseph Morales

6

set transaction isolation level serializable
go
begin transaction
if not exists (select name from sys.sysobjects where name like 'xyp')
begin
 CREATE TABLE xyp( id varchar(1), name varchar(5));
end
commit transaction go

java sql-server jdbctemplate

java sql-server jdbctemplate

share|improve this question

edited Mar 28 at 4:56

Dale Burrell

4,69155 gold badges2828 silver badges5757 bronze badges

asked Mar 28 at 4:45

Joseph MoralesJoseph Morales

6

share|improve this question

edited Mar 28 at 4:56

Dale Burrell

4,69155 gold badges2828 silver badges5757 bronze badges

asked Mar 28 at 4:45

Joseph MoralesJoseph Morales

6

edited Mar 28 at 4:56

Dale Burrell

4,69155 gold badges2828 silver badges5757 bronze badges

edited Mar 28 at 4:56

Dale Burrell

4,69155 gold badges2828 silver badges5757 bronze badges

asked Mar 28 at 4:45

Joseph MoralesJoseph Morales

6

asked Mar 28 at 4:45

Joseph MoralesJoseph Morales

6