Lun

can me convert crytal expression ssrs.?   datevar aodt := date({vw_rpt_inv_short_form_asof.as_of_date}); dateserial (year(aodt),month(aodt),0) fm hi farhan1, from information posted, see there need format value date data type, , return variant of subtype date specified year, month, , day. for format value date type, have cdate, formatdatetime functions in reporting services:          cdate(fields!<fieldname>.value)          formatdatetime(fields!<fieldname>.value, dateformat.shordate) for return variant of subtype date specified year, month, , day, have dateserial function in reporting services too:        dateserial(year(fields!<datefieldname>.value),month(fields!<datefieldname>.value),0) more information expression examples, please see: http://msdn.microsoft.com/en-us/library/ms157328(v=sql.110).aspx thanks, lola please remember mark replies answers if help.

hi,   using ant task build extensions tool , below way calling task. noticied out of 4 flash modules (swf files) 2 getting generated , 2 failing due code errors. team build not showing errors thrown ant. need set configurable properties make sure team build fails when ant build fails? <import project="$(msbuildextensionspath)\microsoft\visualstudio\v10.0\buildextensions\microsoft.teamfoundation.build.extensions.ant.targets" /> <ant teamfoundationserverurl="$(teamfoundationserverurl)"           buildfile="$(srcroot)\flash\build\build.xml"           builduri="$(builduri)"           anthome="$(ant_home)"           javahome="$(java_home)"           flavor="%(configurationtobuild.flavortobuild)"           platform="%(configurationtobuild.platformtobuild)"           properties="binariesroot=$(binariesroot);buildnumber=$(shortbuildnumber);sourcegetversion=$(sourcegetversion)&quo

i have installed team foundation server 2010 , connect server using non visual studio product. in previous versions of tfs msscci provider installed on client achieve this. i have installed team explorer came tfs 2010. tried install msscci 2008, install error microsoft visual studio 2008 team explorer or tools not installed. what need able connect fts 2010 server non vs client, , can down load it? many thanks tony hi, have tried installing tfs2010 msscci provider. can here: http://visualstudiogallery.msdn.microsoft.com/en-us/bce06506-be38-47a1-9f29-d3937d3d88d6 Archived Forums T-U  >  Team Foundation Server - Setup

dear all i have problem replication, so i want modify columns in table, database using replicate. how it? please solution. thank. pc kaveesin. if using sql 2005, can directly use 'alter table alter column..." modify column @ publisher. changes propagated subscribers. more info, please take @ http://msdn2.microsoft.com/en-us/library/ms151870.aspx .   peng SQL Server  >  SQL Server Replication

hi all i have following table code      name        day_of_week       start_time                                 end_time                                 minutes 0001      abc              0                     30/12/1899 10:50:00                 30/12/1899 12:10:00                null 0001      abc              1                     30/12/1899 10:50:00                 30/12/1899 12:10:00                null               0001      abc              1                     30/12/1899 12:10:00                 30/12/1899 13:30:00                null 0002      def              0                      30/12/1899 12:10:00                 30/12/1899 13:30:00                null 0002      def              1                      30/12/1899 10:50:00                 30/12/1899 12:10:00                null .................... ................................ ......................................   data type -  start_time, end_time , minutes datetime i want take

hello all, i using microsift sql server management studio 2005. i want take table backup data . how ? is possible sql server management studio 2005 ? is there data software ? thanks in advance. hello, it's not possible backup single table, cab backup complete database. you export data file the create script table+related objects, olaf helper * cogito ergo sum * errare humanum est * quote erat demonstrandum * wenn ich denke, ist das ein fehler und das beweise ich täglich blog xing SQL Server  >  SQL Server Express

hello, i have age dimension contains age of custemers.  i want make age grouping like 21-26  (21-23, 23-26)      27-35  (27-30, 31-35) 36-45 46-55 56-59 60++ the range has no pattern. there smart way make the age group. thanks alex   add named calc on customer table dsv e.g  case     when age between 21 , 23 '21-23'     when age between 24 , 26 '24-26'     ....     when age >=60then '60++'     else 'bellow 21' end        SQL Server  >  SQL Server Analysis Services

