DotNetShoutout - Stories tagged with SQL Server 2005

SQL Server 2005

atom rss
4
Shouts
spam Shout it Mute it

SQL Server: How to Remap Existing Database Users on New Instance
posted by lionofdezertlionofdezert 569 days, 9 hours, 21 minutes ago
Thursday, November 03, 2011 7:43:31 PM GMT
During shifting databases across different instances a common problem is ORPHAN USERS and remapping of these orphan users of database on new instance. Here is a simple method to resolve this issue. (more)
category: Data | clicked: 2 | comment | | source: connectsql.blogspot.com
tags: SQL Server 2008, SQL Server 2005
3
Shouts
spam Shout it Mute it

ColumnStore Index - SQL-Articles
posted by sqlarticlessqlarticles 682 days, 19 hours, 50 minutes ago
Wednesday, July 13, 2011 9:14:17 AM GMT
What’s this? Columnstore index is a new type of index available from the future release of SQL Server known as Denali aka SQL Server 2011. Columnstore index helps data warehouse queries to execute faster than the normal indexes.This index is suited if the volume of data is high and same type of query is used to retrieve the data. Columnstore index is read-only h... (more)
category: Data | clicked: 0 | comment | | source: sql-articles.com
tags: denali, columnstore, non clustered, sqlarticles, SQL Server 2005, index
4
Shouts
spam Shout it Mute it

Kodyaz Development Resources
published 955 days, 10 hours, 32 minutes ago posted by eralpereralper 956 days, 16 hours, 2 minutes ago
Wednesday, October 13, 2010 6:32:01 PM GMT Tuesday, October 12, 2010 1:02:11 PM GMT
Problem Statement: In your SQL Server database you have two database tables to store expenses and payments for closing expense amount. You want to list the expenses of a customer using t-sql by querying your sql tables. This list will also add the payments done by the same customer to close these expenses. Each payment will be listed as new columns beside the expenses records. (more)
category: Data | clicked: 1 | comment | | source: www.kodyaz.com
tags: SQL Server, CTE, SQL Server 2008, SQL, T-SQL, SQL Server 2005
4
Shouts
spam Shout it Mute it

SSIS–Dynamically set File Mask : FileSpec - Sudeep's Domain
posted by http://rajsudeep.blogspot.com/http://rajsudeep.blogspot.com/ 970 days, 9 hours, 24 minutes ago
Tuesday, September 28, 2010 7:40:25 PM GMT
In the SSIS Forum I cams across the following query and thought of writing a post on the same. “Can anyone give guidance on how to set the mask for a Foreach File Enumerator programmatically? I have a DB that has a list of masks. I am retrieving that into an ADO recordset. For each record I retrieve the value into a variable. I would like to look at a directory and copy all files that begin with the chars for each item in my recordset variable.” The solution I provide uses a Flat File to store the vari... (more)
category: Data | clicked: 2 | comment | | source: beyondrelational.com
tags: For Each loop, MSBI, FileSpec, SQL Server 2008, File System Task, SSIS, Dynamic File Mask, SQL Server 2005
7
Shouts
spam Shout it Mute it

Sequential Guid Algorithm – Implementing Combs in .NET
published 969 days, 9 minutes ago posted by developmentalmadnessdevelopmentalmadness 970 days, 10 hours, 11 minutes ago
Thursday, September 30, 2010 4:54:55 AM GMT Tuesday, September 28, 2010 6:53:26 PM GMT
A class for generating mostly seqential guids (for loads under 1K/second) across system boundaries. (more)
category: Data | clicked: 0 | comment | | source: www.developmentalmadness.com
tags: .NET 2.0/3.0/3.5 Framework, SQL Server 2005
3
Shouts
spam Shout it Mute it

Cannot change column to Not Null: Cannot insert the value NULL
published 1005 days, 16 hours, 1 minute ago posted by codegaincodegain 1006 days, 18 hours, 1 minute ago
Tuesday, August 24, 2010 1:03:07 PM GMT Monday, August 23, 2010 11:03:02 AM GMT
Cannot change column to Not Null: Cannot insert the value NULL into column '', table '.dbo.Tmp_'; column does not allow nulls. (more)
category: Data | clicked: 1 | comment | | source: www.codegain.com
tags: SQL Server 2008, SQL, SQL Server 2005
2
Shouts
spam Shout it Mute it

Named pipe Provider Error for SQL Server 2005 : The CodeGain
posted by codegaincodegain 1027 days, 1 hour, 3 minutes ago
Tuesday, August 03, 2010 4:01:22 AM GMT
Recently I have been working on a article for codegain for that I just tried to add a database file on my solution with visual studio and I have received following error. (more)
category: Data | clicked: 0 | comment | | source: www.codegain.com
tags: SQL Server 2008, SQL Server 2005
3
Shouts
spam Shout it Mute it

SQL Server Database Mail sp_send_dbmail Example
posted by eralpereralper 1082 days, 9 hours, 29 minutes ago
Tuesday, June 08, 2010 7:34:58 PM GMT
SQL Server Database Mail spsenddbmail Example Here is a sample t-sql code using spsenddbmail system stored procedure to send email from SQL Server. Since Database Mail feature is first introduced to administartors and developers with MS SQL Server 2005, SQL Server administrators and t-sql developers can use the below spsenddbmail example sql code on a Microsoft SQL Server 2005, MS SQL Server 2008 or SQL Server 2008 R2 instance (more)
category: Data | clicked: 6 | comment | | source: www.kodyaz.com
tags: SQL Server, database mail, SQL Server 2008, sp_send_dbmail, SQL Server 2005
4
Shouts
spam Shout it Mute it

Schedule database backup for sql server 2005 using maintenance plan
posted by kcherupakcherupa 1177 days, 23 hours, 47 minutes ago
Friday, March 05, 2010 5:16:55 AM GMT
Scheduling a daily backup of sql server 2005 database using sql agent is very easy. By following below steps anyone can do that. Open sql server 2005 Management Studio and connect a serverExpand the tree (left navigation) ”Management->Maintenance Plans”Right click on node Maintenance Plans and Click “Maintenance Plan Wizard” (As shown in figure below) which causes to open a wizard. Follow the wizard In 2nd step of the wizard, You can schedule the task as clicking the Button “Change” as shown i... (more)
category: Data | clicked: 0 | comment | | source: cherupally.blogspot.com
tags: sql agent, recurrent, backup, Database, SQL Server 2005, Daily