8
“New Index…” is greyed out in SSMS
Can’t create a new index? In SQL Server Management Studio, if the New Index… option is greyed out, it is because you have a table’s Design window [...]
8
Full Text Index with Database Project Problem
I was running into issues with scripting full text indexes to my database project when doing a database compare from a SQL Server 2008 R2 database to [...]
15
SQL Server 2008 R2 Spatial Data Notes
Building a Point A point in SQL Server is represented as Longitude and then Latitude geography::STPointFromText(‘POINT(‘ + CAST([Longitude] AS VARCHAR(20)) + ‘ ‘ + CAST([Latitude] AS VARCHAR(20)) [...]
22
Error generating final archive: Debug certificate expired
I’m getting back into android development after being away from it for a while. When trying to build my application (using a 64 bit windows 7 machine) [...]
27
Do I have SQL Server 2008 or SQL Server 2008 R2 installed?
How to identify your SQL Server version and edition SELECT SERVERPROPERTY(‘productversion’), SERVERPROPERTY (‘productlevel’), SERVERPROPERTY (‘edition’) Version Components and Numbering SQL Server 2008 R2 is a minor upgrade [...]
23
SSRS 2008 Security Item Level and System Level Role Definitions
In SSRS 2008 it appears you can no longer configure item-level role definitions and system-level role definitions like you used to be able to do in SSRS [...]
14
Remote Desktop to Console
To RDP directly to a server’s console you can use the following command… mstsc /v:SERVERNAME /console
29
MS SQL Server Management Studio Intellisense Refresh
In MS SQL Server 2008 you will occassionally run into a problem where it appears you have an error in your query because intellisense doesn’t recognize changes [...]
Blogroll
@benmarch
- What is the best tool for generating xml #schema related #documentation?
- OH at home - "All the smart people breathe".
- RT @googlestudents: Announcing the Generation Google Scholarship for graduating high school seniors pursuing CS or related program http: ...
- Visual Studio Achievements | Achievements | Channel 9 http://t.co/qoOBd2rS via @ch9
- RT @MSDownloads: SQL Server 2012 Developer Training Kit Web Installer http://t.co/V7RdOryL
Tag Cloud!
Knowledge Bomb
- January 2012 (2)
- December 2011 (1)
- May 2011 (1)
- February 2011 (2)
- September 2010 (1)
- August 2010 (2)
- June 2010 (1)
- May 2010 (1)
- April 2010 (10)
- March 2010 (1)