Do you do spicy chili or non-spicy?

kajf (10/22/2010)

---

I thank you both very very much for all help and think this is it!

However, if you find any error's or suggestions on improvement I'm all ears.

For example the...

For dtsconfig files, you can do a Windows Explorer search on the directory and it should be able to search inside the files for the account name in question. Just...

Chili!

We're having a chili cooking contest for lunch today. It's gonna be fun. I LOVE my workplace... @=)

Hee!

kajf (10/21/2010)

---

Following your instructions I applied an outer join (of course my way might be wrong). For simplicity I have not include the WHERE #AC_Temp.C IS NULL statement to show...

kancherla.ks (10/21/2010)

---

i have to select a column from a table which has all these 80 words so i am planning to write this using LIke.

please suggest me if you...

Kaj,

Did you understand my comments about how to recode for the simple solution?

But do you see other errors before that which might be connected to the restart fail?

John makes a good point about the log file. Find out what service SQL Agent...

bleary

I think Computer Associates might have a tool too, but I don't know the name of it off the top of my head. Might look at Pragmatic Works. I don't...

Check the Application and System logs in Event Viewer. That might help you track down the source of the issue.

Is this a standalone server or a clustered node?

Is this a...

Thanks, Chris. That does help.

If you're looking for items outside of SQL Server entirely, that's not only a registry issue, but a possible Active Directory issue. There is no way for to use T-SQL...

What Sag999 said. It depends on what transactions get committed and written to the data file during the backup, if any.

And if your database backup is taking two hours, you...