Defining performance is really important.  Most situations would be best suited by trying to run a benchmark of usual activity on your old server, and then do the same on...

You may need to go into the client configuration and configure an alias for your subscriber with the appropriate port number.  Multiple instances varies the port number and sometimes this...

The 'GO' batch terminator is configurable at the client.  Depending on what is running the statement, this may not be a valid terminator.  The script should work without the GO's.

Your...

What is the data provider of your source?  The error is indicating that you are using a provider that does not support query parameters.

One good way around this is what...

It may help to know more about the package, but so far the places to start have been covered.

- service packs need to be the same (and you have already...

The upgrade advisor / upgrade wizard for SQL Server 2005 will also upgrade Analysis Services and it will work on many Analysis Services 2000 cubes.  If you go this route,...

@@Identity basically returns the identity value for the last record your spid inserted. So, if you were inserting records you need to deal with them sequentially:

DECLARE @ParentID INT, @ChildID INT,...

Space not being much of an issue these days, create and last modified user / date is something I require on every table.  Why not have it?  Someone will ask at...

I have also used the ActiveX script component in SSIS as a data source for consuming some oddly formatted files.  So far, I have been amazed at the performance I...

Keep it simple.  Just use MAX

SELECT COUNT(*) AS "COUNT"

 , CAST(StartTimeOrdinal AS INT)

 , CAST(PerformingDayOrdinal AS INT)

 , MAX(Enrolled) AS Enrolled

FROM OpsSchedule WHERE PerformingDayOrdinal IS NOT NULL

GROUP BY StartTimeOrdinal, PerformingDayOrdinal

ORDER BY PerformingDayOrdinal, StartTimeOrdinal

If...

This is typically indicating a network connection error.  The first thing to do is take as much ot of the picture as possible.  If you can use terminal services or...

You may want to simplify this a bit by splitting the two actions.  There are command line utilities that will copy a file from your hard drive to a CD...

You will never run out of options on this one, you can use EXISTS / NOT EXISTS for these as well.

SELECT

 H.[Employee Code]

 , H.Income

 , H.Tax

FROM

 EmployeeSalaryHistory H

WHERE

 NOT EXISTS(SELECT H2.[Employee Code] FROM EmployeeSalaryHistory...

I don't mean to pick at this on you, but it sounds like you are a bit new at this and dynamic SQL is usually not a good place to...

If I am following - you are running into the problem that the domain is stripped off the server login when the user is created for the database.  This can be...