Sounds like you need to run Profiler when you run this job so you can track down exactly where the problem occurs. I'm betting your job gets suspended in the...

That's the way I'm reading it, Perry.

You can accomplish this output in two ways. The first way, as earlier suggested, is to write a stored procedure and put everything in a temp table, then select from...

Google running DTS in SQL Server 2005. Also, check this link for backward compatibility components:

http://www.microsoft.com/downloads/details.aspx?FamilyID=50b97994-8453-4998-8226-fa42ec403d17&DisplayLang=en

I believe you have to have the backward compatibility installed prior to running DTS. I'm sure...

Chandu,

SQL Server does not take passwords for domain accounts. So don't write your code that way.

If you're automating the install of SQL Server itself, then what you're trying won't work....

Which means, what I originally thought is true.

Data Quality is not (or should not be) an issue.

Your biggest worry will be when two people try to change the same record & same field to two different things.

Say I have an auto insurance policy set as...

Glad I could help.

Let us know if you have any more questions after you're through gathering. @=)

Just because the server name is correct in the C# code, doesn't mean it's correct in the T-SQL Code. That's why you were asked to check it.

As far as everything...

Chandu,

Ditto on the password comment of the previous poster. As far as adding a user to the server via VB, all you have to do is use VB to run...

In addition to the above, you'll want to check the Activity Monitor in the GUI as well as employ Profiler to see if there is a specific process or query...

Nikhil (2/13/2009)

---

Hi Friends,

When i execute following statement through query analyser it works fine.

its gives out put for all databases. but when i run this through Excel sheet

from Data>>New database query

it...

Ah. Third party vendors. HappyHappyJoyJoy. @=)

I'd get mailtrust.com involved in this. It could be a domain trust issue or an error on their side or a firewall issue.

Also, check with...

I've heard those too. I certainly will. @=)

Hmm. I also need to write another article for the site. I wonder what I shall compose...

I don't like your setup. Mirror the transaction files, by all means, but I don't see a reason to stripe them across multiple disks. That seems like a waste of...