Robert klimes (6/19/2009)

---

check out the link on how to create triggers. http://msdn.microsoft.com/en-us/library/aa258254(SQL.80).aspx

here is something to help you get started

create trigger trig_name

on table_name

after insert

as

declare @seq varchar(25)

set @seq = (select max(substring(caseid,charindex('-',caseid)+1,len(caseid)))+1...

Hi,

It is a SQL user account. I have no...

Andy Hogg (6/19/2009)

---

Hmm try this.

Next time the account is locked out, open the login properties and uncheck "Enforce password policy".

Then "ok" that. Then go back into the login properties and...

S Hodkinson (6/12/2009)

---

I have set up database mail on one of our servers and can send myself a test mail. However when I set up an operator, database mail...

rvkhadava (6/5/2009)

---

I have two tables, stg,main with the same structure.Each day data is refeshed into stg from the flat file. And from there into main.Before the main table is loaded,I...

But a little bit confusion- Is it necessary to give the Networkpath and Local path destinations eventhough my primary and secondary databases are on the same Server itself? or else...

I would go for mirroring, as it has an ease of setting up and in case you want...

mithun.gite (6/11/2009)

---

Hello Everyone,

I am facing a small problem while creating the SSIS package.

I have a requirement -

The user needs to upload a file in one of the tables in...

Hi,

What version of SQL server u are...

Tara (6/2/2009)

---

How do i find duplicate records in a database of 1.3 TB where in we dont have any PK's ( this might surprise you). I am trying to pull...

GURSETHI (6/3/2009)

---

Hi,

I think this document has explained things pretty well (diff between SP_ATTACH_DB & ALTER DATABASE). A small curx of it.

So why exactly is this important, and what difference does...

Hi,

The package runs OK in BIDS. It does not give me any errors, but I am concerned...

sameer_bhagat_1 (6/2/2009)

---

Hi,

I have Server 2003 Enterprise edition X64 and One Mssql 2005 X64 Instance with SP3.

I have created Maintenance plans on it for backups, reindex, reorganize etc.

.Net framework installed...

Hi,

I am not resetting the package. But when I run from BIDS for first time, no data gets...

HI Aatish,

In just one maintenance plan, it is not a good idea to include index rebuild and index reorganize. You can use a script (modify it as per your req.)