Unfortunately, in...

No problem, glad you found a solution!

houming1982 (4/16/2013)

---

If we need to do modifications on mirror database, we must make it writable (set partner off + restore with recovery). But if the mirroring should be reset, we...

Not necessarily. For example, just tried it on one of my tables and there's > 500 difference.

The first one gives the last...

An instance of both is fine - but I think the Management Studio that comes with Express doesn't have the full functionality.

You could try running a repair on the client...

It's a stab in the dark, but do you have Management Studio Express installed, rather than the full version?

Hi,

You can use DBCC CheckIdent to reseed the column, assuming the values aren't used elsewhere in the database?

To avoid this in the future you could remove the identity property and...

Divine Flame (3/19/2013)

---

Thanks Lowell & Gazareth. We were able to track down the problem last week. It was collation of the SQL Server instance that was playing its role over...

No problem!

Do you need instant notification?

You could achieve this with a trigger on the table calling database mail. I'd be wary of making changes directly to 'system' tables like this...

Hi Mike,

something like this?

use ReportServer

go

SELECT u.UserName, c.CreationDate, c.Name, c.[Path]

FROM dbo.[Catalog] c

left join dbo.Users u on u.UserID = c.CreatedByID

Cheers

=first(fields!SupplierName.Value)

Hi, have you checked they're connecting to the database you think they are?

You can grab the info from profiler - User Error Message event.

Just to rule out a misspelt connection...

Hi, and welcome to SQL Server Central.

Please post and tell us how far you've got with your code & we'll try to help.

We could guess but your requirements aren't quite...

Hi Andrew,

I just discovered this undocumented function recently:

declare @timestring varchar(10) = '12345'

select cast(msdb.dbo.agent_datetime('19000101', @timestring) as time(0))

Any good?

Cheers

Gaz

fmuzul (3/13/2013)

---

You gave me an idea :exclamation::

someone should suggest to SQLServerCentral to start some form of "competition among developers/DbAdmins". A problem of data manipulation, in a field that people...