Blogs about: Sqlserver2005

Featured Blog

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 »

Tags: SQL, SQL Server 2005, SQLSERVER, Remote, sp_addlinkedserver, sys.servers, query, Join, link server

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 »

Tags: SQL Server Management, .Net SqlClient, authentication, Data Provider, login, login failed, SQL, sql authentication, sql login error

Schedule daily backup for sql server 2005 datbase using sql agent2 comments

kcherupa wrote 1 month ago: Open sql server 2005 Management Studio and connect a server Expand the tree (left navigation)  … more »

Tags: SQL Server Management, backup, Schedule, SQL Server 2005, maintenance plan, sql agent, sql job, daily backup, recurrent backup

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 »

Tags: HowTo, SQL Server, eMail, SQLSERVER, sp_send_dbmail, storedprocedure

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 »

Tags: Personal, dba, migration

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 »

Tags: Personal, comparison, dba, mysql

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 Services2 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 »

Tags: BizTalk Server


Have your say. Start a blog.

See our free features »

Related Tags
All »

Follow this tag via RSS

Find other items tagged with “sqlserver2005”:
Technorati Del.icio.us IceRocket