SQL Server on Linux

Technical Article

RE: Can''''t start SQL Server Agent

  • Reply

Click: Start->Run, type in: services.mscScroll down to SQLSERVERAGENT. What do you see in the Logon as column (last column). see image belowIn this scenario I'm running as user Patrick in the Molijn.NET domain.Changing the logon account can be done by double clicking the service and switching to the logon tab.

You rated this post out of 5. Change rating

2005-05-23

Technical Article

RE: Troubleshooting MSDTC in SQL Servers between W2003 and W2000

  • Reply

Hi,I do have the same issue when using Linked Server too in addition to my Openrowset query.Could you post here how did you change those settings? So far I found the articlehttp://msdn.microsoft.com/library/default.asp?url=/library/en-us/cossdk/html/eb45c4ef-73c7-4941-abfb-0ce1adcdfb80.aspthas says that Win2003 SP1 or Win XP SP2 required, that we did not have yetPlatforms: Windows XP Service Pack 2, Windows Server 2003 Service Pack […]

You rated this post out of 5. Change rating

2005-05-20

Technical Article

RE: user!userID used to build report parameter selection list

  • Reply

I'm not sure what I did different OTHERTHAN I noticed you said tht the line must end with a space so I carfully placed the string back in and hit return after the last ".  It works now!!!!!  This is great.  I evidently wasn't holding my breath or crossing my eyes or something right.  Thank […]

You rated this post out of 5. Change rating

2005-05-20

Technical Article

RE: SSPI on query analyzer

  • Reply

Ok, I will try this tomorrow when I am at work where I have SQL Server 2000 (only 2005 at home). Is it always around 125, or was that just that specific time? If it is always after opening that many connections it might be further information pointing to memory issues. Not that 125 is […]

You rated this post out of 5. Change rating

2005-05-16

Technical Article

RE: logical and, or

  • Reply

Rob, Kenneth many thanks to both of you for your input.Kenneth  "SQL is very non-prejudice and will give you an answer to exactly what you have asked, not what you thought you asked ' mean that SQL has a very Feminine outlook. I once had a wife who always insisted that she was answering the […]

You rated this post out of 5. Change rating

2005-05-16

Technical Article

Deletion of SQL Logins

  • Topic

Hi,I am having windows domain logins created in SQL Server long back. Now I need to delete those logins as the users left the company. I have tried to access the properties of individual login users in the Enterprise Manager and was not successful as it is hanging. I tried to work it out from […]

You rated this post out of 5. Change rating

2005-05-16

Blogs

SQL Saturday Boston 2024 Slides

By

Thanks to everyone that came to my talks. Slides are below. Best Practices for...

Small Data SF 2024

By

I can’t remember how I heard about Small Data SF 2024, but it caught...

A New Word: Moledro

By

moledro – n. a feeling of resonant connection with an author or artist you’ll...

Read the latest Blogs

Forums

7 sept, scheduled book

By philip.scott

Comments posted to this topic are about the item 7 sept, scheduled book

7 sept, schedlued article

By philip.scott

Comments posted to this topic are about the item 7 sept, schedlued article

6 sept, published book

By philip.scott

Comments posted to this topic are about the item 6 sept, published book

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers