thanks for the reply........i have to do this from JDBC (java)

i have to execute the query.........

i have tried writing inner join on the tables, but failed as one table...

can you give some example?

thanks for the reply.........let us say i have 4 tables (table1,table2,table3,table4) table1 is the master table with one column having the primary-foreign key relationship among the column in rest of...

thanks for the reply........

Can you please tell me How to create a new sql account and make that one member of the sysadmin group for sqlserver?

ok thanks for the reply....

Actually iam using hibernate, it will take care of such activities...

w.r.t your opinion i have create a sample JDBC connection as shown below, but iam getting...

thanks for the reply.......

I didnot get you...

BP is always to specify the database name you want to connect to (don't rely on the logins default database ! A sql instance...

thanks for the reply.....

Can you please let me know how can i connect to master or tempdb to perform database restore operation.

Tell me how to perform this operation from the...

thanks for the reply,

I have just executed the query in SQL Server 2005, it worked fine...but the database connection was broken

-------

Nonqualified transactions are being rolled back. Estimated rollback completion: 100%.

Failed...

thanks for the reply.......

Iam using type 4 driver (sqljdbc) .......

If a query has to be executed, it has to be in transaction......

Or else is there any other way?

What do you...