np Ian 😀

Try

Update a

Set EmpCode=1

From

EmployeeMasterHoldingArea a

Inner Join

CutoverTransfer b On a.Empcode=b.Employee_Id

Hope this is what you are looking for 🙂

Thats the answer u get from all Bosses regardless of what when it comes to spending, i would suggest then to use SQL response from red-gate which is resonable priced(...

Well that entirely depends upon ur reqirement and whats the price you are willing to pay, if its just a basic monitoring as you said then you can use the...

Say you are trying to connect to ServerA from Server B, u get the above mentioned error, Log into server A and try connecting to SQL server.

Also check for...

Hi Viji

This sounds silly, but have u checked for the MDF file for the deleted database 🙂

can you log into the server locally ( remote one)

Hi Luk

You dont need to change collation, i had implemented my systems for Greek characters, just changed varchar to NVarchar, but...

Are you using right indices, i can understand that you said that it runs slower on times, check with profiler and see is there any other process that is running...

I have faced this problem earlier, all i did is to change the datatype to unicode, we use java applications, its was working fine. 🙂

First and foremost its SQL upgrade advisor, then check all the CU on SQL 2005 and see which ones you need for your platform, then go ahead and do it,...

Try SSIS, i remember one of my friend doing this on SSIS, Hope this helps 🙂

( Iam not well with SSIS 😀 )

Why cant u crate a file name with dates on it that will be helpful to identify the files after a few days or months, there is a option in...

Create a random file name each time when you start your trace, this will solve the problem 🙂

use the below given link, this is from a post on SQLServerCentral, hope this will help

http://sqlblogcasts.com/blogs/drjohn/archive/2007/11/03/ssis-calling-sharepoint-web-services-from-the-data-flow.aspx

😀