Hi,

you can use a common table expression CTE like:

;with cte_Childs(

RelationString,

AccountID

)as(

select cast(r.AccountID...

The third question was, whether you get the error after a longer time of execution.

Have you tried to cast the longtext column to nvarchar? Or create a view in mysql...

The third question was, whether you get the error after a longer time of execution.

Have you tried to cast the longtext column to nvarchar? Or create a view in mysql...

Hi,

Imagine, you implement a replication, all on the same disk. When the robots insert data, this data will be written also to the distribution database on the same disk. Then...

Hi,

Imagine, you implement a replication, all on the same disk. When the robots insert data, this data will be written also to the distribution database on the same disk. Then...

Scope_identity() would fix it, but if you use a second table you can start a tran with a select with a lock hint to prevent other user to get a...

Hi,

usually microsoft writes in his system requirements "SPx or later". That should mean they support the latest.

http://www.microsoft.com/germany/sql/2005/uebersicht/systemanforderungen.mspx

Sorry for the german site, I couldn't find this in english... :unsure:

Hi,

first you must restore the last full backup, after this you only need to restore the last differential backup (because it relates to the last full backup not differential backup)....

Hi,

have you restarted the default instance? How much physical memory is available on the virtualized server and how much on the esx host system? So are you sure that it...

Hi,

have you restarted the default instance? How much physical memory is available on the virtualized server and how much on the esx host system? So are you sure that it...

Hi,

no, you can't get your "subscribers". Through a linked server you connect like any other user in your sql server environment, so you can perhaps get all clients from which...

Hi,

no, you can't get your "subscribers". Through a linked server you connect like any other user in your sql server environment, so you can perhaps get all clients from which...

Either you can convert your boxnumber to an identity column and get the inserted row by SCOPE_IDENTITY() function or you create an extra table to save the last returned boxnumbers.

Either you can convert your boxnumber to an identity column and get the inserted row by SCOPE_IDENTITY() function or you create an extra table to save the last returned boxnumbers.

Have you tried a non-odbc driver to get the data? Is the mysql db on the same server? Have you get the error after a longer time?