Sometime it's caused by internal memory error. In that case only restart can help!

Hi Balaji

I was very busy this week. I hope I'll find more time next week to help you (if it's not too late).

Best regards

Have you modified client registry? If not check BOL , "linked servers, access Oracle database instance".

What's about TNS names, is there an entry for oracle server you are trying to...

I was thinking about your problem and possible solutions and I found that much easier way to achieve your goal is to play with foreign keys. For example, you can...

Trigger (10/29/2007)

---

I have an XML File that contains a heirarchical set of data. There are 3 sets of data within this XML. Customer, Orders & OrderDetails. I also have the...

Maybe the following script will be useful specially if database contains a huge number of SP, functions,...

declare @Name nvarchar(64)

declare @cmd nvarchar(200)

declare @user sysname

set @user = N'DBUser'

declare c1 cursor for

select...

I made corection and tried to test it over many different structures. Pls, give me a feedback.

set nocount on

declare @Order int

Set @Order = 1

IF Exists(SELECT * FROM tempdb.dbo.sysobjects WHERE [ID]...

I'll be back with fix very soon.

Sorry, I found it. I'll try to fix it tomorrow.

Hi,

I'm not sure that I understand well. I've tested this script over a lot of different databases. But it's possible to have some bug. Can you e-mail me script for...

Application role can be a solution for your problem. See BOL for more details.

Attribute (1) or element (2) centric mapping. See BOL.

Are you sure that you have null value?

Try adding letter in dataset and then create group on that field without header and footer but with page break at end.

Can you put SP OthCalculateNextDate in separate box as ConCheckHoliday just to make it readable?