Hi,

although this method is a little bit unusual for relational databases you can get your output by adding a identity column to your table.

create table tbtemp (orderid int identity(1,1), temp...

Hi,

I only want to add that you have a copy and paste error in the following statement:

UPDATE [Clinical_Edu_2006].[dbo].[tblSChestTubeFeedback]

SET [Bedside Procedure & Interventions] =

(

SELECTCount([The learner understands the bedside procedure and nursing...

Hi,

when I correctly remember, part of the encryption mechanism is to include the instance specific guid which is created after setup the instance, so it is not possible to directly...

Hi,

have you checked the non-default configuration changes of both servers (in "Server Dashboard" report)? Perhaps there are some differences.

Greets

Hi,

what degree of parallelism is set on the server? was it changed?

Try to add the maxdop option on the create index command and analyse the differences in execution plans.

Greets

Hi,

the input buffer is the whole batch not the single statement that caused the deadlock. Try to find the whole batch in your code and verify if there is an...

Hi opc.three,

it works for me. Thanks for providing me the right solution.

I think it was too simple to get it on friday afternoon ... 😎

Greets

Hi opc.three,

sorry for my writing form ... it was friday afternoon before going home ... 🙂 ... the next time I will obey the rules. I have updated my initial...

Hi,

check if the server name of the sql server have been also renamed.

Check this with select @@servername.

It should be <Servername>\<Instancename>.

If the servername differs from the machine name rename it with...

Hi,

the space the log is taken on disk is different to the used pages in the log file. So if you have backed up the log, the parts of log...

Hi,

if the amount of data is not too big you can take a cursor to iterate through every line of the select statement odered by OrdNo, Actions and check in...

Hi,

normally in synchronious mode it schould default failover in 10 seconds (time to be sure the master is down) + time to switch over (normally some ms).

see "select * from...

Hi,

if you are trying to set up mirroring in a workgroup environment, you must do following:

1. Create same user on all involved pc's (same username with same password).

2. Let all...

Hi,

are backing up up the logs on local disk or on network share?

if so then change your backing up folder to local disk, because if the network connection is broken...

It doesn't matter. 🙂

Thanks for your information.

Greets

pitcher