September 2009 - Posts

• Will EMPTYFILE on primary ldf "doom" it somehow?

  I just read a newgroup question whether doing SHRINKFILE with the EMPTYFILE option for the primary log file somehow cause ill effects. Shrinkfile for the ldf will not move any data (log records) or so. For an ldf file it is basically a preparation to Read More... Posted Tuesday, September 29, 2009 6:48 PM by TiborKaraszi | 3 Comments Filed under: Transaction log

• SQL Server Agent jobs and user contexts

  In what user context does a job run? I recently found myself in a forum discussion and gave my stock reply, later realizing that I haven't actually tested this for a long time (I used to demo this in class during 6.5 courses - when we actually had time Read More... Posted Saturday, September 19, 2009 11:57 AM by TiborKaraszi | 4 Comments Filed under: Security, SQL Server Agent

• SQL Client config, 32 and 64 bit

  Say you want to change the preferred netlib connection order. Or add a server alias. You can do this using the "SQL Server Configuration Manager" program. But installing this on each client machine where you want to do the modification might not feel Read More... Posted Tuesday, September 08, 2009 2:04 PM by TiborKaraszi | 1 Comments Filed under: Installation, Troubleshooting