It's embedded.  You need to ADD quotes, not take them away

''YEAR_'' + CONVERT(nvarchar(8), YEAR(eventyear)) eventyear,

Before you execute the dynamic SQL, print it.

PRINT @query

Run that query, fix the issues,...

It's embedded.  You need to ADD quotes, not take them away

''YEAR_'' + CONVERT(nvarchar(8), YEAR(eventyear)) eventyear,

Before you execute the dynamic SQL, print it.

PRINT @query

Run that query, fix the issues, and make...

Maybe this?

'YEAR_' + CONVERT(nvarchar(8), YEAR(eventyear)) eventyear,

I'm using AlwaysOn synchronous replica.  User issues an update on primary via SSMS.  In order for the transaction to be committed on primary, the tran needs to get to...

i have a table:

id int,customerid int,balance.

i want to reduce for a "customerid" from his balance,assuming his balance-@amount to reduce>=0.

what is the corret/safe way to do it, assuming the reduce can...

I would suggest log shipping.

The key to minimizing downtime is the frequency of your log backups.  If they are set to, as an example, every 15 minutes, your downtime can...

Is this mirroring, or an availability group?

Run the validate cluster utility if it's an AG.  It will tell you to raise(or lower!, I can't remember) one of the timeout settings.

Michael, this is really doesn't make sense to me, why does someone put something unrelated question to the subject in this thread instead of posting new thread? This is...

Hoping someone can help me understand something that popped up on my pc this morning:

C:\windows\system32>REM Find out if the user is logging on from home:

C:\windows\system32>set : find /i "remote=true"...

I have both.  We purchased SentryOne for our use, and Solar Winds is in use by the third party that monitors our servers.

The choice should be made according to your...

Removing the SA rights and granting developers to db_owner role on Dev servers. What roles would be needed to do all of the following, also which are appropriate for...

• This reply was modified 6 years, 3 months ago by Michael L John.

It depends.

What are the "rules" in your organization?  Here, the devs are admins in the dev environment.  They can do it all.  Most of the time, I have "signoff" on...

There is not a simple answer here.

If this is an Azure VM, and you want to be able to use your Windows AD credentials, you are going to have to...

One more thing.  if you create a project in SSMS you cannot open it with Visual Studio. And visa-versa.

The user needs "view definition" permissions on the database