Why is my suggestion ignored? It may not be as fast, but it gives a more reliable result than Hugo's plus it is suitable also if the number of distinct...

Luis Cazares (4/14/2016)

SELECT YourDate,

CASE WHEN MONTH(YourDate) <> MONTH(DATEADD(day, 1, YourDate)) THEN 'True' ELSE 'False' END,

CASE WHEN YourDate = DATEADD( MM,...

jaincs (3/23/2016)

Cannot insert duplicate key row in...

So true!

But if you want to do it exact, for example because the same element name exist in multiple schemas. Here's the query to get those values:

with xmlnamespaces (

...

J Livingston SQL (4/4/2016)

if this isnt a basic interpretation of your table, then please post a representative script that does explain...

Hugo Kornelis (4/2/2016)

I think that would be for a binary collation. For case-sensitive collations, it would be either LIKE '[a-Z][a-Z]%', or LIKE '[A-z][A-z]%' -...

C.K.Shaiju (4/4/2016)

Jeff Moden (3/17/2016)

Worse than that, there was a bad disk that slowed the system...

sys.sql_modules should be helpful in getting the current definitions from the database. Using this system table you can extract the procedure's current definitions to compare them to wherever you keep...

As long as your application allows users to specify the primary key you'll get these primary key violation conflicts. In a non-replicated environment the users would not be allowed to...

Yes, in real life you do use separate accounts not having sysadmin privileges. If you don't, you're at risk when your security is breached in any way. It's not even...

I haven't tried it, so it's just an idea. Have you tried scheduling a SQL Server Agent job at 'SQL Server Agent Startup'?

I know the OP probably doesn't need an answer any more, but for anyone who has a similar issue and ends up finding this question:

The message text 'An insufficient number...

These are queues generated for Query Notifications. They are dynamically created for each query notification requested by a client. There is no need to transfer these into your new database.

More...

Use getutcdate() not getdate() or you'll run into problems due to daylight savings time. Like last weekend, when the clock was reset back from 03:00 to 02:00.