opc.three (3/27/2012)

---

In your Exec Process task you may have to pass the location of the batch file as a parameter to cmd.exe. Check out the /C switch, from a cmd...

Thanks.

Actually, When I double click the bat file, the results are :- txt file in another folder gets processed....

But when I doing this execute Process task...

Eugene Elutin (3/20/2012)

---

SKYBVI (3/20/2012)

---

Hi,

i have mdb files used by ActiveExperts Network monitor manager.

I want to migrate those access files to sql server databases.

How can i do...

or

DECLARE @datefield VARCHAR(10)

SELECT CAST(@datefield AS DATETIME)

Regards,

Skybvi

balasach82 (3/9/2012)

---

I need to retrieve records whose DATEFIELD is less than 60 days.

select top 1 * from TABLENAME where ISDATE(DATEFIELD) = 1

and convert(datetime,DATEFIELD) <(GETDATE-60)

DATEFIELD --> varchar (10)

Since DATEFIELD is varchar,...

I dont think DDL is needed and sample data i already put..

Leave the question if u can't help.

Hugo Kornelis (3/6/2012)

---

Nope, that's not what I wrote. Here is a quote (emphasis added, but...

Hugo Kornelis (3/6/2012)

---

SKYBVI (3/6/2012)

---

Hugo Kornelis (3/6/2012)

---

Why?

SQL Server 2008 was released almost three years ago now. There has...

Hugo Kornelis (3/6/2012)

---

Why?

SQL Server 2008 was released almost three years ago now. There has already been another...

So, the question was not properly asked. They should mention SQL SERVER 2008

Regards,

Skybvi

Does date data type exist in sql server 2005 ?

Regards,

Skybvi

kumar.sachu08 (2/24/2012)

---

Hi All,

What happen when any user has taken .trn backup from primary database during the processing of the log shipping ?

Suppose I have set agent on primary database to...

For anyone interested I've now resolved this problem.

The issue is due to there being no unique index on the target table, as soon as I created an index on...

Can't understand what you intend to say?

Whisper9999 (2/22/2012)

---

Let's say you have a stored proc or DBCC statement that spits out more than one record set. I can't remember how you only retrieve the results from...