Posts

sql profiler trace what happens if a query did not complete

let sql porfiler  trace half hour. query started during time did not complete. show in trace? hi prem, it's depend on events have captured\selected while configuring profiler trace. example if running 1 query "select * table" , in profiler trace , if checked sql:batchstarting after if cancel query in case you  should able see query. , if selected sql:batchcompleted in case see same query @ 2 places regards, vikas rana vikas rana SQL Server  >  SQL Server Setup & Upgrade

Add Parameters in OLE DB Sourcec Container to loop through quarters

Image
good day, i have project 2 ole db sources, "ole db source 1 = prior qtr" ,  "ole db source 2 = current quarter." both sources merged , transformed these.  i've been manually entering prior quarter , current quarter every set of quarters need calculate. here need with: i'd have file ole db source goes out , picks prior quarter , current quarter, completes transformation, goes file , grabs other set of prior quarter , current quarter, , forth until package reaches last set of prior quarter , current quarter. old db source - prior quarter select [account_number] ,[current_balance] ,[payment_amount] ,[processing_date] [acct_data] processing_date = '03-31-2016' , limit_code not null ole db source - current quarter select [account_number] ,[current_balance] ,[payment_amount] ,[processing_date] [acct_data] processing_date = '06-30-2016' , limit_code not null i'd appreciate help/feedback. thank in adva...

Error creating new team project.

any appreciated.  after setting team foundation server tried create new team project (from team foundation client on application server...single server installation).  fails following error in project creation log: initialization plugin "microsoft.pcw.wss" failed error: "client found response content type of 'text/html', expected 'text/xml'. in advance, jeff please post text around line (there should exception, etc.).  also, user account running vs 2005?  installation guide specifies user used setup tfs, believe.  user trying create project must in namespace admistrators group in tfs. thanks. buck Archived Forums T-U  >  Team Foundation Server - Setup

how not going to fix

but feels being made scapegoat crimes brother accused of, lawyer anne-sophie laguens said manchester united vs fulham live stream - man utd vs fulham live stream - man utd vs fulham live stream - man utd vs fulham live stream - manchester united vs fulham live stream - manchester united vs fulham live stream - fulham vs man utd live stream - fulham vs man utd live stream - fulham vs manchester united live stream - manchester united vs fulham live stream - fulham vs man utd live stream - fulham vs manchester united live stream - man utd v fulham live stream - manchester united v fulham live - fulham v man utd live - fulham v manchester united live  - man utd v fulham live - fulham vs manchester united live stream Archived Forums SA-SM ...

Can't compile MFC app for Arm Platform

i able compile , run mfc app on arm platform, using vs beta & cp version of windows. when  moved rc version of windows 8 & vs12 discovered option blocked. why did happen , can changed/patched? need mfc app arm platform. thanks. hi evgeny,   i'm not msft let me try answer.. mfc intended desktop (so win8 pro : x86 , x64) technology. to target arm platform have use xaml in combination of c++ or c#, or html5/js, , create metro style app. the same comment can done drivers on arm platform : 'target' still exists in vs 2012rc, doesn't (i guess works in msft private versions of vs2012..). regards, julien julien racle Archived Forums T-U  >  Tailoring your Windows Store app for hardware and devices (archived) ...

I cannot connect to my basic SQL server from Visual Studio Ultimate 2013? Error 40 - Cannot establish connection

Image
i started learning asp.net through book, , asks connect "your" sql server , explore .mdf file. i've been trying install sql, got working installation, , won't let me install management software. whenever try connect, error: http://puu.sh/7f2jy.png this connect: 1) open project 2) navigate server explorer 3) click on connect database 4) in menu, can see me machine name on top part, think means it's picking server runningh 5) on bottom, wants me enter database name. think may problem, have no idea here. also, when double click on database file, errpr (52): http://puu.sh/7f2yw.png i don't know here, post tips down below hi, did choose correct server name? should machine name installed sql server on. is empty when open select or enter database name drop box in add connect dialog box in visual studio 2013? “update: re-installed, , used both installers. have server management tools, still cannot connect.” the screenshots indicates sql s...

Recovering SQL 2000 Database without the Log File not in clean disconnected state

we had hard drive crash here. able copy off .mdf file sql server 2000 from drive, not .ldf (which 720k anyhow). when try attach mdf sql server 2000 or 2005 server error saying log file doesn't exist. does know way attach not-cleanly-closed database file , recover data? (apparently person decided need-not backup database :<) thanks can provide! you may lucky , able attach sql 2005 instance , use attach_rebuild_log clause...try this: create database <x> on <filespec> attach_rebuild_log SQL Server  >  SQL Server Tools