Blogs about: Sqlserver2005
Featured Blog
SQL Server 2005 Security Architecture
Security in SQL Server 2005 is based on principals, securables, and permissions. Principals are security accounts that can access the system. Securables are resources within the system. Permissions al… more »
Just to note and share about anything
How to access Remote sql server's database table
kcherupa wrote 2 weeks ago: Recently I got a requirement to migrate data from other sql server’s database to my local sq … more »
The user is not associated with a trusted SQL Server connection. (.Net SqlClient Data Provider)
— 1 comment
kcherupa wrote 1 month ago: Every time I install sql server, in the initial days I used to face problems in logging on by sql se … more »
Schedule daily backup for sql server 2005 datbase using sql agent
— 2 comments
kcherupa wrote 1 month ago: Open sql server 2005 Management Studio and connect a server Expand the tree (left navigation) … more »
Howto: send e-mail from SQL Server 2005 - sp_send_dbmail
Emily wrote 4 months ago: Problem: I need a stored procedure that checks bugs in the support system and find out if any of the … more »
Problem with Orphaned Users/Logins in SQL Server 2005 Migration
bofe wrote 4 months ago: Scenario: You’ve run sp_detach_db on SQL Server 2000 and sp_attach_db on SQL Server 2005. You … more »
Showdown: MySQL vs. SQL Server 2005 (Backups Edition)
— 2 comments
bofe wrote 4 months ago: My disaster recovery needs from a database standpoint: Ability to restore to a point in time Retent … more »
SQL Server 2005 Best Practices!
techsavygal wrote 11 months ago: Hi All, While checking out some stuff on SQL Server, i stumbled on the set of Best Practices availab … more »
Processing an SSAS 2005 cube from the command line with XMLA
anasoft wrote 1 year ago: There was a question recently on the Analysis Services newsgroup asking how to process an Analysis S … more »
SQLServre 2005 BI SSAS
anasoft wrote 1 year ago: Real-time Business Intelligence Using Analysis Services Business Performance Management (BPM) … more »
SQLServer 2005 Notifications Services
anasoft wrote 1 year ago: Overview of Notification ServicesNotification Services provides a framework for developing subscript … more »
Data mining
anasoft wrote 1 year ago: Exploring and analyzing detailed business transactions. It implies “digging through tons of da … more »
Course 2937: Administering and Monitoring Microsoft® SQL Server™ 2005
anasoft wrote 1 year ago: Course 2937: Administering and Monitoring Microsoft® SQL Server™ 2005 Overview of the sqlcm … more »
Reporting Skills for Microsoft® SQL Server™ 2005 Reporting Services
— 2 comments
anasoft wrote 1 year ago: An Overview of SSRSSSRS provides applications and tools to manage the entire lifecycle of enterprise … more »
SQL Server 2005 Security Architecture
anasoft wrote 1 year ago: Security in SQL Server 2005 is based on principals, securables, and permissions. Principals are secu … more »
Microsoft Gives Peek At Next Version Of SQL Server
techsavygal wrote 1 year ago: Hi All, As you are aware, a new version of SQL Server named “Katmai” is going to be … more »
