Lun

i have downloaded copy of sql server 2008 express edition. have been working fine, going through training book. need launch database engine tuning advisor, don't see anywhere in menus in ssms or start menus. how access dta? hi, dta not provided sqlexpress edition.. please have @ features supported byt editions matrix further info.. regards http://www.asql.biz - dbamgr2k - dbamgr , further sql tools SQL Server  >  SQL Server Express

1. powerpivot limitation on rows in sheet ? 2.does has capability connect sbase pull data 1. memory primary limiting factor. if have x64 machine , amount of ram can pull in data upto 2 billion rows. have kept cap of 2 gb (physical file size) while saving beyond block save. 2. long sbase provides standard oledb provider implementing defined interfaces can pull data it.   thanks, deva [msft] blog: http://powerpivot.spaces.live.com/ SQL Server  >  Power Pivot

hello, i have requirement data comes in flat file format.  this data need go through various step of transformations , lookup . have broke down process in steps.  1. stage 2. collect needed data 3. validate data 4. store them in incremental order future use. 5. generate more transaction related incoming rows. 6 send target system.   through out process data going across many tables , servers , have following requirement. 1. need create process in case of failure  if data has not gone through steps  and in target system need  process start left off , finish processing data target.  ( requirement ask not use check point in ssis) 2. in case failure require process same file again data should wipe cleaned in step 1 5 , new file should process   i have looked in batch processing in steps batch id there need better suggestions. please let me know if have suggestion or route should avoid. i advise against using transactions long transac...

hi ! when try create simple silverlight's project (just 1 button in site) , run on localhost ok. when try upload server (support .net 3.5) show white page ! not error alert, not show on page !  what problem ? have install on server run silverlight 2.0  i have intalled 6 mime type follow link http://msdn2.microsoft.com/en-us/library/ms752346.aspx  but not ok !  please !  thank advance ! oh, fixed problem ! it solved when try add .xap mime type in iis.  thank ! Silverlight  >  Silverlight Installation and Setup

hello! i don't know if question belong sql forum or smart device forum. so far able sync data between pda , sql server pc, on wi-fi lan using remote data access. now want same without using wifi lan, mean, want able on gprs connection, same data synchronization. my main question how access sql server database ? connection string (obviously) works in lan. my doubt how can access sql server database data ? i need on here, don't know how can overcome current problem. thank you oooh, see. since mentioned "remote data access" in first post, wrongly assumed using rda already. see not case. depending on requirements, must use either rda, merge replication, sync services or own web service transfer data between local sql compact database , server, rda , merge go via sql ce agent on web server. should consult books online make informed decision on technology choose. in addiotion the product manual, article should give som guidance: http://msdn.microsoft.com/en-us/library/ms8...

aplogies if wrong place submit ... when called command line tfsconfig shows databasename optional parameter, not case think? tfsconfig registerdb /sqlinstance:<new data tier name> [/databasename:<database name>] tfsadmin-july2010.chm::/html/5764e3fc-d0e1-4aa0-928b-8688cf9fa2d9.htm the lastest version of tfs admin guide not list second parameter? in addition documentation changeserverid perhaps misleading or perhaps lack of understanding tfsconfig changeserverid /sqlinstance:contosomain\teamdatabases /databasename:tfs_configurationdb should database name not tfs_configuration thanks s hi oradotnetdev, for command tfsconfig changeserverid /sqlinstance:servername] /databasename:configurationdatabasename [/projectcollectionsonly] [/configdbonly] where servername: specifies name of server hosts configuration database team foundation server , name of instance if want use instance other default instance. if specify instance, must use ...

how can loop through several folder , same file ? folder1 / file folder2 / file folder3 / file if folders on same root folder drag "for loop container" --> double click on  -->click on collection--> folder --> enter path of root folder --> select "traverse subfolder" checkbox regards, sekhar www.calsql.com SQL Server  >  SQL Server Integration Services