if installed ssis on same server later engine itself, have been installed @ earlier service pack engine?  did select @@version on engine , got   microsoft sql server 2005 - 9.00.1399.06 (intel x86)   oct 14 2005 00:33:37   copyright (c) 1988-2005 microsoft corporation  standard edition on windows nt 5.0 (build 2195: service pack 4)   i cant see way client service pack on ssis itself.   i'd sure suggestion 1 of contributors before approaching our technical guys failure install sp 2 of something.     db042188 wrote: if installed ssis on same server later engine itself, have been installed @ earlier service pack engine?  did select @@version on engine , got   microsoft sql server 2005 - 9.00.1399.06 (intel x86)   oct 14 2005 00:33:37   copyright (c) 1988-2005 microsoft corporation  standard edition on windows nt 5.0 (build 2195: service pack 4)   i cant see way client service pack on ssis itself.   i'd sure suggestion 1 of contributors befor

hi, have been developing application in .net 4, silverlight 4 , wcf ria services rc2 , have strange problem @ hand when deploying webhost. my webhost has .net 3.5, silverlight added mime , no installation of wcf server components. says cannot upgrade .net 4 or have wcf component installed, since shared hosting server. understanding of situation far is: 1. silverlight 4 not need specific server side installation, not issue. 2. wcf ria services need not installed on server. workaround including ria assemblies code of application while deploying iis virtual directory. 3. since .net 3.5 available on server, redevelop (essentially copy-paste) application in .net 3.5 , deploy that. possibly can afford since, not know of .net 4 specific feature have used in application. questions , problem: 1. possible can develop application .net 3.5, silverlight 4 , wcf ria services rc2? 2. installation of vs 2010 gives me option develop silverlight 4 app in 3.5, cannot see silverlig

we have environment whereby mirroring on 20 databases on 1 server. have not experienced noticable performance issues or other issues matter. however, wonder if may stretching limits of database mirroring or setting ourselves bad happen.   our environment (read application) dictates create new database each client. not see number of databases in our environment decreasing or stabillizing...only increasing.   i suppose, questions are: are heading towards issues having many databases mirrored? should looking @ alternative ways of segragating our clients' data (schemas, other) rather using separate databases? any assistance and/or opinion welcome.   it depends on various factors memory, bandwidth etc..paul has blogged this, please have @ it. http://www.sqlskills.com/blogs/paul/2007/11/09/conferencequestionspotpourri4howmanydatabasescanyoureallymirrorperinstance.aspx - deepak SQL Server

hello, i'm having trouble setting proxy account.  follow documentation, , under credentials, can select operator.  there way select account under security?    your appreciated! you need create credential on sql server instance before can use create sql server agent proxy. under security node in ssms.   SQL Server  >  SQL Server Integration Services

  hi all, english bad, try explain... when put string and contains ( pg . generictitlefulltxt , '"* dias *" , "* que *"and "* abalaram *" , "* mundo * "' ) in query, results show up.... put " * o * " in search string , not shows ..something linke and contains ( pg . generictitlefulltxt , '"* dias *" , "* que *"and "* abalaram *" , "* o * " , * mundo * "' ) all conditions "and" exists....in catalog have string dias que abalaram o mundo many times..bu if put "o" in search ...not shows nothing...   i droped catalog, indexes..rebuild..etc...   anyone can me ?   thanks.. first of all, should leave blank before , after words, word breaker has broken words in database small pieces can recognized. if words searching single words should leave * signs due same reasons mentioned above. jens k. suessmeyer --- http://www.sqlserver2005.d

