Posts

Export to Data Feed" button missing in SSRS Report

Image
hi all,         holding bunch of ssrs reports ,  i don't find , solution after goggling on "export data feed" button missing  in ssrs" myself holding same issue.        then digged find the <atom> tag  option in reportserver. config file opening in bi and it does exists there.            had modified <atom> tag by changing visible attribute false "true" don't find result, below result image. can 1 me how can "export data feed" button in ssrs reports thanks, sid. an reportserver database on same server lookup before (your screenshot)? if haven't deployed reports maybe re-creating reportserver database easiest way fix issue; click on "change database" button. olaf helper [ blog ] [ xing ] [ mvp ] ...

Database file and log

hi, i familiar sql-server 2005. since created database , played little recognized database file has grown 150 mb log file. i used shrink task resize database file. after doing .ldf remained (150 mb). since not need log information stored there, possible shrink ldf-file well? thanks help! hi, have here: http://www.aspfaq.com/show.asp?id=2471 hth, jens suessmeyer. --- http://www.sqlserver2005.de --- SQL Server  >  Getting started with SQL Server

Setting the intervaloffset of a stripline to a datetime. - SQL2008 R2 / RB 3.0

i have line chart date x-axis (in days). example, x-axis shows 2/1/2010-6/1/2010.  i trying draw stripline @ specfic date - value of held in single value datetime parameter. interval set auto, it's single line. in interval offset using expression call parameter value.  the report processes, stripline not appear on report on expected date. in .net forms there solved problem similar this:  http://social.msdn.microsoft.com/forums/en-us/mswinwebchart/thread/d9da5256-9834-4b11-bac8-95dc6d6197e5  - can't figure out how make solution work in report builder.  this sql2008 r2 , report builder 3.0.  is there more information can provide clarify issue here? still struggling figure out.  SQL Server  >  SQL Server Reporting Services, Power View ...

Removing SQL Express instances

using sql express, under computer management, sql server configuraqtion manager, sql server 2005 network configuration ihave following listed instances   csolution - not listed under services mssqlserver - disabled sqlexpress - diaabled sqltest - disabled sqlexpressdata - used vb05 program   questions a) how delete instancces i not use. in msde, each instance removed via add/remove programs, don't see how remove under express   b) since sqlexpress default sql express installation, vbb05 program use instance; how do that?   any appreciated.   bob a)  when go add/remove programs, select sql 2005 entry , click on remove.  pop box showing instances have on machine.  can select 1 here , continue uninstall remove it.    b)  when create db connection in vb app, you'll need supply db name connect to.  here, use <machinename>/sqlexpress , connect instance.  you'd same thing connect other named instance.    thanks, sam lester (msft)  ...

SQL 2012 Availability Group Connectivity

good afternoon, hope well. have setup sql 2012 on windows server failover cluster, spanning across multiple datacentres. have 2 nodes in each datacentre (dc1 , dc2), , fileshare witness on seperate datacentre (dc3). setup have been able setup alwayson availability group. interesting things i've noticed. created listeners on group have same dns name both subnets of dc's (this keep things simple endusers). can see dns entries created, seems have complete dns flush connect availbilty group following failover (doesnt seem on, customers won't know failover has happened). test both dc's configured synchronous commit, failover automatic. whole dns issues seems little awkward, missing there? assistance appreciated. other queries have span around how little connectivity issue would/could resolved on failover. kind regards, you have hit on specific issue availability groups common.  fortunately you, there fix. set multisubnetfailover property "yes" in a...

striped backups in sql server ?

hi all, i have small doubt on striped backups. have 50gb database , database used space 46 gb , backup file  same size  but in local drive having low disk space . d drive having 10 gb ,e drive having 15 gb, f drive having 15 gb , g drive having 19 gb free space . my doubt , can take striped backup or not?  is fail or not? please post valuable posts asap. thanks , ram ram my doubt , can take striped backup or not?  hello, yes, of course can create striped backups of database. difficult spread striped backup in size on exisiting drives less free space. here powershell script create striped backup command, see striped backup of sql server databases you split backup in 10 files * 5 mb configuration 2 files on d , 3 files on each e,f,g. olaf helper blog xing SQL Server  >  ...

VS2003 and Installing MSSCCI

i'm attempting install tfs 2008 msscci plug in on machine running vs2003 , vss 2005.   from reading forums, didn't see said need install team explorer first, when running msscci.msi, indicates i'm missing tfs client.   so, mean installing vs2008 team explorer alongside vs 2003?   also, there information on how logically switch on source control tfs2008 repository, assuming associated project exists, source code not exist it?   thanks in advance!!!   chad s st. louis, mo hello trianglemoon,     if want use vs 2005 tfs 2008,     need install            1. team explorer 2005            2. patch for working wss 3.0 team explorer 2005                http://support.microsoft.com/kb/932544        luck. Archived Forums V  >  Team Foundation Server -...