SQL
MS SQL and .net Development
Pages
(Move to ...)
Home
▼
Tuesday, January 10, 2012
Installing Microsoft SQL Server Management Studio Express in Windows Vista or Seven: Error 29506.
›
This is a problem about privileges. Probably the installer performs the latests tasks without using elevation. Solution is very simple:...
Monday, January 9, 2012
Nine Steps to Troubleshooting SQL Server problems
›
Nine Steps to Troubleshooting SQL Server problems By Gregory A. Larsen DBAs often have a need to identify why a problem has occur...
1 comment:
Saturday, January 7, 2012
How to programmatically find out when the SQL Server service started?
›
Everytime SQL Server starts, it recreates the tempdb database. So, the creation date and time of the tempdb database tells us the date and...
1 comment:
What is the T-SQL equivalent of IIF (immediate if/ternary operator) function of other programming languages?
›
CASE is the equivalent of IIF function. See SQL Server Books Online for more information. Here's a quick example: CREATE TABLE People (...
Friday, January 6, 2012
IIS FTP Configuration - Failed to retrieve directory listing error in FTP Filezilla Client
›
After I configured the FTP site in IIS on Windows Server 2003 and added permission to a new FTP user on my FTP directory I ran into the ...
‹
›
Home
View web version