hi,  i using tfs 2010 application , database version control. sql server read articles , using sql srcipts projects in sql server 2008 management studio. more difficulties in version control like 1. no sheling option available 2. sometime scripts not getting properly 3. someime same connections, scripts etc duplicating in solution explorer 4. team project multiple persons checkout database project , using. check-in time conflict came in solution file how use better version control in database? other method? found visual studio 2008 project in visual studio templates. can use same thing? better sql server objects database in ssms? or how can use exisitng 1 without issues specified? hi akhilrajau, thank post. according description of issue, can create database projects in vs , put them under tfs version control. to create database project can refer these articles: getting started database projects( http://msdn.microsoft.com/en-us/library/aa833257(vs.90).aspx ) , h

hi, i new ms ssis , i'm trying read data table using ado net source (from dwh) , push data mysql server table using odbc destination. i have mapped columns source target needed - have 7 integer fields , 1 date field. for date field in ado net source inside sql command using cast : "cast(getdate() date)  test_date " the query runs fine when run outside ssis , directly query database, while running package following error messages : [ado net source [2]] error: error "specified cast not valid." occurred while processing "ado net source.outputs[ado net source output].columns[test_date]". [ado net source [2]] error: ssis error code dts_e_inducedtransformfailureonerror.  the "ado net source" failed because error code 0x80004002 occurred, , error row disposition on "ado net source.outputs[ado net source output].columns[test_date]" specifies failure on error. error occurred on specified object of specified component.  

hi all, is there equivalent function of averageofchildren() in dax? or has come across implementation of tabulal model same. thanks. sandeep please specify sql server version while posting questions please mark answer if solved issue please vote helpful if helps solve issue hi liquidloop, in dax, achieve semi-additive measure average of children, can use sum() total divide by distinctcount() of child members. =sum([ facts ])/distinctcount([ child ]) for more information defining semi additive measures in dax, please refer links below: semi additive measures in dax / bism tabular semi-additive measures in dax regards, simon hou technet community support SQL Server  >  SQL Server Analysis Services

hi, i have 1 questions. have done plugin mining sequential patterns. when start plugin algorithm first time (pc reboot, server restart, ...)  data loaded fast (i mean executin all: processcase), but when run algortihm next time data loading slow (10-times , worth). what can problem? thanks advice. edit: using managed plugins version. if relevant code or query exist..could please share it..? think more of performance terms SQL Server  >  Data Mining

hi, we have tfs build server , have configured tfs build service run interactively on build machine. domain account being used start service. account auto logs off , build service stopped.  request: how prevent account auto log off , want service , running interactively. please share thoughts. also, if have used ps/batch scripts control this, please pass on thanks in advance venkatesan nadimuthu 0 hi,  i found solution.  the above workaround did not us.  technet article below helped configure remote desktop session time out settings. set never , worked. build service working expected. https://technet.microsoft.com/en-us/library/cc754272.aspx hope helps! venkatesan nadimuthu Archived Forums V  >  Team Foundation Server - Build and rel

hi,   i novice trying create database use on website. when try connect database in visual web developer express error message generating user instances in sql server disabled. use sp_configure 'user instances enabled' generate user instance.   i have tried find how this, can find no reference using sp_configure.   can me resolve issue, please? have both sql server 2005 express edition , sql server compact edition on pc.   i running windows xp home edition.   many thanks   roger l you have this:   sp_configure 'show advanced options' , '1' go reconfigure go sp_configure 'user instances enabled' , '1' go reconfigure go     SQL Server  >  SQL Server Database Engine

the report 3,385 kb in report builder 2016. once in while when in preview, parameter area grayed out , cannot select parameters. have close report builder , open disappear.  any ideas? hi zenyk, according description, 1. may know if issue related 1 report (3385kb)? other reports parameters , can render correctly in report builder? 2. have tried deploy report report server , when preview there, meet same issue?  3. please share report design? 4. besides, there error information prompting when preview report?  if there 1 report issue, related loading performance. improve performance of reporting service, can refer sql server reporting services best practices performance , maintenance.  best regards, henry  SQL Server  >  SQL Server Reporting Services, Power View

  i downloaded sql server express 5.0 and know - must open sqlserver through studio like sql server management studio express, or can open on own?  come gui inside it?   i clicked start/all programs/microsoft sql server 2005 , submenues displayed, not server itself.  submenues were configuration tools sql server management studio express.   thanks. you have use management studio express edition admin purpose. can not open database file (mdf &ldf) directly double clicking.   you have opend management studio , connect server.   madhu SQL Server  >  SQL Server Express

hi, i running sql server 2008 r2 on san disk around 20 databases. have 4 different production servers , hosted on same server. latency happening quite , our department straightway blame sql this. monitor sql , can't find evidence of latency. when notice department there latency jump on , run sp_who2 check , of time don't odd running. did notice on occusion there alot high disk i/o reading. i running performance monitor not sure how capture event.  is there way in sql server can capture , when happens(email or eventlog). want see if sql causing problem or there other server causing bottleneck. my favourite sys.dm_io_virtual_filestats. run procedure below interval , use query below analyse data. it's columns avg_read/write_time_ms of interest. a spinning disk has latency of 9.5 ms typically, on 15 ms warning sign. unfortunately, not unusual sans see lot worse. create procedure [dbo].[vfsmonitor] as set nocount on if object_id('vfsdata') null begi

environment : ssrs 2008r2, pps2010, connected ssas2008r2 cube problem description:  i have series of reports deployed report server (native mode) embedded in sp through performancepoint services. these reports query ssas cube, both filters , data. filter plain text. reports can rendered without problems in sp pps dashboard. performancepoint filters render , correctly connect reports. however, exporting excel (using webpart menu) not work , gives following error: "this report requires default or user-defined value report parameter '<parameter name>'. run or subscribe report, must provide parameter value. (rsreportparametervaluenotset)" apparently pps parameters not correctly passed excel renderer. export excel work fine if try in report designer. question : there known issues excel rendering pps web part? or missing settings. thanks reply, jeroen. had tested scenario in ie9 , ie8, both of them works fine if choose other values parameter. please cons

i have sql called creates half dozen jobs. these jobs have external dependencies means not want them run designated schedules until dependencies fulfilled - hence include following line @ hthe end of sql creates jobs :- update sysschedules set enabled=0 [name] '%rrd%' (all jobs prefixed rrd). if view jobs in management studio can see schedules indeed not enabled - still run , of course fail. or invoking these jobs @ scheduled time if schedule disabled. neeed disable jobs schedules seems overkill. (i because used leave schedules enabled diable jobs did not work either jobs still ran!) when disable job through management studio (right click disable), not disable job , disable schedule job. if update table (sysjobs) directory, miss update sysschedules tables start the job per schedule. right way disable job through t-sql use sp_update_job procedure exists under msdb database. eg exec msdb.dbo.sp_update_job @job_name = 'test',@enabled = 0 vidhya sagar. mark answer if hel

hi all, i prepared xml through c# xml serializer. how change below xml temp table  '<arrayofint xmlns:xsi="http://www.w3.org/2001/xmlschema-instance" xmlns:xsd="http://www.w3.org/2001/xmlschema"> <int>63</int> <int>13</int> <int>12</int> <int>15</int> <int>16</int> <int>35</int> </arrayofint>'  please help.. try this: declare @xml xml set @xml = '<arrayofint xmlns:xsi="http://www.w3.org/2001/xmlschema-instance" xmlns:xsd="http://www.w3.org/2001/xmlschema"> <int>63</int> <int>13</int> <int>12</int> <int>15</int> <int>16</int> <int>35</int> </arrayofint>' select a.c.value('.', 'int') @xml.nodes('arrayofint/int') a(c) SQL Server

i running demo vm , when following hands-on lab field mappings, getting error when downloading default mappings via vs command prompt: tf244088: run command, must have been granted administer project server integration permission on team foundation server " http://tfsdemo:8080/tfs/defaultcollection ". i logged in lina abola lab instructs, still above error.  idea going on? jp are running visual studio command prompt (2010) as administrator? blog | facebook | twitter | posting provided "as is" no warranties, , confers no rights. project server techcenter | project developer center | project server help | project product page Archived Forums T-U  >  Team Foundation Server and Project Server Integration

my code below. gives me error message says: an error has occurred while establishing connection server.  when connecting sql server 2005, failure may caused fact under default settings sql server not allow remote connections. (provider: sql network interfaces, error: 26 - error locating server/instance specified) my code is: sqlconnection testconnection = new sqlconnection();         sqldataadapter testadapter = new sqldataadapter();         datatable testtable = new datatable();         int rowposition = 0; private void mainform_load(object sender, eventargs e)         {             this.marketstatus();             testconnection.connectionstring = @"data source=i:\documents\visual studio 2005\projects\stockproject\stockproject\stocks.sdf;integrated security=sspi";             testconnection.open();             testadapter = new sqldataadapter("select * stockinfo", testconnection);             sqlcommandbuilder testcommandbuilder = new sqlcommandbuilder(testadapter

can telll me full procedure install windows xp usb(pin) drive im afraid these incorrect forums question. these forums software development only. the best place ask either contact local computer technical support shop or ask here: http://www.microsoft.com/windowsxp/expertzone/newsgroups/reader.mspx?dg=microsoft.public.windowsxp.setup_deployment&lang=en&cr=us thanks   Archived Forums V  >  Team Foundation Server - General

  i have sql 2005 , iis 5.1 i configure olap web site , works ok.   but don't know why stops working, , now i don't see cubes have check security settings in iis , it's ok if browse http://localhost/olap/msmdpump.dll  works fine. but if try connect sql server don't show me cube. if try create cube show me error "either machine\iusr_user user not have permission create new object in machine, or object not exist" SQL Server  >  SQL Server Analysis Services

i’m looking info how sqlio parameters should set simulate sql server behavior possible: 1.        the <number of threads (per test file)>   in datafile setup. according documentation should set equal number of cpu’s. told sql server use 1 io tread per datafile accesses. should value remain 1? 2.        –o parameter (the number of outstanding i/o > requests). should put here value of disk queue length available in perfmon? thanks geert vanhove 1.        the <number of threads (per test file)>   in datafile setup. according documentation should set equal number of cpu’s. told sql server use 1 io tread per datafile accesses. should value remain 1? not sure info came from, sql server i/o asynchronous , use available worker in pool. start using 1 thread per distinct disk when first create database , files created/initialized first time that's all. it's resource availability dependent after that, no 1-1 mapping or that. if only used 1 threa

  hi,     knows how find out ther bit version in sql  , windows os (32 or 64)   regards, s.balavenkatesh   microsoft sql server 2005 - 9.00.1399.06 (intel x86) oct 14 2005 00:33:37 copyright (c) 1988-2005 microsoft corporation standard edition on windows nt 5.2 (build 3790: service pack 2)     intel x86)   -- says sql server 32 bit   madhu SQL Server  >  SQL Server Tools

hi all, i have received sql server 2000 transactional replication publisher database log file full. getting error like: the log file database 'xxxxx' full. transaction log for database free log space. i can not shrink log file, full. , drive log full 100% if replication take care of log file shrink? if add log file in database drive, shrink log file later. if run tlog backup or use dbcc shrinkfile before doing above steps, safe? production sql server instances. please advise me deligently pros , cons. jay yes, safe run tlog backup , shrink file. make sure log reader agent working. looking book on sql server replication? http://www.nwsu.com/0974973602.html looking book on sql server 2008 administration? http://www.amazon.com/microsoft-server-2008-management-administration/dp/067233044x looking book on sql server 2008 full-text search? http://www.amazon.com/pro-full-text-search-server-2008/dp/1430215941

we have reporting service (not sql reporting service) using stored procedures provide data reports. reports on transactional data directly. run timeout exception time time on production server. we can tune query run faster , hope not collide other threads updating same tables. or consider replicating transactional data dedicated reporting database run reports against. wondering right design/pattern such task is. e.g. creating reporting database right approach solve problem? can achieve selecting right isolationlevel? we use sql 2005 , read_comitted both transactional data updates , report sps. thanks hi wan zeng, if not need real-time reports, suggest creating dedicated database generating reports instead of accessing production database. can use etl tool transfer data f @ regular intervals sync production , reporting databases.   please see: http://sqlserverpedia.com/blog/sql-server-bloggers/reporting-on-your-oltp-system/ http://grounding.co.za/blogs/brett/archiv

hi, have installed mysql connector "mysql-connector-odbc-5.2.2-winx64.msi" , tried installing ssma mysql 5.2. error message while installing ssma mysql 5.2 saying " set unable find mysql odbc driver v.5.1 , above". tried "mysql-connector-odbc-5.1.11-winx64.msi" still got same error. can create dsn , test connection odbc connector. system installed software of sql server 2008 r2. thanks, umakanta try install 32-bit mysql odbc driver. maybe need microsoft mdac ( microsoft data access components (mdac) 2.8 sp1 ) SQL Server  >  SQL Server Migration

french characters being transformed unrecognizable characters working pb12.5 did experience also? if yes fix if there one? tfs patch? thanks. marcel hi marcel,   thanks post. what’s version of tfs , tfs server installed using language. we trying better understand customer views on social support experience, participation in interview project appreciated if have time. helping make community forums great place. click here participate survey. Archived Forums V  >  Team Foundation Server - General

one of new users running visual studio 2008 sp1 on windows server 08 connecting tfs 2010.  every few hours workspace disappears server. him able re-create it, has delete local cache , have remove rights project , add them back, otherwise gets error not having adminworkspaces global permissions.  server level admin pretty sure it's not else being malicious or playing pranks.   i've tried 1) changing password, having him create workspace , work disconnected. (thinking running him deleting workspace)  workspace still gets deleted 2) having him create second account on local machine , create multiple workspaces across both local users.  (thinking local environment) of them deleted, though he's on different local user. 3) deleting account in ad , re-created it, gets new sid. (thinking server thing account)  start over, workspace still gets deleted.   is there log somewhere can monitor or turn see what/who deleting workspaces user? other ideas check or change?  

