Hi All,

I got the below error while attempting to run a distributed transaction. The two servers are in different workgroup. We dont have a domain. Please let me know the...

Thanks Tom for trying to justify my ignorance!!!

Its my bad... I inserted a space in one of the column...

Sorry guys..!! :satisfied:

Hi Steve,

I got the below answers in my SQL 2014 instance.. Could you please explain why this answer was incorrect...

Escobar2014-04-06 00:00:00

Escobar2014-04-07 00:00:00

Escobar2014-04-07 00:00:00

Jeter2014-04-01 00:00:00

Jeter2014-04-01 00:00:00

Jeter2014-04-01 00:00:00

Tulo2014-04-01 00:00:00

Tulo2014-04-01 00:00:00

Tulo2014-04-01 00:00:00

Hi Gail,

I am looking at the memory status in 3 of our production servers. This is to create a new database for a new application. I found the CPU usage...

Few days back I read this in the same SSC I guess. And it was the one from where I came to know the answer. SSC Rocks!! 🙂

I believe this is a good solution and it will work better than with identity_insert on.

Thnx.

1) Login using sa

2) Grant create database permission to your windows user

3) Now try with windows authentication

I tried the same and its not reflecting in the GUI. I go by the SQL Query.

Better use the sample code below..

REVOKE EXECUTE ON OBJECT::dbo.StoredProcedure

FROM LoginName;

GO

I believe you cannot disable a stored procedure directly... but there are few ways to accomplish it...

check these links...

http://stackoverflow.com/questions/23114386/enable-disable-stored-procedures

https://go4answers.webhost4life.com/Example/disable-stored-procedure-149295.aspx

PFB the response...

1. Is the identity column the clustered index key? - Yes

2. Can you force the constantly increasing order of the insert? - No

3. Do the identity values need...

Jus got lucky!! Nice question though!! 🙂

I agree with the author. No words for people who are not willing to share their ideas as they don't belong to this world. Are they sure about they haven't...

No, the domain name was not deleted.

The issue got solved when I removed the SQL Login and added and gave permission in mirror server and witness server. 🙂