When Col C(which is of datatype datetime) in table A is updated from null to some date then insert the data to table B.

Here's what my data looks like:

Col A, B and C in table A:

A BC

4460636543NULL

4431076543NULL

3034 1152NULL

4434516543NULL

4405016543NULL

9973 ...

Here's the scenario:

I have tableA with columns A,B,C

if in tableA column B has some value other than null

then insert into tableB, so how do I create trigger for this?

I am using the script that I found online which gives for mdf and ldf files.

But, how to get total free space for the database?

set nocount on

create table #dbfileInfo(

name...

Thank you all.

Somebody thinks that:

Looks like someone may have changed the Max Conns on the database side. The DBAs would have to review it to increase the Max Pool...

Thanks you All.

Actually, I would need to restore on new database full backups and all the logs, what would be the process?

I have full backup taken every day at 10 PM and transaction log every 15 mins.

So, the data got deleted around 3:30 PM on Friday.

In order to restore I have...

I get this error :

Invalid column name 'RN'.

But, that would work only for SQL Logins right?And there might be few AD accounts which are not in prod but in test which might have permission to the database.

No.

It is irrelevant.

All I need is if it starts with P in one column and if with C then other column.

I am able to get till this:

AACaseCCCase

NULL CC-109090

NULL CC-109091

AA-109090 NULL

AA-109091 NULL

Is...

No, that is what I wanted just the casenumbers. How do I do in sql using unpivot?