Thanks for providing the excellent sample code. 😀

Unfortunate I can't reproduce your problem. When I execute the code it is displaying all the correct minimum values in field ed.DateTimeProcessed. I...

From your VB6 you allready install the SQL instance. You could add some additional code to create an ODBC connection when the installation is finished. Next you execute the SQL-code...

I guess this should work (when you are logged in as the SA):

USE [master]

GO

ALTER LOGIN [sa] WITH PASSWORD=N'new_password'

GO

aurato (7/21/2014)

---

I restarted my server's SQL Service when I could not kill a connection for nearly an hour. This caused many issues.

...

2) After the restart, tempdb and the model...

You could try to wrap the code in a TRY...CATCH block. In the TRY part you define the linked server to the primary instance. If this fails it will jump...

It is not possible to create a snapshot of a database on another instance. You could setup some kind of back-up/restore technique (perhaps logshipping?) to create a available database on...

Edward-445599 (7/16/2014)

---

thanks sorry a little confused so I have log shipping enabled...

If I now want to have nightly backups and t-log backups every 30 minutes.

Do I just set up a...

I don't think there is just one script to get all your desired information. You could search the script section of SSC site for several scripts and combine them yourself....

I'm not sure if I understand your question correct, but maybe this can help. You can use a CASE statement in an ORDER BY like this:

SELECT

...

ORDER BY CASE

WHEN ItemNumber...

Perry Whittle (7/15/2014)

---

since a restart of the instance is necessary i would recommend you just remove the file at your next maintenance window. Start the instance single user and remove...

CaptainSlock (12/15/2011)

---

The file "K:\sqldata\PROD_CRICKET\tempdev2.ndf" has been modified in the system catalog. The new path will be used the next time the database is started.

Msg 5042, Level 16, State 1, Line...

Does the SQL Agent service account has permission on the linked server?

Look in the SQL Error log on the linked server and see the detaild errors regarding the failed login.

And in addition to my previous post:

Usinig the backup/restore method you always keep the original database available in case you need to fallback the migration.

I wouldn't opt for the detach/attach option. I would go for a similar option as Eirikur Eiriksson already mentioned in one of the previous posts:

1. Copy all logins with access...

Keep in mind that when one of the parts is NULL, the combined string becomes NULL. It looks like you have one or more rows where "c.First_Name" or "c.Last_Name" is...