As said before this can be the reason.

Phil Parkin (4/14/2015)

---

Ville-Pekka Vahteala (4/14/2015)

---

These did not have those numbers what I asked,...

These did not have those numbers what I asked, but they are very...

I modified you code a little adding index to table.

CREATE Table T (S varchar(2))

Declare @s-2 nvarchar(255)

CREATE INDEX ts ON T (S);

Insert into T

Values ('AR'), ('AT'), ('AW')

Set

For update you need to use deleted or inserted table.

insert into abcd select *, getdate() from deleted if you want values before update.

Did you try to open IE with administrative rights?

This is needed when if you are trying to open reports on same server where instance of SQL server is running.

BWFC (2/11/2015)

---

It's funny. When it snows in my area (usually get 1 snow/ice storm per year, of no more than 4 to 6 inches), we get all of the...

Grant Fritchey (2/2/2015)

---

Sioban Krzywicki (2/2/2015)

---

SQLRNNR (2/2/2015)

---

I have to...

GilaMonster (2/1/2015)

---

sparky-407434 (1/31/2015)

---

On the plus side, storing telephone number as int uses less storage than a varchar. Ok you won't need to use any numeric functions on it, but you...

GilaMonster (1/29/2015)

---

he one I hate seeing...

Lowell (1/28/2015)

---

you'd have to convert to varchar, are you sure that's what you want?

ACTLABCOST = case

...

Select query will be locked because you have transaction still open when it is executed by email.

I second Lowell idea of job or maybe you could use service broker when...

DBA From The Cold (1/27/2015)

---

It's all about how big the columns will be, from MSDN:-

https://msdn.microsoft.com/en-ie/library/ms186939.aspx

The storage size, in bytes, is two times the actual length of data...

Is there varchar parameters used in query predicates? I have seen that reports are calling always with nvarchar and this causes scans instead of seeks.

GilaMonster (1/19/2015)

---

Well this is fun.

Officially, according to the government, South Africa uses the , as the decimal point. In reality, everyone, including the government, uses the .

Windows 7, when used...