If you want to start ssms the command is sqlwb, but I don't know if this is what yout mean. Maybe you want to start a sql session in text...

Maybe I'm wrong, but it looks like the first row already in your table.

Am I missing something?

Very interesting!

Can you provide just a little bit more information? What does the job? Which step failed?

I don't think you'll get any answer with such a post!!

Set the commandTimeout property in the Connection object to 0 (= no timeout).

No backups, I suppose...

In fact the cursor was declared without any option, so I switched it to FAST_FORWARD, just to get a quick fix. I'll try to code it without cursors, also because...

Well, I don't know if it had cursors open in that moment, all I know is that it opened 2 (small) cursors, but I checked and the deallocate instruction was...

In Activity Monitor there's a column named "Open Transactions", that contained a 0 for my mysterious spid... I don't know where that information is extracted from, but I think...

Try working with the linked server options, maybe you can work around your problem. This looks interesting:

(From BOL)

Collation Compatible

Affects Distributed Query execution against linked servers. If this option is set...

Try with this:

SELECT A.personId, A.LogDate, A.selectedValue

FROM MySelectedValues AS A

INNER JOIN (

SELECT personId, MAX(logDate) AS LogDate

FROM MySelectedValues

GROUP BY...

The size of your LDF file depends on the recovery model of the database. If it set to "Simple" the LDF file won't grow a lot, beacuse the space in...

Your trigger expects a single row to be added/updated in your table, you can't be sure of that.

Try this way:

USE [Database]

GO

/****** Object: Trigger [dbo].[clientpanno] Script Date:...

I think you have to set a default value for the CodePage property in the connection properties. I'm working with a connection to a DB2-AS/400 and I set the codepage...

Did you try what suggested by the warning?

One way to achieve it could be to import your excel file into a table and the update the fields in the destination table.

If you want something more complex,...