Received: from mailer4.sqlservercentral.com (89.234.60.73) by
 gibixonline.com (173.14.16.42) with Microsoft SMTP Server id
 14.0.694.0; Thu, 22 Apr 2010 23:52:15 -0600
DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=SqlServerCentral.com; s=mail; bh=VnGg12/s7xH3BraeN5LiiN+I2Ul/db5/jZYYgt4wEIw=; h=Message-ID:From:To:Subject; b=Adan86nqjsFm9WCFnv9P8aoAXYVs1bo1mE5idnHLY3qdUGrJOz82gmdJ53Nab0ZJ/fWGgSs/1tfpqwip5Rvj9oFqL+uvfXU5QpaCuc6aBQZa4BBdYM5QAwWv+b7i7QEEu11W0WgqJfI8qo+GKxVreYd8xQMXZcF8xU5ePvhEcNg=
X-campaignid: rdgt20100423000000
Message-ID: <b25c8f1b2c204f30aef80c0a395c83be@SqlServerCentral.com>
MIME-Version: 1.0
From: SQLServerCentral.com <subscriptions@sqlservercentral.com>
To: Joshua Harley <joshua.harley@gibixonline.com>
Date: Thu, 22 Apr 2010 23:48:26 -0600
Subject: Row Oriented Security Using Triggers and Corruption Help
 (SQLServerCentral.com 4/23/2010)
Content-Type: multipart/alternative;
	boundary="--boundary_436_fe62e6e5-0c7d-4ffa-b944-02d54c42764b"
Return-Path: subscriptions@sqlservercentral.com
X-MS-Exchange-Organization-OriginalArrivalTime: 23 Apr 2010 05:52:15.4152
 (UTC)
X-MS-Exchange-Organization-OriginalClientIPAddress: 89.234.60.73
X-MS-Exchange-Organization-OriginalServerIPAddress: 173.14.16.42
X-MS-Exchange-Organization-AuthSource: gibixonline.com
X-MS-Exchange-Organization-AuthAs: Anonymous
X-MS-Exchange-Organization-MessageDirectionality: Incoming
X-MS-Exchange-Organization-PRD: sqlservercentral.com
X-MS-Exchange-Organization-SenderIdResult: Pass
Received-SPF: Pass (gibixonline.com: domain of
 subscriptions@sqlservercentral.com designates 89.234.60.73 as permitted
 sender) receiver=gibixonline.com; client-ip=89.234.60.73;
 helo=mailer4.sqlservercentral.com;
X-MS-Exchange-Organization-SCL: -1
X-MS-Exchange-Organization-Antispam-Report: v=1.1
 cv=c+oHspu2av7H/xMjFSCQ7iHUq5H0SxeeJW+4ALWnxAI= c=1 sm=1 a=xUnq6xKWzqwA:10
 a=mdJmlY1qlM11cSzN+2yUcg==:17 a=T9Gs38c3AAAA:8 a=CjxXgO3LAAAA:8
 a=69EAbJreAAAA:8 a=-fBP8Z0tAAAA:8 a=tUHSFKFufq09S-c8KAIA:9
 a=Vr4SDxJRjnbr9A9fBkMA:7 a=XK_xl0G3qqVMCPmbeuYk-79q_rIA:4 a=QEXdDO2ut3YA:10
 a=rkLC8oWBkPQA:10 a=t2HAINGZeTYA:10 a=O3pDHqZ74TUA:10 a=sOJbxtuFQ7cA:10
 a=K8tTLWDdI84A:10 a=CiITsrGyF8gA:10 a=s-bDoeBb5JkA:10 a=mK3qly-nsfMA:10
 a=la6KjHO2rkkA:10 a=TMEtPODiblIA:10 a=AF2NrWo62JIA:10 a=hkTZK2qaTEgA:10
 a=QdUp9O7obW0A:10 a=qRHEElgZka0A:10 a=MbMlk6TqlGQA:10 a=VQzAJZQ9r_4A:10
 a=tilHjVh_N04A:10 a=XSRCOsDz_NIA:10 a=GiNA77gDKZ8A:10 a=npCth40KyqEA:10
 a=eEWLRPL_3jIA:10 a=B0TLUwe7iLMA:10 a=fpTdFeU-feIA:10 a=tLt57aIg2xsA:10
 a=bVb0Lfj5QeYA:10 a=zi7P17yvVmgA:10 a=pzBTM8jK7ZAA:10 a=ZZ8vwCD_hskA:10
 a=t02UY082lUUA:10 a=ht1rvyAp8AMA:10 a=fzN5bhHMor8A:10 a=qAcrhZbmhrQA:10
 a=RlQusWXsRu0A:10 a=vHjD56AzkQAA:10 a=hn5gtlyz5Q0A:10 a=xrlAVV_Aav8A:10
 a=Dx5pVnGTzi4A:10 a=oGwmWHIC5WQA:10 a=u0ClHcULX84A:10 a=rETbeksbTokA:10
 a=rA1N_AbsMc4A:10 a=I...

----boundary_436_fe62e6e5-0c7d-4ffa-b944-02d54c42764b
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: quoted-printable

--------------------------------------------------------=0D=0A-- SQL SERVER=
 CENTRAL COMMUNITY UPDATE FOR 2010-04-23 --=0D=0A--------------------------------------------------------=
=0D=0ARead more at http://www.sqlservercentral.com/links/288241/150902=0D=0A=
=0D=0A=0D=0AEDITORIAL - SPRING CLEANING=0D=0A---------------------------=
=0D=0AFor a Friday poll this week, Steve Jones is looking at those spring=
 cleaning or annual maintenance activities that you might perform on your=
 systems.=0D=0Ahttp://www.sqlservercentral.com/links/288241/150903=0D=0A=
=0D=0A=0D=0AADVERTISEMENT=0D=0A-------------=0D=0AToday's Newsletter sponsored=
 by:=0D=0AFree trial of SQL Backup=E2=84=A2=0D=0A"SQL Backup was able to=
 cut down my backup time significantly AND achieved a 90% compression at=
 the same time!" Joe Cheng. Download a free trial now. =0D=0A=0D=0Ahttp://www.sqlservercentral.com/links/288241/150874=
=0D=0A=0D=0AADVERTISEMENT=0D=0A-------------=0D=0AToday's Newsletter sponsored=
 by:=0D=0AFree trial of the happiest SQL tool in the business.=0D=0A"I downloaded=
 the SQL tools from Red Gate and the next 14 days were the best SQL days=
 in my life." Gu=C3=B0bjartur Haraldsson.=0D=0ADownload your own 14-days=
 of SQL heaven today.=0D=0A=0D=0Ahttp://www.sqlservercentral.com/links/288241/150875=
=0D=0A=0D=0AFEATURED ARTICLES=0D=0A-----------------=0D=0A=0D=0AROW ORIENTED=
 SECURITY USING TRIGGERS=0D=0AHandling security in an application can be=
 a bit cumbersome. R Glen Cooper brings us a database design technique from=
 the real world that can help you.=0D=0Ahttp://www.sqlservercentral.com/links/288241/150876=
=0D=0A=0D=0AHELP, MY DATABASE IS CORRUPT. NOW WHAT?=0D=0AThe stuff of nightmares,=
 a corrupt database. However Gail Shaw gives you some advice about how to=
 handle this situation.=0D=0Ahttp://www.sqlservercentral.com/links/288241/150877=
=0D=0A=0D=0ARETRIEVE DEFAULT SQL SERVER BACKUP FOLDER USING POWERSHELL=0D=0AIn=
 a previous tip on creating a Function to Return Default SQL Server Backup=
 Folder , you've seen how you can create a T-SQL function to query the registry=
 and retrieve the default SQL Server Backup folder. Is there an easier way=
 to do it in Windows PowerShell? =0D=0Ahttp://www.sqlservercentral.com/links/288241/150878=
=0D=0A=0D=0A=0D=0AQUESTION OF THE DAY - DEFENSIVE PROGRAMMING=0D=0A-------------------------------------------=
=0D=0AMany people think that defensive programming is a very important technique,=
 but few know whether it's a recent development or an ancient one. In which...=
=0D=0ARead more at http://www.sqlservercentral.com/links/288241/150893=0D=0A=
=0D=0AHarness the power of SQL Server, Microsoft=E2=80=99s high-performance=
 database and data analysis software package, by accesing everything you=
 need to know in Microsoft SQL Server 2008 Bible. Learn the best practices,=
 tips, and tricks from this comprehensive tutorial and reference, which=
 includes specific examples and sample code, with nearly every task demonstrated=
 in both a graphical and SQL code method. Understand how to develop SQL=
 Server databases and data connections, how to administer the SQL Server=
 and keep databases performing optimally, and how to navigate all the new=
 features of the 2008 release. =0D=0Ahttp://www.sqlservercentral.com/links/288241/150895=
=0D=0A=0D=0AYESTERDAY'S QUESTION OF THE DAY - TRUNCATE ROLLBACK=0D=0A---------------------------------------------------=
=0D=0AHow many rows are returned in the last select in SQL Server 2008?=
=0D=0A<BR/>=0D=0A=0D=0A<BR/>=0D=0Ause tempdb=0D=0A<BR/>=0D=0Ago=0D=0A<BR/>=
=0D=0Acreate table a (b int)=0D=0A<BR/>=0D=0Ago=0D=0A<BR/>=0D=0Ainsert into=
 a (b) values (1), (2), (3)=0D=0A<BR/>=0D=0A=0D=0A<BR/>=0D=0Aselect...=0D=0ARead=
 more at http://www.sqlservercentral.com/links/288241/150904=0D=0ACorrect=
 answer: 3=0D=0A=0D=0AStarting simply and gradually progressing to increasingly=
 advanced topics, this introduction to the SQL Server database focuses on=
 what is distinctive about the SQL environment=E2=80=94SQL Server 2008,=
 in particular=E2=80=94versus other programming environments. Author Robert=
 Vieira draws on his experience as one of the leading authorities on Microsoft=
 SQL Server and uses his unique tutorial approach to explain the significant=
 changes to the fundamental core components of SQL Server 2008. =0D=0Ahttp://www.sqlservercentral.com/links/288241/150898=
=0D=0A=0D=0AFEATURED SCRIPT=0D=0A---------------=0D=0ACOPY TABLE STRUCTURE=
 WITHOUT DATA USING 1 LINE QUERY=0D=0AThe script copies the table structure=
 to the newly created table without copying any data to it.=0D=0Ahttp://www.sqlservercentral.com/links/288241/150899=
=0D=0A=0D=0A=0D=0ADATABASE PROS WHO NEED YOUR HELP!=0D=0A---------------------------------=
=0D=0AHere's a few of the new posts today on the forums. To see more, visit=
 the forums at http://www.sqlservercentral.com/links/288241/150900=0D=0A=
