It looks like you are dividing 2 integers and getting an integer as the result. Try casting one of the values to something like DECIMAL (10,2).

To demonstrate the issue...

For me, my main instrument is bass guitar. I also play guitar (depending on the mood, electric or acoustic), occassionally keys (mostly to help with arrangements), flute (classically trained...

DISABLE TRIGGER is a SQL 2005 command. If your database compatability is below 90, it is not supported. You will need to use the equivalent ALTER command instead.

If...

Is your database set to compatability level 80 (SQL 2000) ?

Are the relevant Oracle tools (SQL Net is the most important) installed on the server ?

When you say that you can connect using SQL Plus, is this from your workstation...

SQL Server attempts to maintain a cross reference of objects (e.g. stored procedures) and the objects that are used by them (e.g. other stored procedures, tables, views). When you...

I assume that you want to stop replicating a single table within a publication because there are a lot of changes made. To do that, drop all subscribers to the...

My understanding is that you should only consider using fibers if a couple conditions apply, which are:

1. You server is consistently experiencing very high work load (high CPU utilisation)

2. a...

msdb has 3 roles (SQLAgentUserRole, SQLAgentReaderRole, or SQLAgentOperatorRole) that allow varying levels of access to SQL Agent.

SQLAgentOperatorRole is the most powerful of them all - it allow a...

FYI : changing the database compatability mode only changes how the optimizer parses your queries. The most likely issue that you will encounter is SQL code that the application...

I would suggest that you take a full backup sometime well before your batch process commences and transaction log backup regular after that. If you need to restore to...

SSIS Configurations exist for this sort of purpose. You can configure the properties of various tasks and connections in your package using these - including passwords of course.

Your configuration...

I think that what you are referring to is Microsoft System Centre Operations Manager. You can get heaps of info on this at http://www.microsoft.com/systemcenter/opsmgr/default.mspx

I have not used it myself...

Certainly is...

INSERT INTO Table2 (columnlist1)

SELECT columnlist2 from Table1

The names of the columns does not need to match but you do need to have the right number...

Have a look at the "Expressions" property of the execute package task. You should be able to supply the name of the package to call at runtime in a...