select * from Table1

where column4 IS NULL

There are only four columns

Sample Data:

1124100065.16

1156101101.11

11781015NULL

118991015NULL

11989102834NULL

please provide error detail as it must be different error then what you encountered earlier.

Verify permission of user under which agent is running.

You need to perform snapshot in this case and then start synchronization

Check Remote Connections thru SQL Server 2005 Surface Area Configuration and make sure Local and Remote Connections is checked.

I do not think that there is any way to figure out growth for past any days unless you have some sort of script or tool configured.

what about http://msdn2.microsoft.com/en-us/library/ms175490.aspx?

To use Hot Add Memory you must start SQL Server 2005 using the -h option

doesn't it tell to add -h?

Second option is correct answer.

Answer from option 1 and option 3 will be incorrect 98% times whereas chances of getting wrong answer from option 2 is not more than...

try this...

select convert(binary,251000000042000001),convert(numeric,0x00000000000000000000000000000000000012000001815E20912BBB7B03), convert(decimal,0x00000000000000000000000000000000000012000001815E20912BBB7B03)

change value whatever you have.

I think, you should follow method recommended by Chris.

Hi Sarvesh,

I understand you have performed backup of database not imported data. If it is then following command will help you to restore .csv file:

restore database Test from disk='c:\mohan\test.csv' with...

can you please add following command in backup step in job:

select databasepropertyex(' ','UserAccess')

and let me know output?

r u trying to do this operationg through Linked Server? If yes then make sure RPC, RPC Out is on under Linked Server's Server Option property tab.

check the service start-up account, and also check application event viewer for that instance

make sure RPC, RPC Out is on. Check this under Server Option of ur linked Server Name