Sanjay Rohra (11/4/2008)

---

sudeepta.ganguly (11/4/2008)

---

One of our database writes huge logs as as we have created a Transactional Replication on that. I was trying to automate the process of truncating the...

sudeepta.ganguly (11/4/2008)

---

One of our database writes huge logs as as we have created a Transactional Replication on that. I was trying to automate the process of truncating the logs as...

That tells me that the version of MSDE you are running is SQL Server 2000 as well. All you need to do is a backup of the database on...

Jeff Moden (11/3/2008)

---

Sridevi (11/3/2008)

---

Many Thanks to you.

I wrote a function and i got the result too.

CREATE FUNCTION select_concat (@A INT )

RETURNS VARCHAR(MAX) AS BEGIN

...

Have to agree with Sergiy on this one.

And with all that having been said, you DON'T want to be shrinking the transaction log after every backup. You just force SQL Server to make it grow again...

With no code, no idea of the data involved, my swag is both will take...

1. Have you verified that the schemas and indexes are identical between databases.

2. Is there any difference the number of rows being insert between the databases.

3. Read...

Garadin (10/31/2008)

---

You don't need a loop, or a cursor. All you need to do is:

1. Create a clustered index on your row# column. (It is most likely...

Also curious, how big was the database you lost?

Making a guess here about nvl...

This:

sysdate between org.effective_start_date and nvl(org.effective_end_date,sysdate)

would be this:

getdate() between org.effective_start_date and isnull(org.effective_end_date, getdate())

what does this do: nvl(org.effective_end_date,sysdate)?

paul.starr (11/3/2008)

---

maybe its this line i have commented out:

how would i write this line:

--and between GetDate()org.effective_start_date and GetDate() org.effective_end_date

data types

EFFECTIVE_START_DATE ...

As you are converting from pl/sql to t-sql, is it safe to say you are also porting the database from oracle to sql server? You provided the data types...

Something is missing somewhere. I don't see anything that would cause this conversion error: Error converting data type nvarchar to float. The only non-character data type is ca.account_established_date,...