Browse by Tags

Changing the Data Files Location after Installation

The other day i wanted to change the "Data Files" location for a 2005 database engine installation and a 2005 Analysis Services installation which you can specify under the advanced options during installation. I quickly found out that there appears to be no documented ways to do this other...

Posted to Andrew Calvett (Weblog) by ACALVETT on 08-10-2008
SqlClrProject version 2.6 Released

I have just released a new version - 2.6 - of the deployment tool for SQLCLR assemblies. It is a minor release, but it implements some changes that are fundamental for coming versions and also fixes a couple of minor bugs. The download page for it is here , and if you want general information about what...

Posted to Niels SQL Server Blog (Weblog) by nielsb on 02-27-2008
Transaction log backup deadlock

Recently we started to see deadlock errors when backing up our transaction logs. The "important" part of the error is shown below. Could not insert a backup or restore history/detail record in the msdb database. This may indicate a problem with the msdb database. The backup/restore operation was still...

Posted to Andrew Calvett (Weblog) by ACALVETT on 02-19-2008
Update of SQLCLRProject

I’ve had some feed-back about SQLCLRProject (thanks Doug et al!), and based on that fixed some issues. Read all about it, and get the updates on the download page . As always, comments and suggestions for improvements are very welcome!! Niels

Posted to Niels SQL Server Blog (Weblog) by nielsb on 01-30-2008
SSMS Log file viewer and Deadlock Graphs

Firstly I must say a big thank you to Microsoft for the new deadlock trace flag 1222. Compared to the trace flag output for 1204 & 1205 that you had to use in SQL 2000 it’s a walk in the park to interpret. Anyway, back to the post at hand! This is a quick FYI as i`m not going to go through how to...

Posted to Andrew Calvett (Weblog) by ACALVETT on 01-23-2008
Like Phoenix Rising ... or New Version of SQLCLRProjct

Hi everyone, it’s been a while (shame one me!)!! As some of you may know, back in the days I developed a tool for deploying .NET assemblies to SQL Server 2005 (or, as it was called then, Yukon). Initially it was just a tool used from the command line. As time went by, it evolved into a project named...

Posted to Niels SQL Server Blog (Weblog) by nielsb on 01-14-2008
The Job whose owner kept coming back......

I thought i would share this little quirk about the SQL Agent jobs for maintenance plans. One of our members of staff had left and we had the usual case of a few jobs failing with: "Unable to determine if the owner (DOMAIN\xxx) of job <JOB_Name> has server access (reason: error code 0x534. [SQLSTATE...

Posted to Andrew Calvett (Weblog) by ACALVETT on 12-30-2007
My old mate sp_recompile

As soon as i saw the error messages in the logs i thought to myself "Oh my, that did not happen in testing" (ok, maybe it was more colourful than that). We were creating a clustered index on a tiny little table and the index went through fine. However, the application started to generate the message...

Posted to Andrew Calvett (Weblog) by ACALVETT on 10-12-2007
SSMS Restore backup error

We had a requirement to allow someone to create and restore databases on a test server today and i thought to myself "Thats easy, i`ll just grant the "Create Any Database" right to the appropriate user, thats when the pain began! The user was using SSMS connecting using a SQL login to restore a database...

Posted to Andrew Calvett (Weblog) by ACALVETT on 09-14-2007
SQL2005 Peer to Peer Replication Overview.

I have cleaned up my blog a little, it was looking really messy but hopefully it's a little easier on the eyes now. The attached document is a brief overview on SQL 2005 Peer-To-Peer replication. It's by no means a technical implementation document rather an evaluation of whether the solution will...

Posted to MSSQL Resources (Weblog) by rayb on 09-14-2007

Page 1 of 2 (17 items) 1 2 Next >