I gave a thought a writing trigger but im not able to write it

can you please help me to write one

Hi

The problem seems to be fixed atleast for me!!!

The reason for this error is that the Resource Database had not been upgraded to the SP2 version 9.00.3068.00. It...

I too have same problem!!!

I'm on SQL 2005 Dev edition SP2 build 9.00.3068.00 and I use wizard to create a maintenance plan

anand (9/18/2008)

---

Can any one help me to prepare basic check list for database server for SQL server 2005.

after creating the database i want to some basic check on database like...

also check if the server is VM server.

For me coz of VM server the sql memory usually goes that high!!

Jeff Moden (9/11/2008)

---

On the other hand, look at the bright side... 🙂 They have such a crappy DB that they need someone like you to wade through it and...

Jeff Moden (9/10/2008)

---

Sergiy (9/10/2008)

---

khushbu.kumar (9/10/2008)

---

Thanks a lot Chris!

But the here posted code was just a snippet

i really dont know how many rows can be present(i'm selecting them on the...

Thanks a lot Chris!

But the here posted code was just a snippet

i really dont know how many rows can be present(i'm selecting them on the basis of id and...

hey

I got it resolved by myself.. 🙂

The steps i followed is :

1.Increased the no pf CPU used to all available on server

2. Released the SQL Server to ping...

ahhh it seems I will have to drop constraint and then again recreate it...

my head goes twisted when i think of doing it on production db..!!!

Thanks for the help

I dont...

no ordering

and i just need to display 4 row.. not the other row

No SP is involved when storing the name

The code passes the error on duplication

Still we have duplicate name.

My probable guess is if user clicks on save tab multiple...

Hi i have a statement this way -

@getTname - gets the list of tables

EXEC ('UPDATE ' + @getTname + ' SET db_User_ID= ' + @toUserId + ' WHERE...

ALTER TABLE Tbl_ServTime NOCHECK CONSTRAINT FK_Tbl__ServTime_Tbl_xyz

there are no other FK on this table

ans

1)Timeout expired.The timeout period elapsed prior to completion of the operation or the server is not responding.

2) approx after 50-60 sec

3)SP takes approx 3-4 in QA