Hi ,

Thanx  Johnson for ur effort but i mentioned before dont define the table structure before.

Hi Remi,'

But openrowset doesnt work.

from

killer

Hi Chris,

I altered the sp_helpcolumns this gives all the information related to a table structure and i managed to create a table with records but now i dont have any...

hi neo,

Me.SqlConnection1.ConnectionString = "workstation id=clientname;packet size=4096;integrated security=SSPI;data source" & _

"=servername;persist security info=False;initial catalog=trial"

End Sub

in ur sqlconnection string u should also...

Hi neo,

U r problem sounds like u are not using the username and password. in urcode.

if u post the  connection code then it will be much better.

from

killer

Thanx Chris,

This is not what i need i dont want to define the columns that exist in the output

Is there anycommand that we can create a table without defining the...

Hi Chris,

Thanx for ur support.As MSQL Server uses a SP to create a script but the  profilor fails to trace how Sql server writes the table structure to the disk.(in a...

Thanx Chris,

I need to do this by code .

Problem is i have a OLAP server having the same database as my production server but sometime my programmers need to increase...

Hi,

Thanx Chris.

But as my question (i have 2 sql server Server A and Server B i want to script few tables of server b from server A)

Can anyone help

from

killer

HI,

Pls put ur database online

USE master

GO

ALTER DATABASE pubs

set online

GO

hope this helps

from

killer

Hi Ach,

From BOL

Autocommit mode is the default transaction management mode of Microsoft® SQL Server™. Every Transact-SQL statement is committed or rolled back when it completes. If a statement completes successfully,...

Dear Hemant,

we can as many logfile as we want. as per the books on line says with examples.

Then what is the questation that it is not recomnded. Did microsoft says...

Hi Asad,

If i understand ur questation and per my knowledge we cannt track the user activity not in sql user accounts. but yes u can track it from ur operating...

Hi,

If u are incremental update then u have u process ur dimensions first.

then u go for cube incrmental process.

from

killer

Hi Arun,

Bkelley comment is fine if u run both the select and insert statement on the same database. but this  in second aspect if u are executing insert and select...

Hi Saadiq,

U did not mentioned about the error. as per my knowledge ur SQL Server agent is stoped.

from

killer