hi all, i have installed sql server 2008 r2 enterprise edition (64-bit) on a new server , restored sql 2005 database on it. have added login (an ad group) server role , database role membership as 'public'.  same settings on sql 2005 database server.  i getting following error when trying execute update query sql 2008 server works fine on sql server 2005. the update permission denied on object 'table1', database 'database1', schema 'dbo' i have compared sql 2005 , sql 2008 security logins , roles, both same.  this has been fixed. restared server have noticed has not been restarted after installation of sql server 2008. now, update query working fine without errors. have unchecked 'db_datareader' & 'db_datawriter' , query working fine. thanks lot. thank mr. wolter, appreciate help... SQL Server

to can me   we have application written in straight asp, upgraded our sql database connecting application sql 2000 2005  here issue   currently sql 2005 located in our test , uat environments, sql 2005 not clustered in either location.  let me make clear problem not happening in our test environment, repeat problem not happening in our test enviroment, problem happening in our uat enviroment   each enviroment outfitted following sql 2005 environment, enterprise edition sp1 cumlative hotfix package 2153  siss fix only   now problem this,  have vb program located directly on server has sql 2005 on vb program inserts timestamp table inside database, how happens program connects database , opens recordset forwardonly cursor , inserts timestamp   now exact problem vb program cannot open multiple recordsets, error received labled this   odbc driver error 8000405 shared memory sql doesnt exist or accessed denied,   now here interesting part, again not happening in

