Sachin,

If you had finished the MCDBA course you would be eligible for one upgrade exam. But as it is, you will probably have to sit for all the exams in...

try to use the actual tsql to attach

CREATE TABLE myTable(Document varbinary(max))
GO

INSERT INTO myTable(Document)    
SELECT * FROM 
OPENROWSET(BULK N'C:\Image1.jpg', SINGLE_BLOB) 
AS Document 

GO

the one that got me chuckling was the Star Wars variable names...

hope you guys will be around for even longer to share your knowledge

talking about "experts", one of the them advised a client to use floats on monetary columns, instead of using the more intuitive MONEY datatype.

if i got you right you can use the FOR XML AUTO

declare

@STR as nvarchar(4000)

intresting idea. i think this is possible, try using the Visual Studio Add in project template

put this statement at the top of your query

SET NOCOUNT OFF;

try this in your connection string

connectionString="server=XXXXX;Initial Catalog=DBName;UID=XXXXX;PWD=XXXXXX"

if you are using windows authentication, ensure that the user that runs the IIS process has access to the sql server,

read this article it will help you understand

http://www.sqlservercentral.com/columnists/mcoles/fourrulesfornulls.asp

quick and dirty, run your script in the query windows as you are doing, then do into SSMS right click > Design

drag you column to the position you want,...

you can use replicated databases, i think they are better than trying to connect directly unless if you have super efficient connections

what do you mean by hasty approach, your aim is to return all the columns as one column so that you can assign them to your variable. did you get...

i have used it with sql 2005