Hi Tim,

Did you check the network. A while ago we had performance problems that where caused by a corrupt network card on the server.

Klaas-Jan

Hi , the sql-dmo samples are installed (i used the default installation location)

in:

C:\Program Files\Microsoft SQL Server\80\Tools\DevTools\Samples\sqldmo

best regards,

Klaas-Jan

Hi,

I found this in the sql-dmo samples

first create the table

then add the primary key constraint like this

 

Private Sub CreateMyTable()

On Error GoTo ErrorHandler

'This example illustrates...

you can use the osql commandline utility to write the output to a file.

Hi tom,

i just did some tests. With bulk insert and a format file the columns are correctly filled. You only have to trim spaces.

create table...

Hi, Prakash

You could add sybase as a linked server to sql, but that will be slow. Then you could the linked server syntax (openquerie or ...)

You could try to connect...

Hi Chris,

I have a simular problem, the only thing i could find is Q302621, i don't know when this bug is solved. maybe somebody has found an other workarround

...

Hi, can you post your complete code of the stored procedure, maybe there is a way to avoid using a cursor.

Klaas-Jan

Hi, put the begin transaction in the try block.

regards,

Klaas-Jan

Hi,

1) you are correct if you add fields in a table you have to drop and recreate the linked table. You can do this in code with refreshlink.

When you add...

Hi, did you check the auto_close option ?

Klaas-Jan

hi, try this

select sum([value]) from tbltest

where left([id],2)=11

group by left([id],2)

union all

select sum([value]) from tbltest

where [id] between 2015 and 2025

group by left([id],2)

Hi, there is also a column loginname which captures sql login or a windows login in the form domain\username

regards,

Klaas-Jan

Hi,

In a number (or decimal or float) field you could not fill in a quote.

In your code yould where you build your sql string you could something like this:

strsql="insert into...

hi Chris,

How much impact has the encryption of the databasefiles on performance?

Klaas-Jan