please look into this area, explains more on MARS compatability with sql

http://blogs.msdn.com/angelsb/archive/2004/09/07/226597.aspx

You need to initate the data sources odbc with sybase to sql server first.

you need to sys-admin rights/permissions to do this job

Question of the Day for 26 Oct 2007 :-

Which functionality provides the best granularity of ownership of objects within SQL Server?

Correct answer: create objects with schemas

Explanation: ...

You can use the BLOB datatypes to store & retrive the information.

But the recommanded solution is,

- Store the Binary Objects in Common Server

...

open 2 instances of sql...

1) Test db.

2) Production db.

If u hav database publishing wizard, then point the connection string to testdb & relevant database.

That will run a...

You need to have sys_admin roles to perform any activity.

try out varchar

Overview

SQL Server 2000 Indexed Views are similar to Materialized Views in Oracle - the Result Set is stored in the Database. Query Performance can be dramatically enhanced using Indexed...

http://www.microsoft.com/technet/prodtechnol/sql/2005/dwsqlsy.mspx - Overview of Business Intelligence and Data Warehousing

http://msdn2.microsoft.com/en-us/library/ms173767.aspx - Introducing Business Intelligence Development Studio

Try to pull out some useful tip from the above...

Excellent way of showing the example with meaningful image clips for data extraction.

We can also use cursors for bulk inserts.

READ UNCOMMITTED

Implements dirty read, or isolation level 0 locking, which means that no shared locks are issued and no exclusive locks are honored. When this option is set, it is...

design your report in such a way that, bring or drag & drop the relevant fields into the detail column of the report. set the detail column property by showing...

Version control means managing the versions of the objects created and deployed in their SQL Server environments. Typically, this involves developers and DBAs checking scripts including object creation scripts into...