Amit Chaudhary (10/18/2008)

---

I have a bcp out command running on Server A. The command runs against different Servers ( e.g. B, C, D ). It extracts Data from Tables on...

Jason Shadonix (1/7/2009)

---

Anyone know if there is a way to stop SQL from writing certain events to the Windows Event log? Perhaps stopping it from just doing a certain...

Eric Klovning (1/7/2009)

---

This will give you a list of identity columns.

SELECT *

FROM

INFORMATION_SCHEMA.COLUMNS

WHERE

COLUMNPROPERTY -- get columns where is_identity = 1

(

OBJECT_ID(QUOTENAME(table_schema) + '.' + QUOTENAME(table_name)) --...

MANU (1/6/2009)

---

The IDENTITY property and the column it's attached to are inseparable, which means that you can't add or remove IDENTITY from an existing column.You can use workarounds, but these...

Create table table1

(

id int identity(1,1) not null,

name varchar(50)

)

i have created table as above script.

Now i want to remove identity on id column using TSQL Script .

Any idea?

Ed Wyant (5/2/2008)

---

What is the method (if there is one) to notify multiple operators of a single job’s run conditions...ie

Failures, success, or completions? The present database mail configuration works ...

timscronin (1/5/2009)

---

I have been having an issue with distrubuted transactions between 2 sql servers. I create a temp table, load the data to the other server, and then update...

Please check any database trigger is ebable or not?

pavankumarh2 (1/5/2009)

---

Dear Friends ,

I am moving to work on Production support as DBA ,plz any tell me any body what are the common responsibilities of...

Wesley Brown (1/5/2009)

---

Hello all,

I've got a weird one. It appears that I have had the SQL Agent just skip running a scheduled job task. No failure no job stuck executing...

mahesh.vsp (1/5/2009)

---

Hi Pals,

Can anyone suggest few links on disaster recovery scenarios for SQL Server 2005.

Example : IF "master" database is corrupted what needs to be done.

.....

Pete T (1/5/2009)

---

I want to create a text file summary of the schematics for a database. Essentially, I want to have what is output for sp_help objectname, but for...

PaulB (1/5/2009)

---

You may want to test your code, unfortunatelly it doesn't work.

I think it will be better to...

dakshinamurthy (12/10/2008)

---

Hi,

I am new to this logshipping concept and tried to configure LogShipping for my Database, in this set up i had two servers (Sql Servers). I was not having...

anita (1/2/2009)

---

Hello All,

Thanx in advance....

can anyone help me with this problem.

I had added the linked server excel and trying to retrieve the data thru query

SELECT * FROM EXCEL...Stock$

the same process...