Hi,

When i was new to SQL Server, I started with BOL. It's a good place to start and you can find almost everything there except from undocumented functionalities.

If I had...

select cast(getdate() as date) doesn't work on SQL Server 2005

Hey, I like sysnonyms, one of the things I always wanted SQL Server to take from ORACLE, and now it's done.

Regards

Richellère

Hi,

AWE and /3GB may bring you some extra memory for the cache but this won't solve the problem if the server is very busy. It will be a matter...

This should be your last solution if nothing else work.

The first thing to do is to find the cause of the problem by diving in the logs and then take...

I did this in the past and had problems with my code using the new functionalities of SQL Server 2005. I still dont understand why your vendor want to switch...

Hey Barry,

Tried this and it works for me.

Thanks for the Solution

Richellere

Yes Paul, that's right. I'm reading all these posts now and I find them very interessting.

Thank you for the good explanations.

Richellere