My high-level decommission tasks checklist (24 applications, several databases, multiple technologies etc.)

Get sign-off from appropriate stakeholder that application can be decommissioned

Create shutdown plan and timeline

Archive data - Files needed for...

Are you kidding me? The link might be suspicious but the intention isn't :alien:

You'll end up here: http://www.google.com/search?btnG=1&pws=0&q=%27decommission+database%27

You might want to search for "decommission" or "decommissioning" as well. After a merger last year we had a few systems to retire/decommission and one aspect to consider were legal...

Jon-413357 (9/29/2011)

---

I have a small junk drawer with pens, pencils (why so many??? :-P) keys, business cards, paracetamol, staples etc. and I have a big junk drawer with bigger stuff...

I even found some UAT (user acceptance test) sign-off's (wet signature on paper!) which were soooo important to collect. After the project nobody dared to file them properly and they...

The Source_File_Path is either a variable or a constant value somewhere in your code. Have you made a search for Source_File_Path in your VBA project already?

Nakul: I like the Microsoft example very much 🙂

Impressive for me would be if the CIA or NSA are using SQL Server to store their intelligence data.

Have a nice day!

Just for the records so that not everybody has to google it who isn't familiar with this feature: TDE = Transparent Data Encryption

Nice article though.

😉

If shrink should be available? Of course it should! There are situations where you need to have a tool to help you out. If any user decides to use it...

Thanks for the article!

There is a small typo in the following query

SELECT a.[name] AS 'Logical Name',

, a.[server_name] AS 'Server Name'

, b.[name] AS...

Check this article: http://support.microsoft.com/kb/892490/EN-US/

It explains how to use a DSN-less connection to a SQL Server for linked tables in Access. With this approach you can prevent that users have to...

Well, I have no real experience in this but in general I would create a SQL Server login using SQL Server authentication and use this information in your connection...

Try this:

SELECT DISTINCT ([ContactID]) AS myContact

FROM tblContact

WHERE ((([City]) In ("Toronto","Vancouver"))

AND (([ContactID]) In (SELECT [ContactID] FROM [tblContact] As Tmp GROUP BY [ContactID] HAVING Count(*)>1 )))

OR [City] IN ("Montreal");

The original query...

Nakul said it all! Have the same opinion and I'm luckily in a job where no life's are at risk if I'm not responding immediately 😉

Cheers R.

Not sure if I understand what you are looking for exactly. Hence the following is based on a lot of guessing:

This one gives you the Contact Id for every contact...