In general I am against AV on a server, because the vast majority of the time it is useless. However, the very occasional time it is useful (eg. prevent a...

Always a possibility!!! All I can suggest is that you run some tests.

Andy

I'm sure there are docs out there to help with importing from Access. I haven't done it for a while, so I created a demo table in Access 2003 with...

As you have to EXEC a snippet of SQL code (hmmm, unless you updated the schema tables directly....), probably easier to run this in a Cursor. May not be the...

I think you'll have to write some CASE logic around the information held in:

select TABLE_NAME, COLUMN_NAME from INFORMATION_SCHEMA.COLUMNS where DATA_TYPE = 'ntext'

Andy

Thanks Phil,

Templates have been a well-kept-secret from me. I have never used them. But I can see how they could really speed up some of my work. Much appreciated info.

Andy

Hearty congratulations to Steve, Andy and Brian.

Steve, maybe you can celebrate by buying a new T-shirt... 🙂

Any predictions for how long it will take to reach 2 million?

Andy

With the new spatial data types included in SQL Server 2008, most of the functionality of ArcSDE is now redundant. It will be interesting to see whether ESRI embraces the...

I think, as long as the Client Workstation is licensed for SSMS, and the Server is licensed for the database engine, you are covered.

Although bear in mind that remote connections...

Sounds like your hands are tied a little here. However, Windows Operating Systems absolutely hate running out of hard-drive space, especially on the system drive. You will have continuous, unexpected...

The general consensus seems to be that knowing your co-workers salaries would lead to jealousy and resentment. This would only be true if pay is unfair.

To argue this a slightly...

HR Departments are certainly able to make these decisions.... they just judge you on the clothes you are wearing 😛

Try to think through where the object is being created..... Any object created in the database will be mirrored.

The main gotcha here are Security Principals, eg. Logins. These are not...

My view is that if the company is paying its staff FAIRLY, then there can be no resentment. In the EU, there is a "fair pay" directive which is gradually...

Thanks Philip, interesting.

Do you know if the problem lies purely with the size of the LDF file (and how full it is), or is it related to the speed the...