http://beyondrelational.com/modules/2/blogs/77/posts/11360/changing-sql-server-service-account-or-password-avoid-restarting-sql-server.aspx

pveilleux (5/31/2012)

---

SQLKnowItAll (5/31/2012)

---

Since it is a domain account, why not just change the password and see who comes complaining to you? Who all needs to know that password? Hopefully only...

Try going to gpedit.msc and navigating to Computer Configuration --> Administrative Templates --> System-Logon; then enable "always wait for the network at computer startup and logon."

Off the top of my head, you can try changing the SQL Services to delayed start. I think there may also be a registry setting or WMI setting to make...

Since it is a domain account, why not just change the password and see who comes complaining to you? Who all needs to know that password? Hopefully only you...

It could be that a script is being run via task scheduler or some other windows/web application is kicking off the job.

EDIT: I see the difference in the messages now between schedule and what you are displaying.

Scheduled jobs run under the service account for SQL Server Agent.

The problem with NOLOCK is that you can get strange results back when you attempt to read data that is being updated, in some cases you can see the before...

My first guess is that they are mapped drives; i.e. the drive letter exists when you are logged in and you attach the files. Then when you log out...

Glad to help!

Ok, so this?

INSERT INTO @destinationB (ProjID, DataOne)

SELECT a.ID, o.DataOne

FROM @destinationA a

INNER JOIN @OriginalTable o

ON a.DataTwelve = o.DataTwelve

Is this a 1-time migration of data or something that has to be done regularly? I believe you can just do a separate insert into each table. You...

I'm sorry... but I don't see a question. 🙂 EDIT: I see the question now:

My guess is no, but I have to...

Kind of hard to help when we don't have the DDL for the tables 🙂 Also, default collation, database collation, view definition...