=0D=0A=0D=0A=0D=0AADMINISTERING (http://www.sqlservercentral.com/Forums/Forum146-1.aspx)=
=0D=0A----------------------------------------------------------------------=
=0D=0A=0D=0AREPORTING SERVICES ON NON DEFAULT PORT - =0D=0A =0D=0A=0D=0A=
 =0D=0AHi,=0D=0A =0D=0A=0D=0A =0D=0AWe have installed & configured SQL Server=
 2005 reporting services. But on port 80 some other website is runng so=
 we...=0D=0A(http://www.sqlservercentral.com/Forums/FindPost908209.aspx)=
=0D=0A=0D=0ARUNNING SQL TRACE - My security team would like to run SQL traces=
 on one of our database servers.  How can I restart a...=0D=0A(http://www.sqlservercentral.com/Forums/FindPost908019.aspx)=
=0D=0A=0D=0ADELETING LOGINS AND USERS IN SQL SERVER 2005 - Can anyone help=
 me with providing with  script to delete some specific logins and users=
 assosiated with that login from...=0D=0A(http://www.sqlservercentral.com/Forums/FindPost907996.aspx)=
=0D=0A=0D=0AHOW MUCH RAM USED BY SQL SERVER 2005/SET LIMIT ON RAM - I forget=
 this.=0D=0A =0D=0AThere is a way to tell SQL server to use x amount of=
 RAM ( instead of using all...=0D=0A(http://www.sqlservercentral.com/Forums/FindPost907990.aspx)=
=0D=0A=0D=0AHOW TO FIND TABLES THAT ARE NOT USING SINCE LOG TIME? - Hi ,=
=0D=0A =0D=0A=0D=0A =0D=0Ai need to find the tables that are not using since=
 long time in the database=0D=0A =0D=0A=0D=0A =0D=0Ait would be great...=
=0D=0A(http://www.sqlservercentral.com/Forums/FindPost907946.aspx)=0D=0A=
=0D=0ACOMPORTEMENT ON ERROR RESUME NEXT - Bonjour,=0D=0A =0D=0A=0D=0A =0D=0Aj'ai=
 fait une requete qui contient un curseur, lorsque j'execute la requete=
 dans SSMS il y a des erreurs mais...=0D=0A(http://www.sqlservercentral.com/Forums/FindPost907857.aspx)=
=0D=0A=0D=0ABACKUPS VS MIRRORING VS REPLICATIONS VS SNAPSHOT - hi All,=0D=0A=
 =0D=0A=0D=0A =0D=0AI knew Backup & Restore of DBs only .=0D=0A =0D=0A=0D=0A=
 =0D=0Aevery time i am getting confused with the terms "Mirroring VS Replications...=
=0D=0A(http://www.sqlservercentral.com/Forums/FindPost907453.aspx)=0D=0A=
=0D=0ACOPYING SYSTEM DB'S TO A NEW SERVER - hi all=0D=0A =0D=0A=0D=0A =0D=0Awe=
 have our current live sql server, and a new test sql server.=0D=0A =0D=0Awhen=
 im finished with test it will...=0D=0A(http://www.sqlservercentral.com/Forums/FindPost906849.aspx)=
=0D=0A=0D=0AREINDEX MINIMALLY LOGGED - DOES NOT WORK - Hi=0D=0A =0D=0A=0D=0A=
 =0D=0AI am using a job to rebuild indexes. Step one I put the database=
 in Bulk Load. Step 2 I...=0D=0A(http://www.sqlservercentral.com/Forums/FindPost906578.aspx)=
=0D=0A=0D=0ACOLLATION SETTINGS FOR REPORTSERVER DATABASE - Hi,=0D=0A =0D=0A=
=0D=0A =0D=0AWhat are the collation settings for ReportServer & ReportServerTempDb?=
=0D=0A =0D=0A=0D=0A =0D=0AI know that the Reporting Services Configuration=
 Manager sets the collation settings as...=0D=0A(http://www.sqlservercentral.com/Forums/FindPost906399.aspx)=
=0D=0A=0D=0ADELETING BACKUP FILES USING A SCRIPT. - Hi =0D=0A =0D=0AAny=
 one with a script that can delete backups.bk files that are older than=
 3days, pls help.=0D=0A(http://www.sqlservercentral.com/Forums/FindPost902969.aspx)=
=0D=0A=0D=0AMORE THAN 250 INDEXES ON A TABLE - For a customer i have to=
 investigate a table wich has more than 250 indexes on it. The company who...=
=0D=0A(http://www.sqlservercentral.com/Forums/FindPost897494.aspx)=0D=0A=
=0D=0AROW LEVEL VERSIONING - Hey,=0D=0A =0D=0A=0D=0A =0D=0AWe're using SQL=
 Server 2005 in our company and we have an application that may benefit=
 by using the row...=0D=0A(http://www.sqlservercentral.com/Forums/FindPost897023.aspx)=
=0D=0A=0D=0ABLOCKING WHILE RUNNING REPORTS - Hi,=0D=0A =0D=0A=0D=0A =0D=0AWe=
 have SQL Server 2005 Reporting service on Server A & it's databases ReportServer=
 & ReportServerTemDB are on Server B. From the...=0D=0A(http://www.sqlservercentral.com/Forums/FindPost887114.aspx)=
=0D=0A=0D=0ABEST WAY TO CREATE A WEEKLY EMAIL REPORT FOR SQL SERVER - Hi,=
=0D=0A =0D=0A=0D=0A =0D=0AI have been asked to create a automated "report"=
 of some sort to provide some kind of statistics on our...=0D=0A(http://www.sqlservercentral.com/Forums/FindPost883102.aspx)=
=0D=0A=0D=0AJOB ENABLED AND SCHEDULE ENABLED CONFUSION - Hello,=0D=0A =0D=0A=
=0D=0A =0D=0AI can't seem to reconcile this and can't find a clear explanation=
 on it.=0D=0A =0D=0A=0D=0A =0D=0AI have a Job set up with...=0D=0A(http://www.sqlservercentral.com/Forums/FindPost650924.aspx)=
=0D=0A=0D=0ASYSTEM DATABASES ON AN ISCSI LUN - Hi All,=0D=0A =0D=0A=0D=0A=
 =0D=0AI am preparing to build a new SQL Server 2008 Enterprise server.=
 The machine is very well equipped (Windows...=0D=0A(http://www.sqlservercentral.com/Forums/FindPost638606.aspx)=
=0D=0A=0D=0ASP_SEND_DBMAIL TO SMS ERROR - Hi,=0D=0A =0D=0A=0D=0A =0D=0AI=
 am trying to use sp_send_dbmail to both email and sms address. The email=
 works fine both in HTML and...=0D=0A(http://www.sqlservercentral.com/Forums/FindPost514505.aspx)=
=0D=0A=0D=0A=0D=0ABACKUPS (http://www.sqlservercentral.com/Forums/Forum357-1.aspx)=
=0D=0A----------------------------------------------------------------=0D=0A=
=0D=0ABACKUP T-SQL -- RETURN VARIABLES - I'm trying to do a backup in an=
 SP.  Is there any way to get the data outputed by a...=0D=0A(http://www.sqlservercentral.com/Forums/FindPost907938.aspx)=
=0D=0A=0D=0ADIFFERENTIAL BACKUP OF DATABASE - Dear all,=0D=0A =0D=0AI have=
 a database of 1 TB size. I planned to take full backup on sunday and differential=
 backup...=0D=0A(http://www.sqlservercentral.com/Forums/FindPost907660.aspx)=
=0D=0A=0D=0A=0D=0ABUSINESS INTELLIGENCE (http://www.sqlservercentral.com/Forums/Forum147-1.aspx)=
=0D=0A------------------------------------------------------------------------------=
=0D=0A=0D=0ACALCULATED MEASURES IN CUBE GIVING VERY POOR PERFORMANCE - I=
 have an SSAS 2005 OLAP cube with 4 dimensions (Including servertime) and=
 5 measure groups along with 8 calculated...=0D=0A(http://www.sqlservercentral.com/Forums/FindPost885757.aspx)=
=0D=0A=0D=0AERROR -1056899072 : THE FOLLOWING SYSTEM ERROR OCCURRED:  KEY=
 NOT VALID FOR USE IN SPECIFIED STATE. . WHILE DEPLOYING SAMPLE PROJECT=
 OF SSAS CUBES. - Error -1056899072 : The following system error occurred:=
  Key not valid for use in specified state. .=0D=0A =0D=0AI am using Visual=
 Studio...=0D=0A(http://www.sqlservercentral.com/Forums/FindPost881874.aspx)=
=0D=0A=0D=0A=0D=0ACLR INTEGRATION AND PROGRAMMING. (http://www.sqlservercentral.com/Forums/Forum386-1.aspx)=
=0D=0A-----------------------------------------------------------------------------------------=
=0D=0A=0D=0ACENTRALLY LOCATED STORED PROCS? - For instance, say i have ten=
 databases all of which contain a copy of the same procedure.  is it possible...=
=0D=0A(http://www.sqlservercentral.com/Forums/FindPost907137.aspx)=0D=0A=
=0D=0A=0D=0ADEVELOPMENT (http://www.sqlservercentral.com/Forums/Forum145-1.aspx)=
=0D=0A--------------------------------------------------------------------=
=0D=0A=0D=0AKEYWORD BETWEEN - I need a sql  as "select * from mytable rownum=
 &gt;=3D10 and rownum &lt;=3D 20;=0D=0A =0D=0ADoes ms sql support above=
 sql, if...=0D=0A(http://www.sqlservercentral.com/Forums/FindPost908034.aspx)=
=0D=0A=0D=0ACRITERIA TABLE - Hi All,=0D=0A =0D=0A=0D=0A =0D=0AI'm kind of=
 newbie, I have time registered here, but this is my first post. After searching=
 through the...=0D=0A(http://www.sqlservercentral.com/Forums/FindPost907378.aspx)=
=0D=0A=0D=0AFULLTEXT SEARCH SLOW SQL SERVER 2005 - Hi,=0D=0A =0D=0A=0D=0A=
 =0D=0AWe had a table presently around 12000 rows.It has got upto 10 indexes.It=
 also had a fulltext index on a...=0D=0A(http://www.sqlservercentral.com/Forums/FindPost906453.aspx)=
=0D=0A=0D=0AEXECUTE A STORED PROCEDURE INSIDE A USER DEFINED FUNCTION -=
 Hello,=0D=0A =0D=0AI need to execute a stored procedure inside a function.=
 Can=C2=A0it be possible?=0D=0A =0D=0A=0D=0A =0D=0AThanks...=0D=0A =0D=0AMCVilbar=
=0D=0A =0D=0A=0D=0A(http://www.sqlservercentral.com/Forums/FindPost308097.aspx)=
=0D=0A=0D=0A=0D=0ASQL SERVER 2005 COMPACT EDITION (http://www.sqlservercentral.com/Forums/Forum323-1.aspx)=
=0D=0A----------------------------------------------------------------------------------------=
=0D=0A=0D=0AADD A COLUMN TO TABLE - I want to add a column to a table in=
 My SQL CE database by using the following command:=0D=0A =0D=0A=0D=0A =
=0D=0AALTER TABLE...=0D=0A(http://www.sqlservercentral.com/Forums/FindPost894468.aspx)=
=0D=0A=0D=0A=0D=0ASQL SERVER 2005 GENERAL DISCUSSION (http://www.sqlservercentral.com/Forums/Forum149-1.aspx)=
=0D=0A-------------------------------------------------------------------------------------------=
=0D=0A=0D=0AHOW DO YOU HIDE THE SQLAGENT90.EXE COMMAND WINDOW? - After some=
 recent maintenance, our SQL Server machine began to create/display a blank=
 command window for the SQLAGENT90.exe=0D=0A =0D=0A=0D=0A =0D=0ASomething=
 had been...=0D=0A(http://www.sqlservercentral.com/Forums/FindPost907980.aspx)=
=0D=0A=0D=0APROCEDURE HAS TOO MANY ARGUMENTS - Posted - 04/20/2010 :  09:17:52=
             =0D=0A =0D=0A--------------------------------------------------------------------------------=
=0D=0A =0D=0A =0D=0A =0D=0AHi All,=0D=0A =0D=0A=0D=0A =0D=0AI have a SP=
 that has nearly 27 parameters. No compilation error is shown but when...=
=0D=0A(http://www.sqlservercentral.com/Forums/FindPost906819.aspx)=0D=0A=
=0D=0AHOW TO TUNE/SPEED UP A PROCEDURE - I have a stored procedure where=
 I am converting old mainframe data that is in a staging table, and converting...=
=0D=0A(http://www.sqlservercentral.com/Forums/FindPost903150.aspx)=0D=0A=
=0D=0ASSMS - ALWAYS OPEN FILE WITH NEW CONNECTION - After i run a query=
 in server A, database X, then open a .sql file, two things may happen:=
=0D=0A =0D=0A=0D=0A =0D=0A1 - the...=0D=0A(http://www.sqlservercentral.com/Forums/FindPost901670.aspx)=
=0D=0A=0D=0A=0D=0ASQL SERVER 2005 SECURITY (http://www.sqlservercentral.com/Forums/Forum359-1.aspx)=
=0D=0A---------------------------------------------------------------------------------=
=0D=0A=0D=0AHIDING PAYROLL DATA FROM ADMIN - we have a new payroll system=
 coming online using SQL 2005 and questions have come up regarding security,=
 specifically securing...=0D=0A(http://www.sqlservercentral.com/Forums/FindPost907708.aspx)=
=0D=0A=0D=0A=0D=0ASQL SERVER 2005 STRATEGIES (http://www.sqlservercentral.com/Forums/Forum361-1.aspx)=
=0D=0A-----------------------------------------------------------------------------------=
=0D=0A=0D=0AFASCINATING CHALLENGE: CREATING A CENTRALIZED PK GENERATOR TO=
 SUPPORT CROSS-COLO ETL FOR A GLOBAL SAAS PRODUCT - First some brief background.=
 We have a global SaaS solution for the insurance industry. Our product=
 has a dynamic UI...=0D=0A(http://www.sqlservercentral.com/Forums/FindPost906741.aspx)=
=0D=0A=0D=0AHOW TO DO THIS ?? CSV OHLC DATA STORAGE - Ok..to give you an=
 idea.=0D=0A =0D=0A=0D=0A =0D=0ACopy this URL into browser address bar:=
=0D=0A =0D=0Ahttp://ichart.finance.yahoo.com/table.csv?s=3D^DJI&a=3D01&b=3D01&c=3D1900&d=3Dignore&e=3D&ignore&f=3Dignore&g=3Dd&ignore=3D.csv=
=0D=0A =0D=0A=0D=0A =0D=0AThe result is a CSV file with: Date, O,H,L,C,V,AdjC=
 with...=0D=0A(http://www.sqlservercentral.com/Forums/FindPost906417.aspx)=
=0D=0A=0D=0A=0D=0ASS2K5 REPLICATION (http://www.sqlservercentral.com/Forums/Forum291-1.aspx)=
=0D=0A--------------------------------------------------------------------------=
=0D=0A=0D=0AERROR CREATING TRANSACTIONAL REPLICATION OR ENABLING REPLICATION=
 ON DB - I an trying to enable transactional replication on some of my databases.=
  I try to create the publication and get...=0D=0A(http://www.sqlservercentral.com/Forums/FindPost907935.aspx)=
=0D=0A=0D=0ASYSTEM TABLE WHICH HOLDS THE SUBSCRIBER SERVER NAME - Hi All,=
=0D=0A =0D=0A=0D=0A =0D=0AIm trying to build a query which will give me=
 a snapshot of our replicated environment showing things such...=0D=0A(http://www.sqlservercentral.com/Forums/FindPost907891.aspx)=
=0D=0A=0D=0A=0D=0ASQL SERVER EXPRESS (http://www.sqlservercentral.com/Forums/Forum324-1.aspx)=
=0D=0A---------------------------------------------------------------------------=
=0D=0A=0D=0ACANNOT OPEN USER DEFAULT DATABASE - On SQL Management Studio=
 Express this error appears when i try to see the properties of a LOGIN=
=0D=0A =0D=0A=0D=0A =0D=0ATITLE: Microsoft SQL...=0D=0A(http://www.sqlservercentral.com/Forums/FindPost595705.aspx)=
=0D=0A=0D=0A=0D=0ASQL SERVER 2005 PERFORMANCE TUNING (http://www.sqlservercentral.com/Forums/Forum360-1.aspx)=
=0D=0A-------------------------------------------------------------------------------------------=
=0D=0A=0D=0AEFFICIENT WAY TO FETCH DATA THROUGH JOB - Hi=0D=0A =0D=0A=0D=0A=
 =0D=0AI'm using sql server 2000. I've to write a job which fetches around=
 10 lakhs records from a table and...=0D=0A(http://www.sqlservercentral.com/Forums/FindPost906734.aspx)=
=0D=0A=0D=0AGENERAL POINTERS ON READING WAIT STATISTICS - Hello,=0D=0A =
=0D=0A=0D=0A =0D=0AI know it's not easy to answer questions about performance=
 tuning given the variations and unique circumstances across SQL systems,...=
=0D=0A(http://www.sqlservercentral.com/Forums/FindPost906381.aspx)=0D=0A=
=0D=0A=0D=0ASQL SERVER 2005 INTEGRATION SERVICES (http://www.sqlservercentral.com/Forums/Forum148-1.aspx)=
=0D=0A---------------------------------------------------------------------------------------------=
=0D=0A=0D=0ASSIS QUESTION - I have OrderSent column(timestamp datatype)=
 in AS400 file with the below values:=0D=0A =0D=0A2009-03-11-13.07.24.922000=
=0D=0A =0D=0A2009-02-18-13.07.24.924000=0D=0A =0D=0A=0D=0A =0D=0AWhen I=
 am trying to load this AS400 column...=0D=0A(http://www.sqlservercentral.com/Forums/FindPost908140.aspx)=
=0D=0A=0D=0ASEND MAIL TASK FAILING USING A HOTMAIL ACCOUNT - When I execute=
 the following code SSMS, the e-mail is sent:=0D=0A =0D=0A=0D=0A =0D=0AUSE=
 msdb=0D=0A =0D=0AGO=0D=0A =0D=0AEXEC sp_send_dbmail @profile_name=3D'Hotmail',=
=0D=0A =0D=0A@recipients=3D'myusername@hotmail.com',=0D=0A =0D=0A@subject=3D'Test=
 message',=0D=0A =0D=0A@body=3D'This is the body of the...=0D=0A(http://www.sqlservercentral.com/Forums/FindPost908060.aspx)=
=0D=0A=0D=0ASTRING RESULT SET - I am using SQL Server 2005 SP3 on Windows=
 Server 2003.  =0D=0A =0D=0A=0D=0A =0D=0AI have an ExecuteSQL task with=
 the following SQL...=0D=0A(http://www.sqlservercentral.com/Forums/FindPost908044.aspx)=
=0D=0A=0D=0AKONESANS CHECKSUM 2008 ISSUE - Hi,=0D=0A =0D=0A=0D=0A =0D=0AI=
 installed Konesans checksum 2008 component on SQL Server 2005 box. It installed=
 successfully but I am not seeing the...=0D=0A(http://www.sqlservercentral.com/Forums/FindPost907330.aspx)=
=0D=0A=0D=0ASELECTIVE DELTA REFRESH - Hi, we have a set of packages which=
 involve pulling data from a source table and performin a delta refresh...=
=0D=0A(http://www.sqlservercentral.com/Forums/FindPost907240.aspx)=0D=0A=
=0D=0AEXECUTE TASKS CONDITIONALLY? - Is there a function, method, or technique=
 that someone could share with me?=0D=0A =0D=0A=0D=0A =0D=0AI have a large=
 dataflow that services records...=0D=0A(http://www.sqlservercentral.com/Forums/FindPost906676.aspx)=
=0D=0A=0D=0AWMI EVENT WATCHER TASK - I am using the WMI Event Watcher Task=
 to watch for the arrival of a file.  =0DI have the following...=0D=0A(http://www.sqlservercentral.com/Forums/FindPost741292.aspx)=
=0D=0A=0D=0ASSIS AND SSRS INTERVIEW QUESTIONS -  can any one tell some interview=
 questions in reporting service and integration service=0Don sql server=
 2005=0D=0D please this is urgent...=0D=0A(http://www.sqlservercentral.com/Forums/FindPost394152.aspx)=
=0D=0A=0D=0A=0D=0AT-SQL (SS2K5) (http://www.sqlservercentral.com/Forums/Forum338-1.aspx)=
=0D=0A----------------------------------------------------------------------=
=0D=0A=0D=0AT-SQL T EXPORT TABLE TO ACCESS - How do I use T-SQL to export=
 a table of my choosing to a pre-defined access database.  I want to...=
=0D=0A(http://www.sqlservercentral.com/Forums/FindPost907022.aspx)=0D=0A=
=0D=0ASUBSTRING FUNCTION IN WHERE CLAUSE - I am currently doing string manipulations=
 with T-sql. In the where statement of my code I have the following substring...=
=0D=0A(http://www.sqlservercentral.com/Forums/FindPost907003.aspx)=0D=0A=
=0D=0ACONVERTING A DATE - I'm having an issue with trying to have a query=
 run for todays date. I'm not sure how to have...=0D=0A(http://www.sqlservercentral.com/Forums/FindPost903762.aspx)=
=0D=0A=0D=0A=0D=0ASQL SERVER NEWBIES (http://www.sqlservercentral.com/Forums/Forum1291-1.aspx)=
=0D=0A----------------------------------------------------------------------------=
=0D=0A=0D=0ASSRS 2008 - I did go through few articles for these questions=
 but thought i could find a better one here..=0D=0A =0D=0A=0D=0A =0D=0A1.Can=
 anyone tell...=0D=0A(http://www.sqlservercentral.com/Forums/FindPost907805.aspx)=
=0D=0A=0D=0AREMOVE DUPLICATE RECORDS, BUT KEEP MOST "CURRENT" - I am working=
 on a database where we are storing data on multiple servers (SQL 2005),=
 I am importing the...=0D=0A(http://www.sqlservercentral.com/Forums/FindPost904866.aspx)=
=0D=0A=0D=0A'-' IN SQL SERVER - Hi! =0D=0A =0D=0A=0D=0A =0D=0Athere=C2=B4s=
 a sql server named 'srv-dev'.=0D=0A =0D=0AI=C2=B4ve to update certain tables=
 in 'srv-dev' from my server but sql says that...=0D=0A(http://www.sqlservercentral.com/Forums/FindPost903644.aspx)=
=0D=0A=0D=0A=0D=0AADMINISTRATION (http://www.sqlservercentral.com/Forums/Forum5-1.aspx)=
=0D=0A---------------------------------------------------------------------=
=0D=0A=0D=0AMASS CHANING DTS PASSWORD - Dear all,=0D=0A =0D=0A=0D=0A =0D=0AI=
 am ask by the management to change all password in our system regularly,=
 this includes DTS password, =0D=0A =0D=0ADo...=0D=0A(http://www.sqlservercentral.com/Forums/FindPost636045.aspx)=
=0D=0A=0D=0A=0D=0AGENERAL (http://www.sqlservercentral.com/Forums/Forum9-1.aspx)=
=0D=0A--------------------------------------------------------------=0D=0A=
=0D=0ASQL SERVER 2005 INSTALLATION - Hi, guys how are you doing?=0D=0A =
=0D=0A=0D=0A =0D=0A  i have windows server 2003 and recently, i installed=
 SQL server 2000 in drive...=0D=0A(http://www.sqlservercentral.com/Forums/FindPost905431.aspx)=
=0D=0A=0D=0ASTORED PROCEDURE ORGANIZATION - =0D=0A =0D=0AI currently have=
 a somewhat large web application.=C2=A0 For some of the code I use Inline=
 SQL code, not Stored...=0D=0A(http://www.sqlservercentral.com/Forums/FindPost289727.aspx)=
=0D=0A=0D=0A=0D=0ASQL SERVER NEWBIES (http://www.sqlservercentral.com/Forums/Forum169-1.aspx)=
=0D=0A---------------------------------------------------------------------------=
=0D=0A=0D=0ALOGSHIPPING - Hi,=0D=0A =0D=0A=0D=0A =0D=0AThis question is=
 actually not realted to sql server, but I am not able to get the answer=
 from anywhere...=0D=0A(http://www.sqlservercentral.com/Forums/FindPost906582.aspx)=
=0D=0A=0D=0ACONCATENATE ROWS (SQL SERVER 2000) - Hi all, I have the following=
 problem when using sql server 2000=0D=0A =0D=0A=0D=0A =0D=0AThe following=
 table has around 200 records.=0D=0A =0D=0A=0D=0A =0D=0ACompany / Employee=
=0D=0A =0D=0A1005 / A=0D=0A =0D=0A1005...=0D=0A(http://www.sqlservercentral.com/Forums/FindPost862480.aspx)=
=0D=0A=0D=0ASTORED PROCEDURE - UPDATE TABLES IN 2 DATABASES - I have to=
 update 2 databases at once from a stored procedure. How can this be done?=
 This is what...=0D=0A(http://www.sqlservercentral.com/Forums/FindPost856486.aspx)=
=0D=0A=0D=0A=0D=0AT-SQL (http://www.sqlservercentral.com/Forums/Forum8-1.aspx)=
=0D=0A------------------------------------------------------------=0D=0A=
=0D=0AERROR WHEN CONCATENATING WITH A CASE STATEMENT - Select DISTINCT ACCT.ACCTNBR||','||=
=0D=0A =0D=0ACASE PERSPERSTYP.PERSTYPCD when 'EMP' then 'EMP' else null=
 end as type||','|| PERSPHONE.AREACD||PERSPHONE.EXCHANGE||PERSPHONE.PHONENBR=
 as CELLPHONE =0D=0A =0D=0AFROM ACCT,PERSPERSTYP,PERSPHONE WHERE (UPPER(PERSPERSTYP.PERSTYPCD)...=
=0D=0A(http://www.sqlservercentral.com/Forums/FindPost908160.aspx)=0D=0A=
=0D=0AACCESSING DEFAULT INSTANCE OF SQL SERVER 2000 ACROSS WAN - =0D=0A=
 =0D=0AWas wondering if someone could help me with the following query.Is=
 it possible to connect to a default instance of...=0D=0A(http://www.sqlservercentral.com/Forums/FindPost898556.aspx)=
=0D=0A=0D=0A=0D=0ASQL SERVER 2008 - GENERAL (http://www.sqlservercentral.com/Forums/Forum391-1.aspx)=
=0D=0A----------------------------------------------------------------------------------=
=0D=0A=0D=0AREAD RESOURCE MONITOR? - Hi,=0D=0A =0D=0A=0D=0A =0D=0AI want=
 to monitor my SQL server better. When running sp_who2, I see that RESOURCE=
 MONITOR is always running... does...=0D=0A(http://www.sqlservercentral.com/Forums/FindPost908105.aspx)=
=0D=0A=0D=0AMICROSOFT OLE DB PROVIDER FOR ODBC DRIVERS - Hi GURUs,=0D=0A=
 =0D=0A=0D=0A =0D=0AI have Notes database to be imported into SQL 2005,=
 I have the required driver set up and have...=0D=0A(http://www.sqlservercentral.com/Forums/FindPost907939.aspx)=
=0D=0A=0D=0AINSERTION PROBLEM - I am doing an insertion with a procedure.All=
 the tables inside procedure is heavilly weighted.=0D=0A =0D=0AProcedure=
 contains following process.=0D=0A =0D=0ATable A contains...=0D=0A(http://www.sqlservercentral.com/Forums/FindPost907599.aspx)=
=0D=0A=0D=0AINFORMIX LINKED SERVER PROBLEMS - I have been asked to set up=
 a few procs that will take data from our core data source in...=0D=0A(http://www.sqlservercentral.com/Forums/FindPost907592.aspx)=
=0D=0A=0D=0ATRIGGER FOR DELETE - MULTIPLE ROW VALUE - hi, i have a question,=
 how to read 'value from deleted' from multiple row in trigger for delete?=
=0D=0A =0D=0A=0D=0A =0D=0Aselect @id =3D id...=0D=0A(http://www.sqlservercentral.com/Forums/FindPost907519.aspx)=
=0D=0A=0D=0ADID THE WAY SQL SERVER 2008 EVALUATES A CASE WHEN CONDITION=
 WHEN USED IN A FILTER? - I am looking at a weird issue since morning. Below=
 query works fine in SQL Server 2005 but throws a...=0D=0A(http://www.sqlservercentral.com/Forums/FindPost907495.aspx)=
=0D=0A=0D=0AMERGE & TRANSACTIONAL PUBLICATIONS ON THE SAME DB - Hello,=0D=0A=
 =0D=0A=0D=0A =0D=0AI've setup a Merge Publication and Subscriber between=
 Server A (Publisher) and Server B (Subscriber) that works perfectly.  But=
 now...=0D=0A(http://www.sqlservercentral.com/Forums/FindPost904620.aspx)=
=0D=0A=0D=0ADETECT IF AN INSTANCE OF SQL SERVER HAS BEEN UPGRADED - I would=
 like to know a reliable way of detecting if a particular instance of SQL=
 Server has been upgraded...=0D=0A(http://www.sqlservercentral.com/Forums/FindPost901213.aspx)=
=0D=0A=0D=0AVISUAL STUDIO VERSION? - I see there's a download to "upgrade"=
 Visual Studio 2005 to use with Katmai, but it doesn't allow you to...=0D=0A(http://www.sqlservercentral.com/Forums/FindPost431251.aspx)=
=0D=0A=0D=0A=0D=0AT-SQL (SS2K8) (http://www.sqlservercentral.com/Forums/Forum392-1.aspx)=
=0D=0A----------------------------------------------------------------------=
=0D=0A=0D=0AALTER TABLE ON-THE-FLY - Hi=0D=0A =0D=0A=0D=0A =0D=0AI need=
 to automate the table update process where a table is imported from a production=
 snapshot at the end...=0D=0A(http://www.sqlservercentral.com/Forums/FindPost907641.aspx)=
=0D=0A=0D=0A=0D=0AWORKING WITH ORACLE (http://www.sqlservercentral.com/Forums/Forum1044-1.aspx)=
=0D=0A-----------------------------------------------------------------------------=
=0D=0A=0D=0ACONNECTING TO ORACLE ON 64-BIT MACHING USING SSIS - Hello All,=
=0D=0A =0D=0A=0D=0A =0D=0AI have problem connecting to Oracle server using=
 SSIS. I'm using Microsoft OLE DB Provider for OLE DB Source...=0D=0A(http://www.sqlservercentral.com/Forums/FindPost906086.aspx)=
=0D=0A=0D=0A=0D=0ASQL SERVER NEWBIES (http://www.sqlservercentral.com/Forums/Forum1292-1.aspx)=
=0D=0A----------------------------------------------------------------------------=
=0D=0A=0D=0AADVANTAGE OF USING CONSTRAINT WHEN ADDING FK OR PK - Hi All,=
 =0D=0A =0D=0A=0D=0A =0D=0AI've been reading some sql tutorials and doing=
 some exercise and found that a Primary Key can be...=0D=0A(http://www.sqlservercentral.com/Forums/FindPost908233.aspx)=
=0D=0A=0D=0ASQL SYNTAX - Hi All,=0D=0A =0D=0A=0D=0A =0D=0AI'm looking for=
 the correct syntax to find my workorder number within my serial number=
 which starts at the...=0D=0A(http://www.sqlservercentral.com/Forums/FindPost907871.aspx)=
=0D=0A=0D=0AA DBA'S DAILY ROUTINE (AND OTHER ITEMS...) - Greetings all!!=
=0D=0A =0D=0A=0D=0A =0D=0AI hope to find an answer to my question(s) here.=
  If not, I will continue my quest.=0D=0A =0D=0A=0D=0A =0D=0ADue to a...=
=0D=0A(http://www.sqlservercentral.com/Forums/FindPost907832.aspx)=0D=0A=
=0D=0A[SQSRVRES] CHECKQUERYPROCESSORALIVE: SQLEXECDIRECT FAILED - Currently,=
 we only have 1 Cluster (SQLCLU1).  This weekend I was going to add a failover=
 node; SQLCLU2.  So as...=0D=0A(http://www.sqlservercentral.com/Forums/FindPost907820.aspx)=
=0D=0A=0D=0ACOMBINE MULTIPLE ROWS INTO ONE DYNAMICALLY QUERY QUESTION -=
 Hi, I have the below table, and I need to combine them=0Dinto one records=
 dynamically (I'm not sure I'm clear...=0D=0A(http://www.sqlservercentral.com/Forums/FindPost781712.aspx)=
=0D=0A=0D=0A=0D=0ASQL SERVER 2008 HIGH AVAILABILITY (http://www.sqlservercentral.com/Forums/Forum1549-1.aspx)=
=0D=0A-------------------------------------------------------------------------------------------=
=0D=0A=0D=0AIS IT POSSIBLE?  MIRROR 2005 SE TO 2008 EE - Is it possible=
 to mirror a database from SQL Server 2005 Standard Edition to SQL Server=
 2008 Enterprise Edition?  I...=0D=0A(http://www.sqlservercentral.com/Forums/FindPost904360.aspx)=
=0D=0A=0D=0AMIRROR VS. CLUSTER - WHICH SHOULD WE DO? - We have about 130=
 databases for clients and are looking for high avail.=0D=0A =0D=0A=0D=0A=
 =0D=0AIn the next year we expect to double...=0D=0A(http://www.sqlservercentral.com/Forums/FindPost900833.aspx)=
=0D=0A=0D=0AH A ADVICE - Good day forumites,=0D=0A =0D=0AI am looking into=
 implementing a H A solution for my company. Its in the transition of being...=
=0D=0A(http://www.sqlservercentral.com/Forums/FindPost897753.aspx)=0D=0A=
=0D=0A=0D=0ASQL SERVER 2008 ADMINISTRATION (http://www.sqlservercentral.com/Forums/Forum1550-1.aspx)=
=0D=0A----------------------------------------------------------------------------------------=
=0D=0A=0D=0ALIMIT THE CPU USAGE OF SQL SERVER 20008 - Hi Team,=0D=0A =0D=0A=
=0D=0A =0D=0ALimit the CPU usage of sql server 2008, when we running the=
 sql jobs CPU performance using 90% at...=0D=0A(http://www.sqlservercentral.com/Forums/FindPost906655.aspx)=
=0D=0A=0D=0ATHE SPECIFIED NETWORK PASSWORD IS INCORRECT - Hi All,=0D=0A=
 =0D=0A=0D=0A =0D=0AI m facing an issue with starting SQL Service with a=
 particular domain A/c for the past two days....=0D=0A(http://www.sqlservercentral.com/Forums/FindPost906066.aspx)=
=0D=0A=0D=0A=0D=0ACERTIFICATION (http://www.sqlservercentral.com/Forums/Forum10-1.aspx)=
=0D=0A---------------------------------------------------------------------=
=0D=0A=0D=0AMCJ - THE MISSING LINK - If you haven't seen it yet, there is=
 a pretty good discussion on the Missing Certification based on an Editorial...=
=0D=0A(http://www.sqlservercentral.com/Forums/FindPost897076.aspx)=0D=0A=
=0D=0A=0D=0AEMPLOYERS AND EMPLOYEES (http://www.sqlservercentral.com/Forums/Forum334-1.aspx)=
=0D=0A--------------------------------------------------------------------------------=
=0D=0A=0D=0ASQL PREMIER FIELD ENGINEER. SOME QUESTIONS ON THIS ROLE... -=
 There is a role in my location for a Sql server premier field engineer.=
 Currently i am in application support,...=0D=0A(http://www.sqlservercentral.com/Forums/FindPost838012.aspx)=
=0D=0A=0D=0A=0D=0AGENERAL (http://www.sqlservercentral.com/Forums/Forum23-1.aspx)=
=0D=0A---------------------------------------------------------------=0D=0A=
=0D=0AGRABING PRINT STATEMENTS VIA ADO .NET WHEN NO EXCEPTION IS RAISED?=
 - Hi there,=0D=0A =0D=0A=0D=0A =0D=0AFor various reasons, I need to build=
 a small Query Analyser kind of tool in .Net and everything works...=0D=0A(http://www.sqlservercentral.com/Forums/FindPost908181.aspx)=
=0D=0A=0D=0ALOOKING FOR HELP TO MODIFY A QUERY INTO A STORED PROCEDURE.=
 - I am trying to convert this query into a stored proecedure. I need a=
 parameter for Name and a StartDate/EndDate....=0D=0A(http://www.sqlservercentral.com/Forums/FindPost907936.aspx)=
=0D=0A=0D=0A=0D=0AANYTHING THAT IS NOT ABOUT SQL! (http://www.sqlservercentral.com/Forums/Forum61-1.aspx)=
=0D=0A---------------------------------------------------------------------------------------=
=0D=0A=0D=0AWHAT DO YOU DO WHEN YOU DON'T GET PAID? - Long story short...=
 I've been involved on a project where I had to build a printing application=
 for a paint...=0D=0A(http://www.sqlservercentral.com/Forums/FindPost907985.aspx)=
=0D=0A=0D=0ATODAY'S RANDOM WORD! - HI =0D=0A =0D=0A=0D=0A =0D=0AWhen you=
 woke up today, or logged-onto Opera Forums, you may have had a dream, a=
 thought, a scene...=0D=0A(http://www.sqlservercentral.com/Forums/FindPost812849.aspx)=
=0D=0A=0D=0AARE THE POSTED QUESTIONS GETTING WORSE? - Is it me, or are the=
 posted questions getting worse these days?=0D=0A =0D=0A=0D=0A =0D=0AI just=
 read a post by someone apparently in...=0D=0A(http://www.sqlservercentral.com/Forums/FindPost604325.aspx)=
=0D=0A=0D=0A=0D=0AREPORTING SERVICES (http://www.sqlservercentral.com/Forums/Forum150-1.aspx)=
=0D=0A---------------------------------------------------------------------------=
=0D=0A=0D=0AWORKING WITH MULTIPLE DATASET WITHING A TABLE IN SSRS - Hi,=
=0D=0A =0D=0A=0D=0A =0D=0AI have a main dataset which displays invoice details.=
 I have another dataset which displays meter information for given invoice...=
=0D=0A(http://www.sqlservercentral.com/Forums/FindPost564445.aspx)=0D=0A=
=0D=0A=0D=0AREPORTING SERVICES 2005 DEVELOPMENT (http://www.sqlservercentral.com/Forums/Forum1063-1.aspx)=
=0D=0A---------------------------------------------------------------------------------------------=
=0D=0A=0D=0ASSRS TEXT BOX MAX LENGTH ISSUE - Hi everyone,=0D=0A =0D=0A=0D=0A=
 =0D=0AI have a comments fieldname with nvarchar(2000).=0D=0A =0D=0A=0D=0A=
 =0D=0AWhen pulled into a report, the text value is getting cut off.=0D=0A=
 =0D=0A=0D=0A =0D=0AIs there...=0D=0A(http://www.sqlservercentral.com/Forums/FindPost906939.aspx)=
=0D=0A=0D=0AREFER TO REPORT DATASETS FROM EMBEDDED CODE OR CUSTOM ASSEMBLY=
 (VB.NET) - Hi there,=0D=0A =0D=0A=0D=0A =0D=0AI am currently developing=
 a report which takes Sales Orders and assigns units from either stock or=
 already raised...=0D=0A(http://www.sqlservercentral.com/Forums/FindPost572495.aspx)=
=0D=0A=0D=0A=0D=0AANALYSIS SERVICES (http://www.sqlservercentral.com/Forums/Forum17-1.aspx)=
=0D=0A-------------------------------------------------------------------------=
=0D=0A=0D=0AGOOD MDX TUTORIAL ? - Hi, =0D=0A =0D=0ACould anybody recommend=
 good MDX tutorial ?=0D=0A =0D=0A=0D=0A =0D=0AThanks.=0D=0A =0D=0A=0D=0A(http://www.sqlservercentral.com/Forums/FindPost908212.aspx)=
=0D=0A=0D=0ASSAS DEPLOYMENT AND DISASTER RECOVERY - Hello,=0D=0A =0D=0AI'm=
 just getting into the BI side of SQL Server.  I've been asked to develop=
 some reports and since I'm...=0D=0A(http://www.sqlservercentral.com/Forums/FindPost906321.aspx)=
=0D=0A=0D=0APERIOD TO DATE - Hi, I am working with MDX, and I have the following=
 MDX-statement:=0D=0A =0D=0A=0D=0A =0D=0A[color=3D#0000ff]WITH Member [Measures].[SummarizedStock]=
 as=0D=0A =0D=0A	aggregate(PeriodsTODAte([Time dimension].[(All)]),[Measures].[Stock])=
=0D=0A =0D=0A=0D=0A =0D=0ASelect	{[Measures].[SummarizedStock], [Measures].[Stock]=
 } on columns,=0D=0A =0D=0A		nonempty([Time Dimension].[Month].members)...=
=0D=0A(http://www.sqlservercentral.com/Forums/FindPost902272.aspx)=0D=0A=
=0D=0ACALCULATED MEASURE RESULT IS BASED IN DIMENSION PICKED - Dear All,=
=0D=0A =0D=0A=0D=0A =0D=0AI have the following Case ... In the Fact:=0D=0A=
 =0D=0A=0D=0A =0D=0APerson Name     Plan ID      Earned Days=0D=0A =0D=0AJohn=
 Smith       A              10=0D=0A =0D=0AJohn Smith       B          =
    10...=0D=0A(http://www.sqlservercentral.com/Forums/FindPost899336.aspx)=
=0D=0A=0D=0A=0D=0A----------------------------------------------------------------=
=0D=0ATo be removed from this list, please visit http://www.sqlservercentral.com/Unsubscribe?u=3DiiXqQhXy%2fO8gGcQpbbm%2bLA%3d%3d&n=3DNewsletterSubscriber=
=0D=0AIf you have any problems leaving the list, please contact webmaster@sqlservercentral.com.=
=0D=0AThis newsletter was sent to you because you signed up at SQLServerCentral.com.=
 Feel free to forward this to any colleagues that you think might be interested.=
 If you have received this email from a colleague, you can register to receive=
 it at http://www.sqlservercentral.com/links/288241/150901=0D=0AThis transmission=
 is (c) Copyright 2010 Red Gate Software Ltd. All rights reserved. Contact:=
 Webmaster@sqlservercentral.com
----boundary_436_fe62e6e5-0c7d-4ffa-b944-02d54c42764b
Content-Type: text/html; charset="utf-8"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">=
=0D=0A<html>=0D=0A  <head>=0D=0A    <META http-equiv=3D"Content-Type" content=3D"text/html;=
 charset=3Dutf-16">=0D=0A    <title>SQLServerCentral.com Community Update=
 for 2010-04-23</title>=0D=0A  </head>=0D=0A  <body bgcolor=3D"#dce9f0">=
=0D=0A    <style type=3D"text/css">=0D=0A    *{margin:0; padding:0;}=0D=0A=
    body {background:#dce9f0 url(http://www.sqlservercentral.com/Resources/Images/Newsletter/background.jpg)=
 left top repeat-x; margin:20px; }=0D=0A    body, td { font-family: Verdana;=
 line-height:16px; font-size: 12px; }=0D=0A    h1 { font-family:arial; float:left;=
 font-style:italic; font-size:12px; color:#002b7c; margin:52px 0 0 0	}=0D=0A=
    h2 { color:#FFF; padding:1px 5px 0px 10px; font-size:12px; }=0D=0A =
   h3 { color: #000000; font-weight: bold; font-size: 12px; margin:0}=0D=0A=
    h4 { color: #000000; font-weight: bold; font-size: 14px; margin:12px=
 0px 2px 0px; text-align:center; }=0D=0A    p { color: #1B1B1B; font-size:=
 12px; line-height:18px; margin:10px 0 0 0}=0D=0A    p.byLine { font-size:=
 11px; color: #56595C; margin:5px 0 0 0}=0D=0A    a:link, a:hover, a:active=
 { color: #003399;}=0D=0A    a:visited { text-decoration:none;color: #800080;}=
=0D=0A    #head td {vertical-align:bottom; padding:0 0 10px 0}=0D=0A   =
 .linkArrow {font-size:11px;}=0D=0A    .outerTable {background:white; width:100%;=
 margin:0 auto; text-align:center}=0D=0A    .innerTable {background:white;=
 width:100%;margin:0 auto;}=0D=0A    .topImgRow, .bottomImgRow {height:10px;}=
=0D=0A    .topImgRow .cnLeft {background:white url(http://www.sqlservercentral.com/Resources/Images/Newsletter/background_tl.jpg)=
 left top no-repeat;}=0D=0A    .topImgRow .cnRight {background:white url(http://www.sqlservercentral.com/Resources/Images/Newsletter/background_tr.jpg)=
 right top no-repeat;}=0D=0A    .bottomImgRow .cnLeft {background:white=
 url(http://www.sqlservercentral.com/Resources/Images/Newsletter/background_bl.jpg)=
 left bottom no-repeat;}=0D=0A    .bottomImgRow .cnRight {background:white=
 url(http://www.sqlservercentral.com/Resources/Images/Newsletter/background_br.jpg)=
 right bottom no-repeat;}=0D=0A    .cnLeft {text-align:left; width:10px;}=
=0D=0A    .cnRight {text-align:right; width:10px;}=0D=0A    .padding {padding:10px=
 20px 20px 20px}=0D=0A    .innerTable .h2Left {background:#11578b url(http://www.sqlservercentral.com/Resources/Images/Newsletter/background_h2.jpg)=
 top left no-repeat; height:30px;}=0D=0A    .innerTable .h2Right {background:#11578b=
 url(http://www.sqlservercentral.com/Resources/Images/Newsletter/background_h2.jpg)=
 top right no-repeat;width:4px; height:30px;}=0D=0A    .content, .sponsor=
 td { padding:15px; margin:0}=0D=0A    .sponsor {background:#edf4f7; margin:10px;}=
=0D=0A    hr { height:1px; width:100%; margin:0; padding:0}=0D=0A    ol,=
 ul {font-size: 11px; list-style-position: outside; margin-left: 25px; margin-top:=
 15px; margin-bottom: 15px;}=0D=0A    li {margin: 5px; line-height:150%;}=
=0D=0A    .footer {text-align:center;}=0D=0A    img.floatRight {float:right;}=
=0D=0A    img.floatLeft {float:left;}=0D=0A    img { border:none; }=0D=0A=
    img.ContentItemIcon { float:right }=0D=0A  </style>=0D=0A    <table=
 class=3D"outerTable" cellpadding=3D"0" cellspacing=3D"0" align=3D"center"=
 border=3D"0">=0D=0A      <tbody align=3D"left">=0D=0A        <tr class=3D"topImgRow">=
=0D=0A          <td class=3D"cnLeft"></td>=0D=0A          <td class=3D"cnRight"></td>=
=0D=0A        </tr>=0D=0A        <tr>=0D=0A          <td colspan=3D"2" class=3D"padding">=
=0D=0A            <table class=3D"innerTable" cellpadding=3D"0" cellspacing=3D"0"=
 border=3D"0">=0D=0A              <tr>=0D=0A                <td colspan=3D"2">=
=0D=0A                  <table id=3D"head" cellpadding=3D"0" cellspacing=3D"0"=
 border=3D"0" width=3D"100%">=0D=0A                    <tr>=0D=0A      =
                <td width=3D"154" style=3D"padding-bottom:1px; vertical-align:bottom"><a=
 href=3D'http://www.sqlservercentral.com/links/288241/150873' ><img alt=3D"SQL=
 Server Central - www.sqlservercentral.com" align=3D"bottom" border=3D"0"=
 src=3D"http://www.sqlservercentral.com/Resources/Images/Newsletter/sqlservercentral_logo.gif"></a></td>=
=0D=0A                      <td>=0D=0A                        <h1>A community=
 of more than 1,215,000 database professionals and growing</h1>=0D=0A  =
                    </td>=0D=0A                    </tr>=0D=0A         =
         </table>=0D=0A                </td>=0D=0A              </tr>=0D=0A=
              <tr class=3D"heading">=0D=0A                <td class=3D"h2Left"=
 valign=3D"middle" style=3D"color:#FFF" bgcolor=3D"#11578b">=0D=0A     =
             <h2>In this issue</h2>=0D=0A                </td>=0D=0A   =
             <td class=3D"h2Right"></td>=0D=0A              </tr>=0D=0A=
              <tr>=0D=0A                <td colspan=3D"2" class=3D"content"=
 style=3D"border:0px dotted red; padding-top:2px;">=0D=0A              =
    <table width=3D"100%" cellpadding=3D"0" cellspacing=3D"0" border=3D"0">=
=0D=0A                    <tr valign=3D"top">=0D=0A                    =
  <td style=3D"padding-top:12px;">=0D=0A                        <h3>Featured=
 Articles</h3>=0D=0A                        <p>=0D=0A                  =
        <ul>=0D=0A                            <li><a href=3D"#content69668">Row=
 Oriented Security Using Triggers</a></li>=0D=0A                       =
     <li><a href=3D"#content65804">Help, my database is corrupt. Now what?</a></li>=
=0D=0A                            <li><a href=3D"#content70066">Retrieve=
 Default SQL Server Backup Folder using PowerShell</a></li>=0D=0A      =
                    </ul>=0D=0A                        </p>=0D=0A      =
                  <h3>Editorial</h3>=0D=0A                        <p>=0D=0A=
                          <ul>=0D=0A                            <li><a href=3D"#content70101">Spring=
 Cleaning</a></li>=0D=0A                          </ul>=0D=0A          =
              </p>=0D=0A                        <h3>Featured Script</h3>=
=0D=0A                        <p>=0D=0A                          <ul>=0D=0A=
                            <li><a href=3D"#content70059">Copy Table Structure=
 Without Data Using 1 Line Query</a></li>=0D=0A                        =
  </ul>=0D=0A                        </p>=0D=0A                      </td>=
=0D=0A                      <td width=3D"10">=C2=A0</td>=0D=0A         =
             <td align=3D"right" width=3D"45%">=0D=0A                  =
      <table border=3D"0">=0D=0A                          <tr>=0D=0A   =
                         <td align=3D"center"><img align=3D"middle" src=3D"http://www.sqlservercentral.com/Resources/Images/downarrow.gif"><span=
 style=3D"letter-spacing: 3px; color:#555; font-size:10px;">=C2=A0advertisement</span></td>=
=0D=0A                          </tr>=0D=0A                          <tr>=
=0D=0A                            <td>=C2=A0</td>=0D=0A                =
          </tr>=0D=0A                          <tr>=0D=0A              =
              <td align=3D"left">=0D=0A=0D=0A<table border=3D"0" cellpadding=3D"0"=
 cellspacing=3D"10" width=3D"100%">=0D=0A	<colgroup>=0D=0A		<col width=3D"68"=
 />=0D=0A		<col width=3D"1266" />=0D=0A	</colgroup>=0D=0A	<tr align=3D"left"=
 valign=3D"top">=0D=0A		<td><a href=3D'http://www.sqlservercentral.com/links/288241/150874'=
 ><img alt=3D"SQL Backup" height=3D"68" src=3D"http://www.red-gate.com/images/sql_server_central/backup3d_68x68.gif"=
 width=3D"68" /></a></td>=0D=0A		<td><strong>Free trial of SQL Backup=E2=84=A2</strong><br=
 />&quot;SQL Backup was able to cut down my backup time significantly AND=
 achieved a 90% compression at the same time!&quot; Joe Cheng. <a href=3D'http://www.sqlservercentral.com/links/288241/150874'=
 >Download a free trial now.</a></td>=0D=0A	</tr>=0D=0A</table>=0D=0A</td>=
=0D=0A                          </tr>=0D=0A                          <tr>=
=0D=0A                            <td>=C2=A0</td>=0D=0A                =
          </tr>=0D=0A                          <tr>=0D=0A              =
              <td align=3D"left"><table border=3D"0" cellpadding=3D"0" cellspacing=3D"10"=
 width=3D"100%">=0D=0A <colgroup>=0D=0A  <col width=3D"68" />=0D=0A  <col=
 width=3D"1266" />=0D=0A </colgroup>=0D=0A <tr align=3D"left" valign=3D"top">=
=0D=0A  <td><a href=3D'http://www.sqlservercentral.com/links/288241/150875'=
 ><img alt=3D"SQL Compare" height=3D"68" src=3D"http://www.red-gate.com/images/marketing/SSC/CompareSplash-68x68.gif"=
 width=3D"68" /></a></td>=0D=0A  <td><strong>Free trial of the happiest=
 SQL tool in the business.<br> </strong>&quot;I downloaded the SQL tools=
 from Red Gate and the next 14 days were the best SQL days in my life.&quot;=
 Gu=C3=B0bjartur Haraldsson. <a href=3D'http://www.sqlservercentral.com/links/288241/150875'=
 >Download your own 14-days of SQL heaven today</a>.</td>=0D=0A </tr>=0D=0A</table></td>=
=0D=0A                          </tr>=0D=0A                        </table>=
=0D=0A                      </td>=0D=0A                    </tr>=0D=0A =
                 </table>=0D=0A                </td>=0D=0A             =
 </tr>=0D=0A              <tr class=3D"heading">=0D=0A                <td=
 class=3D"h2Left" valign=3D"middle" style=3D"color:#FFF" bgcolor=3D"#11578b">=
=0D=0A                  <h2>Featured Articles</h2>=0D=0A               =
 </td>=0D=0A                <td class=3D"h2Right"></td>=0D=0A          =
    </tr>=0D=0A              <tr>=0D=0A                <td class=3D"content"=
 colspan=3D"2"><a name=3D"content69668"></a><h3><a href=3D'http://www.sqlservercentral.com/links/288241/150876'=
 >Row Oriented Security Using Triggers</a></h3>=0D=0A                  <p=
 class=3D"byline">R Glen Cooper from <a href=3D'http://www.sqlservercentral.com/links/288241/150873'=
 >SQLServerCentral.com</a></p>=0D=0A                  <p>Handling security=
 in an application can be a bit cumbersome. R Glen Cooper brings us a database=
 design technique from the real world that can help you.=C2=A0<a href=3D'http://www.sqlservercentral.com/links/288241/150876'=
 >More</a><span class=3D"linkArrow"> &raquo;</span></p>=0D=0A          =
      </td>=0D=0A              </tr>=0D=0A              <tr class=3D"lineBreak">=
=0D=0A                <td colspan=3D"2">=0D=0A                  <hr>=0D=0A=
                </td>=0D=0A              </tr>=0D=0A              <tr>=0D=0A=
                <td class=3D"content" colspan=3D"2"><a name=3D"content65804"></a><h3><a=
 href=3D'http://www.sqlservercentral.com/links/288241/150877' >Help, my=
 database is corrupt. Now what?</a></h3>=0D=0A                  <p class=3D"byline">Gail=
 Shaw from <a href=3D'http://www.sqlservercentral.com/links/288241/150873'=
 >SQLServerCentral.com</a></p>=0D=0A                  <p>The stuff of nightmares,=
 a corrupt database. However Gail Shaw gives you some advice about how to=
 handle this situation.=C2=A0<a href=3D'http://www.sqlservercentral.com/links/288241/150877'=
 >More</a><span class=3D"linkArrow"> &raquo;</span></p>=0D=0A          =
      </td>=0D=0A              </tr>=0D=0A              <tr class=3D"lineBreak">=
=0D=0A                <td colspan=3D"2">=0D=0A                  <hr>=0D=0A=
                </td>=0D=0A              </tr>=0D=0A              <tr>=0D=0A=
                <td class=3D"content" colspan=3D"2"><a name=3D"content70066"></a><h3><a=
 href=3D'http://www.sqlservercentral.com/links/288241/150878' >Retrieve=
 Default SQL Server Backup Folder using PowerShell</a></h3>=0D=0A      =
            <p class=3D"byline">Additional Articles from <a href=3D'http://www.sqlservercentral.com/links/288241/150879'=
 >MSSQLTips.com</a></p>=0D=0A                  <p>In a previous tip on creating=
 a Function to Return Default SQL Server Backup Folder , you've seen how=
 you can create a T-SQL function to query the registry and retrieve the=
 default SQL Server Backup folder. Is there an easier way to do it in Windows=
 PowerShell? =C2=A0<a href=3D'http://www.sqlservercentral.com/links/288241/150878'=
 >More</a><span class=3D"linkArrow"> &raquo;</span></p>=0D=0A          =
      </td>=0D=0A              </tr>=0D=0A              <tr class=3D"lineBreak">=
=0D=0A                <td colspan=3D"2">=0D=0A                  <hr>=0D=0A=
                </td>=0D=0A              </tr>=0D=0A              <tr class=3D"heading">=
=0D=0A                <td class=3D"h2Left" valign=3D"middle" style=3D"color:#FFF"=
 bgcolor=3D"#11578b"><a name=3D"content70101"></a><h2>Editorial - Spring=
 Cleaning</h2>=0D=0A                </td>=0D=0A                <td class=3D"h2Right"></td>=
=0D=0A              </tr>=0D=0A              <tr>=0D=0A                <td=
 class=3D"content" colspan=3D"2"><p><img alt=3D"http://www.ic.nc.gov/ncic/pages/spring-cleaning.jpg"=
 border=3D"0"  height=3D"362" src=3D"http://www.sqlservercentral.com/Images/6128.jpg"=
 width=3D"344" />=0D=0A</p><P>=0D=0AI was reading <a href=3D'http://www.sqlservercentral.com/links/288241/150880'=
 > an article the other day on spring cleaning</a>, talking about all that=
 data that is out there in the world, on people's machines, and is taking=
 up space, with almost no chance of being used again. It's seems that storage=
 is constantly a battle for many people, trying to decide how much to keep,=
 how much to delete, and if the cost of storing something is worth it.</p>=
=0D=0A<p>This article is written for the end user, but it could be applied=
 to servers as well. Especially database servers where we are constantly=
 adding more data, and at increasing rates over time. For this Friday, I=
 wanted to ask a poll question related to managing your servers.</p>=0D=0A<h3>Do=
 you perform spring cleaning?</h3>=0D=0A<p>I'm wondering are there any types=
 of annual maintenance that you perform to manage space and storage, perhaps=
 archiving or removing old data, or even deleting data that might not be=
 needed.</p>=0D=0A<p>It's been years since I worked at a company where we=
 performed any kind of maintenance. In most of the systems I managed in=
 the last decade, the databases have been so small, and storage capacities=
 growing so fast, that we never deleted anything. In fact, we often captured=
 data that we knew we wouldn't use, but we didn't stop because we didn't=
 need to.</p>=0D=0A<p>I have tended to come down on the side of &quot;save=
 everything&quot; you can, but I realize that as your company grows, and=
 as users keep more and more data around, you can have serious scalability=
 issues with servers. Usually file servers or Exchange servers, but I can=
 certainly see database servers costing lots of money as we store more types=
 of data in there from various portals and applications.</p>=0D=0A<p>Let=
 us know this Friday if you perform maintenance, and if so, what kind.</p>=
=0D=0A<p class=3D"byline">Steve Jones from <a href=3D'http://www.sqlservercentral.com/links/288241/150873'=
 >SQLServerCentral.com</a></p>=0D=0A                  <p>&raquo; <a href=3D'http://www.sqlservercentral.com/links/288241/150881'=
 >Join the debate, and respond to today's editorial on the forums</a></p>=
=0D=0A	<hr />=0D=0A	<h3>The Voice of the DBA Podcasts</h3>=0D=0A	<p><img=
 alt=3D"Everyday Jones" align=3D"right" class=3D"floatRight" align=3D"right"=
 src=3D"http://www.sqlservercentral.com/Images/4309.jpg" width=3D"320" height=3D"240"=
 /></p>=0D=0A	<p>The podcast feeds are available at <a href=3D'http://www.sqlservercentral.com/links/288241/150882'=
 >sqlservercentral.mevio.com</a>. You can also follow <A href=3D"">Steve=
 Jones on Twitter</a>:<br />=0D=0A	<a href=3D'http://www.sqlservercentral.com/links/288241/150883'=
 >=0D=0A	<img src=3D"http://assets0.twitter.com/images/twitter_logo_125x29.png"=
 border=3D"0"></a>=0D=0A	<p>=0D=0A	Overall RSS Feed: <a href=3D'http://www.sqlservercentral.com/links/288241/150884'=
 >=0D=0A	<img src=3D"http://www.podshow.com/images/feed-icon/default/images/png/feed-icon-16x16.png"=
 border=3D"0"></a>=0D=0A	 or now on iTunes!=0D=0A	 <A href=3D'http://www.sqlservercentral.com/links/288241/150885'=
 >=0D=0A	 <img src=3D"http://www.mevio.com/images/icons/icon_itune.png"=
 border=3D"0"></a>=0D=0A	</p>=0D=0A	<ul>=0D=0A		<li><a href=3D'http://www.sqlservercentral.com/links/288241/150886'=
 >Windows Media Podcast</a> - 25.6MB WMV =0D=0A		  <a href=3D'http://www.sqlservercentral.com/links/288241/150887'=
 ><img src=3D"http://www.sqlservercentral.com/Resources/Images/feed.gif"=
 border=3D"0"></a>=0D=0A	   </li>=0D=0A		<li><a href=3D'http://www.sqlservercentral.com/links/288241/150888'=
 >iPod Video Podcast</a> - 18.0MB MP4=0D=0A			 <a href=3D'http://www.sqlservercentral.com/links/288241/150885'=
 ><img src=3D"http://www.sqlservercentral.com/Resources/Images/feed.gif"=
 border=3D"0"></a></li>=0D=0A	   </li>=0D=0A		<li><a href=3D'http://www.sqlservercentral.com/links/288241/150889'=
 >MP3 Audio Podcast</a> - 4.0MB MP3=0D=0A			 <a href=3D'http://www.sqlservercentral.com/links/288241/150890'=
 ><img src=3D"http://www.sqlservercentral.com/Resources/Images/feed.gif"=
 border=3D"0"></a></li>=0D=0A	   </li>=0D=0A	</ul>=0D=0A	<p>Today's podcast=
 features music by Everyday Jones. No relation, but I stumbled on to them=
 and really like the music. Support this great duo at <A href=3D'http://www.sqlservercentral.com/links/288241/150891'=
 >www.everydayjones.com</a>.</p>=0D=0A	<p>I really appreciate and value=
 feedback on the podcasts. Let us know what you like, don't like, or even=
 send in ideas for the show. If you'd like to comment, <a href=3D'http://www.sqlservercentral.com/links/288241/150892'=
 >post something here</a>. The boss will be sure to read it.</p>=0D=0A =
               </td>=0D=0A              </tr>=0D=0A              <tr class=3D"lineBreak">=
=0D=0A                <td colspan=3D"2">=0D=0A                  <hr>=0D=0A=
                </td>=0D=0A              </tr>=0D=0A              <tr class=3D"heading">=
=0D=0A                <td class=3D"h2Left" valign=3D"middle" style=3D"color:#FFF"=
 bgcolor=3D"#11578b">=0D=0A                  <h2>Question of the Day</h2>=
=0D=0A                </td>=0D=0A                <td class=3D"h2Right"></td>=
=0D=0A              </tr>=0D=0A              <tr>=0D=0A                <td=
 class=3D"content" colspan=3D"2">=0D=0A                  <p><b>Today's Question:</b></p>=
=0D=0A                  <p><!-- Generated by XStandard version 2.0.0.0 on=
 2010-02-28T17:09:21 -->=0D=0A=0D=0A<p>Many people think that defensive=
 programming is a very important technique, but few know whether it's a=
 recent development or an ancient one. In which year was a paper submitted=
 to the Royal Society of London (who subsequently published it) which contains=
 the following passage:</p>=0D=0A<p>&quot;The difficulty lies not in detecting=
 the presence of a mistake, but in diagnosing it. In practice its presence=
 is nearly always obvious, for the character of most programmes is such=
 that even a slight error will usually have an extensive effect. If its=
 presence is not immediately apparent, it will be detected by the arithmetic=
 checks which must be incorporated in every calculation.&quot;</p>=0D=0A<p=
 class=3D"byline">By Tom Thomson</p>=0D=0A                  </p>=0D=0A =
                 <p align=3D"center"><b>Think you know the answer? <a href=3D'http://www.sqlservercentral.com/links/288241/150893'=
 >Click here</a>, and find out if you are right.</b></p>=0D=0A         =
         <p>This question is worth 6 points in this category: <i>Trivia</i>.=
 We keep track of your score to give you bragging rights against your peers.</p>=
=0D=0A                  <p>We'd love to give you credit for your own question=
 and answer. To submit a QOD, simply log in to <a href=3D'http://www.sqlservercentral.com/links/288241/150894'=
 >Contribution Center</a>.</p>=0D=0A                </td>=0D=0A        =
      </tr>=0D=0A              <tr>=0D=0A                <td class=3D"content"=
 colspan=3D"2"><p>=0D=0A<a href=3D'http://www.sqlservercentral.com/links/288241/150895'=
 >=0D=0A<img src=3D"http://ecx.images-amazon.com/images/I/51tV8Yys4DL._SL500_AA240_.jpg"=
 width=3D"115" height=3D"115" align=3Dleft border=3D0></a>=0D=0A</p><p>=
=0D=0AHarness the power of SQL Server, Microsoft=E2=80=99s high-performance=
 database and data analysis software package, by accesing everything you=
 need to know in Microsoft SQL Server 2008 Bible. Learn the best practices,=
 tips, and tricks from this comprehensive tutorial and reference, which=
 includes specific examples and sample code, with nearly every task demonstrated=
 in both a graphical and SQL code method. Understand how to develop SQL=
 Server databases and data connections, how to administer the SQL Server=
 and keep databases performing optimally, and how to navigate all the new=
 features of the 2008 release. <a href=3D'http://www.sqlservercentral.com/links/288241/150895'=
 >Grab your copy today</a> from B&N!=0D=0A</p></td>=0D=0A              </tr>=
=0D=0A              <tr class=3D"lineBreak">=0D=0A                <td colspan=3D"2">=
=0D=0A                  <hr>=0D=0A                </td>=0D=0A          =
    </tr>=0D=0A              <tr class=3D"heading">=0D=0A              =
  <td class=3D"h2Left" valign=3D"middle" style=3D"color:#FFF" bgcolor=3D"#11578b">=
=0D=0A                  <h2>Yesterday's Question of the Day</h2>=0D=0A =
               </td>=0D=0A                <td class=3D"h2Right"></td>=0D=0A=
              </tr>=0D=0A              <tr>=0D=0A                <td class=3D"content"=
 colspan=3D"2">=0D=0A                  <p>=0D=0A<p>How many rows are returned=
 in the last select in SQL Server 2008?</p>=0D=0A<pre class=3D"brush: sql;">=
=0D=0Ause tempdb<br />go<br />create table a (b int)<br />go<br />insert=
 into a (b) values (1), (2), (3)=0D=0A=0D=0Aselect * from a=0D=0A=0D=0Abegin=
 tran<br />truncate table a=0D=0A=0D=0Aselect * from a=0D=0A=0D=0Arollback=
 tran=0D=0A=0D=0Aselect * from a=0D=0A=0D=0Adrop table a=0D=0A</pre>=0D=0A<p=
 class=3D"byline">By Ninja's_RGR'us</p>=0D=0A                  </p>=0D=0A=
                  <p><b>Answer: </b>3</p>=0D=0A                  <p><b>Explanation:=
 </b>The truncate can be rolled back, so the removal of the rows is undone=
 by the rollback. Compared to the DELETE statement, TRUNCATE TABLE has the=
 following advantages:=0D=0A<ul>=0D=0A  <li>Less transaction log space is=
 used.</li>=0D=0A  <li>The DELETE statement removes rows one at a time and=
 records an entry in the transaction log for each deleted row. TRUNCATE=
 TABLE removes the data by deallocating the data pages used to store the=
 table data and records only the page deallocations in the transaction log.=
 </li>=0D=0A  <li>Since the operation is logged, it can be undone.</li>=
=0D=0A</ul>=0D=0A</p><p>=0D=0ARef: TRUNCATE TABLE - <A href=3D'http://www.sqlservercentral.com/links/288241/150896'=
 >http://msdn.microsoft.com/en-us/library/ms177570.aspx</a></p>=0D=0A  =
                <p>&raquo; <a href=3D'http://www.sqlservercentral.com/links/288241/150897'=
 >Discuss this question and answer on the forums</a></p>=0D=0A         =
       </td>=0D=0A              </tr>=0D=0A              <tr>=0D=0A    =
            <td class=3D"content" colspan=3D"2"><p>=0D=0A<a href=3D'http://www.sqlservercentral.com/links/288241/150898'=
 >=0D=0A<img src=3D"http://ecx.images-amazon.com/images/I/41X8I36rgyL._BO2,204,203,200_PIsitb-sticker-arrow-click,TopRight,35,-76_AA240_SH20_OU01_.jpg"=
 width=3D"115" height=3D"115" align=3Dleft border=3D0></a>=0D=0A</p><p>=
=0D=0AStarting simply and gradually progressing to increasingly advanced=
 topics, this introduction to the SQL Server database focuses on what is=
 distinctive about the SQL environment=E2=80=94SQL Server 2008, in particular=E2=80=94versus=
 other programming environments. Author Robert Vieira draws on his experience=
 as one of the leading authorities on Microsoft SQL Server and uses his=
 unique tutorial approach to explain the significant changes to the fundamental=
 core components of SQL Server 2008. <a href=3D'http://www.sqlservercentral.com/links/288241/150898'=
 >Grab your copy today</a> from B&N!</p></td>=0D=0A              </tr>=0D=0A=
              <tr class=3D"lineBreak">=0D=0A                <td colspan=3D"2">=
=0D=0A                  <hr>=0D=0A                </td>=0D=0A          =
    </tr>=0D=0A              <tr class=3D"heading">=0D=0A              =
  <td class=3D"h2Left" valign=3D"middle" style=3D"color:#FFF" bgcolor=3D"#11578b">=
=0D=0A                  <h2>Featured Script</h2>=0D=0A                </td>=
=0D=0A                <td class=3D"h2Right"></td>=0D=0A              </tr>=
=0D=0A              <tr>=0D=0A                <td class=3D"content" colspan=3D"2"><a=
 name=3D"content70059"></a><h3><a href=3D'http://www.sqlservercentral.com/links/288241/150899'=
 >Copy Table Structure Without Data Using 1 Line Query</a></h3>=0D=0A  =
                <p class=3D"byline">Kaifi from <a href=3D'http://www.sqlservercentral.com/links/288241/150873'=
 >SQLServerCentral.com</a></p>=0D=0A                  <p>The script copies=
 the table structure to the newly created table without copying any data=
 to it.=C2=A0<a href=3D'http://www.sqlservercentral.com/links/288241/150899'=
 >More</a><span class=3D"linkArrow"> &raquo;</span></p>=0D=0A          =
      </td>=0D=0A              </tr>=0D=0A              <tr class=3D"lineBreak">=
=0D=0A                <td colspan=3D"2">=0D=0A                  <hr>=0D=0A=
                </td>=0D=0A              </tr>=0D=0A              <tr class=3D"heading">=
=0D=0A                <td class=3D"h2Left" valign=3D"middle" style=3D"color:#FFF"=
 bgcolor=3D"#11578b">=0D=0A                  <h2>Database Pros Who Need=
 Your Help!</h2>=0D=0A                </td>=0D=0A                <td class=3D"h2Right"></td>=
=0D=0A              </tr>=0D=0A              <tr>=0D=0A                <td=
 colspan=3D"2" class=3D"content">=0D=0A                  <p>Here's a few=
 of the new posts today on the forums. To see more, <a href=3D'http://www.sqlservercentral.com/links/288241/150900'=
 >visit the forums</a>.</p>=0D=0A                  <p><h4><a href=3D"http://www.sqlservercentral.com/Forums/Forum415-1.aspx">SQL=
 Server 2005</a> : <a href=3D"http://www.sqlservercentral.com/Forums/Forum146-1.aspx">Administering</a></h4>=
 =0D=0A<p>=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost908209.aspx">Reporting=
 services on non default port</a>=0D=0A - =0D=0A =0D=0A=0D=0A =0D=0AHi,=
=0D=0A =0D=0A=0D=0A =0D=0AWe have installed & configured SQL Server 2005=
 reporting services. But on port 80 some other website is runng so we...</p>=
=0D=0A<p>=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost908019.aspx">Running=
 SQL Trace</a>=0D=0A - My security team would like to run SQL traces on=
 one of our database servers.  How can I restart a...</p>=0D=0A<p>=0D=0A<a=
 href=3D"http://www.sqlservercentral.com/Forums/FindPost907996.aspx">Deleting=
 Logins and Users in SQL Server 2005</a>=0D=0A - Can anyone help me with=
 providing with  script to delete some specific logins and users assosiated=
 with that login from...</p>=0D=0A<p>=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost907990.aspx">How=
 much RAM used by SQL server 2005/Set limit on RAM</a>=0D=0A - I forget=
 this.=0D=0A =0D=0AThere is a way to tell SQL server to use x amount of=
 RAM ( instead of using all...</p>=0D=0A<p>=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost907946.aspx">how=
 to find tables that are not using since log time?</a>=0D=0A - Hi ,=0D=0A=
 =0D=0A=0D=0A =0D=0Ai need to find the tables that are not using since long=
 time in the database=0D=0A =0D=0A=0D=0A =0D=0Ait would be great...</p>=
=0D=0A<p>=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost907857.aspx">comportement=
 on error resume next</a>=0D=0A - Bonjour,=0D=0A =0D=0A=0D=0A =0D=0Aj'ai=
 fait une requete qui contient un curseur, lorsque j'execute la requete=
 dans SSMS il y a des erreurs mais...</p>=0D=0A<p>=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost907453.aspx">Backups=
 Vs Mirroring VS Replications Vs Snapshot</a>=0D=0A - hi All,=0D=0A =0D=0A=
=0D=0A =0D=0AI knew Backup & Restore of DBs only .=0D=0A =0D=0A=0D=0A =0D=0Aevery=
 time i am getting confused with the terms "Mirroring VS Replications...</p>=
=0D=0A<p>=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost906849.aspx">Copying=
 system DB's to a new server</a>=0D=0A - hi all=0D=0A =0D=0A=0D=0A =0D=0Awe=
 have our current live sql server, and a new test sql server.=0D=0A =0D=0Awhen=
 im finished with test it will...</p>=0D=0A<p>=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost906578.aspx">Reindex=
 minimally logged - Does not work</a>=0D=0A - Hi=0D=0A =0D=0A=0D=0A =0D=0AI=
 am using a job to rebuild indexes. Step one I put the database in Bulk=
 Load. Step 2 I...</p>=0D=0A<p>=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost906399.aspx">collation=
 settings for reportserver database</a>=0D=0A - Hi,=0D=0A =0D=0A=0D=0A =
=0D=0AWhat are the collation settings for ReportServer & ReportServerTempDb?=
=0D=0A =0D=0A=0D=0A =0D=0AI know that the Reporting Services Configuration=
 Manager sets the collation settings as...</p>=0D=0A<p>=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost902969.aspx">DELETING=
 BACKUP FILES USING A SCRIPT.</a>=0D=0A - Hi =0D=0A =0D=0AAny one with a=
 script that can delete backups.bk files that are older than 3days, pls=
 help.</p>=0D=0A<p>=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost897494.aspx">more=
 than 250 indexes on a table</a>=0D=0A - For a customer i have to investigate=
 a table wich has more than 250 indexes on it. The company who...</p>=0D=0A<p>=
=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost897023.aspx">Row=
 Level Versioning</a>=0D=0A - Hey,=0D=0A =0D=0A=0D=0A =0D=0AWe're using=
 SQL Server 2005 in our company and we have an application that may benefit=
 by using the row...</p>=0D=0A<p>=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost887114.aspx">Blocking=
 while running reports</a>=0D=0A - Hi,=0D=0A =0D=0A=0D=0A =0D=0AWe have=
 SQL Server 2005 Reporting service on Server A & it's databases ReportServer=
 & ReportServerTemDB are on Server B. From the...</p>=0D=0A<p>=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost883102.aspx">Best=
 way to create a weekly email report for SQL Server</a>=0D=0A - Hi,=0D=0A=
 =0D=0A=0D=0A =0D=0AI have been asked to create a automated "report" of=
 some sort to provide some kind of statistics on our...</p>=0D=0A<p>=0D=0A<a=
 href=3D"http://www.sqlservercentral.com/Forums/FindPost650924.aspx">Job=
 Enabled and Schedule Enabled confusion</a>=0D=0A - Hello,=0D=0A =0D=0A=
=0D=0A =0D=0AI can't seem to reconcile this and can't find a clear explanation=
 on it.=0D=0A =0D=0A=0D=0A =0D=0AI have a Job set up with...</p>=0D=0A<p>=
=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost638606.aspx">System=
 databases on an iSCSI LUN</a>=0D=0A - Hi All,=0D=0A =0D=0A=0D=0A =0D=0AI=
 am preparing to build a new SQL Server 2008 Enterprise server. The machine=
 is very well equipped (Windows...</p>=0D=0A<p>=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost514505.aspx">sp_send_dbmail=
 to SMS error</a>=0D=0A - Hi,=0D=0A =0D=0A=0D=0A =0D=0AI am trying to use=
 sp_send_dbmail to both email and sms address. The email works fine both=
 in HTML and...</p>=0D=0A<h4><a href=3D"http://www.sqlservercentral.com/Forums/Forum415-1.aspx">SQL=
 Server 2005</a> : <a href=3D"http://www.sqlservercentral.com/Forums/Forum357-1.aspx">Backups</a></h4>=
 =0D=0A<p>=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost907938.aspx">Backup=
 T-SQL -- Return variables</a>=0D=0A - I'm trying to do a backup in an SP.=
  Is there any way to get the data outputed by a...</p>=0D=0A<p>=0D=0A<a=
 href=3D"http://www.sqlservercentral.com/Forums/FindPost907660.aspx">Differential=
 Backup of Database</a>=0D=0A - Dear all,=0D=0A =0D=0AI have a database=
 of 1 TB size. I planned to take full backup on sunday and differential=
 backup...</p>=0D=0A<h4><a href=3D"http://www.sqlservercentral.com/Forums/Forum415-1.aspx">SQL=
 Server 2005</a> : <a href=3D"http://www.sqlservercentral.com/Forums/Forum147-1.aspx">Business=
 Intelligence</a></h4> =0D=0A<p>=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost885757.aspx">Calculated=
 measures in cube giving very poor performance</a>=0D=0A - I have an SSAS=
 2005 OLAP cube with 4 dimensions (Including servertime) and 5 measure groups=
 along with 8 calculated...</p>=0D=0A<p>=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost881874.aspx">Error=
 -1056899072 : The following system error occurred:  Key not valid for use=
 in specified state. . While deploying Sample Project of SSAS Cubes.</a>=
=0D=0A - Error -1056899072 : The following system error occurred:  Key not=
 valid for use in specified state. .=0D=0A =0D=0AI am using Visual Studio...</p>=
=0D=0A<h4><a href=3D"http://www.sqlservercentral.com/Forums/Forum415-1.aspx">SQL=
 Server 2005</a> : <a href=3D"http://www.sqlservercentral.com/Forums/Forum386-1.aspx">CLR=
 Integration and Programming.</a></h4> =0D=0A<p>=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost907137.aspx">Centrally=
 located stored procs?</a>=0D=0A - For instance, say i have ten databases=
 all of which contain a copy of the same procedure.  is it possible...</p>=
=0D=0A<h4><a href=3D"http://www.sqlservercentral.com/Forums/Forum415-1.aspx">SQL=
 Server 2005</a> : <a href=3D"http://www.sqlservercentral.com/Forums/Forum145-1.aspx">Development</a></h4>=
 =0D=0A<p>=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost908034.aspx">keyword=
 between</a>=0D=0A - I need a sql  as "select * from mytable rownum &gt;=3D10=
 and rownum &lt;=3D 20;=0D=0A =0D=0ADoes ms sql support above sql, if...</p>=
=0D=0A<p>=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost907378.aspx">Criteria=
 Table</a>=0D=0A - Hi All,=0D=0A =0D=0A=0D=0A =0D=0AI'm kind of newbie,=
 I have time registered here, but this is my first post. After searching=
 through the...</p>=0D=0A<p>=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost906453.aspx">Fulltext=
 search slow sql server 2005</a>=0D=0A - Hi,=0D=0A =0D=0A=0D=0A =0D=0AWe=
 had a table presently around 12000 rows.It has got upto 10 indexes.It also=
 had a fulltext index on a...</p>=0D=0A<p>=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost308097.aspx">Execute=
 a stored procedure inside a user defined function</a>=0D=0A - Hello,=0D=0A=
 =0D=0AI need to execute a stored procedure inside a function. Can=C2=A0it=
 be possible?=0D=0A =0D=0A=0D=0A =0D=0AThanks...=0D=0A =0D=0AMCVilbar=0D=0A=
 =0D=0A</p>=0D=0A<h4><a href=3D"http://www.sqlservercentral.com/Forums/Forum415-1.aspx">SQL=
 Server 2005</a> : <a href=3D"http://www.sqlservercentral.com/Forums/Forum323-1.aspx">SQL=
 Server 2005 Compact Edition</a></h4> =0D=0A<p>=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost894468.aspx">Add=
 a Column to Table</a>=0D=0A - I want to add a column to a table in My SQL=
 CE database by using the following command:=0D=0A =0D=0A=0D=0A =0D=0AALTER=
 TABLE...</p>=0D=0A<h4><a href=3D"http://www.sqlservercentral.com/Forums/Forum415-1.aspx">SQL=
 Server 2005</a> : <a href=3D"http://www.sqlservercentral.com/Forums/Forum149-1.aspx">SQL=
 Server 2005 General Discussion</a></h4> =0D=0A<p>=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost907980.aspx">How=
 do you hide the SQLAgent90.exe command window?</a>=0D=0A - After some recent=
 maintenance, our SQL Server machine began to create/display a blank command=
 window for the SQLAGENT90.exe=0D=0A =0D=0A=0D=0A =0D=0ASomething had been...</p>=
=0D=0A<p>=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost906819.aspx">Procedure=
 has too many arguments</a>=0D=0A - Posted - 04/20/2010 :  09:17:52    =
         =0D=0A =0D=0A--------------------------------------------------------------------------------=
=0D=0A =0D=0A =0D=0A =0D=0AHi All,=0D=0A =0D=0A=0D=0A =0D=0AI have a SP=
 that has nearly 27 parameters. No compilation error is shown but when...</p>=
=0D=0A<p>=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost903150.aspx">How=
 to tune/speed up a procedure</a>=0D=0A - I have a stored procedure where=
 I am converting old mainframe data that is in a staging table, and converting...</p>=
=0D=0A<p>=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost901670.aspx">SSMS=
 - always open file with new connection</a>=0D=0A - After i run a query=
 in server A, database X, then open a .sql file, two things may happen:=
=0D=0A =0D=0A=0D=0A =0D=0A1 - the...</p>=0D=0A<h4><a href=3D"http://www.sqlservercentral.com/Forums/Forum415-1.aspx">SQL=
 Server 2005</a> : <a href=3D"http://www.sqlservercentral.com/Forums/Forum359-1.aspx">SQL=
 Server 2005 Security</a></h4> =0D=0A<p>=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost907708.aspx">Hiding=
 payroll data from admin</a>=0D=0A - we have a new payroll system coming=
 online using SQL 2005 and questions have come up regarding security, specifically=
 securing...</p>=0D=0A<h4><a href=3D"http://www.sqlservercentral.com/Forums/Forum415-1.aspx">SQL=
 Server 2005</a> : <a href=3D"http://www.sqlservercentral.com/Forums/Forum361-1.aspx">SQL=
 Server 2005 Strategies</a></h4> =0D=0A<p>=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost906741.aspx">Fascinating=
 challenge: Creating a centralized PK generator to support cross-colo ETL=
 for a global SaaS product</a>=0D=0A - First some brief background. We have=
 a global SaaS solution for the insurance industry. Our product has a dynamic=
 UI...</p>=0D=0A<p>=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost906417.aspx">How=
 to do this ?? csv OHLC data storage</a>=0D=0A - Ok..to give you an idea.=
=0D=0A =0D=0A=0D=0A =0D=0ACopy this URL into browser address bar:=0D=0A=
 =0D=0Ahttp://ichart.finance.yahoo.com/table.csv?s=3D^DJI&a=3D01&b=3D01&c=3D1900&d=3Dignore&e=3D&ignore&f=3Dignore&g=3Dd&ignore=3D.csv=
=0D=0A =0D=0A=0D=0A =0D=0AThe result is a CSV file with: Date, O,H,L,C,V,AdjC=
 with...</p>=0D=0A<h4><a href=3D"http://www.sqlservercentral.com/Forums/Forum415-1.aspx">SQL=
 Server 2005</a> : <a href=3D"http://www.sqlservercentral.com/Forums/Forum291-1.aspx">SS2K5=
 Replication</a></h4> =0D=0A<p>=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost907935.aspx">Error=
 Creating transactional replication or enabling replication on DB</a>=0D=0A=
 - I an trying to enable transactional replication on some of my databases.=
  I try to create the publication and get...</p>=0D=0A<p>=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost907891.aspx">System=
 table which holds the subscriber server name</a>=0D=0A - Hi All,=0D=0A=
 =0D=0A=0D=0A =0D=0AIm trying to build a query which will give me a snapshot=
 of our replicated environment showing things such...</p>=0D=0A<h4><a href=3D"http://www.sqlservercentral.com/Forums/Forum415-1.aspx">SQL=
 Server 2005</a> : <a href=3D"http://www.sqlservercentral.com/Forums/Forum324-1.aspx">SQL=
 Server Express</a></h4> =0D=0A<p>=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost595705.aspx">Cannot=
 open user default database</a>=0D=0A - On SQL Management Studio Express=
 this error appears when i try to see the properties of a LOGIN=0D=0A =0D=0A=
=0D=0A =0D=0ATITLE: Microsoft SQL...</p>=0D=0A<h4><a href=3D"http://www.sqlservercentral.com/Forums/Forum415-1.aspx">SQL=
 Server 2005</a> : <a href=3D"http://www.sqlservercentral.com/Forums/Forum360-1.aspx">SQL=
 Server 2005 Performance Tuning</a></h4> =0D=0A<p>=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost906734.aspx">Efficient=
 way to fetch data through job</a>=0D=0A - Hi=0D=0A =0D=0A=0D=0A =0D=0AI'm=
 using sql server 2000. I've to write a job which fetches around 10 lakhs=
 records from a table and...</p>=0D=0A<p>=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost906381.aspx">General=
 pointers on reading wait statistics</a>=0D=0A - Hello,=0D=0A =0D=0A=0D=0A=
 =0D=0AI know it's not easy to answer questions about performance tuning=
 given the variations and unique circumstances across SQL systems,...</p>=
=0D=0A<h4><a href=3D"http://www.sqlservercentral.com/Forums/Forum415-1.aspx">SQL=
 Server 2005</a> : <a href=3D"http://www.sqlservercentral.com/Forums/Forum148-1.aspx">SQL=
 Server 2005 Integration Services</a></h4> =0D=0A<p>=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost908140.aspx">SSIS=
 question</a>=0D=0A - I have OrderSent column(timestamp datatype) in AS400=
 file with the below values:=0D=0A =0D=0A2009-03-11-13.07.24.922000=0D=0A=
 =0D=0A2009-02-18-13.07.24.924000=0D=0A =0D=0A=0D=0A =0D=0AWhen I am trying=
 to load this AS400 column...</p>=0D=0A<p>=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost908060.aspx">Send=
 Mail Task Failing using a Hotmail Account</a>=0D=0A - When I execute the=
 following code SSMS, the e-mail is sent:=0D=0A =0D=0A=0D=0A =0D=0AUSE msdb=
=0D=0A =0D=0AGO=0D=0A =0D=0AEXEC sp_send_dbmail @profile_name=3D'Hotmail',=
=0D=0A =0D=0A@recipients=3D'myusername@hotmail.com',=0D=0A =0D=0A@subject=3D'Test=
 message',=0D=0A =0D=0A@body=3D'This is the body of the...</p>=0D=0A<p>=
=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost908044.aspx">String=
 Result Set</a>=0D=0A - I am using SQL Server 2005 SP3 on Windows Server=
 2003.  =0D=0A =0D=0A=0D=0A =0D=0AI have an ExecuteSQL task with the following=
 SQL...</p>=0D=0A<p>=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost907330.aspx">Konesans=
 Checksum 2008 issue</a>=0D=0A - Hi,=0D=0A =0D=0A=0D=0A =0D=0AI installed=
 Konesans checksum 2008 component on SQL Server 2005 box. It installed successfully=
 but I am not seeing the...</p>=0D=0A<p>=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost907240.aspx">selective=
 Delta refresh</a>=0D=0A - Hi, we have a set of packages which involve pulling=
 data from a source table and performin a delta refresh...</p>=0D=0A<p>=
=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost906676.aspx">Execute=
 Tasks Conditionally?</a>=0D=0A - Is there a function, method, or technique=
 that someone could share with me?=0D=0A =0D=0A=0D=0A =0D=0AI have a large=
 dataflow that services records...</p>=0D=0A<p>=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost741292.aspx">WMI=
 Event Watcher Task</a>=0D=0A - I am using the WMI Event Watcher Task to=
 watch for the arrival of a file.  =0DI have the following...</p>=0D=0A<p>=
=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost394152.aspx">ssis=
 and ssrs interview questions</a>=0D=0A -  can any one tell some interview=
 questions in reporting service and integration service=0Don sql server=
 2005=0D=0D please this is urgent...</p>=0D=0A<h4><a href=3D"http://www.sqlservercentral.com/Forums/Forum415-1.aspx">SQL=
 Server 2005</a> : <a href=3D"http://www.sqlservercentral.com/Forums/Forum338-1.aspx">T-SQL=
 (SS2K5)</a></h4> =0D=0A<p>=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost907022.aspx">T-SQL=
 t export table to Access</a>=0D=0A - How do I use T-SQL to export a table=
 of my choosing to a pre-defined access database.  I want to...</p>=0D=0A<p>=
=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost907003.aspx">Substring=
 Function in Where Clause</a>=0D=0A - I am currently doing string manipulations=
 with T-sql. In the where statement of my code I have the following substring...</p>=
=0D=0A<p>=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost903762.aspx">Converting=
 a date</a>=0D=0A - I'm having an issue with trying to have a query run=
 for todays date. I'm not sure how to have...</p>=0D=0A<h4><a href=3D"http://www.sqlservercentral.com/Forums/Forum415-1.aspx">SQL=
 Server 2005</a> : <a href=3D"http://www.sqlservercentral.com/Forums/Forum1291-1.aspx">SQL=
 Server Newbies</a></h4> =0D=0A<p>=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost907805.aspx">SSRS=
 2008</a>=0D=0A - I did go through few articles for these questions but=
 thought i could find a better one here..=0D=0A =0D=0A=0D=0A =0D=0A1.Can=
 anyone tell...</p>=0D=0A<p>=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost904866.aspx">remove=
 duplicate records, but keep most "current"</a>=0D=0A - I am working on=
 a database where we are storing data on multiple servers (SQL 2005), I=
 am importing the...</p>=0D=0A<p>=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost903644.aspx">'-'=
 in sql server</a>=0D=0A - Hi! =0D=0A =0D=0A=0D=0A =0D=0Athere=C2=B4s a=
 sql server named 'srv-dev'.=0D=0A =0D=0AI=C2=B4ve to update certain tables=
 in 'srv-dev' from my server but sql says that...</p>=0D=0A<h4><a href=3D"http://www.sqlservercentral.com/Forums/Forum406-1.aspx">SQL=
 Server 7,2000</a> : <a href=3D"http://www.sqlservercentral.com/Forums/Forum5-1.aspx">Administration</a></h4>=
 =0D=0A<p>=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost636045.aspx">Mass=
 Chaning DTS Password</a>=0D=0A - Dear all,=0D=0A =0D=0A=0D=0A =0D=0AI am=
 ask by the management to change all password in our system regularly, this=
 includes DTS password, =0D=0A =0D=0ADo...</p>=0D=0A<h4><a href=3D"http://www.sqlservercentral.com/Forums/Forum406-1.aspx">SQL=
 Server 7,2000</a> : <a href=3D"http://www.sqlservercentral.com/Forums/Forum9-1.aspx">General</a></h4>=
 =0D=0A<p>=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost905431.aspx">Sql=
 server 2005 installation</a>=0D=0A - Hi, guys how are you doing?=0D=0A=
 =0D=0A=0D=0A =0D=0A  i have windows server 2003 and recently, i installed=
 SQL server 2000 in drive...</p>=0D=0A<p>=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost289727.aspx">Stored=
 Procedure Organization</a>=0D=0A - =0D=0A =0D=0AI currently have a somewhat=
 large web application.=C2=A0 For some of the code I use Inline SQL code,=
 not Stored...</p>=0D=0A<h4><a href=3D"http://www.sqlservercentral.com/Forums/Forum406-1.aspx">SQL=
 Server 7,2000</a> : <a href=3D"http://www.sqlservercentral.com/Forums/Forum169-1.aspx">SQL=
 Server Newbies</a></h4> =0D=0A<p>=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost906582.aspx">Logshipping</a>=
=0D=0A - Hi,=0D=0A =0D=0A=0D=0A =0D=0AThis question is actually not realted=
 to sql server, but I am not able to get the answer from anywhere...</p>=
=0D=0A<p>=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost862480.aspx">concatenate=
 rows (sql server 2000)</a>=0D=0A - Hi all, I have the following problem=
 when using sql server 2000=0D=0A =0D=0A=0D=0A =0D=0AThe following table=
 has around 200 records.=0D=0A =0D=0A=0D=0A =0D=0ACompany / Employee=0D=0A=
 =0D=0A1005 / A=0D=0A =0D=0A1005...</p>=0D=0A<p>=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost856486.aspx">Stored=
 procedure - update tables in 2 databases</a>=0D=0A - I have to update 2=
 databases at once from a stored procedure. How can this be done? This is=
 what...</p>=0D=0A<h4><a href=3D"http://www.sqlservercentral.com/Forums/Forum406-1.aspx">SQL=
 Server 7,2000</a> : <a href=3D"http://www.sqlservercentral.com/Forums/Forum8-1.aspx">T-SQL</a></h4>=
 =0D=0A<p>=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost908160.aspx">Error=
 when concatenating with a case statement</a>=0D=0A - Select DISTINCT ACCT.ACCTNBR||','||=
=0D=0A =0D=0ACASE PERSPERSTYP.PERSTYPCD when 'EMP' then 'EMP' else null=
 end as type||','|| PERSPHONE.AREACD||PERSPHONE.EXCHANGE||PERSPHONE.PHONENBR=
 as CELLPHONE =0D=0A =0D=0AFROM ACCT,PERSPERSTYP,PERSPHONE WHERE (UPPER(PERSPERSTYP.PERSTYPCD)...</p>=
=0D=0A<p>=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost898556.aspx">Accessing=
 Default Instance of SQL Server 2000 across WAN</a>=0D=0A - =0D=0A =0D=0AWas=
 wondering if someone could help me with the following query.Is it possible=
 to connect to a default instance of...</p>=0D=0A<h4><a href=3D"http://www.sqlservercentral.com/Forums/Forum419-1.aspx">SQL=
 Server 2008</a> : <a href=3D"http://www.sqlservercentral.com/Forums/Forum391-1.aspx">SQL=
 Server 2008 - General</a></h4> =0D=0A<p>=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost908105.aspx">Read=
 RESOURCE MONITOR?</a>=0D=0A - Hi,=0D=0A =0D=0A=0D=0A =0D=0AI want to monitor=
 my SQL server better. When running sp_who2, I see that RESOURCE MONITOR=
 is always running... does...</p>=0D=0A<p>=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost907939.aspx">Microsoft=
 OLE DB Provider for ODBC Drivers</a>=0D=0A - Hi GURUs,=0D=0A =0D=0A=0D=0A=
 =0D=0AI have Notes database to be imported into SQL 2005, I have the required=
 driver set up and have...</p>=0D=0A<p>=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost907599.aspx">Insertion=
 Problem</a>=0D=0A - I am doing an insertion with a procedure.All the tables=
 inside procedure is heavilly weighted.=0D=0A =0D=0AProcedure contains following=
 process.=0D=0A =0D=0ATable A contains...</p>=0D=0A<p>=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost907592.aspx">Informix=
 Linked Server problems</a>=0D=0A - I have been asked to set up a few procs=
 that will take data from our core data source in...</p>=0D=0A<p>=0D=0A<a=
 href=3D"http://www.sqlservercentral.com/Forums/FindPost907519.aspx">Trigger=
 For Delete - Multiple Row Value</a>=0D=0A - hi, i have a question, how=
 to read 'value from deleted' from multiple row in trigger for delete?=0D=0A=
 =0D=0A=0D=0A =0D=0Aselect @id =3D id...</p>=0D=0A<p>=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost907495.aspx">Did=
 the way SQL Server 2008 evaluates a CASE WHEN condition when used in a=
 filter?</a>=0D=0A - I am looking at a weird issue since morning. Below=
 query works fine in SQL Server 2005 but throws a...</p>=0D=0A<p>=0D=0A<a=
 href=3D"http://www.sqlservercentral.com/Forums/FindPost904620.aspx">Merge=
 & Transactional Publications on the same DB</a>=0D=0A - Hello,=0D=0A =0D=0A=
=0D=0A =0D=0AI've setup a Merge Publication and Subscriber between Server=
 A (Publisher) and Server B (Subscriber) that works perfectly.  But now...</p>=
=0D=0A<p>=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost901213.aspx">Detect=
 if an instance of SQL Server has been upgraded</a>=0D=0A - I would like=
 to know a reliable way of detecting if a particular instance of SQL Server=
 has been upgraded...</p>=0D=0A<p>=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost431251.aspx">Visual=
 Studio Version?</a>=0D=0A - I see there's a download to "upgrade" Visual=
 Studio 2005 to use with Katmai, but it doesn't allow you to...</p>=0D=0A<h4><a=
 href=3D"http://www.sqlservercentral.com/Forums/Forum419-1.aspx">SQL Server=
 2008</a> : <a href=3D"http://www.sqlservercentral.com/Forums/Forum392-1.aspx">T-SQL=
 (SS2K8)</a></h4> =0D=0A<p>=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost907641.aspx">Alter=
 table on-the-fly</a>=0D=0A - Hi=0D=0A =0D=0A=0D=0A =0D=0AI need to automate=
 the table update process where a table is imported from a production snapshot=
 at the end...</p>=0D=0A<h4><a href=3D"http://www.sqlservercentral.com/Forums/Forum419-1.aspx">SQL=
 Server 2008</a> : <a href=3D"http://www.sqlservercentral.com/Forums/Forum1044-1.aspx">Working=
 with Oracle</a></h4> =0D=0A<p>=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost906086.aspx">Connecting=
 to Oracle on 64-bit maching using SSIS</a>=0D=0A - Hello All,=0D=0A =0D=0A=
=0D=0A =0D=0AI have problem connecting to Oracle server using SSIS. I'm=
 using Microsoft OLE DB Provider for OLE DB Source...</p>=0D=0A<h4><a href=3D"http://www.sqlservercentral.com/Forums/Forum419-1.aspx">SQL=
 Server 2008</a> : <a href=3D"http://www.sqlservercentral.com/Forums/Forum1292-1.aspx">SQL=
 Server Newbies</a></h4> =0D=0A<p>=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost908233.aspx">Advantage=
 of Using Constraint when adding FK or PK</a>=0D=0A - Hi All, =0D=0A =0D=0A=
=0D=0A =0D=0AI've been reading some sql tutorials and doing some exercise=
 and found that a Primary Key can be...</p>=0D=0A<p>=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost907871.aspx">SQL=
 Syntax</a>=0D=0A - Hi All,=0D=0A =0D=0A=0D=0A =0D=0AI'm looking for the=
 correct syntax to find my workorder number within my serial number which=
 starts at the...</p>=0D=0A<p>=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost907832.aspx">A=
 DBA's Daily routine (and other items...)</a>=0D=0A - Greetings all!!=0D=0A=
 =0D=0A=0D=0A =0D=0AI hope to find an answer to my question(s) here.  If=
 not, I will continue my quest.=0D=0A =0D=0A=0D=0A =0D=0ADue to a...</p>=
=0D=0A<p>=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost907820.aspx">[sqsrvres]=
 CheckQueryProcessorAlive: sqlexecdirect failed</a>=0D=0A - Currently, we=
 only have 1 Cluster (SQLCLU1).  This weekend I was going to add a failover=
 node; SQLCLU2.  So as...</p>=0D=0A<p>=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost781712.aspx">combine=
 multiple rows into one dynamically query question</a>=0D=0A - Hi, I have=
 the below table, and I need to combine them=0Dinto one records dynamically=
 (I'm not sure I'm clear...</p>=0D=0A<h4><a href=3D"http://www.sqlservercentral.com/Forums/Forum419-1.aspx">SQL=
 Server 2008</a> : <a href=3D"http://www.sqlservercentral.com/Forums/Forum1549-1.aspx">SQL=
 Server 2008 High Availability</a></h4> =0D=0A<p>=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost904360.aspx">Is=
 it Possible?  Mirror 2005 SE to 2008 EE</a>=0D=0A - Is it possible to mirror=
 a database from SQL Server 2005 Standard Edition to SQL Server 2008 Enterprise=
 Edition?  I...</p>=0D=0A<p>=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost900833.aspx">Mirror=
 vs. Cluster - Which should we do?</a>=0D=0A - We have about 130 databases=
 for clients and are looking for high avail.=0D=0A =0D=0A=0D=0A =0D=0AIn=
 the next year we expect to double...</p>=0D=0A<p>=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost897753.aspx">H=
 A advice</a>=0D=0A - Good day forumites,=0D=0A =0D=0AI am looking into=
 implementing a H A solution for my company. Its in the transition of being...</p>=
=0D=0A<h4><a href=3D"http://www.sqlservercentral.com/Forums/Forum419-1.aspx">SQL=
 Server 2008</a> : <a href=3D"http://www.sqlservercentral.com/Forums/Forum1550-1.aspx">SQL=
 Server 2008 Administration</a></h4> =0D=0A<p>=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost906655.aspx">Limit=
 the CPU usage of sql server 20008</a>=0D=0A - Hi Team,=0D=0A =0D=0A=0D=0A=
 =0D=0ALimit the CPU usage of sql server 2008, when we running the sql jobs=
 CPU performance using 90% at...</p>=0D=0A<p>=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost906066.aspx">The=
 specified Network password is incorrect</a>=0D=0A - Hi All,=0D=0A =0D=0A=
=0D=0A =0D=0AI m facing an issue with starting SQL Service with a particular=
 domain A/c for the past two days....</p>=0D=0A<h4><a href=3D"http://www.sqlservercentral.com/Forums/Forum409-1.aspx">Career</a>=
 : <a href=3D"http://www.sqlservercentral.com/Forums/Forum10-1.aspx">Certification</a></h4>=
 =0D=0A<p>=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost897076.aspx">MCJ=
 - The Missing Link</a>=0D=0A - If you haven't seen it yet, there is a pretty=
 good discussion on the Missing Certification based on an Editorial...</p>=
=0D=0A<h4><a href=3D"http://www.sqlservercentral.com/Forums/Forum409-1.aspx">Career</a>=
 : <a href=3D"http://www.sqlservercentral.com/Forums/Forum334-1.aspx">Employers=
 and Employees</a></h4> =0D=0A<p>=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost838012.aspx">SQL=
 Premier Field Engineer. Some questions on this role...</a>=0D=0A - There=
 is a role in my location for a Sql server premier field engineer. Currently=
 i am in application support,...</p>=0D=0A<h4><a href=3D"http://www.sqlservercentral.com/Forums/Forum407-1.aspx">Programming</a>=
 : <a href=3D"http://www.sqlservercentral.com/Forums/Forum23-1.aspx">General</a></h4>=
 =0D=0A<p>=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost908181.aspx">Grabing=
 PRINT statements via ADO .Net when no exception is raised?</a>=0D=0A -=
 Hi there,=0D=0A =0D=0A=0D=0A =0D=0AFor various reasons, I need to build=
 a small Query Analyser kind of tool in .Net and everything works...</p>=
=0D=0A<p>=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost907936.aspx">Looking=
 for help to modify a query into a Stored Procedure.</a>=0D=0A - I am trying=
 to convert this query into a stored proecedure. I need a parameter for=
 Name and a StartDate/EndDate....</p>=0D=0A<h4><a href=3D"http://www.sqlservercentral.com/Forums/Forum410-1.aspx">SQLServerCentral.com</a>=
 : <a href=3D"http://www.sqlservercentral.com/Forums/Forum61-1.aspx">Anything=
 that is NOT about SQL!</a></h4> =0D=0A<p>=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost907985.aspx">What=
 do you do when you don't get paid?</a>=0D=0A - Long story short... I've=
 been involved on a project where I had to build a printing application=
 for a paint...</p>=0D=0A<p>=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost812849.aspx">Today's=
 Random Word!</a>=0D=0A - HI =0D=0A =0D=0A=0D=0A =0D=0AWhen you woke up=
 today, or logged-onto Opera Forums, you may have had a dream, a thought,=
 a scene...</p>=0D=0A<p>=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost604325.aspx">Are=
 the posted questions getting worse?</a>=0D=0A - Is it me, or are the posted=
 questions getting worse these days?=0D=0A =0D=0A=0D=0A =0D=0AI just read=
 a post by someone apparently in...</p>=0D=0A<h4><a href=3D"http://www.sqlservercentral.com/Forums/Forum416-1.aspx">Reporting=
 Services</a> : <a href=3D"http://www.sqlservercentral.com/Forums/Forum150-1.aspx">Reporting=
 Services</a></h4> =0D=0A<p>=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost564445.aspx">working=
 with multiple dataset withing a table in SSRS</a>=0D=0A - Hi,=0D=0A =0D=0A=
=0D=0A =0D=0AI have a main dataset which displays invoice details. I have=
 another dataset which displays meter information for given invoice...</p>=
=0D=0A<h4><a href=3D"http://www.sqlservercentral.com/Forums/Forum416-1.aspx">Reporting=
 Services</a> : <a href=3D"http://www.sqlservercentral.com/Forums/Forum1063-1.aspx">Reporting=
 Services 2005 Development</a></h4> =0D=0A<p>=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost906939.aspx">SSRS=
 text box max length issue</a>=0D=0A - Hi everyone,=0D=0A =0D=0A=0D=0A =
=0D=0AI have a comments fieldname with nvarchar(2000).=0D=0A =0D=0A=0D=0A=
 =0D=0AWhen pulled into a report, the text value is getting cut off.=0D=0A=
 =0D=0A=0D=0A =0D=0AIs there...</p>=0D=0A<p>=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost572495.aspx">Refer=
 to report datasets from embedded code or custom assembly (VB.net)</a>=0D=0A=
 - Hi there,=0D=0A =0D=0A=0D=0A =0D=0AI am currently developing a report=
 which takes Sales Orders and assigns units from either stock or already=
 raised...</p>=0D=0A<h4><a href=3D"http://www.sqlservercentral.com/Forums/Forum408-1.aspx">Data=
 Warehousing</a> : <a href=3D"http://www.sqlservercentral.com/Forums/Forum17-1.aspx">Analysis=
 Services</a></h4> =0D=0A<p>=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost908212.aspx">Good=
 MDX tutorial ?</a>=0D=0A - Hi, =0D=0A =0D=0ACould anybody recommend good=
 MDX tutorial ?=0D=0A =0D=0A=0D=0A =0D=0AThanks.=0D=0A =0D=0A</p>=0D=0A<p>=
=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost906321.aspx">SSAS=
 Deployment and Disaster Recovery</a>=0D=0A - Hello,=0D=0A =0D=0AI'm just=
 getting into the BI side of SQL Server.  I've been asked to develop some=
 reports and since I'm...</p>=0D=0A<p>=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost902272.aspx">Period=
 to date</a>=0D=0A - Hi, I am working with MDX, and I have the following=
 MDX-statement:=0D=0A =0D=0A=0D=0A =0D=0A[color=3D#0000ff]WITH Member [Measures].[SummarizedStock]=
 as=0D=0A =0D=0A	aggregate(PeriodsTODAte([Time dimension].[(All)]),[Measures].[Stock])=
=0D=0A =0D=0A=0D=0A =0D=0ASelect	{[Measures].[SummarizedStock], [Measures].[Stock]=
 } on columns,=0D=0A =0D=0A		nonempty([Time Dimension].[Month].members)...</p>=
=0D=0A<p>=0D=0A<a href=3D"http://www.sqlservercentral.com/Forums/FindPost899336.aspx">Calculated=
 Measure Result is Based in Dimension Picked</a>=0D=0A - Dear All,=0D=0A=
 =0D=0A=0D=0A =0D=0AI have the following Case ... In the Fact:=0D=0A =0D=0A=
=0D=0A =0D=0APerson Name     Plan ID      Earned Days=0D=0A =0D=0AJohn Smith=
       A              10=0D=0A =0D=0AJohn Smith       B              10...</p>=
=0D=0A</p>=0D=0A                </td>=0D=0A              </tr>=0D=0A   =
           <tr class=3D"lineBreak">=0D=0A                <td colspan=3D"2">=
=0D=0A                  <hr>=0D=0A                </td>=0D=0A          =
    </tr>=0D=0A              <tr>=0D=0A                <td class=3D"footer"=
 colspan=3D"2">=0D=0A                  <p>=0D=0A          To be removed=
 from this list, please click=0D=0A          <a href=3D"http://www.sqlservercentral.com/Unsubscribe?u=3DiiXqQhXy%2fO8gGcQpbbm%2bLA%3d%3d&amp;n=3DNewsletterSubscriber">=
=0D=0A            here=0D=0A          </a></p>=0D=0A                  <p>=
=0D=0A          If you have any problems leaving the list, please contact=
 the <a href=3D"mailto:webmaster@sqlservercentral.com">webmaster@sqlservercentral.com</a>.=
=0D=0A        </p>=0D=0A                  <p>=0D=0A          This newsletter=
 was sent to you because you signed up at SQLServerCentral.com. Feel free=
 to forward this to any colleagues that you think might be interested. If=
 you have received this email from a colleague, you can register to receive=
 it <a href=3D'http://www.sqlservercentral.com/links/288241/150901' >here</a>.=
=0D=0A        </p>=0D=0A                  <p>=0D=0A          This transmission=
 is &copy;2010 Red Gate Software Ltd. All rights reserved. Contact: <a href=3D"mailto:webmaster@sqlservercentral.com">webmaster@sqlservercentral.com</a></p>=
=0D=0A                </td>=0D=0A              </tr>=0D=0A            </table>=
=0D=0A          </td>=0D=0A        </tr>=0D=0A      </tbody>=0D=0A    </table>=
=0D=0A  </body>=0D=0A</html>
----boundary_436_fe62e6e5-0c7d-4ffa-b944-02d54c42764b--