SQL Server 2005 General Discussion

• Topics

  Started by

  Posts

  Last post

• How to script a remove 'IDENTITY(1,1)'

  Hi All! I got some good help on changing fields the other day. My problem now is the ID field. It i…

  Edvard Korsbæk

  6 replies

  15 years ago

  By: Brandie Tarvin

• Identity column gernerating non unique value

  I had created a sp which is creating a non unique value for n concuurent user using this table.Migh…

  kotnala_manish

  6 replies

  15 years ago

  By: Brandie Tarvin

• Job appears to run successfully, but doesn't.

  I am trying to get a job to run successfully and have it scheduled in sql server agent. The job wil…

  scrowley 30472

  4 replies

  15 years ago

  By: Brandie Tarvin

• Cpu usage is high

  Dear All, we are having sql serevr 2005 servers.The below problem is in all servers. In our environ…

  Minto Minto(quendans)

  5 replies

  15 years ago

  By: Brandie Tarvin

• Locked tables clarification

  Hi, Does somesone know if a table is been updated every 5 minutes using an SSIS job…i.e. data bein…

  pwalter83

  10 replies

  15 years ago

  By: AmolNaik

• Error 1067 when starting MSSQLServer service

  when i try to start the service it gives me: "WIndows could not start the SQL server service on loc…

  meganh-1034194

  3 replies

  15 years ago

  By: Adiga

• STORED PROCEDURE OR TRIGGERS? CALCULATE FEES

  HELLO! I have two tables : product , tax Product'fields: id amount Tax …

  bamek_daddy

  5 replies

  15 years ago

  By: chris.stuart

• Query performance n Index needed?

  Consider a table cleardaytrans having following columns prim_id int identity(1,1) primary key temp…

  BeginnerBug

  6 replies

  15 years ago

  By: tfifield

• Reset Row_Number() against column

  create table t1(ename varchar(50),deptname varchar(50)) insert into t1 values('abc1','sales') inser…

  gulzarahamed.a

  5 replies

  15 years ago

  By: Sean Lange

• UPDATE with JOINS to change a column

  Hello all, This is probably so simple I will kick myself when I find the answer, but I had to get u…

  krushkoder

  2 replies

  15 years ago

  By: krushkoder

• Variable reference using Visual Studio 2008 Database Professional GDR 2

  We have Stored Procedure which connects to AS400 system and retrieve or insert/update data in the A…

  vishal.shinde

  1 replies

  15 years ago

  By: Grant Fritchey

• Transaction Log restore(LOG SHIPPING)

  Hi We have a database on sqlserver 2005 on a schedule for transaction log backups is in place alre…

  LAravind

  3 replies

  15 years ago

  By: seven.srikanth

• Trouble with CTE

  I'm trying to write a recursive query that's not quite the same as the one in Jeff Moden's article.…

  pietlinden

  18 replies

  15 years ago

  By: pietlinden

• Function to retrieve dynamic columns

  Hi All, I desperately need help. I have created a stored proc that retrieves my data correctly fr…

  TheGrem

  2 replies

  15 years ago

  By: TheGrem

• database mail trigger on insert

  Hi, i am trying to create a trigger to send an automated mail after an insert to my inventory table…

  spin

  17 replies

  15 years ago

  By: spin