Archive for September, 2009

Disable Auto-Recover in SSMS

I recently upgraded to SQL Server Management Studio 2008. (I LOVE the Script as … Drop and Create functionality.) Everything was working great at first, but after a while I noticed that management studio was freezing up on for a couple of seconds every minute. This got progressively worse throughout the day.

Then I noticed that this freeze coincided with the Auto Recover save time. I had never messed with this setting before, so I looked around to see where to change it.

Apparently there is no way to change this in the GUI, but you can change it in the registry.

SQL 2005

Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\90\Tools\Shell\General\AutoRecover]
"AutoRecover Always Enabled"=dword:00000000
"AutoRecover Enabled"=dword:00000000

SQL 2008

Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\100\Tools\Shell\General\AutoRecover]
"AutoRecover Always Enabled"=dword:00000000
"AutoRecover Enabled"=dword:00000000

~Ron

Installing (and Running) SSRS 2008 in Windows Vista

It’s been a while since I’ve played around with SQL Server Reporting Services, and I found a couple of interesting articles on using a report model with SSRS, so I decided to give it a go.

The installation went smoothly, as I have performed this task many times. However, when I visited the reporting services site I had no access. I am an administrator on the machine, and as such should have had access to the site.

I searched around for a good half hour and still hadn’t found anything that worked. Somehow I got the idea to run my internet browser as Administrator. Eureka! I added my local account to the SSRS instance and everything works very nicely.

~Ron

Easy way to move documents – Sharepoint

We wanted to move a whole bunch of documents from one folder to another and was looking for a easy way to do it. I Googled it and got the answer:

From your computer go to “My Network Places”, click on “Add network connections” enter the URL for the site you want to open as a network place. This will open the site as a network folder; you will need to open two instances of the network place if the document libraries are located on the same site. Double click on the Document Folder which contains the documents you want to move in one window, and drag them to the Document folder in the other window.

Another optional way to open a WSS site as a folder is to use Internet Explorer to open the site as a web folder. Select File — Open from IE, Enter the URL of the site in the text box and select “Open As Web Folder”, click “OK” and the site will open as a web folder. Here you will have the same option of dragging or cutting and copying documents between document libraries.

Using this method you can also easily copy files from your computer into Document Libraries or even save email attachments to the WSS Network Place.

A note if you renamed your Shared Document Folder on the WSS site, it will always be named Shared Document Folder when you browse the site as a Web Folder or Network Place.

Hope this helps 🙂

Happy Programming,

Cheers,

Raja

Debug Stored Procedures in SQL 2000 with Visual Studio

Before I forget this again … if you are not a member of the sysadmin role you need to run this to debug SQL 2000 stored procedures in Visual Studio.

USE [master];
GO

GRANT EXECUTE ON sp_sdidebug TO [User\Group\Role];