hi, 1 of parameters user has choose drop down control. control, populates names , each 1 has id. id gets passed. question: how can name of selected item drop down parameter onto report? thanks hi  arkiboys, you need make use of expression as: =parameters!reportparameter1.label parameters!reportparameter1.value return id , parameters!reportparameter1.label return name. repalce reportparameter1 actual name of parameter. and if in case parameter multiselect one, have write expression =join(parameters!reportparameter1.label, ",") let me know if need more info. hth. cheers, iceqb please mark correct answers :) SQL Server  >  SQL Server Reporting Services, Power View

hi, we have tried deploy sql server 2012 our development machines sccm 2012 without success. commandline parameters or configuration.ini in either case installation failed without useful errorlog. exists howto covers this scenario? regards genne hello, please see following article requirements sql server instances intended sccm 2012: http://www.sqlcoffee.com/tips0019.htm please check see if summary.txt log file exists after installation attempts? following article may locate file on disk: http://technet.microsoft.com/en-us/library/ms143702(v=sql.110) please share log file us, if possible. hope helps. regards, alberto morillo sqlcoffee.com SQL Server  >  SQL Server Setup & Upgrade

hi all, i'm new sql , mdx in general i'm trying build following , maybe guys can me. i have snowflake database table containing subscription. each subscription has date/time @ starts , date/time @ terminated: subscription: id start_date end_date .... 100 10-jul-2005 17:00 10-aug-2005 11:00 ... 101 11-jun-2005 17:00 12-dec-2006 18:00 ... 102 1-may-2005 17:00 17-jan-2007 13:00 ... 103 10-apr-2005 17:00 10-sep-2005 15:00 ... and there dimension-table called datetime: id year month .... 10-jul-2005 17:00 2005 06 ... 10-jul-2005 18:00 2005 06 ... ... .. .. ... 11-jul-2005 17:00 2005 06 ... 11-jul-2005 18:00 2005 06 ... as generate count-measures start-date , end-date (e.g. number of subscriptions started @ given moment: 1 started @ 10-jul-2005 17:00). want know how many subscription active @ given moment (e.g. 0 @ 1-jan-2005 12:00, 2 @ 1-jan-2006 12:00 , 4 @ 1-aug-

recently azure shut down sql plan using , didn't make recommendation substitute.  we migrated new sql plan ended costing 10 times more. migrate plan similar old 1 can't find information choice. can shed light on issue? leongrin hello leongrin, the standard s0 performance level still available in sql database , should able select database. are not able see performance level in portal? getting error message when try use it? thanks, jan Microsoft Azure  >  Azure SQL Database

hi, i executiong sqlprofiler. i want check host_name or ipaddress of user.. becoz easy track users activity on database.. when run profiler has given eventclass,spid,clientprocessid,textdata etc..how identify users activity through sqlprofiler most of users deleting storedprocedure,functions so how track users or how ipaddress sqlprofiler sql server profiler not expose ipadress, can hostname, username (databae user) , loginname. default of settings not enabled @ templates can check them going event selection tab , check appropiatr properties @ matrix. if want ipadress , know user longer connected, can use spid , information dmv select   client_net_address from sys . dm_exec_connections -jens jens k. suessmeyer http://blogs.msdn.com/jenss SQL Server  >  SQL Server Tools

i wish microsoft inform licensing department cal's come retail tfs product. the white paper  states tfs retail product comes 5 eula licenses microsoft licensing department mention volume license tfs server product doesnt come cal's retail product comes cals ?!? the tfs cals arent cheap, around $500+ whereas server product around $2600 adding into  mix msdn visual subscription 1 tfs cal , server product can installed "production" instance. so in summary ..does sound right  : 1. purchase retail tfs 5 cals (this install only) 2. vl tfs 0 cals + 5 purchased additional cals 3. msdn tfs 1 cal + 4 purchased cals.   micatio software free iis azure web log app yes, sounds right.  volume licenses not come 5 cals in retail license.  if have follow questions, can contact msdn subscription helpline numbers, http://msdn.microsoft.com/en-us/subscriptions/aa948875.aspx please remember mark replies answers if help. blog: http://geekswithblogs.net/taru

can tell me how user gets lockedout in sql 2005. ?   i guessing refer login being locked out because of password policy , correct? stswordman suggested, can use alter login manually enable/disable account again. detailed information, please refer bol.     there known windows bug may affecting having premature lockout. more details please refer ( kb 818087: user account may prematurely locked out ).        i hope information helps. please let know if have further questions, glad help.   -raul garcia   sde/t   sql server engine SQL Server  >  SQL Server Security

 hi ... although visited expression tools website, i´m bit confused main differences between expression versions, plus example: don´t think expression web better using visual studio css editor, since hand coding everything: css, html, javascript, etc, plus don´t see features collapse points in expression web have in visual studio, regarding expression , silverlight have no idea relationship between ... need use expression or can silverlight app visual studio? tips? personal conclusions based on self usage of thoses apps? expression blend 2 (may preview: http://go.microsoft.com/fwlink/?linkid=79076&clcid=0x409 ) can used author silverlight 1.0/1.1 applications , provides rich design-time experience manipulate xaml , timelines.  in addition, visual studio "orcas" beta 1 preview silverlight tools aid in managed code/javascript code of silverlight applications.  can silverlight app notepad if you'd like, using expression blend lot of ui elements faster/n

my school has recorded lectures playing on silverlight , has 1 video stream slides , 1 video stream classroom itself. these play concurrently , no problems in firefox or ie.  i have been unable second video (classroom stream) ever work in chrome , have been unsuccessful in searching forums , silverlight faqs several months. it's not critical problem, it's annoyance. i have discovered these problems windows 7 home premium 32-bit, windows 7 ultimate 64-bit, windows 8, , windows 8.1, running latest versions of chrome , silverlight. issue has been continuous several months , running video stream in incognito chrome presents same issue. silverlight on chrome: https://dl.dropboxusercontent.com/u/779803/silverlight.png silverlight on ie: https://dl.dropboxusercontent.com/u/779803/silverlight%20ie.png hello, do mean second video (classroom stream) not work in chrome? first video work in chrome? if not work in chrome, suggest check if chrome silverlight plugin enabled, h

sql server guru's, we follows weekly/ monthly/ quarterly sql server reboot general practice, did not came across recommendations ms after days sql services/ server needs restarted? please guide..thank in advance regards, nilesh - nilesh in addition olaf response, may ask reason doing reboot? have seen people lot of times, wanted clear stuff, clean statistics, clear memory cache, rebuild indexes, , on. sql server have build in options actions. if reason reboot, please don't , try use options example clean memory: dbcc freeproccache http://msdn.microsoft.com/en-us/library/ms174283.aspx removes clean buffers buffer pool: dbcc dropcleanbuffers http://msdn.microsoft.com/en-us/library/ms187762.aspx reset wait , latch statistics.: dbcc sqlperf http://msdn.microsoft.com/en-us/library/ms189768.aspx drops statistics: drop statistics http://msdn.microsoft.com/en-us/library/ms175075.aspx reorganize , rebuild indexes http://msdn.microsoft.com/en-us/lib