mah_j (9/19/2012)

---

great it works ,tanks alot both of you.

what about apex?is there any table that it reads from that?

i need to know it shows the log from where?

i think it...

keka4747 (9/19/2012)

---

Hello Gurus,

Im new to SSIS . Need your help to resolve a performance issue.

I have a dimension table with 120 columns in which 80 columns change frequently and...

mah_j (9/19/2012)

---

2:in full recovery,i have a full backup from 09:00 am yesterday,and a log backup from 11:00 pm yesterday,can i restore the data from 8:00 pm yesterday?

how can i obtain...

So DJ has some choices to make.

1) Stick with Access and maybe use SSIS to poll the data...

Just to clarify on the error handling in SSIS. Because you're able to configure the workflow of the package, you can redirect the package elsewhere so you deal with failed...

Douglasjbell (9/18/2012)

---

Hi Abu

Thanks for the reply, adding timestamps and the such to the tables will not be an issue, and it is only one way synch, Access to SQL as...

Douglasjbell (9/18/2012)

---

Hi

Thanks for the reply, I have just been reading about SQL 2012 free LocalDB that can be deployed with an application. This looks like a very good database for...

Why not use @@VERSION instead?

declare @isSqlServer2005 bit

declare @version varchar(50)

select @version = @@version

select @isSqlServer2005 = CASE when left(@version, charindex('-', @version)-1) like '%2008%' then 1 else 0 end

select @isSqlServer2005

Added LEFT...

Good question....

See this: http://msdn.microsoft.com/en-us/library/ms172417(v=sql.105).aspx

SQL Server...

Let me see if I've understood this correctly:

You have your touch screen devices with their own local ACCES DBs containing the three tables:

ACCESS-DB-1

ACCESS-DB-2

and you have a SQL Server 2008 instance...

rhythmk (9/18/2012)

---

Recently I attended an interview for a role of Senior SQL Developer and I wondered the kind of questions panel asked.Here are few of them.

1.How many columns a SQL...

I have an interview tomorrow with a company not far from where I live. So I thought I'd...

GSquared (8/7/2012)

---

Weirdest interview I ever had was 4 hours long. They flew me out to their city, put me up in the local Hilton, rented a car for me...

Sorry I should have used my words more wisely. I know there's no real concept of an offline backup within SQL...

Hi John,

Yes, you are right. There is no reason for this job to be run manually....