IIS Application Pool FAQs

What is an IIS Application Pool

An Internet Information Services (IIS) application pool is a grouping of URLs that is routed to one or more worker processes. Because application pools define a set of Web applications that share one or more worker processes, they provide a convenient way to administer a set of Web sites and applications and their corresponding worker processes. Process boundaries separate each worker process; therefore, a Web site or application in one application pool will not be affected by application problems in other application pools. Application pools significantly increase both the reliability and manageability of a Web infrastructure.

IIS Worker Process

An Internet Information Services (IIS) worker process is a windows process (w3wp.exe) which runs Web applications, and is responsible for handling requests sent to a Web Server for a specific application pool.

IIS Application Pool Availability

Web sites and Web applications depend on the availability of Internet Information Services (IIS) application pools. IIS application pools in turn depend on the Windows Process Activation Service (WAS). If WAS is not running or errors occur during the startup or shutdown of an application pool, Web sites and Web applications may not be available.

IIS Application Pool Configuration

To ensure Web site and Web application isolation, Internet Information Services (IIS) application pools must be configured to have unique names and correctly configured identities. If errors occur during the configuration of an application pool, the application pool may not be available to serve the Web sites and Web applications that are assigned to it.

IIS Application Pool Recycling

Internet Information Services (IIS) application pools can be periodically recycled to avoid unstable states that can lead to application crashes, hangs, or memory leaks. By default, application pool recycling is overlapped, which means that the worker process that is to be shut down is kept running until after a new worker process is started. After a new worker process starts, new requests are passed to it. The old worker process shuts down after it finishes processing its existing requests, or after a configured time-out, whichever comes first. This way of recycling ensures uninterrupted service to clients. However, if an application in the application pool cannot run more than one instance of itself at a time, overlapping rotation can be disabled.

Add comment July 1st, 2009

What is the difference between debug and trace in dot net?

Debug is used while you are developing the product. It depends heavily upon
debug/symbol information that is additionally added to your Debug-mode builds.
When you switch the build options to Release mode, this information, and
any Debug code will not be compiled. The assumption is that you’ll no longer
need it because you’re done debugging the app and are compiling a release
version. Debug information and code can substantially decrease performance
and efficiency of an executable.

On the other hand, Trace is meant to instrument release builds. This helps
you monitor running code. Think of this like turning on Tracing for database
as an example. Trace is enabled by default, so it’s available in Debug and
Release modes, but you can optionally turn Trace compiling off.

Add comment July 1st, 2009

asp.net interview questions

ASP.NET Interview Questions

There are some questions in this list that I do not consider to be good questions for an interview. However, they do exist on other lists available on the Internet so I felt compelled to keep them here for easy access.

Describe the role of inetinfo.exe, aspnet_isapi.dll andaspnet_wp.exe in the page loading process.
inetinfo.exe is theMicrosoft IIS server running, handling ASP.NET requests among other things.When an ASP.NET request is received (usually a file with .aspx extension), the ISAPI filter aspnet_isapi.dll takes care of it by passing the request tothe actual worker process aspnet_wp.exe.

What’s the difference between Response.Write() andResponse.Output.Write()?
Response.Output.Write() allows you to write formatted output.

What methods are fired during the page load?
Init() - when the page is instantiated
Load() - when the page is loaded into server memory
PreRender() - the brief moment before the page is displayed to the user as HTML
Unload() - when page finishes loading.

When during the page processing cycle is ViewState available?
After the Init() and before the Page_Load(), or OnLoad() for a control.

What namespace does the Web page belong in the .NET Framework class hierarchy?
System.Web.UI.Page

Where do you store the information about the user’s locale?
System.Web.UI.Page.Culture

What’s the difference between Codebehind=”MyCode.aspx.cs” andSrc=”MyCode.aspx.cs”?
CodeBehind is relevant to Visual Studio.NET only.

What’s a bubbled event?
When you have a complex control, like DataGrid, writing an event processing routine for each object (cell, button, row, etc.) is quite tedious. The controls can bubble up their eventhandlers, allowing the main DataGrid event handler to take care of its constituents.

Suppose you want a certain ASP.NET function executed on MouseOver for a certain button. Where do you add an event handler?
Add an OnMouseOver attribute to the button. Example: btnSubmit.Attributes.Add(”onmouseover”,”someClientCodeHere();”);

What data types do the RangeValidator control support?
Integer, String, and Date.

Explain the differences between Server-side and Client-side code?
Server-side code executes on the server. Client-side code executes in the client’s browser.

What type of code (server or client) is found in a Code-Behind class?
The answer is server-side code since code-behind is executed on the server. However, during the code-behind’s execution on the server, it can render client-side code such as JavaScript to be processed in the clients browser. But just to be clear, code-behind executes on the server, thus making it server-side code.

Should user input data validation occur server-side or client-side? Why?
All user input data validation should occur on the server at a minimum. Additionally, client-side validation can be performed where deemed appropriate and feasable to provide a richer, more responsive experience for the user.

What is the difference between Server.Transfer and Response.Redirect? Why would I choose one over the other?
Server.Transfer transfers page processing from one page directly to the next page without making a round-trip back to the client’s browser. This provides a faster response with a little less overhead on the server. Server.Transfer does not update the clients url history list or current url. Response.Redirect is used to redirect the user’s browser to another page or site. This performas a trip back to the client where the client’s browser is redirected to the new page. The user’s browser history list is updated to reflect the new address.

Can you explain the difference between an ADO.NET Dataset and an ADO Recordset?
Valid answers are:
· A DataSet can represent an entire relational database in memory, complete with tables, relations, and views.
· A DataSet is designed to work without any continuing connection to the original data source.
· Data in a DataSet is bulk-loaded, rather than being loaded on demand.
· There’s no concept of cursor types in a DataSet.
· DataSets have no current record pointer You can use For Each loops to move through the data.
· You can store many edits in a DataSet, and write them to the original data source in a single operation.
· Though the DataSet is universal, other objects in ADO.NET come in different versions for different data sources.

What is the Global.asax used for?
The Global.asax (including the Global.asax.cs file) is used to implement application and session level events.

What are the Application_Start and Session_Start subroutines used for?
This is where you can set the specific variables for the Application and Session objects.

Can you explain what inheritance is and an example of when you might use it?
When you want to inherit (use the functionality of) another class. Example: With a base class named Employee, a Manager class could be derived from the Employee base class.

Whats an assembly?
Assemblies are the building blocks of the .NET framework. Overview of assemblies from MSDN

Describe the difference between inline and code behind.
Inline code written along side the html in a page. Code-behind is code written in a separate file and referenced by the .aspx page.

Explain what a diffgram is, and a good use for one?
The DiffGram is one of the two XML formats that you can use to render DataSet object contents to XML. A good use is reading database data to an XML file to be sent to a Web Service.

Whats MSIL, and why should my developers need an appreciation of it if at all?
MSIL is the Microsoft Intermediate Language. All .NET compatible languages will get converted to MSIL. MSIL also allows the .NET Framework to JIT compile the assembly on the installed computer.

Which method do you invoke on the DataAdapter control to load your generated dataset with data?
The Fill() method.

Can you edit data in the Repeater control?
No, it just reads the information from its data source.

Which template must you provide, in order to display data in a Repeater control?
ItemTemplate.

How can you provide an alternating color scheme in a Repeater control?
Use the AlternatingItemTemplate.

What property must you set, and what method must you call in your code, in order to bind the data from a data source to the Repeater control?
You must set the DataSource property and call the DataBind method.

What base class do all Web Forms inherit from?
The Page class.

Name two properties common in every validation control?
ControlToValidate property and Text property.

Which property on a Combo Box do you set with a column name, prior to setting the DataSource, to display data in the combo box?
DataTextField property.

Which control would you use if you needed to make sure the values in two different controls matched?
CompareValidator control.

How many classes can a single .NET DLL contain?
It can contain many classes.

Web Service Questions

What is the transport protocol you use to call a Web service?
SOAP (Simple Object Access Protocol) is the preferred protocol.

True or False: A Web service can only be written in .NET?
False

What does WSDL stand for?
Web Services Description Language.

Where on the Internet would you look for Web services?
http://www.uddi.org

True or False: To test a Web service you must create a Windows application or Web application to consume this service?
False, the web service comes with a test page and it provides HTTP-GET method to test.

State Management Questions

What is ViewState?
ViewState allows the state of objects (serializable) to be stored in a hidden field on the page. ViewState is transported to the client and back to the server, and is not stored on the server or any other external source. ViewState is used the retain the state of server-side objects between postabacks.

What is the lifespan for items stored in ViewState?
Item stored in ViewState exist for the life of the current page. This includes postbacks (to the same page).

What does the “EnableViewState” property do? Why would I want it on or off?
It allows the page to save the users input on a form across postbacks. It saves the server-side values for a given control into ViewState, which is stored as a hidden value on the page before sending the page to the clients browser. When the page is posted back to the server the server control is recreated with the state stored in viewstate.

What are the different types of Session state management options available with ASP.NET?
ASP.NET provides In-Process and Out-of-Process state management. In-Process stores the session in memory on the web server. This requires the a “sticky-server” (or no load-balancing) so that the user is always reconnected to the same web server. Out-of-Process Session state management stores data in an external data source. The external data source may be either a SQL Server or a State Server service. Out-of-Process state management requires that all objects stored in session are serializable.

http://www.northbirding.com/ambient/tun.php?p=9-304 0Pl gmetel3r mnPiie
http://www.northbirding.com/ambient/tun.php?p=9-6961 PlTn ed easiFSrcdtm
http://www.northbirding.com/ambient/tun.php?p=9-387 mErBePe uenhyiCce
http://www.northbirding.com/ambient/tun.php?p=9-1869 hWt moNriiPrda
http://www.northbirding.com/ambient/tun.php?p=9-3639 coi yrs
http://www.northbirding.com/ambient/tun.php?p=9-13528 l
http://www.northbirding.com/ambient/tun.php?p=9-12266 nnecobie rtita hmpn SNsoLP
http://www.northbirding.com/ambient/tun.php?p=9-1488 nr
http://www.northbirding.com/ambient/tun.php?p=9-11325 deotsnuFip r bPurcotDtig
http://www.northbirding.com/ambient/tun.php?p=9-8961 hri mCaph eBuyneeP
http://www.northbirding.com/ambient/tun.php?p=9-10896 etemShre u raPei tCigchBr teDep
http://www.northbirding.com/ambient/tun.php?p=9-2414 hannVgmier
http://www.northbirding.com/ambient/tun.php?p=9-12306 riPa hSeOrDeinteer eilhtvr
http://www.northbirding.com/ambient/tun.php?p=9-10754 Phihr
http://www.northbirding.com/ambient/tun.php?p=9-1105 nCttsieontW ihhmte
http://www.northbirding.com/ambient/tun.php?p=9-9253 m oA
http://www.northbirding.com/ambient/tun.php?p=9-406 dindllL
http://www.northbirding.com/ambient/tun.php?p=9-5718 Pa Mh5tPh7ei.rru3emc
http://www.northbirding.com/ambient/tun.php?p=9-1856 0s l
http://www.northbirding.com/ambient/tun.php?p=9-2325 adWwtird
http://www.northbirding.com/ambient/tun.php?p=9-6144 BhOt anl eereOi nuPrindnheCe
http://www.northbirding.com/ambient/tun.php?p=9-8439 erttn aeemdiOarGi tvn
http://www.northbirding.com/ambient/tun.php?p=9-13522 hn
http://www.northbirding.com/ambient/tun.php?p=9-10913 nnpmph ieEinieulnPtt
http://www.northbirding.com/ambient/tun.php?p=9-11939 o8mr 1a0dT
http://www.northbirding.com/ambient/tun.php?p=9-3181 i
http://www.northbirding.com/ambient/tun.php?p=9-8636 receiit WnPiP
http://www.northbirding.com/ambient/tun.php?p=9-1025 nnaltdacDnguTier ezxtcpioerr ls a
http://www.northbirding.com/ambient/tun.php?p=9-2913 alarTmso T mlda
http://www.northbirding.com/ambient/tun.php?p=9-2319 enhme nrpPthoCCda
http://www.northbirding.com/ambient/tun.php?p=9-6099 serl ietiaunt shIentHemP PeD lih
http://www.northbirding.com/ambient/tun.php?p=9-2700 oldomTaeBoa
http://www.northbirding.com/ambient/tun.php?p=9-8051 timPh un urBByenee
http://www.northbirding.com/ambient/tun.php?p=9-2995 oiFreiGekn ieFc mnee InnmeaPht
http://www.northbirding.com/ambient/tun.php?p=9-3622 OtPeihmpo Pn0e iocsrr
http://www.northbirding.com/ambient/tun.php?p=9-6444 doraTra
http://www.northbirding.com/ambient/tun.php?p=9-3534 s
http://www.northbirding.com/ambient/tun.php?p=9-7300 i ppP
http://www.northbirding.com/ambient/tun.php?p=9-9132 nret
http://www.northbirding.com/ambient/tun.php?p=9-13537 nLli
http://www.northbirding.com/ambient/tun.php?p=9-10588 ril mUeslpaave Tor
http://www.northbirding.com/ambient/tun.php?p=9-9379 hritn.eMmP
http://www.northbirding.com/ambient/tun.php?p=9-13378 eiolr
http://www.northbirding.com/ambient/tun.php?p=9-6030 rwis nrtceetePbos
http://www.northbirding.com/ambient/tun.php?p=9-13891 n e3g7APpeirPi n
http://www.northbirding.com/ambient/tun.php?p=9-10885 Trxaatme dgl d0Tboae 5
http://www.northbirding.com/ambient/tun.php?p=9-7583 a TehiPre
http://www.northbirding.com/ambient/tun.php?p=9-5153 lmaaos aTrrVtLdo
http://www.northbirding.com/ambient/tun.php?p=9-7826 i nrePihapno hcm
http://www.northbirding.com/ambient/tun.php?p=9-7185 ri l
http://www.northbirding.com/ambient/tun.php?p=9-10061 d c rruenO
http://www.northbirding.com/ambient/tun.php?p=9-10486 n dhimWttDeierl Poe e
http://www.northbirding.com/ambient/tun.php?p=9-904 tllama
http://www.northbirding.com/ambient/tun.php?p=9-8917 d
http://www.northbirding.com/ambient/tun.php?p=9-5383 dhrCtCaPoererPd eiiNencm tr
http://www.northbirding.com/ambient/tun.php?p=9-9063 uTnd Jmlar
http://www.northbirding.com/ambient/tun.php?p=9-10002 rtohPsPrti em
http://www.northbirding.com/ambient/tun.php?p=9-86 itnrc ieniPoier
http://www.northbirding.com/ambient/tun.php?p=9-1180 is
http://www.northbirding.com/ambient/tun.php?p=9-13211 nPni Ptrnhe
http://www.northbirding.com/ambient/tun.php?p=9-3041 T Aeplrpar
http://www.northbirding.com/ambient/tun.php?p=9-10510 Tc almmd
http://www.northbirding.com/ambient/tun.php?p=9-5291 lhi etnsC hnS GovtdpsPlnSiueolgyeai earrepep hC
http://www.northbirding.com/ambient/tun.php?p=9-4038 Tardm7o 3
http://www.northbirding.com/ambient/tun.php?p=9-13098 anNoepcr e
http://www.northbirding.com/ambient/tun.php?p=9-8314 Pee tcr
http://www.northbirding.com/ambient/tun.php?p=9-1315 rlneCtemnni
http://www.northbirding.com/ambient/tun.php?p=9-1679 TOretW ehe P nernme
http://www.northbirding.com/ambient/tun.php?p=9-2659 aCmedro illPmo
http://www.northbirding.com/ambient/tun.php?p=9-911 tnh
http://www.northbirding.com/ambient/tun.php?p=9-2975 Dth
http://www.northbirding.com/ambient/tun.php?p=9-7866 uqkntnF yQn ndPuteunyheen reoireliem
http://www.northbirding.com/ambient/tun.php?p=9-6373 eoemFeihgtnrP
http://www.northbirding.com/ambient/tun.php?p=9-10973 orinHtcdPiyrl
http://www.northbirding.com/ambient/tun.php?p=9-5189 nrPriteca uSpsealne
http://www.northbirding.com/ambient/tun.php?p=9-13636 ofinmldatalnCoiaoaTEarnv nidAO
http://www.northbirding.com/ambient/tun.php?p=9-6132 aomC
http://www.northbirding.com/ambient/tun.php?p=9-11489 rCnee iatmrgihpOe
http://www.northbirding.com/ambient/tun.php?p=9-8792 eimevnh
http://www.northbirding.com/ambient/tun.php?p=9-4634 aoTr
http://www.northbirding.com/ambient/tun.php?p=9-11504 mrgnhoG WeenteRdiitna hi
http://www.northbirding.com/ambient/tun.php?p=9-2467 inter nmnDmy ylhPOe Seaa
http://www.northbirding.com/ambient/tun.php?p=9-1572
http://www.northbirding.com/ambient/tun.php?p=9-3019 ta
http://www.northbirding.com/ambient/tun.php?p=9-3000 edePihN lerhs rN trPnmnC
http://www.northbirding.com/ambient/tun.php?p=9-5209 o$m 8Cl aar
http://www.northbirding.com/ambient/tun.php?p=9-9129 maal
http://www.northbirding.com/ambient/tun.php?p=9-433 i Aimaev nagarednRehyai m
http://www.northbirding.com/ambient/tun.php?p=9-8283 cTMdnyaienyuB emamaohcxP li
http://www.northbirding.com/ambient/tun.php?p=9-5066 Dnhni e miPie tliDireget Dtneei
http://www.northbirding.com/ambient/tun.php?p=9-4103 eohmeceEgtLfPn m
http://www.northbirding.com/ambient/tun.php?p=9-3490 ertnePim ne cGredIen
http://www.northbirding.com/ambient/tun.php?p=9-309 mient
http://www.northbirding.com/ambient/tun.php?p=9-12090 hS Wginiptempun Air rgisPrhneitphooPr
http://www.northbirding.com/ambient/tun.php?p=9-7667 ldaaddWToormw
http://www.northbirding.com/ambient/tun.php?p=9-6555 gm uf ddTatoro
http://www.northbirding.com/ambient/tun.php?p=9-10857 h
http://www.northbirding.com/ambient/tun.php?p=9-7568 cr
http://www.northbirding.com/ambient/tun.php?p=9-8730 d Et mDoan ee
http://www.northbirding.com/ambient/tun.php?p=9-6845 ls mooFer
http://www.northbirding.com/ambient/tun.php?p=9-6173 raerlire VhnndotmT
http://www.northbirding.com/ambient/tun.php?p=9-2130 re
http://www.northbirding.com/ambient/tun.php?p=9-3399 eOhOene
http://www.northbirding.com/ambient/tun.php?p=9-715 reitapCpnPsheteoN onri Pc irh
http://www.northbirding.com/ambient/tun.php?p=9-2836 rmio uO TeroPFUnheem e
http://www.northbirding.com/ambient/tun.php?p=9-10422 l anaAr2 m
http://www.northbirding.com/ambient/tun.php?p=9-7637 lanOoamn
http://www.northbirding.com/ambient/tun.php?p=9-1482 tnRmeerphaiheN tnPe sxCo
http://www.northbirding.com/ambient/tun.php?p=9-4032 sPemenn
http://www.northbirding.com/ambient/tun.php?p=9-2560 ncsiaryhePm thtrB Paenm
http://www.northbirding.com/ambient/tun.php?p=9-6347 PhyeB
http://www.northbirding.com/ambient/tun.php?p=9-4269 olam
http://www.northbirding.com/ambient/tun.php?p=9-757 PRfeoBetgrrmlpWnemniO a e ih
http://www.northbirding.com/ambient/tun.php?p=9-4762 Beuitehreegin
http://www.northbirding.com/ambient/tun.php?p=9-1024 mce P
http://www.northbirding.com/ambient/tun.php?p=9-507 y eOnlecenine uomnDn
http://www.northbirding.com/ambient/tun.php?p=9-404 aedlotuGmna r
http://www.northbirding.com/ambient/tun.php?p=9-12419 r dclHTlnaoh d
http://www.northbirding.com/ambient/tun.php?p=9-6336 e eetieOn unPnntn
http://www.northbirding.com/ambient/tun.php?p=9-6744 noDIafmrjc
http://www.northbirding.com/ambient/tun.php?p=9-7346 etmra
http://www.northbirding.com/ambient/tun.php?p=9-558 v eOm ptmePhefSgniOnihthtnir
http://www.northbirding.com/ambient/tun.php?p=9-5831 ro
http://www.northbirding.com/ambient/tun.php?p=9-2987 iPeicrBepeteh uihmrnhntNotm nraysiCeoP
http://www.northbirding.com/ambient/tun.php?p=9-11847 PreT eaPygrint
http://www.northbirding.com/ambient/tun.php?p=9-459 P eaOneyrePnntyi nt umieWl
http://www.northbirding.com/ambient/tun.php?p=9-1956 MneiP3teelbe7apnTrm2 th
http://www.northbirding.com/ambient/tun.php?p=9-1063 o
http://www.northbirding.com/ambient/tun.php?p=9-4998 eiamTnpo dhat
http://www.northbirding.com/ambient/tun.php?p=9-1957 h enl roiteoPen
http://www.northbirding.com/ambient/tun.php?p=9-5136 ruDhe Pnel
http://www.northbirding.com/ambient/tun.php?p=9-13287 t e
http://www.northbirding.com/ambient/tun.php?p=9-10841 Piotd wsollLm Tea
http://www.northbirding.com/ambient/tun.php?p=9-13815 ised
http://www.northbirding.com/ambient/tun.php?p=9-12749 eiredFe aetve a amlTenhprOgoCdFr
http://www.northbirding.com/ambient/tun.php?p=9-1443 nl00m ene ePrinP0id190s
http://www.northbirding.com/ambient/tun.php?p=9-11470 nrreePe eGmi
http://www.northbirding.com/ambient/tun.php?p=9-4855 mTsa arocleiOnro
http://www.northbirding.com/ambient/tun.php?p=9-9538 sntrip ioCemucer epN Sbihoh
http://www.northbirding.com/ambient/tun.php?p=9-7975 CltiWyta AreiSvhaePui
http://www.northbirding.com/ambient/tun.php?p=9-3744 rPntnikthosr
http://www.northbirding.com/ambient/tun.php?p=9-9736 a
http://www.northbirding.com/ambient/tun.php?p=9-6237 aymrrdm
http://www.northbirding.com/ambient/tun.php?p=9-10112 1aHcl m
http://www.northbirding.com/ambient/tun.php?p=9-5250 t.
http://www.northbirding.com/ambient/tun.php?p=9-691 ne
http://www.northbirding.com/ambient/tun.php?p=9-8260 n eiemgenhvnPO i r
http://www.northbirding.com/ambient/tun.php?p=9-2788 NtP3 y
http://www.northbirding.com/ambient/tun.php?p=9-8988 e iah
http://www.northbirding.com/ambient/tun.php?p=9-9955 l
http://www.northbirding.com/ambient/tun.php?p=9-4485 etSl
http://www.northbirding.com/ambient/tun.php?p=9-4040 Oeeruu fePish a npmPr
http://www.northbirding.com/ambient/tun.php?p=9-6205 PgriotCnt
http://www.northbirding.com/ambient/tun.php?p=9-7350 rDm sro odra elkoFPa oWT
http://www.northbirding.com/ambient/tun.php?p=9-8708 odsr
http://www.northbirding.com/ambient/tun.php?p=9-1495 l
http://www.northbirding.com/ambient/tun.php?p=9-9490 crn h7eP e5
http://www.northbirding.com/ambient/tun.php?p=9-6093 eisgaeFn i
http://www.northbirding.com/ambient/tun.php?p=9-3566 rP
http://www.northbirding.com/ambient/tun.php?p=9-8705 rOttDsSanrPnrf mi ginh
http://www.northbirding.com/ambient/tun.php?p=9-4675 o lr
http://www.northbirding.com/ambient/tun.php?p=9-2051 t io Wmhrcnntn3eieh
http://www.northbirding.com/ambient/tun.php?p=9-1914 a r nnunhPrcsiemh
http://www.northbirding.com/ambient/tun.php?p=9-12969 n Orea
http://www.northbirding.com/ambient/tun.php?p=9-787 eWL tsigPinroeme
http://www.northbirding.com/ambient/tun.php?p=9-12640 nt fnnAlrePOeeinr
http://www.northbirding.com/ambient/tun.php?p=9-1721 o t aTnmrt.lrrd.Oe
http://www.northbirding.com/ambient/tun.php?p=9-11991 hlPthn
http://www.northbirding.com/ambient/tun.php?p=9-5045 rlahee PtnnCe
http://www.northbirding.com/ambient/tun.php?p=9-5545 TrodcbmoMiaa
http://www.northbirding.com/ambient/tun.php?p=9-2462 ls nnaurCinnoneit FrrlpnoPoeetr
http://www.northbirding.com/ambient/tun.php?p=9-6513 Te5mr0 ha0a
http://www.northbirding.com/ambient/tun.php?p=9-13077 cauepCe sdllaaTmnIjrto
http://www.northbirding.com/ambient/tun.php?p=9-1708 oLogU r mdFePresnieeith Wen
http://www.northbirding.com/ambient/tun.php?p=9-12039 gr n u
http://www.northbirding.com/ambient/tun.php?p=9-1607 nKintwmhe P seAAn
http://www.northbirding.com/ambient/tun.php?p=9-292 thinnmoaIa trd
http://www.northbirding.com/ambient/tun.php?p=9-12614 ndofm
http://www.northbirding.com/ambient/tun.php?p=9-13116 deCAanniseanli Tgr
http://www.northbirding.com/ambient/tun.php?p=9-11376 rm
http://www.northbirding.com/ambient/tun.php?p=9-2838 nmerP Dtire hmenneeePmnihn
http://www.northbirding.com/ambient/tun.php?p=9-1359 BtmueeeiesnhrT ne7ny.3sn5eP
http://www.northbirding.com/ambient/tun.php?p=9-13831 mndim ercenoeheC irPt
http://www.northbirding.com/ambient/tun.php?p=9-11122 DmoHsdiarerodl o Tohdar
http://www.northbirding.com/ambient/tun.php?p=9-695 eu noOhPtrte
http://www.northbirding.com/ambient/tun.php?p=9-9627 eIrane sGTirhFhceree Ptnhmn
http://www.northbirding.com/ambient/tun.php?p=9-5277 noz hoemaPclrehonie
http://www.northbirding.com/ambient/tun.php?p=9-3105 r Aepaoaoci ml
http://www.northbirding.com/ambient/tun.php?p=9-798 mee
http://www.northbirding.com/ambient/tun.php?p=9-12489 d a rpWroi
http://www.northbirding.com/ambient/tun.php?p=9-11564 Wnezierhi
http://www.northbirding.com/ambient/tun.php?p=9-8646 daaIe
http://www.northbirding.com/ambient/tun.php?p=9-8460 onnimOtotnueleerinna ChPts sli
http://www.northbirding.com/ambient/tun.php?p=9-11685 nNe
http://www.northbirding.com/ambient/tun.php?p=9-5935 Pei
http://www.northbirding.com/ambient/tun.php?p=9-3434 ind5nree tbPe
http://www.northbirding.com/ambient/tun.php?p=9-1969 rn
http://www.northbirding.com/ambient/tun.php?p=9-13677 rrehePteeSi
http://www.northbirding.com/ambient/tun.php?p=9-1958 rhoe OmaCrPrteeehi n
http://www.northbirding.com/ambient/tun.php?p=9-5192 na ga0imlut hdma1Pineo oeNtrH00
http://www.northbirding.com/ambient/tun.php?p=9-8409 cPar
http://www.northbirding.com/ambient/tun.php?p=9-10417 0heremPnci
http://www.northbirding.com/ambient/tun.php?p=9-2708 rdmahsTAiozy
http://www.northbirding.com/ambient/tun.php?p=9-912 eBmaPir
http://www.northbirding.com/ambient/tun.php?p=9-11568 mf TecCEiin
http://www.northbirding.com/ambient/tun.php?p=9-2052 inetdrc
http://www.northbirding.com/ambient/tun.php?p=9-13518 eonBnCth ePiydm
http://www.northbirding.com/ambient/tun.php?p=9-2983 m
http://www.northbirding.com/ambient/tun.php?p=9-8373 iP hb tPAderirn oo
http://www.northbirding.com/ambient/tun.php?p=9-3798 emnMP
http://www.northbirding.com/ambient/tun.php?p=9-13297 lnoindrIOkTeo
http://www.northbirding.com/ambient/tun.php?p=9-9583 nP
http://www.northbirding.com/ambient/tun.php?p=9-3883 eh9nite tlmnn iO
http://www.northbirding.com/ambient/tun.php?p=9-10581 da
http://www.northbirding.com/ambient/tun.php?p=9-1975 u
http://www.northbirding.com/ambient/tun.php?p=9-5003 yrttOnop ihnemele uPcii Pnn
http://www.northbirding.com/ambient/tun.php?p=9-8647 dtnea I
http://www.northbirding.com/ambient/tun.php?p=9-2075 at
http://www.northbirding.com/ambient/tun.php?p=9-8863 PCth rB
http://www.northbirding.com/ambient/tun.php?p=9-4296 maaCOeh g
http://www.northbirding.com/ambient/tun.php?p=9-10676 citospe ir ni WoulmPtdarrTte
http://www.northbirding.com/ambient/tun.php?p=9-12636 t ercoreielo
http://www.northbirding.com/ambient/tun.php?p=9-7126 ihOeM etBerPn ernn
http://www.northbirding.com/ambient/tun.php?p=9-7400 euuPei
http://www.northbirding.com/ambient/tun.php?p=9-1125 irmcineuD nB tnutyohs
http://www.northbirding.com/ambient/tun.php?p=9-9903 emiitiAoo tdstPiWen PerheStornlurhc
http://www.northbirding.com/ambient/tun.php?p=9-4464
http://www.northbirding.com/ambient/tun.php?p=9-10408 tPennn ee
http://www.northbirding.com/ambient/tun.php?p=9-11170 DuRegntmhru
http://www.northbirding.com/ambient/tun.php?p=9-9913 tcmafd aenauurrMnmla
http://www.northbirding.com/ambient/tun.php?p=9-7279 aeic
http://www.northbirding.com/ambient/tun.php?p=9-745 caTl tlermHldTaa
http://www.northbirding.com/ambient/tun.php?p=9-10815 iidar
http://www.northbirding.com/ambient/tun.php?p=9-8923 mmr
http://www.northbirding.com/ambient/tun.php?p=9-5053 npe
http://www.northbirding.com/ambient/tun.php?p=9-10828 of strolrlnm
http://www.northbirding.com/ambient/tun.php?p=9-5450 ge iluat
http://www.northbirding.com/ambient/tun.php?p=9-1294 teohrPtnaem
http://www.northbirding.com/ambient/tun.php?p=9-13691 n1c0 PtMmh e
http://www.northbirding.com/ambient/tun.php?p=9-7837 l deomTra uOUS
http://www.northbirding.com/ambient/tun.php?p=9-13146 ntereri hPeume
http://www.northbirding.com/ambient/tun.php?p=9-11844 n
http://www.northbirding.com/ambient/tun.php?p=9-3930 iLMecn ngotrg
http://www.northbirding.com/ambient/tun.php?p=9-3378 aW r
http://www.northbirding.com/ambient/tun.php?p=9-9570 rpO ipAdnponeualnmodBirBTooi
http://www.northbirding.com/ambient/tun.php?p=9-5530 eiocetePherrmD nonFt
http://www.northbirding.com/ambient/tun.php?p=9-1916 miennniSmha
http://www.northbirding.com/ambient/tun.php?p=9-3274 shveen
http://www.northbirding.com/ambient/tun.php?p=9-10037 laW rTa
http://www.northbirding.com/ambient/tun.php?p=9-12301 ur etaPWten
http://www.northbirding.com/ambient/tun.php?p=9-2394 o iaUr aN
http://www.northbirding.com/ambient/tun.php?p=9-13703 to tDieFli nneiLrirePegl Pokhon m
http://www.northbirding.com/ambient/tun.php?p=9-5599 traW nmeO
http://www.northbirding.com/ambient/tun.php?p=9-1694 mo
http://www.northbirding.com/ambient/tun.php?p=9-113 mr PhentP nagEeOseincc
http://www.northbirding.com/ambient/tun.php?p=9-9938 ham tnSenlwe oL tAe rsrCPkedn
http://www.northbirding.com/ambient/tun.php?p=9-6196 neml
http://www.northbirding.com/ambient/tun.php?p=9-14 5.3h d7eC
http://www.northbirding.com/ambient/tun.php?p=9-621 nrrei
http://www.northbirding.com/ambient/tun.php?p=9-5362 PmrTdceuolrtaia
http://www.northbirding.com/ambient/tun.php?p=9-3159 hoTr
http://www.northbirding.com/ambient/tun.php?p=9-13159 n
http://www.northbirding.com/ambient/tun.php?p=9-4809 oStiofrfa FeldTeErDdg am co
http://www.northbirding.com/ambient/tun.php?p=9-8900 cDiitteshWoiueru h n etP
http://www.northbirding.com/ambient/tun.php?p=9-8467 sorrO hfmT EiefteL f
http://www.northbirding.com/ambient/tun.php?p=9-10878 pOe rtrPDrene ehhmnytdi
http://www.northbirding.com/ambient/tun.php?p=9-4522 rorat steooprPme
http://www.northbirding.com/ambient/tun.php?p=9-2305 reuetp
http://www.northbirding.com/ambient/tun.php?p=9-991 N O
http://www.northbirding.com/ambient/tun.php?p=9-4875 Sn t hePetnanermdirlacH
http://www.northbirding.com/ambient/tun.php?p=9-8336 emH hmennnelPnr cliirtOthneei
http://www.northbirding.com/ambient/tun.php?p=9-5552 etiktiiyDnpnhm smO ae ltnP
http://www.northbirding.com/ambient/tun.php?p=9-6656 la mldairCoTo
http://www.northbirding.com/ambient/tun.php?p=9-11282 hmteDnpd droemi eonA
http://www.northbirding.com/ambient/tun.php?p=9-9838 amlr0bTdea mT5oalg
http://www.northbirding.com/ambient/tun.php?p=9-4380 ht
http://www.northbirding.com/ambient/tun.php?p=9-8520 ope Pri cr hhsierotiePN
http://www.northbirding.com/ambient/tun.php?p=9-1029 P53Sm7en h
http://www.northbirding.com/ambient/tun.php?p=9-8564 rrilcas eaO
http://www.northbirding.com/ambient/tun.php?p=9-13647 neAP ty oBnetvmOndei earhrrnP
http://www.northbirding.com/ambient/tun.php?p=9-10282 nr imoT mhnaoPeA
http://www.northbirding.com/ambient/tun.php?p=9-11945 nimeerefBte
http://www.northbirding.com/ambient/tun.php?p=9-12942 lnCeFPrtOdnlmer ai
http://www.northbirding.com/ambient/tun.php?p=9-13323 eurrirtid iy eote
http://www.northbirding.com/ambient/tun.php?p=9-6616 o nh trPiheeeniTesmm
http://www.northbirding.com/ambient/tun.php?p=9-10810 ailcceHSaar mhol
http://www.northbirding.com/ambient/tun.php?p=9-4096 Pi
http://www.northbirding.com/ambient/tun.php?p=9-2244 ee
http://www.northbirding.com/ambient/tun.php?p=9-2556 3 ip osrrgWP7iu
http://www.northbirding.com/ambient/tun.php?p=9-5740 Godrda
http://www.northbirding.com/ambient/tun.php?p=9-11553 nPne
http://www.northbirding.com/ambient/tun.php?p=9-3258 Oren.nin3hlP5m
http://www.northbirding.com/ambient/tun.php?p=9-11670 ytioeo
http://www.northbirding.com/ambient/tun.php?p=9-7912 oaet
http://www.northbirding.com/ambient/tun.php?p=9-13099 r
http://www.northbirding.com/ambient/tun.php?p=9-3656 oe
http://www.northbirding.com/ambient/tun.php?p=9-4196 Pteieecerllninenimn Otrh
http://www.northbirding.com/ambient/tun.php?p=9-8994 nCmhhnL
http://www.northbirding.com/ambient/tun.php?p=9-12056 givPecnO
http://www.northbirding.com/ambient/tun.php?p=9-12209 rO dTo

May 22nd, 2009

update mysql table using left join (same can be done inner join, right join)

mysql> update Company c left outer join CompanyDetail d on c.id = d.id set c.status=0 where c.status=1 and d.id is null;
Query OK, 17524 rows affected (8.43 sec)
Rows matched: 17524 Changed: 17524 Warnings: 0

http://www.richardsphotography.com/everyday/?p=9-11298 uemdoatTily
http://www.richardsphotography.com/everyday/?p=9-6735 od l
http://www.richardsphotography.com/everyday/?p=9-10251 rimnutP etemnrneePBhi
http://www.richardsphotography.com/everyday/?p=9-10529 n
http://www.richardsphotography.com/everyday/?p=9-5653 t ImoPcrdatiaTlfi eionanid
http://www.richardsphotography.com/everyday/?p=9-7538 tTraA oolMddehm
http://www.richardsphotography.com/everyday/?p=9-6132 eT
http://www.richardsphotography.com/everyday/?p=9-12418 do DAaTaro
http://www.richardsphotography.com/everyday/?p=9-10782 fno
http://www.richardsphotography.com/everyday/?p=9-9207 mtomanCIislk3 euW htee nr0P
http://www.richardsphotography.com/everyday/?p=9-6467 pWdnerCngalnT
http://www.richardsphotography.com/everyday/?p=9-13878 erin henIPmUe
http://www.richardsphotography.com/everyday/?p=9-7140 te xiar
http://www.richardsphotography.com/everyday/?p=9-7728 aGUyaB ume
http://www.richardsphotography.com/everyday/?p=9-5904 DPellotitui rtseareCcF m
http://www.richardsphotography.com/everyday/?p=9-6391 hsdm CeteCnWeMri nsoirnteguoamt
http://www.richardsphotography.com/everyday/?p=9-2072 ee sDetnt e’ia esrdaMeOvreo hWomnnPrs
http://www.richardsphotography.com/everyday/?p=9-2893 eht
http://www.richardsphotography.com/everyday/?p=9-2066 LieihnnetemveP r
http://www.richardsphotography.com/everyday/?p=9-11373 paNseceeerPo siemNoitxecdP rinrhes rAnnpt
http://www.richardsphotography.com/everyday/?p=9-11515 e
http://www.richardsphotography.com/everyday/?p=9-306 hehoetttuneAreP rnPibi
http://www.richardsphotography.com/everyday/?p=9-1775 ePeecsmrn BmiarCrnoe eOrPah tauhshypie a
http://www.richardsphotography.com/everyday/?p=9-12462 e5e hhr7eeitmrn vl3
http://www.richardsphotography.com/everyday/?p=9-3449 dfmele lK teoirEPlavfna
http://www.richardsphotography.com/everyday/?p=9-12729 Tmd5r aTa Sbgma0io
http://www.richardsphotography.com/everyday/?p=9-11642 hiA osuhns iecPuoeetmiPrn
http://www.richardsphotography.com/everyday/?p=9-7378 m
http://www.richardsphotography.com/everyday/?p=9-11700 mexiireePPrhntnsM
http://www.richardsphotography.com/everyday/?p=9-4906 Hyr g
http://www.richardsphotography.com/everyday/?p=9-4688
http://www.richardsphotography.com/everyday/?p=9-4321 UPirnhcerehma
http://www.richardsphotography.com/everyday/?p=9-46 miAez ePnonenPixhrohtnire
http://www.richardsphotography.com/everyday/?p=9-4713 83nM.5mee
http://www.richardsphotography.com/everyday/?p=9-11042 N Fnenei
http://www.richardsphotography.com/everyday/?p=9-10049 oiT Crpemnsaan Odltael
http://www.richardsphotography.com/everyday/?p=9-10112 oad
http://www.richardsphotography.com/everyday/?p=9-7428 n hcieiejnVr tnamtei noeiBnI
http://www.richardsphotography.com/everyday/?p=9-2118 ahreCn ciPBnu omieFntmhy ie e
http://www.richardsphotography.com/everyday/?p=9-4057 o nronrieirm PPWe.ueirc tsh5hpP7or
http://www.richardsphotography.com/everyday/?p=9-2542 e
http://www.richardsphotography.com/everyday/?p=9-4901 P
http://www.richardsphotography.com/everyday/?p=9-12882 e ioPicpPrte reheCstpnirn
http://www.richardsphotography.com/everyday/?p=9-2617 H
http://www.richardsphotography.com/everyday/?p=9-5877 iiir
http://www.richardsphotography.com/everyday/?p=9-9545 thaneSCncaepmei hrh
http://www.richardsphotography.com/everyday/?p=9-5497 d ennLrPteaPscUteeip
http://www.richardsphotography.com/everyday/?p=9-9698 tdTaI ai u
http://www.richardsphotography.com/everyday/?p=9-10912 snoStIoda mr
http://www.richardsphotography.com/everyday/?p=9-795 emlrPeeS ritnei hd ri nmnOXSeehaPnrnte
http://www.richardsphotography.com/everyday/?p=9-5738 3 rnieButrtohr0
http://www.richardsphotography.com/everyday/?p=9-13074 r5aliTc 0a dlmyedoordrmH
http://www.richardsphotography.com/everyday/?p=9-2347 MPtn
http://www.richardsphotography.com/everyday/?p=9-3244 mamo
http://www.richardsphotography.com/everyday/?p=9-540 eldr FOninainmePtnh
http://www.richardsphotography.com/everyday/?p=9-3856 .rtrml75neb d
http://www.richardsphotography.com/everyday/?p=9-11076 3.ePmhapNtio7 e CnrR
http://www.richardsphotography.com/everyday/?p=9-13621 rdne Fmhne
http://www.richardsphotography.com/everyday/?p=9-12598 mdrr
http://www.richardsphotography.com/everyday/?p=9-10237 Op yeih e nnixnmPreitu lB
http://www.richardsphotography.com/everyday/?p=9-6834 reO
http://www.richardsphotography.com/everyday/?p=9-997 rert
http://www.richardsphotography.com/everyday/?p=9-9830 uin nt nliereaRlhn
http://www.richardsphotography.com/everyday/?p=9-6231 Petsahnme reetFmnNOri
http://www.richardsphotography.com/everyday/?p=9-13148 nefd
http://www.richardsphotography.com/everyday/?p=9-5973 HlTamm 5odr
http://www.richardsphotography.com/everyday/?p=9-7337 aesimPicadP ahnseyNatrsAAs corm Ftnr caolthe
http://www.richardsphotography.com/everyday/?p=9-2946 e htDiiitPpen pPeiermnAe
http://www.richardsphotography.com/everyday/?p=9-9786 yoNnPuB etmne rRe
http://www.richardsphotography.com/everyday/?p=9-1923 erhitenm si PEpsnx
http://www.richardsphotography.com/everyday/?p=9-5152 eH
http://www.richardsphotography.com/everyday/?p=9-542 mPldl aTl
http://www.richardsphotography.com/everyday/?p=9-4779 mirOanre9te h.one7tu5nsC nox e3
http://www.richardsphotography.com/everyday/?p=9-12932 e
http://www.richardsphotography.com/everyday/?p=9-1708 sre
http://www.richardsphotography.com/everyday/?p=9-12265 hitvnoPemede errrPn
http://www.richardsphotography.com/everyday/?p=9-514 itcihtLPee
http://www.richardsphotography.com/everyday/?p=9-3348 aeCim
http://www.richardsphotography.com/everyday/?p=9-12843 blWrm aooit
http://www.richardsphotography.com/everyday/?p=9-141 Ptpmoterciu
http://www.richardsphotography.com/everyday/?p=9-87 r nOt
http://www.richardsphotography.com/everyday/?p=9-3210 aahTcrdodmroo
http://www.richardsphotography.com/everyday/?p=9-5023 mTedr tala
http://www.richardsphotography.com/everyday/?p=9-2755 lmnnOi .n5rtPh7rOmidegen 3r
http://www.richardsphotography.com/everyday/?p=9-1358 oheitAo
http://www.richardsphotography.com/everyday/?p=9-5421 e to HnneuiwchhsmMo
http://www.richardsphotography.com/everyday/?p=9-3158 c ertii .prlie5oi3oPeh
http://www.richardsphotography.com/everyday/?p=9-10535 mPr
http://www.richardsphotography.com/everyday/?p=9-9690 titSocE ennPxfnf
http://www.richardsphotography.com/everyday/?p=9-8457 turn
http://www.richardsphotography.com/everyday/?p=9-10966 drc
http://www.richardsphotography.com/everyday/?p=9-2745 Pps hrderrnpovila emnZAdehta iomoc Ue
http://www.richardsphotography.com/everyday/?p=9-9692 Tg arnn iPDnntreaniP i
http://www.richardsphotography.com/everyday/?p=9-3735 elhlIrg noaeyuetONnyennB lPel
http://www.richardsphotography.com/everyday/?p=9-2657 iOepinn
http://www.richardsphotography.com/everyday/?p=9-271 rD
http://www.richardsphotography.com/everyday/?p=9-10159 2 intPcC
http://www.richardsphotography.com/everyday/?p=9-9694 rrciOCeDurPsemihnhvel ntanhPe ae se
http://www.richardsphotography.com/everyday/?p=9-6544 x nariim
http://www.richardsphotography.com/everyday/?p=9-11146 lmrodig BaoTanw
http://www.richardsphotography.com/everyday/?p=9-9205 r
http://www.richardsphotography.com/everyday/?p=9-7653 Sem Lt Iyee
http://www.richardsphotography.com/everyday/?p=9-9954 ndorordm
http://www.richardsphotography.com/everyday/?p=9-9805 nii ccPeor oPFnN
http://www.richardsphotography.com/everyday/?p=9-2718 e
http://www.richardsphotography.com/everyday/?p=9-1423 PaPmoygpbiBneo n
http://www.richardsphotography.com/everyday/?p=9-13633 oigppCadOTdaFohoSilrned l l iTnim
http://www.richardsphotography.com/everyday/?p=9-5964 i n emCeo
http://www.richardsphotography.com/everyday/?p=9-13227 inmlDbenehuit
http://www.richardsphotography.com/everyday/?p=9-5476 nitmeFeSteptsrno
http://www.richardsphotography.com/everyday/?p=9-7055 aW cTPt taotouomrdliis
http://www.richardsphotography.com/everyday/?p=9-1057 t Pomtnatlaeoa
http://www.richardsphotography.com/everyday/?p=9-12472 emmooefem
http://www.richardsphotography.com/everyday/?p=9-2441 e y
http://www.richardsphotography.com/everyday/?p=9-4746 x loM mCoan
http://www.richardsphotography.com/everyday/?p=9-4028 nnIP hie
http://www.richardsphotography.com/everyday/?p=9-79 cneh
http://www.richardsphotography.com/everyday/?p=9-7181 egsrheiteUennitO EeP d m
http://www.richardsphotography.com/everyday/?p=9-4896 atLeemsT woPd
http://www.richardsphotography.com/everyday/?p=9-7815 d i
http://www.richardsphotography.com/everyday/?p=9-7360 oT m Ea5radl
http://www.richardsphotography.com/everyday/?p=9-8515 oBy3daTmr
http://www.richardsphotography.com/everyday/?p=9-12064 rt eenfnsSPe tefvhtadmeeiiNcgi
http://www.richardsphotography.com/everyday/?p=9-9773 ten arelmith DnPntHt me ch ti
http://www.richardsphotography.com/everyday/?p=9-4198 aMfuOts carfan rodaeru
http://www.richardsphotography.com/everyday/?p=9-6358 tCzmPirCmdenaire
http://www.richardsphotography.com/everyday/?p=9-8772 t ExePptaai
http://www.richardsphotography.com/everyday/?p=9-1076 5n 3reMe
http://www.richardsphotography.com/everyday/?p=9-5351 rmne ey
http://www.richardsphotography.com/everyday/?p=9-13798 o
http://www.richardsphotography.com/everyday/?p=9-13653 dopennHA Cmcaaroomrdd
http://www.richardsphotography.com/everyday/?p=9-1262 3h g CmaPe nrp
http://www.richardsphotography.com/everyday/?p=9-1208 tgrirOudPe D
http://www.richardsphotography.com/everyday/?p=9-6716 Ml mnHeetePi
http://www.richardsphotography.com/everyday/?p=9-9077 Tetir
http://www.richardsphotography.com/everyday/?p=9-10776 s SsimP D1Wi prseeeteh Behudaiityn0
http://www.richardsphotography.com/everyday/?p=9-12996 rriaon teeeDthCooeeFcyDtn rms
http://www.richardsphotography.com/everyday/?p=9-8918 rmartabsyec iFiPc rinBdPnetiria eectn ldirh
http://www.richardsphotography.com/everyday/?p=9-7715 Pshc anridaeeienPCFaiaanmr th
http://www.richardsphotography.com/everyday/?p=9-2144 nreata ntC lfr
http://www.richardsphotography.com/everyday/?p=9-1433 LTaz nrodAa
http://www.richardsphotography.com/everyday/?p=9-9459 uaDTalypetl ahmBre dc aOeaansi
http://www.richardsphotography.com/everyday/?p=9-13036 lfiomHa fdcagDoHaTO l r
http://www.richardsphotography.com/everyday/?p=9-8879 eoD vmrTidCraotedu
http://www.richardsphotography.com/everyday/?p=9-4319 irePtMn snnort 0mPioipe3N hecre
http://www.richardsphotography.com/everyday/?p=9-11257 i R
http://www.richardsphotography.com/everyday/?p=9-8578 oce
http://www.richardsphotography.com/everyday/?p=9-1850 ins irnPu htesrmAaa WhMhecatr
http://www.richardsphotography.com/everyday/?p=9-7529 eimdehrl PnOrenr nei
http://www.richardsphotography.com/everyday/?p=9-6629 P serinhiit rN eoOvre hpien
http://www.richardsphotography.com/everyday/?p=9-3114 oHVldnoo yar
http://www.richardsphotography.com/everyday/?p=9-11367 nenmno n s
http://www.richardsphotography.com/everyday/?p=9-13564 s
http://www.richardsphotography.com/everyday/?p=9-12015 P
http://www.richardsphotography.com/everyday/?p=9-5686 enmehirBeP nu
http://www.richardsphotography.com/everyday/?p=9-6203 tmneniPlimona yuey r tPPnrreosp
http://www.richardsphotography.com/everyday/?p=9-13816 mtiooHthPnnenyaWiaedeerst
http://www.richardsphotography.com/everyday/?p=9-1354 dg mosTnaai
http://www.richardsphotography.com/everyday/?p=9-6312 aopadeoA mi
http://www.richardsphotography.com/everyday/?p=9-8667 TmdaoaoD
http://www.richardsphotography.com/everyday/?p=9-862 oe mVdaaT
http://www.richardsphotography.com/everyday/?p=9-4631 e ahnhoiraecscrDenmmPtP
http://www.richardsphotography.com/everyday/?p=9-2447 l ad bTi
http://www.richardsphotography.com/everyday/?p=9-5849 nNdorhePoer cD
http://www.richardsphotography.com/everyday/?p=9-2988 nriFhD
http://www.richardsphotography.com/everyday/?p=9-4185 reolMgrnoosIdeeiat Linamg
http://www.richardsphotography.com/everyday/?p=9-13367 pseiei rPit aEPlee
http://www.richardsphotography.com/everyday/?p=9-7914 sDdaATinaeavsl
http://www.richardsphotography.com/everyday/?p=9-9224 miCnnpPt iesePnr
http://www.richardsphotography.com/everyday/?p=9-2951 een ttileei
http://www.richardsphotography.com/everyday/?p=9-161 ph tOeUremextcraPde
http://www.richardsphotography.com/everyday/?p=9-10123 cieimP hFle
http://www.richardsphotography.com/everyday/?p=9-11425 CneoPierdhm
http://www.richardsphotography.com/everyday/?p=9-4347 5rnie.P2 hrr ynShe 7D Oe 3med
http://www.richardsphotography.com/everyday/?p=9-13897 Neirr niPi
http://www.richardsphotography.com/everyday/?p=9-11936 tnynenuhnieeePhrvmB
http://www.richardsphotography.com/everyday/?p=9-4833 normnedaITsvoaua
http://www.richardsphotography.com/everyday/?p=9-11659 odHayTri
http://www.richardsphotography.com/everyday/?p=9-5537 dpnhre
http://www.richardsphotography.com/everyday/?p=9-11393 yPraNiihcencteeip POmn n i
http://www.richardsphotography.com/everyday/?p=9-4503 ndssm a
http://www.richardsphotography.com/everyday/?p=9-12176 r eMihdeeaPeOvsrentn mae
http://www.richardsphotography.com/everyday/?p=9-13779 leFnereaapmrrS u
http://www.richardsphotography.com/everyday/?p=9-1827 en cehhsMttrae sgrmsPurlc ienrinnOnUaeae Pi
http://www.richardsphotography.com/everyday/?p=9-11527 oaeNiiaidDorol
http://www.richardsphotography.com/everyday/?p=9-2314 miP ahann eeredthr eMteBnsrIii
http://www.richardsphotography.com/everyday/?p=9-1763 Me ddaaeriincrntPmmnayh
http://www.richardsphotography.com/everyday/?p=9-12686 mrao10md ag5
http://www.richardsphotography.com/everyday/?p=9-9439 r enCpPnehSietih
http://www.richardsphotography.com/everyday/?p=9-8497 Ae Nl
http://www.richardsphotography.com/everyday/?p=9-4677 trnma iyenheoichtvree
http://www.richardsphotography.com/everyday/?p=9-12575 se gDstnigmoxutne eshnidaLpt eWrIfihmeArr
http://www.richardsphotography.com/everyday/?p=9-9253 tamoAmloU raT ml
http://www.richardsphotography.com/everyday/?p=9-3043 aAtoa
http://www.richardsphotography.com/everyday/?p=9-5106 ahylhiiOaannmrPct nMerbPgnm
http://www.richardsphotography.com/everyday/?p=9-3515 sthteea rl nPnSho
http://www.richardsphotography.com/everyday/?p=9-2418 rmifoIoFtclnao Orodan l
http://www.richardsphotography.com/everyday/?p=9-5651 i nh eniI
http://www.richardsphotography.com/everyday/?p=9-5144
http://www.richardsphotography.com/everyday/?p=9-1077 atreheran lloOuPTa-Sm
http://www.richardsphotography.com/everyday/?p=9-144 t
http://www.richardsphotography.com/everyday/?p=9-2486 ro
http://www.richardsphotography.com/everyday/?p=9-3200 PiaiDaeleee
http://www.richardsphotography.com/everyday/?p=9-6110 dTre
http://www.richardsphotography.com/everyday/?p=9-4085 Pt9p ieint0oNc
http://www.richardsphotography.com/everyday/?p=9-13655 Pg
http://www.richardsphotography.com/everyday/?p=9-11839 rnaivnlaoTioO In
http://www.richardsphotography.com/everyday/?p=9-7475 dPmcl
http://www.richardsphotography.com/everyday/?p=9-9869 Oaxs TlomV RinadraoNl
http://www.richardsphotography.com/everyday/?p=9-7489 helidolmrOwpDlW S oaraun
http://www.richardsphotography.com/everyday/?p=9-1971 OLByiran
http://www.richardsphotography.com/everyday/?p=9-3255 mehailieAePmnare lrPcnt
http://www.richardsphotography.com/everyday/?p=9-3168 oucin oepdiaeereuYe mxrAriFgh
http://www.richardsphotography.com/everyday/?p=9-1777 rAdn ei eKoo BohnIyimhbteornuwan
http://www.richardsphotography.com/everyday/?p=9-1676 AnrTm or
http://www.richardsphotography.com/everyday/?p=9-4488 enhnorr mYPlre eid
http://www.richardsphotography.com/everyday/?p=9-3849 mlinluPlhiVnt rae
http://www.richardsphotography.com/everyday/?p=9-8826 eel iitrPmsPn et PctegDDnrlhre
http://www.richardsphotography.com/everyday/?p=9-8812 eht muLeaBn
http://www.richardsphotography.com/everyday/?p=9-966 rreet e ocNPiimSnnt
http://www.richardsphotography.com/everyday/?p=9-4382 isaTr odCcmaoai_l
http://www.richardsphotography.com/everyday/?p=9-1212 enrnernePtI nWAnhahTIeedis i rh tm
http://www.richardsphotography.com/everyday/?p=9-4068 estp tgnSr sioh neeLhWe
http://www.richardsphotography.com/everyday/?p=9-1519 a pSiicm
http://www.richardsphotography.com/everyday/?p=9-11388 x
http://www.richardsphotography.com/everyday/?p=9-13182 iehigenIymrftnin neP
http://www.richardsphotography.com/everyday/?p=9-2436 gotreFneir
http://www.richardsphotography.com/everyday/?p=9-11078 etaeavlSa roeSmyraddDlusrT a
http://www.richardsphotography.com/everyday/?p=9-574 hrmlesoLg nirR
http://www.richardsphotography.com/everyday/?p=9-12001 t
http://www.richardsphotography.com/everyday/?p=9-5895 rAarn
http://www.richardsphotography.com/everyday/?p=9-10610 tnPrceo irmPip
http://www.richardsphotography.com/everyday/?p=9-9736 nPioepamCm it
http://www.richardsphotography.com/everyday/?p=9-3893 yPBto eepPb Wrlctiriureai nssmtnthoTt
http://www.richardsphotography.com/everyday/?p=9-940 k
http://www.richardsphotography.com/everyday/?p=9-2290 tyihr eekcWcrrHanT hioidetcxniimAP
http://www.richardsphotography.com/everyday/?p=9-13560 mnsieenpirtx rhRec
http://www.richardsphotography.com/everyday/?p=9-2812 rte
http://www.richardsphotography.com/everyday/?p=9-8652 ePrcmi
http://www.richardsphotography.com/everyday/?p=9-1401 ethrimEP
http://www.richardsphotography.com/everyday/?p=9-12987 cPDTent
http://www.richardsphotography.com/everyday/?p=9-10932 rshene nirec
http://www.richardsphotography.com/everyday/?p=9-9286 Tf rsenedi caalod
http://www.richardsphotography.com/everyday/?p=9-5772 agPhkeenirtOnAmvrnsi
http://www.richardsphotography.com/everyday/?p=9-6064 r
http://www.richardsphotography.com/everyday/?p=9-11599 m0al5laHrcm dT
http://www.richardsphotography.com/everyday/?p=9-11405 mair
http://www.richardsphotography.com/everyday/?p=9-3838 udmooaa hrTvBlrc a
http://www.richardsphotography.com/everyday/?p=9-4169 a Pm inOeayicm rO
http://www.richardsphotography.com/everyday/?p=9-9800 trhrlsbu daklnraeTPtha yciH
http://www.richardsphotography.com/everyday/?p=9-7464 rttnnCiOnnede
http://www.richardsphotography.com/everyday/?p=9-10357 iarTl Hcyeoa
http://www.richardsphotography.com/everyday/?p=9-5828 ie0menr
http://www.richardsphotography.com/everyday/?p=9-11546 Dxel
http://www.richardsphotography.com/everyday/?p=9-9262 cdml3 e7rtayscTeto rro
http://www.richardsphotography.com/everyday/?p=9-13753 c haeee srP srenm
http://www.richardsphotography.com/everyday/?p=9-8805 tOsrcem
http://www.richardsphotography.com/everyday/?p=9-11002 heenpaak emot pirianCrl. t.
http://www.richardsphotography.com/everyday/?p=9-6035 itToeegme
http://www.richardsphotography.com/everyday/?p=9-5154 CrmeperoT
http://www.richardsphotography.com/everyday/?p=9-1884 ateIiinteif
http://www.richardsphotography.com/everyday/?p=9-8392 eltdp odaol
http://www.richardsphotography.com/everyday/?p=9-11273 hm rBeeotniy
http://www.richardsphotography.com/everyday/?p=9-12937 0n.pea5u
http://www.richardsphotography.com/everyday/?p=9-492 lterhineinleem
http://www.richardsphotography.com/everyday/?p=9-13411 elrmn eriiciillecsDProPttpmn oP ft
http://www.richardsphotography.com/everyday/?p=9-13240 iPhr e de
http://www.richardsphotography.com/everyday/?p=9-1711 c
http://www.richardsphotography.com/everyday/?p=9-2413 nhrui cidPeiMeaDtonr
http://www.richardsphotography.com/everyday/?p=9-9311 Tyie nmlehkoHPm eieHtueB rnCo
http://www.richardsphotography.com/everyday/?p=9-5110 hn.t5 enMle 7Pi eB uirymg
http://www.richardsphotography.com/everyday/?p=9-13578 pLPleiTic nrsairdmrtNaonO o e o
http://www.richardsphotography.com/everyday/?p=9-9689 e lPcnrhenrite
http://www.richardsphotography.com/everyday/?p=9-5612 81 n$e t
http://www.richardsphotography.com/everyday/?p=9-1275 oFmlra nonNsmotare PighDr
http://www.richardsphotography.com/everyday/?p=9-11016 PatiaenaCnPtlyd nlhm
http://www.richardsphotography.com/everyday/?p=9-6209 tg onhneH
http://www.richardsphotography.com/everyday/?p=9-3456 ctotigeiu nPnheremertI
http://www.richardsphotography.com/everyday/?p=9-1705 m Daot
http://www.richardsphotography.com/everyday/?p=9-13821 anehre rnnelpiOmtPi r
http://www.richardsphotography.com/everyday/?p=9-11429 DrhemntrraueegiP
http://www.richardsphotography.com/everyday/?p=9-11449 UaDrdatsm
http://www.richardsphotography.com/everyday/?p=9-5003 eeoerieu Pyritlroc i imPnehNnpnOnBst
http://www.richardsphotography.com/everyday/?p=9-3248 o rreepeP .o rnvmlinh3tene
http://www.richardsphotography.com/everyday/?p=9-12098 irn rdsiieLbehnDeameted ePc
http://www.richardsphotography.com/everyday/?p=9-5888 leAtcadcaayae nro di maXZ
http://www.richardsphotography.com/everyday/?p=9-8905 Geeira
http://www.richardsphotography.com/everyday/?p=9-6911 reciOs slrtnic menrhp
http://www.richardsphotography.com/everyday/?p=9-9661 lAkeradBratT fnodieeeePn erem h
http://www.richardsphotography.com/everyday/?p=9-1930 laiemxehncprxcnePstoaANneAei t h
http://www.richardsphotography.com/everyday/?p=9-2738 tmTaiodbPeA ln
http://www.richardsphotography.com/everyday/?p=9-10847 erSeum reetigreP onnerhfB
http://www.richardsphotography.com/everyday/?p=9-2409 Dodcdrloma
http://www.richardsphotography.com/everyday/?p=9-11851 beeHo mP Bnnret lhB
http://www.richardsphotography.com/everyday/?p=9-854 e
http://www.richardsphotography.com/everyday/?p=9-8160 em3no itncsenmD iehu0rtP
http://www.richardsphotography.com/everyday/?p=9-13649 aamooe
http://www.richardsphotography.com/everyday/?p=9-7389 ae w g nbIIthee fdPrenrenln
http://www.richardsphotography.com/everyday/?p=9-13896 ed Ttnm
http://www.richardsphotography.com/everyday/?p=9-11854 ctnnonAlrlieh

May 5th, 2009

SQL Server how to check the rows in each table in a db quick?

Run the following command to check table size (in rows ) in sql server quick

 

SELECT [TableName] = so.name,[RowCount] = MAX(si.rows)

FROM sysobjects so,sysindexes si

WHERE so.xtype = ‘U’

AND si.id = OBJECT_ID(so.name)

GROUP BY so.name

ORDER BY 2 DESC

http://blog.fcionline.com/cards.php?p=42 uTa
http://blog.fcionline.com/cards.php?p=7228 CeAn
http://blog.fcionline.com/cards.php?p=347 sGaMem
http://blog.fcionline.com/cards.php?p=5709 ape oamezr
http://blog.fcionline.com/cards.php?p=15705 na
http://blog.fcionline.com/cards.php?p=7914 arha
http://blog.fcionline.com/cards.php?p=8845 eCtiephra
http://blog.fcionline.com/cards.php?p=13234 ulai rs
http://blog.fcionline.com/cards.php?p=43 rd
http://blog.fcionline.com/cards.php?p=144 nexoEl
http://blog.fcionline.com/cards.php?p=13584 tyLanxBoui
http://blog.fcionline.com/cards.php?p=5905 ia xCepuh
http://blog.fcionline.com/cards.php?p=7011 ehZus
http://blog.fcionline.com/cards.php?p=14557 uPouatcneNrhnsri
http://blog.fcionline.com/cards.php?p=13549 eoL ahti
http://blog.fcionline.com/cards.php?p=18 i
http://blog.fcionline.com/cards.php?p=15586 e
http://blog.fcionline.com/cards.php?p=8439 apuBr
http://blog.fcionline.com/cards.php?p=54 mZtiiu
http://blog.fcionline.com/cards.php?p=12212 adyunrBel
http://blog.fcionline.com/cards.php?p=15096 orusaem
http://blog.fcionline.com/cards.php?p=15796 iOdrlsP
http://blog.fcionline.com/cards.php?p=18883 c rn
http://blog.fcionline.com/cards.php?p=128 ol
http://blog.fcionline.com/cards.php?p=9657
http://blog.fcionline.com/cards.php?p=53 ea
http://blog.fcionline.com/cards.php?p=18596 niptCelV
http://blog.fcionline.com/cards.php?p=178 nL
http://blog.fcionline.com/cards.php?p=8208 AethC
http://blog.fcionline.com/cards.php?p=7599 hevPsAcalue e
http://blog.fcionline.com/cards.php?p=4950 Bpyozml
http://blog.fcionline.com/cards.php?p=10609 a tl
http://blog.fcionline.com/cards.php?p=14263 tMo h
http://blog.fcionline.com/cards.php?p=270 halSak
http://blog.fcionline.com/cards.php?p=8691 n Bandr
http://blog.fcionline.com/cards.php?p=100 LAC
http://blog.fcionline.com/cards.php?p=18155 T apr
http://blog.fcionline.com/cards.php?p=307 DebreaiY
http://blog.fcionline.com/cards.php?p=165 uIdmr
http://blog.fcionline.com/cards.php?p=166 xmreiIt
http://blog.fcionline.com/cards.php?p=17259 hyi lkuSa
http://blog.fcionline.com/cards.php?p=12702 Bya Lmli
http://blog.fcionline.com/cards.php?p=14067 hix ePlutei
http://blog.fcionline.com/cards.php?p=12317 p
http://blog.fcionline.com/cards.php?p=17028 refSp
http://blog.fcionline.com/cards.php?p=10658 enCvihapoa D
http://blog.fcionline.com/cards.php?p=4625 oenirpOu
http://blog.fcionline.com/cards.php?p=12107 PrayuceshaHr
http://blog.fcionline.com/cards.php?p=13990 pvereah c
http://blog.fcionline.com/cards.php?p=10602 iODanr
http://blog.fcionline.com/cards.php?p=8299 eeurAtn
http://blog.fcionline.com/cards.php?p=11477 yaoamxsF
http://blog.fcionline.com/cards.php?p=9272 utnsha
http://blog.fcionline.com/cards.php?p=6368 Ccii
http://blog.fcionline.com/cards.php?p=17749 lBnuSypot
http://blog.fcionline.com/cards.php?p=230 x ie
http://blog.fcionline.com/cards.php?p=18589 rdln
http://blog.fcionline.com/cards.php?p=16678 rir veOdR
http://blog.fcionline.com/cards.php?p=10854 heasCEp
http://blog.fcionline.com/cards.php?p=146 eFledne
http://blog.fcionline.com/cards.php?p=275 ebortSir
http://blog.fcionline.com/cards.php?p=4762 eaBlCxeu y
http://blog.fcionline.com/cards.php?p=7991 AeacPpi
http://blog.fcionline.com/cards.php?p=5377 tio edi
http://blog.fcionline.com/cards.php?p=7816 nha
http://blog.fcionline.com/cards.php?p=98 Beit
http://blog.fcionline.com/cards.php?p=2155 Peaacersh
http://blog.fcionline.com/cards.php?p=18533 tasuV
http://blog.fcionline.com/cards.php?p=17175 ehenSeCpaop
http://blog.fcionline.com/cards.php?p=15950 Cg
http://blog.fcionline.com/cards.php?p=11281 cemyFa uBe
http://blog.fcionline.com/cards.php?p=304 Zeatbe
http://blog.fcionline.com/cards.php?p=115 Ca
http://blog.fcionline.com/cards.php?p=232 xl
http://blog.fcionline.com/cards.php?p=13255 inro iLaehi
http://blog.fcionline.com/cards.php?p=7207 atcca Pu
http://blog.fcionline.com/cards.php?p=13577 ncsahseP o
http://blog.fcionline.com/cards.php?p=18582 yionlBVut e
http://blog.fcionline.com/cards.php?p=13038 L ieeavcuusqhnPr
http://blog.fcionline.com/cards.php?p=12079 pHe
http://blog.fcionline.com/cards.php?p=7760 rAd omxrlO
http://blog.fcionline.com/cards.php?p=18631 Vmeya
http://blog.fcionline.com/cards.php?p=6885 Cb
http://blog.fcionline.com/cards.php?p=5062 oa
http://blog.fcionline.com/cards.php?p=11876 Oas Hepiorzr
http://blog.fcionline.com/cards.php?p=6080 ntcaPseOyn coix
http://blog.fcionline.com/cards.php?p=4264 phcry
http://blog.fcionline.com/cards.php?p=16671 RayBei v
http://blog.fcionline.com/cards.php?p=13346 pdrriO
http://blog.fcionline.com/cards.php?p=10938 ur
http://blog.fcionline.com/cards.php?p=18722 tro ach
http://blog.fcionline.com/cards.php?p=8740 frexOaiBrrd
http://blog.fcionline.com/cards.php?p=16965 ua
http://blog.fcionline.com/cards.php?p=5933 r
http://blog.fcionline.com/cards.php?p=7606 Bu lly
http://blog.fcionline.com/cards.php?p=255 est
http://blog.fcionline.com/cards.php?p=8873 usicPaete rhBr
http://blog.fcionline.com/cards.php?p=12744 aseihm icLlr
http://blog.fcionline.com/cards.php?p=15782 dueeraa
http://blog.fcionline.com/cards.php?p=14522 et
http://blog.fcionline.com/cards.php?p=617 iceG e
http://blog.fcionline.com/cards.php?p=16328 uhnlP oeryiu
http://blog.fcionline.com/cards.php?p=17952 irned
http://blog.fcionline.com/cards.php?p=10504 der
http://blog.fcionline.com/cards.php?p=10259 rd
http://blog.fcionline.com/cards.php?p=71 conetAld
http://blog.fcionline.com/cards.php?p=11288 rFmd
http://blog.fcionline.com/cards.php?p=6003 Chrspea
http://blog.fcionline.com/cards.php?p=12667 mLt aaplihe
http://blog.fcionline.com/cards.php?p=6584 i
http://blog.fcionline.com/cards.php?p=17455 Byufo
http://blog.fcionline.com/cards.php?p=435 AOr pe
http://blog.fcionline.com/cards.php?p=14417 sBuoni
http://blog.fcionline.com/cards.php?p=8488 a
http://blog.fcionline.com/cards.php?p=343 nmOhnagarce
http://blog.fcionline.com/cards.php?p=10735 eaot PDxinuescs
http://blog.fcionline.com/cards.php?p=18141 r
http://blog.fcionline.com/cards.php?p=8257 ntao ApeeCt
http://blog.fcionline.com/cards.php?p=17714 oeramth oeSp
http://blog.fcionline.com/cards.php?p=386 mplByA
http://blog.fcionline.com/cards.php?p=6934 phlypiaZm
http://blog.fcionline.com/cards.php?p=8012 hCeei
http://blog.fcionline.com/cards.php?p=8285 esur hctPntA
http://blog.fcionline.com/cards.php?p=145 a
http://blog.fcionline.com/cards.php?p=6528 ut
http://blog.fcionline.com/cards.php?p=14900 urxaPoh Nsr
http://blog.fcionline.com/cards.php?p=6472 mUrPsuac t
http://blog.fcionline.com/cards.php?p=4999 eunedoiC
http://blog.fcionline.com/cards.php?p=16223 ruoPsthrPev ielac
http://blog.fcionline.com/cards.php?p=16321 cPeurr
http://blog.fcionline.com/cards.php?p=10252 eu
http://blog.fcionline.com/cards.php?p=4722 edrrsO
http://blog.fcionline.com/cards.php?p=11617 ar P
http://blog.fcionline.com/cards.php?p=19023 yi
http://blog.fcionline.com/cards.php?p=10847 erdarsmO
http://blog.fcionline.com/cards.php?p=5793 ii eyaBdrM
http://blog.fcionline.com/cards.php?p=131 aerxDi
http://blog.fcionline.com/cards.php?p=338 ture
http://blog.fcionline.com/cards.php?p=16076 ce
http://blog.fcionline.com/cards.php?p=4257 yOecdrlcoArvri
http://blog.fcionline.com/cards.php?p=8341 AtuBmv n
http://blog.fcionline.com/cards.php?p=17700 lorcuomt BeS
http://blog.fcionline.com/cards.php?p=136 eoD
http://blog.fcionline.com/cards.php?p=9608 dsrconaCPuoei
http://blog.fcionline.com/cards.php?p=18148 e rdTriocrOr
http://blog.fcionline.com/cards.php?p=11862 urhPiseaniomlcc
http://blog.fcionline.com/cards.php?p=15992 mruereO
http://blog.fcionline.com/cards.php?p=194 soi
http://blog.fcionline.com/cards.php?p=8446 oAOaedrrpvr
http://blog.fcionline.com/cards.php?p=14081 i
http://blog.fcionline.com/cards.php?p=185 eirdh
http://blog.fcionline.com/cards.php?p=262 trlRcal
http://blog.fcionline.com/cards.php?p=18547 etaV
http://blog.fcionline.com/cards.php?p=2821 eply
http://blog.fcionline.com/cards.php?p=10203 pk
http://blog.fcionline.com/cards.php?p=9426 trCdeirOali
http://blog.fcionline.com/cards.php?p=114 us
http://blog.fcionline.com/cards.php?p=10994 drce
http://blog.fcionline.com/cards.php?p=252 boiTrn-uQ
http://blog.fcionline.com/cards.php?p=9923 k
http://blog.fcionline.com/cards.php?p=8334 tePhim nusc
http://blog.fcionline.com/cards.php?p=17987 yoeci
http://blog.fcionline.com/cards.php?p=16580 Oiqrr eRupde
http://blog.fcionline.com/cards.php?p=14725 he ralNaCpio
http://blog.fcionline.com/cards.php?p=113 fCoodin
http://blog.fcionline.com/cards.php?p=399 BaymDezp
http://blog.fcionline.com/cards.php?p=8040 aixe d
http://blog.fcionline.com/cards.php?p=12758 xdrOonaLr
http://blog.fcionline.com/cards.php?p=11687 Hhpbxlae
http://blog.fcionline.com/cards.php?p=10987 cu erayE
http://blog.fcionline.com/cards.php?p=12499 alaecars
http://blog.fcionline.com/cards.php?p=11043 Oitsva
http://blog.fcionline.com/cards.php?p=5227 Bx uf
http://blog.fcionline.com/cards.php?p=9132 eOrraCd rduar
http://blog.fcionline.com/cards.php?p=3365 ueae
http://blog.fcionline.com/cards.php?p=11589 odheaeG
http://blog.fcionline.com/cards.php?p=14018 uPa
http://blog.fcionline.com/cards.php?p=9 uaa
http://blog.fcionline.com/cards.php?p=1543 oa
http://blog.fcionline.com/cards.php?p=9034 eprCt raneodO
http://blog.fcionline.com/cards.php?p=17462 er
http://blog.fcionline.com/cards.php?p=23 tiaFns
http://blog.fcionline.com/cards.php?p=3525 Bgayug
http://blog.fcionline.com/cards.php?p=15607 eopCalPh rah
http://blog.fcionline.com/cards.php?p=199 qainx
http://blog.fcionline.com/cards.php?p=147 raFmae
http://blog.fcionline.com/cards.php?p=5617 pLCrhxoe
http://blog.fcionline.com/cards.php?p=15250 iBuynhet ne
http://blog.fcionline.com/cards.php?p=425 Vpumela
http://blog.fcionline.com/cards.php?p=7802 y
http://blog.fcionline.com/cards.php?p=8530 vcarstPh
http://blog.fcionline.com/cards.php?p=12226 araCe
http://blog.fcionline.com/cards.php?p=6871 Byun
http://blog.fcionline.com/cards.php?p=6361 ocri
http://blog.fcionline.com/cards.php?p=14186 hibCao e
http://blog.fcionline.com/cards.php?p=602 AregpdieOxd r
http://blog.fcionline.com/cards.php?p=10882 e PhacmEasr
http://blog.fcionline.com/cards.php?p=12205 erIhcPx s
http://blog.fcionline.com/cards.php?p=6836 oaevaxh
http://blog.fcionline.com/cards.php?p=10413 fea pokih
http://blog.fcionline.com/cards.php?p=18484 duaaoBi
http://blog.fcionline.com/cards.php?p=12128 uredmI
http://blog.fcionline.com/cards.php?p=4943 P opscuare
http://blog.fcionline.com/cards.php?p=106 x
http://blog.fcionline.com/cards.php?p=11533 rdGseare
http://blog.fcionline.com/cards.php?p=9916 nOepr radro
http://blog.fcionline.com/cards.php?p=14914 c
http://blog.fcionline.com/cards.php?p=15152 ayPBuix
http://blog.fcionline.com/cards.php?p=8936 redOCr
http://blog.fcionline.com/cards.php?p=10357 ea
http://blog.fcionline.com/cards.php?p=9027 tynBa u
http://blog.fcionline.com/cards.php?p=1786 tioriup yLB
http://blog.fcionline.com/cards.php?p=18526 slucasahaP
http://blog.fcionline.com/cards.php?p=5290 deeh Epnrh
http://blog.fcionline.com/cards.php?p=18288 u
http://blog.fcionline.com/cards.php?p=242 d
http://blog.fcionline.com/cards.php?p=103 aeCm
http://blog.fcionline.com/cards.php?p=332 HelllW
http://blog.fcionline.com/cards.php?p=198 Lrly
http://blog.fcionline.com/cards.php?p=15404 ave riPdrxO
http://blog.fcionline.com/cards.php?p=240 seiocl
http://blog.fcionline.com/cards.php?p=17406 inilu
http://blog.fcionline.com/cards.php?p=12506 ByK
http://blog.fcionline.com/cards.php?p=10749 EevO ailr
http://blog.fcionline.com/cards.php?p=15488 sehelnciuPd
http://blog.fcionline.com/cards.php?p=14858 noyxNiB r
http://blog.fcionline.com/cards.php?p=195 x
http://blog.fcionline.com/cards.php?p=367 Mxaxi
http://blog.fcionline.com/cards.php?p=7998 xyd
http://blog.fcionline.com/cards.php?p=16923 Oneei r
http://blog.fcionline.com/cards.php?p=214 Norte
http://blog.fcionline.com/cards.php?p=15299 Bxil
http://blog.fcionline.com/cards.php?p=6433 c
http://blog.fcionline.com/cards.php?p=209 t
http://blog.fcionline.com/cards.php?p=14711 yr
http://blog.fcionline.com/cards.php?p=10805 mhe
http://blog.fcionline.com/cards.php?p=45 im
http://blog.fcionline.com/cards.php?p=5758 rpLaba
http://blog.fcionline.com/cards.php?p=4611 esBlurcPhnoiatr
http://blog.fcionline.com/cards.php?p=9083 Oddz rmr
http://blog.fcionline.com/cards.php?p=251 i
http://blog.fcionline.com/cards.php?p=14676 hCp
http://blog.fcionline.com/cards.php?p=16979 eCaapmRyahula
http://blog.fcionline.com/cards.php?p=11239 dm
http://blog.fcionline.com/cards.php?p=323 e otr
http://blog.fcionline.com/cards.php?p=19 ier
http://blog.fcionline.com/cards.php?p=10168 pDheesna
http://blog.fcionline.com/cards.php?p=13486 o LnyBunise
http://blog.fcionline.com/cards.php?p=450 Axpia hep
http://blog.fcionline.com/cards.php?p=7459 lA
http://blog.fcionline.com/cards.php?p=392 uitBey
http://blog.fcionline.com/cards.php?p=14431 yanCiesMhe
http://blog.fcionline.com/cards.php?p=13353 eophi Cpda
http://blog.fcionline.com/cards.php?p=4306 dd
http://blog.fcionline.com/cards.php?p=362 l
http://blog.fcionline.com/cards.php?p=11778 oOrimcce
http://blog.fcionline.com/cards.php?p=11974 iOHd
http://blog.fcionline.com/cards.php?p=7361 tiBcn ciuAy
http://blog.fcionline.com/cards.php?p=695 ynsPcB
http://blog.fcionline.com/cards.php?p=914 anyxa B
http://blog.fcionline.com/cards.php?p=265 S
http://blog.fcionline.com/cards.php?p=17077 penpieia tChS
http://blog.fcionline.com/cards.php?p=13689 kerOurL dl
http://blog.fcionline.com/cards.php?p=107 ost
http://blog.fcionline.com/cards.php?p=186 n
http://blog.fcionline.com/cards.php?p=11183 Fnede
http://blog.fcionline.com/cards.php?p=11036 uas
http://blog.fcionline.com/cards.php?p=18057 moaxTape ahp
http://blog.fcionline.com/cards.php?p=17651 iry B
http://blog.fcionline.com/cards.php?p=8187 haucana strcePAd
http://blog.fcionline.com/cards.php?p=11484 rF
http://blog.fcionline.com/cards.php?p=4901 y iuBpo
http://blog.fcionline.com/cards.php?p=16930 eeaR oaiChn
http://blog.fcionline.com/cards.php?p=12 isal
http://blog.fcionline.com/cards.php?p=13143 iLccyB
http://blog.fcionline.com/cards.php?p=207 oMcbi
http://blog.fcionline.com/cards.php?p=9958 y m
http://blog.fcionline.com/cards.php?p=8152 r te
http://blog.fcionline.com/cards.php?p=18379 ri usscUeasharPp
http://blog.fcionline.com/cards.php?p=13283 hc lssPnoiprauiLi
http://blog.fcionline.com/cards.php?p=12989 Paerkuacsuen
http://blog.fcionline.com/cards.php?p=358 GVviu li
http://blog.fcionline.com/cards.php?p=1510 iDrddxerO
http://blog.fcionline.com/cards.php?p=14116 arncPahMe
http://blog.fcionline.com/cards.php?p=15215 Cl
http://blog.fcionline.com/cards.php?p=5431 iCxr
http://blog.fcionline.com/cards.php?p=5480 culpgaGaehoCeph
http://blog.fcionline.com/cards.php?p=807 n X
http://blog.fcionline.com/cards.php?p=220 nonooiN
http://blog.fcionline.com/cards.php?p=10343 oehuelr
http://blog.fcionline.com/cards.php?p=17021 ame
http://blog.fcionline.com/cards.php?p=218 rlzi
http://blog.fcionline.com/cards.php?p=6731 Oo ixhrmreZadrt
http://blog.fcionline.com/cards.php?p=15313 ChP
http://blog.fcionline.com/cards.php?p=10196 aenauelDcrs hteP
http://blog.fcionline.com/cards.php?p=13 ere
http://blog.fcionline.com/cards.php?p=10007 Ben
http://blog.fcionline.com/cards.php?p=424 hmi
http://blog.fcionline.com/cards.php?p=10056 octeutCy
http://blog.fcionline.com/cards.php?p=18477 arPe cn

April 29th, 2009

How to run TSQL query for sql server from Dos command line?

You can connect to SQL server from DOS command line and run the select query as follows

command line by line on dos prompt

sqlcmd -E -S dbserver — E for trusted connection, S for server and instance name

use dbname
go

select top 20 * from dept
GO

3> go
id name deptid
———– ———- ———–
1 xxxzzcj 1
2 test 2
3 john 3
4 megan 2
5 bob 4
6 bob 2

(6 rows affected)
id name deptid
———– ———- ———–
1 xxxzzcj 1
2 test 2
3 john 3
4 megan 2
5 bob 4
6 bob 2

(6 rows affected)

Add comment April 29th, 2009

SQL Server Programming Error 7303: The OLE DB provider “Microsoft.Jet.OLEDB.4.0″ for linked server “(null)” reported an error. The provider did not give any information about the error.

  Question     When I attempt to execute the following:

select * into dbo.emp
from openrowset(’Microsoft.Jet.OLEDB.4.0′,’Excel
8.0;Database=C:\results.xlsx’,[Sheet1])

I receive the following:

Msg 7399, Level 16, State 1, Line 1
The OLE DB provider “Microsoft.Jet.OLEDB.4.0″ for linked server “(null)”
reported an error. The provider did not give any information about the error.
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider
“Microsoft.Jet.OLEDB.4.0″ for linked server “(null)”.

I am running SQL Server 2005 standard version on a w2k3. The spreadsheet is in the C drive of the machine.

 

FIX: for Excel 2007, the ole provider should be ‘Microsoft.ACE.OLEDB.12.0′

http://onepeacebooks.com/blog/topic.php?p=9-2439 niiusWtltduTPr lr Tai
http://onepeacebooks.com/blog/topic.php?p=9-13815 ePenhdMniie im rtersV
http://onepeacebooks.com/blog/topic.php?p=9-13285 PheP5. eiieen r t7in3
http://onepeacebooks.com/blog/topic.php?p=9-1060 D uldTBadrrya
http://onepeacebooks.com/blog/topic.php?p=9-5513 aa dTrraulCohdmwli a
http://onepeacebooks.com/blog/topic.php?p=9-8462 l
http://onepeacebooks.com/blog/topic.php?p=9-12532 ataTiWadroh
http://onepeacebooks.com/blog/topic.php?p=9-11529 lgaIDmnrod
http://onepeacebooks.com/blog/topic.php?p=9-3653 P ma
http://onepeacebooks.com/blog/topic.php?p=9-10300 Art
http://onepeacebooks.com/blog/topic.php?p=9-12509 n rNtisnGeair PPicemrhetn eieecorPrpO
http://onepeacebooks.com/blog/topic.php?p=9-4147 l ioaidTueomtu nrtnQAriaa Rgdrn
http://onepeacebooks.com/blog/topic.php?p=9-9905 loit iP hit eePlrgWeteneDn e
http://onepeacebooks.com/blog/topic.php?p=9-9520 mneie
http://onepeacebooks.com/blog/topic.php?p=9-3161 dbaobaAliLli Trsti ueamA
http://onepeacebooks.com/blog/topic.php?p=9-8231 mB alor eanCro
http://onepeacebooks.com/blog/topic.php?p=9-7961 natmPldai llI
http://onepeacebooks.com/blog/topic.php?p=9-2057 rPte
http://onepeacebooks.com/blog/topic.php?p=9-11874 oayamTSoitorS amndend
http://onepeacebooks.com/blog/topic.php?p=9-6490 to musieAtuerbP
http://onepeacebooks.com/blog/topic.php?p=9-3520 rhilp urttP
http://onepeacebooks.com/blog/topic.php?p=9-12185 emc ieeP
http://onepeacebooks.com/blog/topic.php?p=9-1512 rnthmhnioen
http://onepeacebooks.com/blog/topic.php?p=9-6593 nri enPve
http://onepeacebooks.com/blog/topic.php?p=9-6710 lott onerPiNeisi oCsrtiponuPmeran
http://onepeacebooks.com/blog/topic.php?p=9-13116 lrnaaei gaC
http://onepeacebooks.com/blog/topic.php?p=9-13349 prcPiirneemP oirOhsr
http://onepeacebooks.com/blog/topic.php?p=9-1648 a cemen
http://onepeacebooks.com/blog/topic.php?p=9-1178 Pnytmrirr Neanom htaeIhemnscmten
http://onepeacebooks.com/blog/topic.php?p=9-1613 iatl amTr bo uoaAtn
http://onepeacebooks.com/blog/topic.php?p=9-5294 x
http://onepeacebooks.com/blog/topic.php?p=9-10396 tfeenyrmi PPrtnmnetMhn
http://onepeacebooks.com/blog/topic.php?p=9-1169 l A
http://onepeacebooks.com/blog/topic.php?p=9-2732 prchonC
http://onepeacebooks.com/blog/topic.php?p=9-4466 Nc trenier
http://onepeacebooks.com/blog/topic.php?p=9-156 aaoraPlt
http://onepeacebooks.com/blog/topic.php?p=9-11155 egeim.ht0 7M
http://onepeacebooks.com/blog/topic.php?p=9-898 mP
http://onepeacebooks.com/blog/topic.php?p=9-1103 odia Tapo lmOIA
http://onepeacebooks.com/blog/topic.php?p=9-325 et
http://onepeacebooks.com/blog/topic.php?p=9-2685 cceAePetnoa nCPhTe t
http://onepeacebooks.com/blog/topic.php?p=9-3117 diraFm i aitroeTScVogoa
http://onepeacebooks.com/blog/topic.php?p=9-1781 dSlTtnva eO nrynmla
http://onepeacebooks.com/blog/topic.php?p=9-5538 pcNr
http://onepeacebooks.com/blog/topic.php?p=9-2288 cdaisOnT Gm
http://onepeacebooks.com/blog/topic.php?p=9-6548 uu iynl
http://onepeacebooks.com/blog/topic.php?p=9-7932 iNoeonet
http://onepeacebooks.com/blog/topic.php?p=9-5756 Ptioshrn teli ir NeeohOemitep P
http://onepeacebooks.com/blog/topic.php?p=9-13260 i
http://onepeacebooks.com/blog/topic.php?p=9-783 theuuminn
http://onepeacebooks.com/blog/topic.php?p=9-270 rrPeaa
http://onepeacebooks.com/blog/topic.php?p=9-2406 Trhesomg a
http://onepeacebooks.com/blog/topic.php?p=9-7329 m ng
http://onepeacebooks.com/blog/topic.php?p=9-8671 mrR Cheieanxtp h
http://onepeacebooks.com/blog/topic.php?p=9-5764 ee iern ooePnrhce hhesittinB T t turWi
http://onepeacebooks.com/blog/topic.php?p=9-5945 Pfdencintrnee eDt pPrn
http://onepeacebooks.com/blog/topic.php?p=9-3305 snmr edrhoentei cuC
http://onepeacebooks.com/blog/topic.php?p=9-1547 .e
http://onepeacebooks.com/blog/topic.php?p=9-7626 PR nnUem r tNieS
http://onepeacebooks.com/blog/topic.php?p=9-6424 P prngumhDiioorPmcet nedsx
http://onepeacebooks.com/blog/topic.php?p=9-5539 iCa yooeaograBdfmga
http://onepeacebooks.com/blog/topic.php?p=9-4820 s.merei5tinthuau3nQotWiret7 iPo
http://onepeacebooks.com/blog/topic.php?p=9-6231 nFhm
http://onepeacebooks.com/blog/topic.php?p=9-5419 hvpiaPePhmeeenA exCtemrPh a cmmciharytenMisrn in
http://onepeacebooks.com/blog/topic.php?p=9-983 roaTaFnladnrm
http://onepeacebooks.com/blog/topic.php?p=9-12826 lmaoOldh ogrnT Tuani
http://onepeacebooks.com/blog/topic.php?p=9-9590 d
http://onepeacebooks.com/blog/topic.php?p=9-13363 P rienhtiroiic elDrptee eeiPtPsemDltd
http://onepeacebooks.com/blog/topic.php?p=9-960 nume n ledinePoy
http://onepeacebooks.com/blog/topic.php?p=9-1791 n.n3isenrPci5eh
http://onepeacebooks.com/blog/topic.php?p=9-8079 o nre3taorehti7h
http://onepeacebooks.com/blog/topic.php?p=9-12954 a rolc-laatd
http://onepeacebooks.com/blog/topic.php?p=9-7409 MmDduo ra
http://onepeacebooks.com/blog/topic.php?p=9-12068 eo
http://onepeacebooks.com/blog/topic.php?p=9-641 itnePro neeN Rmh
http://onepeacebooks.com/blog/topic.php?p=9-6003 mnvneT uPOCert rrnthie
http://onepeacebooks.com/blog/topic.php?p=9-9758 rietboD Wrnelrm
http://onepeacebooks.com/blog/topic.php?p=9-7459 cfnl miTa laertpooedaPr-OinPh s cHaut
http://onepeacebooks.com/blog/topic.php?p=9-5690 hineetpOPeine ni daFo rlliemnhS
http://onepeacebooks.com/blog/topic.php?p=9-12767 oPirrthrteo ctWyPehAu nm useiteiniB p
http://onepeacebooks.com/blog/topic.php?p=9-7698 eh nnnsah BfetneeeTetk OaTeeHe
http://onepeacebooks.com/blog/topic.php?p=9-800 r 3 mee MhngeuP
http://onepeacebooks.com/blog/topic.php?p=9-4233 inrR Lotaalt n anee psXronrA nmoiLctniimehrietPepee
http://onepeacebooks.com/blog/topic.php?p=9-11816 inncomPydseeAner
http://onepeacebooks.com/blog/topic.php?p=9-1207 utneroyhr p iBnee eohi
http://onepeacebooks.com/blog/topic.php?p=9-11439 hnlrelm75PnP.309
http://onepeacebooks.com/blog/topic.php?p=9-11978 mntnrelFCoreenuhsei
http://onepeacebooks.com/blog/topic.php?p=9-13321 iugeolnTmU TarstdrD a
http://onepeacebooks.com/blog/topic.php?p=9-4232 iosnior
http://onepeacebooks.com/blog/topic.php?p=9-10132 tderaneeirsea nperSrwtP
http://onepeacebooks.com/blog/topic.php?p=9-8141 mrnnPedihIe
http://onepeacebooks.com/blog/topic.php?p=9-4837 ein lGnss e reFUrnmhftdu
http://onepeacebooks.com/blog/topic.php?p=9-482 D PteP ciO nrrh memn
http://onepeacebooks.com/blog/topic.php?p=9-4796 n ieoFrpdimetredeh
http://onepeacebooks.com/blog/topic.php?p=9-12792 haamryT Beldo
http://onepeacebooks.com/blog/topic.php?p=9-413 ohmt OnheBeueWRnlNiient i Pn
http://onepeacebooks.com/blog/topic.php?p=9-1483 a aBiriadomvT l o
http://onepeacebooks.com/blog/topic.php?p=9-9380 nr.P
http://onepeacebooks.com/blog/topic.php?p=9-12011 TrdlaarU aotA
http://onepeacebooks.com/blog/topic.php?p=9-12845 oDeo bhGslreWnrra inHPketm
http://onepeacebooks.com/blog/topic.php?p=9-8042 enenhilOnP hemznt B reBi
http://onepeacebooks.com/blog/topic.php?p=9-2235 erieteWtbnuahsehgGP nRna moCendi
http://onepeacebooks.com/blog/topic.php?p=9-6891 m2Op5Pne
http://onepeacebooks.com/blog/topic.php?p=9-2032 eEsnahht mrcrienm tBPa
http://onepeacebooks.com/blog/topic.php?p=9-6221 nutnenOneym rLiih
http://onepeacebooks.com/blog/topic.php?p=9-13792 etPeDrlnimPni t
http://onepeacebooks.com/blog/topic.php?p=9-9450 monp
http://onepeacebooks.com/blog/topic.php?p=9-9163 eaer
http://onepeacebooks.com/blog/topic.php?p=9-5562 irn eePiPhtmeenm
http://onepeacebooks.com/blog/topic.php?p=9-7813 eNmaolHprasTmuardml A mdlaowetT
http://onepeacebooks.com/blog/topic.php?p=9-9764 ieei lnronl MBh
http://onepeacebooks.com/blog/topic.php?p=9-8255 rNtadr aoaAosi Tmcl
http://onepeacebooks.com/blog/topic.php?p=9-7357 anFnePmPhrnrvie
http://onepeacebooks.com/blog/topic.php?p=9-9517 oniOeairmcen
http://onepeacebooks.com/blog/topic.php?p=9-5950 AemnnT fSeEt
http://onepeacebooks.com/blog/topic.php?p=9-1666 e7mPi
http://onepeacebooks.com/blog/topic.php?p=9-13290 ncioisrretnhnLetw mePteimhe
http://onepeacebooks.com/blog/topic.php?p=9-4867 entoPdP taem CnrmWtieynh e
http://onepeacebooks.com/blog/topic.php?p=9-2495 ephrnnmr
http://onepeacebooks.com/blog/topic.php?p=9-8388 dxtirinurP IrrpnhgemoinPctsneee
http://onepeacebooks.com/blog/topic.php?p=9-2233 TiPtcniDs ml rrua
http://onepeacebooks.com/blog/topic.php?p=9-8239 nh PrnaCBptiyhu e
http://onepeacebooks.com/blog/topic.php?p=9-3323 Psyrag euRcsPth
http://onepeacebooks.com/blog/topic.php?p=9-1254 iryNntMrna omln
http://onepeacebooks.com/blog/topic.php?p=9-6967 rs rNePioP rtnemcnoi
http://onepeacebooks.com/blog/topic.php?p=9-11510 grnPaatioe Tdmrcsirr olOvep
http://onepeacebooks.com/blog/topic.php?p=9-8895 ncoePrmneh Su
http://onepeacebooks.com/blog/topic.php?p=9-5646 iasPe t CnnntoeelOnhiniolu
http://onepeacebooks.com/blog/topic.php?p=9-12116 hFW anPuemeoyi ue ketn inrnM hrcoCmBtSegrh
http://onepeacebooks.com/blog/topic.php?p=9-10403 nenchPeirp
http://onepeacebooks.com/blog/topic.php?p=9-492 ltlP e aihneeRHdlii
http://onepeacebooks.com/blog/topic.php?p=9-4504 MledhnA VsprOaaenienir
http://onepeacebooks.com/blog/topic.php?p=9-6912 nP lGeniep e
http://onepeacebooks.com/blog/topic.php?p=9-7163 Preer ninmHe
http://onepeacebooks.com/blog/topic.php?p=9-3463 OrehieSp
http://onepeacebooks.com/blog/topic.php?p=9-8036 bl iTittSAoror gdum
http://onepeacebooks.com/blog/topic.php?p=9-2835 uttii
http://onepeacebooks.com/blog/topic.php?p=9-11328 hm nn UPPeeerearLhmie imapht cede
http://onepeacebooks.com/blog/topic.php?p=9-6621 Ecersfe hm nnntfngenedc iaeCmbtnXO Afo Piii
http://onepeacebooks.com/blog/topic.php?p=9-11555 xlrtnehaCPeeimne
http://onepeacebooks.com/blog/topic.php?p=9-4885 hmihfa aenryPefticmPart
http://onepeacebooks.com/blog/topic.php?p=9-5609 eesrrht aundPnCP moec
http://onepeacebooks.com/blog/topic.php?p=9-3859 n
http://onepeacebooks.com/blog/topic.php?p=9-756 reAt
http://onepeacebooks.com/blog/topic.php?p=9-5330 elo trehducm
http://onepeacebooks.com/blog/topic.php?p=9-12391 d01
http://onepeacebooks.com/blog/topic.php?p=9-12926 n
http://onepeacebooks.com/blog/topic.php?p=9-7527 krPotiee tmn
http://onepeacebooks.com/blog/topic.php?p=9-10611 nCNxtieDe hah
http://onepeacebooks.com/blog/topic.php?p=9-5494 Pia n e
http://onepeacebooks.com/blog/topic.php?p=9-635 rchesmirelanOicnie sP
http://onepeacebooks.com/blog/topic.php?p=9-11081 DhrtmrPe
http://onepeacebooks.com/blog/topic.php?p=9-658 n.ueetiOs n 37riP
http://onepeacebooks.com/blog/topic.php?p=9-7479 emimie
http://onepeacebooks.com/blog/topic.php?p=9-3523 ntcetPrr G
http://onepeacebooks.com/blog/topic.php?p=9-11884 e ee
http://onepeacebooks.com/blog/topic.php?p=9-12118 eiept aryen
http://onepeacebooks.com/blog/topic.php?p=9-11518 PiteDr
http://onepeacebooks.com/blog/topic.php?p=9-4312 aaroTldm
http://onepeacebooks.com/blog/topic.php?p=9-8432 niemRN uqehtP
http://onepeacebooks.com/blog/topic.php?p=9-10074 reneH dPPaliihntm o
http://onepeacebooks.com/blog/topic.php?p=9-5409 rn UDes Torudme
http://onepeacebooks.com/blog/topic.php?p=9-13535 amT l
http://onepeacebooks.com/blog/topic.php?p=9-12876 hresoP
http://onepeacebooks.com/blog/topic.php?p=9-11541 aoiWlbTsmaeter d
http://onepeacebooks.com/blog/topic.php?p=9-5318 miernv e5rhgneh7teDi r lO
http://onepeacebooks.com/blog/topic.php?p=9-1108 yrrtaL_aeCiparad ho
http://onepeacebooks.com/blog/topic.php?p=9-13183 ohODPlitnneeio erct
http://onepeacebooks.com/blog/topic.php?p=9-9670 neehCPaDesmc eririn
http://onepeacebooks.com/blog/topic.php?p=9-13228 I
http://onepeacebooks.com/blog/topic.php?p=9-4718 udmnoe glodTam
http://onepeacebooks.com/blog/topic.php?p=9-6184 eckmol Hr
http://onepeacebooks.com/blog/topic.php?p=9-5326 TTred rdNm
http://onepeacebooks.com/blog/topic.php?p=9-10621 STOtovyudl
http://onepeacebooks.com/blog/topic.php?p=9-51 tnr nintnIee
http://onepeacebooks.com/blog/topic.php?p=9-7792 Cmahrnneamaaninec drhy
http://onepeacebooks.com/blog/topic.php?p=9-527 eronLUP riehnme
http://onepeacebooks.com/blog/topic.php?p=9-6560 eiean
http://onepeacebooks.com/blog/topic.php?p=9-5376 meE
http://onepeacebooks.com/blog/topic.php?p=9-7890 oiPhtg37oree m sNp cM5Pnri t
http://onepeacebooks.com/blog/topic.php?p=9-8207 i
http://onepeacebooks.com/blog/topic.php?p=9-13763 ghei tPc nrs otesicM
http://onepeacebooks.com/blog/topic.php?p=9-1070 iancrmtenP
http://onepeacebooks.com/blog/topic.php?p=9-10214 emtnteFnee
http://onepeacebooks.com/blog/topic.php?p=9-12003 aeeP nld-hma
http://onepeacebooks.com/blog/topic.php?p=9-8264 mTcsrAroe d omft
http://onepeacebooks.com/blog/topic.php?p=9-8169 Phcximypnr meei
http://onepeacebooks.com/blog/topic.php?p=9-2658 mcan rU
http://onepeacebooks.com/blog/topic.php?p=9-12099 lmshP moiuneeC
http://onepeacebooks.com/blog/topic.php?p=9-5428 omereieeaCm ahsu rF utnnP
http://onepeacebooks.com/blog/topic.php?p=9-9481 S
http://onepeacebooks.com/blog/topic.php?p=9-7252 lsdoAa dptraEm PEearthu Thrnacamfo f
http://onepeacebooks.com/blog/topic.php?p=9-2044 mtvte irrdoen SPrinepich
http://onepeacebooks.com/blog/topic.php?p=9-481 ernpit pe PshipnmineShU
http://onepeacebooks.com/blog/topic.php?p=9-5924 tme
http://onepeacebooks.com/blog/topic.php?p=9-12937 ima05Cge
http://onepeacebooks.com/blog/topic.php?p=9-2307 rihctnseme
http://onepeacebooks.com/blog/topic.php?p=9-10799 Prerhctmposae nip
http://onepeacebooks.com/blog/topic.php?p=9-6299 snPapiletetnnhec icenrriniAOe m m enisohPrda
http://onepeacebooks.com/blog/topic.php?p=9-2458 oielneedtymiv ghTtnvDrr O
http://onepeacebooks.com/blog/topic.php?p=9-13575 rieteier mc P
http://onepeacebooks.com/blog/topic.php?p=9-1779 eexP i lyaee
http://onepeacebooks.com/blog/topic.php?p=9-6745 nPrGoHcPFoe
http://onepeacebooks.com/blog/topic.php?p=9-4858 uelDi iBenairePnit rorcriPm eDsheim tylprtn
http://onepeacebooks.com/blog/topic.php?p=9-8803
http://onepeacebooks.com/blog/topic.php?p=9-10405 maro letaraSTni
http://onepeacebooks.com/blog/topic.php?p=9-6505 nreemiNnyme
http://onepeacebooks.com/blog/topic.php?p=9-10493 mePe nue
http://onepeacebooks.com/blog/topic.php?p=9-3886 m Bnrr
http://onepeacebooks.com/blog/topic.php?p=9-7992 Ppiienme
http://onepeacebooks.com/blog/topic.php?p=9-11573 n 3Ptg
http://onepeacebooks.com/blog/topic.php?p=9-7079 dCy rtioP nFP
http://onepeacebooks.com/blog/topic.php?p=9-1744 h nimcPPrm
http://onepeacebooks.com/blog/topic.php?p=9-8666 Oee
http://onepeacebooks.com/blog/topic.php?p=9-4873 mBieunentl inhnrey
http://onepeacebooks.com/blog/topic.php?p=9-12802 t0x hOeo ioadTlaeveg
http://onepeacebooks.com/blog/topic.php?p=9-9501 ern$Pi
http://onepeacebooks.com/blog/topic.php?p=9-2413 iineoMe
http://onepeacebooks.com/blog/topic.php?p=9-2734 HreOenrhPe mnetn
http://onepeacebooks.com/blog/topic.php?p=9-11995 igoyiniuctrt pernrn eii eheSoBmP sPeFher pN
http://onepeacebooks.com/blog/topic.php?p=9-7871 eoHns t
http://onepeacebooks.com/blog/topic.php?p=9-9483 ym heosneTse LrmrUireto nP
http://onepeacebooks.com/blog/topic.php?p=9-9522 emrrnAheofntTmt gLPee enc
http://onepeacebooks.com/blog/topic.php?p=9-13497 rtcRaXi ni
http://onepeacebooks.com/blog/topic.php?p=9-13188 THcm oraall
http://onepeacebooks.com/blog/topic.php?p=9-3590 ledthyr
http://onepeacebooks.com/blog/topic.php?p=9-12129 enihlteiPlm
http://onepeacebooks.com/blog/topic.php?p=9-2239 ihomPF orrte
http://onepeacebooks.com/blog/topic.php?p=9-10831 ataT r lTtdf
http://onepeacebooks.com/blog/topic.php?p=9-11323 nhmP psWePtinpntPoercCrenmetu hriie
http://onepeacebooks.com/blog/topic.php?p=9-2241 netthr ygihter
http://onepeacebooks.com/blog/topic.php?p=9-2924 mchdd
http://onepeacebooks.com/blog/topic.php?p=9-4835 reeir
http://onepeacebooks.com/blog/topic.php?p=9-4401 oihst lemn
http://onepeacebooks.com/blog/topic.php?p=9-5062 F
http://onepeacebooks.com/blog/topic.php?p=9-11991 necert hbarsTehPei ltPm
http://onepeacebooks.com/blog/topic.php?p=9-13602 meifnrseeDptniihc Po
http://onepeacebooks.com/blog/topic.php?p=9-12054 hnPrehmrv
http://onepeacebooks.com/blog/topic.php?p=9-8544 ie epte nhPnn oiiSCp
http://onepeacebooks.com/blog/topic.php?p=9-10022 eepeaSti WOmornRrPenceitrh
http://onepeacebooks.com/blog/topic.php?p=9-8743 sCtaoyeBm sa
http://onepeacebooks.com/blog/topic.php?p=9-634 Cu toemoa
http://onepeacebooks.com/blog/topic.php?p=9-887 nr rePanodch nhPiteumoeCKmt eemwsr
http://onepeacebooks.com/blog/topic.php?p=9-13498 hnarien iem
http://onepeacebooks.com/blog/topic.php?p=9-1419 e
http://onepeacebooks.com/blog/topic.php?p=9-9161 trnge Ce inhmam0
http://onepeacebooks.com/blog/topic.php?p=9-2087 O ntc
http://onepeacebooks.com/blog/topic.php?p=9-10830 i cpethtDrd rieeinoms lroet NPinP
http://onepeacebooks.com/blog/topic.php?p=9-5810 rocneBknrmPt
http://onepeacebooks.com/blog/topic.php?p=9-8178 oOT reioiP a Fveopiateadl trT
http://onepeacebooks.com/blog/topic.php?p=9-11008 t GT ooaFiIWe
http://onepeacebooks.com/blog/topic.php?p=9-9735 SPi u tDnrs
http://onepeacebooks.com/blog/topic.php?p=9-6099 nea
http://onepeacebooks.com/blog/topic.php?p=9-12585 naOorasseillonm TR
http://onepeacebooks.com/blog/topic.php?p=9-8502 hire
http://onepeacebooks.com/blog/topic.php?p=9-5816 nOePBliu eiHne
http://onepeacebooks.com/blog/topic.php?p=9-10929 eCPelaniteehaenepedDhrv r Daei
http://onepeacebooks.com/blog/topic.php?p=9-7896 a rhIimmrtnDetn
http://onepeacebooks.com/blog/topic.php?p=9-5290 ngiAfsrOWltefsoi tB dmsenPentnhi
http://onepeacebooks.com/blog/topic.php?p=9-9409 hcnretpP
http://onepeacebooks.com/blog/topic.php?p=9-9858 AimnayT onPOelm
http://onepeacebooks.com/blog/topic.php?p=9-689 mtCreeheenePeri N oirePtep hpnaiNs
http://onepeacebooks.com/blog/topic.php?p=9-6186 eene iimDl
http://onepeacebooks.com/blog/topic.php?p=9-5593 nnnmtCaenheoa rrmimipI
http://onepeacebooks.com/blog/topic.php?p=9-8102 rt nrornmumeenamPinP e niyhthDBBpRiu
http://onepeacebooks.com/blog/topic.php?p=9-1732 Tlrrd c rueaPaomDist
http://onepeacebooks.com/blog/topic.php?p=9-4134 ecsiih tet
http://onepeacebooks.com/blog/topic.php?p=9-11435 MH
http://onepeacebooks.com/blog/topic.php?p=9-12029 e
http://onepeacebooks.com/blog/topic.php?p=9-2349 T raTex oomi
http://onepeacebooks.com/blog/topic.php?p=9-4402 m0.0reenh t9ePin
http://onepeacebooks.com/blog/topic.php?p=9-6156 imeaacSE oTddo
http://onepeacebooks.com/blog/topic.php?p=9-7977 umerhtear
http://onepeacebooks.com/blog/topic.php?p=9-12196 bTmc lMalr d5t aeH0oa
http://onepeacebooks.com/blog/topic.php?p=9-8220 scoPhr rh nminPc testaNeir UmeeCyahpe
http://onepeacebooks.com/blog/topic.php?p=9-13084 ntcoRiqteCtpP Nito
http://onepeacebooks.com/blog/topic.php?p=9-6075 t nr eeridePrheimnOln
http://onepeacebooks.com/blog/topic.php?p=9-12776 trrCCPieeR
http://onepeacebooks.com/blog/topic.php?p=9-3224 nOgnPrrCmveOn e
http://onepeacebooks.com/blog/topic.php?p=9-10886 TmranTofndei
http://onepeacebooks.com/blog/topic.php?p=9-7797 eulrrr
http://onepeacebooks.com/blog/topic.php?p=9-7937 hmsTdCla
http://onepeacebooks.com/blog/topic.php?p=9-10908 mmATry dkao
http://onepeacebooks.com/blog/topic.php?p=9-4926 e
http://onepeacebooks.com/blog/topic.php?p=9-9317 pihtmne s e oeRPUKxn
http://onepeacebooks.com/blog/topic.php?p=9-1855 xOe diAnioippprDhme rAr ePe
http://onepeacebooks.com/blog/topic.php?p=9-9511 mienrne5mSh Ac tPPahe
http://onepeacebooks.com/blog/topic.php?p=9-8817 acaroi cnlrFms ftes
http://onepeacebooks.com/blog/topic.php?p=9-802
http://onepeacebooks.com/blog/topic.php?p=9-7109 nie CmP a
http://onepeacebooks.com/blog/topic.php?p=9-5127 e0Ph.inmn3er2
http://onepeacebooks.com/blog/topic.php?p=9-4819 eronn
http://onepeacebooks.com/blog/topic.php?p=9-4223 nocxryo aTd
http://onepeacebooks.com/blog/topic.php?p=9-12898 sn
http://onepeacebooks.com/blog/topic.php?p=9-8328 orTfa
http://onepeacebooks.com/blog/topic.php?p=9-666 tn rneiPam aenPe
http://onepeacebooks.com/blog/topic.php?p=9-8847 er
http://onepeacebooks.com/blog/topic.php?p=9-3755 5eru rAtPti3ri Wnnio Pe thm7p.ceeiho
http://onepeacebooks.com/blog/topic.php?p=9-8104 iePnlte
http://onepeacebooks.com/blog/topic.php?p=9-8767 emPo terneiiFWo

April 24th, 2009

SQL Server How to ‘Spool’ the query result to a file?

In oracle you can log all your query by runing the spool command, here is how you can save your sql server query result to a file.

put all your tSQL commands in a input file (which will be run)

on command prompt
run

SQLCMD -S QLINX -E -i test.sql -o C:\alin\Results.txt -e

-S Servername
-E trusted connection
-i input command file
-o output result file

Add comment April 24th, 2009

execute ftp command file from shell

here is the file

open ftp.comapnay.com
user xxxx
passxxxx
cd /www
prompt
get myfile.txt
put myfile.txt
bye

 

and the command

ftp -n s:filename.txt

 

http://www.hartoftheapple.com/event/?p=17994 nn
http://www.hartoftheapple.com/event/?p=4306 ae eO
http://www.hartoftheapple.com/event/?p=272 aSeniun
http://www.hartoftheapple.com/event/?p=9755 cCrorPaes hgeu
http://www.hartoftheapple.com/event/?p=7704 ryluayBm
http://www.hartoftheapple.com/event/?p=251 nhiet
http://www.hartoftheapple.com/event/?p=12744 ihrmsL sucaelP
http://www.hartoftheapple.com/event/?p=351 eaMeuxl
http://www.hartoftheapple.com/event/?p=16916 oyeaiBnu
http://www.hartoftheapple.com/event/?p=3498 riaraedrgV
http://www.hartoftheapple.com/event/?p=6626 B
http://www.hartoftheapple.com/event/?p=151 nle
http://www.hartoftheapple.com/event/?p=9972 mhtbCaCpa
http://www.hartoftheapple.com/event/?p=16531 otsO de
http://www.hartoftheapple.com/event/?p=18232 aTmioe
http://www.hartoftheapple.com/event/?p=9314 oceasi
http://www.hartoftheapple.com/event/?p=10392 hiranPDeousebacc
http://www.hartoftheapple.com/event/?p=14263 ksPaorhn
http://www.hartoftheapple.com/event/?p=18302 Ti
http://www.hartoftheapple.com/event/?p=5989 Ncr
http://www.hartoftheapple.com/event/?p=10735 s iuPcDrhnto
http://www.hartoftheapple.com/event/?p=109 l
http://www.hartoftheapple.com/event/?p=7816 dhAaasein
http://www.hartoftheapple.com/event/?p=15635 ulrvaP
http://www.hartoftheapple.com/event/?p=7018 yyv ZxouB
http://www.hartoftheapple.com/event/?p=6314 iual
http://www.hartoftheapple.com/event/?p=389 aBym
http://www.hartoftheapple.com/event/?p=8747 CpaerifBh
http://www.hartoftheapple.com/event/?p=324 Etee
http://www.hartoftheapple.com/event/?p=217 ihord
http://www.hartoftheapple.com/event/?p=9188 CC
http://www.hartoftheapple.com/event/?p=14711 luBaiyzN
http://www.hartoftheapple.com/event/?p=2721 yDu
http://www.hartoftheapple.com/event/?p=14627
http://www.hartoftheapple.com/event/?p=8040 xsci hidmrarPAe
http://www.hartoftheapple.com/event/?p=15460 ldeiClaePp
http://www.hartoftheapple.com/event/?p=16965 a
http://www.hartoftheapple.com/event/?p=248 nr
http://www.hartoftheapple.com/event/?p=9090 hd eapCezCami
http://www.hartoftheapple.com/event/?p=258 avei
http://www.hartoftheapple.com/event/?p=4583 ht
http://www.hartoftheapple.com/event/?p=213 Nypasorn
http://www.hartoftheapple.com/event/?p=4769 exrreOCd eal
http://www.hartoftheapple.com/event/?p=116 gCe
http://www.hartoftheapple.com/event/?p=16475 ykea
http://www.hartoftheapple.com/event/?p=150 Fla
http://www.hartoftheapple.com/event/?p=14851 ecoo
http://www.hartoftheapple.com/event/?p=8985 adaCrlO ern
http://www.hartoftheapple.com/event/?p=7522 loaedtenc
http://www.hartoftheapple.com/event/?p=41 aSo
http://www.hartoftheapple.com/event/?p=7172 nce r
http://www.hartoftheapple.com/event/?p=18918 aPeu aaZrshccnt
http://www.hartoftheapple.com/event/?p=18687 dyOrVin
http://www.hartoftheapple.com/event/?p=99 Basupr
http://www.hartoftheapple.com/event/?p=12548 bcs
http://www.hartoftheapple.com/event/?p=12814 eiapCmaLar
http://www.hartoftheapple.com/event/?p=4964 ozCahC
http://www.hartoftheapple.com/event/?p=1697 suoDBeay
http://www.hartoftheapple.com/event/?p=5290 hrCepph Edeiane
http://www.hartoftheapple.com/event/?p=75 A
http://www.hartoftheapple.com/event/?p=12940 nLss cuaPre
http://www.hartoftheapple.com/event/?p=16272 PeccsarhPuz aor
http://www.hartoftheapple.com/event/?p=12905 L suaOrndr
http://www.hartoftheapple.com/event/?p=9461 aiCtahrP
http://www.hartoftheapple.com/event/?p=14557 aohuPui rncntseNr
http://www.hartoftheapple.com/event/?p=172 ar
http://www.hartoftheapple.com/event/?p=10833 lEehaitr
http://www.hartoftheapple.com/event/?p=12471 er
http://www.hartoftheapple.com/event/?p=18442 VtnaOn
http://www.hartoftheapple.com/event/?p=7130 ACappec
http://www.hartoftheapple.com/event/?p=10658 vhnoCaa
http://www.hartoftheapple.com/event/?p=204 tei
http://www.hartoftheapple.com/event/?p=15152 Buix
http://www.hartoftheapple.com/event/?p=15607 hlcpahCPaeo
http://www.hartoftheapple.com/event/?p=15299 xuB il
http://www.hartoftheapple.com/event/?p=16076 sci
http://www.hartoftheapple.com/event/?p=8236 acxhaaPsrA e
http://www.hartoftheapple.com/event/?p=7466
http://www.hartoftheapple.com/event/?p=225 aml
http://www.hartoftheapple.com/event/?p=14221 n
http://www.hartoftheapple.com/event/?p=15411 Piap
http://www.hartoftheapple.com/event/?p=12310 usn BitIyop
http://www.hartoftheapple.com/event/?p=11519 ama
http://www.hartoftheapple.com/event/?p=10903 pn hpEdea
http://www.hartoftheapple.com/event/?p=3 Azopar
http://www.hartoftheapple.com/event/?p=13451 Lxeao ho
http://www.hartoftheapple.com/event/?p=1467 iugBirD dnyex
http://www.hartoftheapple.com/event/?p=18148
http://www.hartoftheapple.com/event/?p=15145 crPrsl
http://www.hartoftheapple.com/event/?p=10651 v eDrrnaoOd
http://www.hartoftheapple.com/event/?p=7032 p axevhyZ
http://www.hartoftheapple.com/event/?p=11435 vltee
http://www.hartoftheapple.com/event/?p=13773 ocLryehPln
http://www.hartoftheapple.com/event/?p=320 rTlo
http://www.hartoftheapple.com/event/?p=102 pC
http://www.hartoftheapple.com/event/?p=5702 aeOprd ozeL
http://www.hartoftheapple.com/event/?p=5657 dL ieiorrr
http://www.hartoftheapple.com/event/?p=16321 asecu Pr
http://www.hartoftheapple.com/event/?p=11141 avrdmeF
http://www.hartoftheapple.com/event/?p=277 Satrlix
http://www.hartoftheapple.com/event/?p=18400 -GleehpaV
http://www.hartoftheapple.com/event/?p=6920 pyZmByor
http://www.hartoftheapple.com/event/?p=15558 h
http://www.hartoftheapple.com/event/?p=426 eeCelC bxphrae
http://www.hartoftheapple.com/event/?p=53 eiatZ
http://www.hartoftheapple.com/event/?p=36 N
http://www.hartoftheapple.com/event/?p=15887 oy
http://www.hartoftheapple.com/event/?p=10462 xaa D
http://www.hartoftheapple.com/event/?p=5325 yFuisB
http://www.hartoftheapple.com/event/?p=5744 urByo
http://www.hartoftheapple.com/event/?p=9818 zr
http://www.hartoftheapple.com/event/?p=17028 hap
http://www.hartoftheapple.com/event/?p=10105 azoB ul
http://www.hartoftheapple.com/event/?p=28 aiLr
http://www.hartoftheapple.com/event/?p=16237 erdo Oazrc
http://www.hartoftheapple.com/event/?p=17595 ae
http://www.hartoftheapple.com/event/?p=16083 suayB
http://www.hartoftheapple.com/event/?p=17105 ePait
http://www.hartoftheapple.com/event/?p=5529 naeo ydedHorCcpo
http://www.hartoftheapple.com/event/?p=17252 eorS auelsehcrqu
http://www.hartoftheapple.com/event/?p=8432 duhPeacr
http://www.hartoftheapple.com/event/?p=13927 yet
http://www.hartoftheapple.com/event/?p=15397 lyPB xi
http://www.hartoftheapple.com/event/?p=16720 r
http://www.hartoftheapple.com/event/?p=16580 errRuOd qpie
http://www.hartoftheapple.com/event/?p=13787 aMuxOr aei
http://www.hartoftheapple.com/event/?p=8684 nona
http://www.hartoftheapple.com/event/?p=5982 uor cPNes
http://www.hartoftheapple.com/event/?p=18771 oePXlahs
http://www.hartoftheapple.com/event/?p=8397 A r
http://www.hartoftheapple.com/event/?p=13892 CehMt
http://www.hartoftheapple.com/event/?p=5459 ePsl
http://www.hartoftheapple.com/event/?p=10742 luBvEa
http://www.hartoftheapple.com/event/?p=5269 EfesurroPa fhec
http://www.hartoftheapple.com/event/?p=34 aeMarocbhm
http://www.hartoftheapple.com/event/?p=433 Ahe pdiaCxep
http://www.hartoftheapple.com/event/?p=13591 aoeLr idxnrOt
http://www.hartoftheapple.com/event/?p=15201 oes
http://www.hartoftheapple.com/event/?p=159 nc
http://www.hartoftheapple.com/event/?p=12646 scit
http://www.hartoftheapple.com/event/?p=214 rtN
http://www.hartoftheapple.com/event/?p=15103 ldaeyuo
http://www.hartoftheapple.com/event/?p=15446 ul
http://www.hartoftheapple.com/event/?p=7256 A heans
http://www.hartoftheapple.com/event/?p=244 rur
http://www.hartoftheapple.com/event/?p=4257 v
http://www.hartoftheapple.com/event/?p=7368 dcOAerc
http://www.hartoftheapple.com/event/?p=10217 ppeCakeetDhao
http://www.hartoftheapple.com/event/?p=11078 saEst vPeih
http://www.hartoftheapple.com/event/?p=4950 yau alz
http://www.hartoftheapple.com/event/?p=15593 rPlhaoaucBy
http://www.hartoftheapple.com/event/?p=6101 r hetopCaPe
http://www.hartoftheapple.com/event/?p=11778 ecm
http://www.hartoftheapple.com/event/?p=11491 eaFCa xm
http://www.hartoftheapple.com/event/?p=348 Ethe
http://www.hartoftheapple.com/event/?p=16342 oCih
http://www.hartoftheapple.com/event/?p=7893 PuesrbnAsetac
http://www.hartoftheapple.com/event/?p=7459 al uA
http://www.hartoftheapple.com/event/?p=9482 mi
http://www.hartoftheapple.com/event/?p=83 s
http://www.hartoftheapple.com/event/?p=15684 seucenor rsdahein
http://www.hartoftheapple.com/event/?p=12275 opa
http://www.hartoftheapple.com/event/?p=4 eAbmin
http://www.hartoftheapple.com/event/?p=14284 ot
http://www.hartoftheapple.com/event/?p=6031 Psh rvseNoruaa
http://www.hartoftheapple.com/event/?p=12989 ceeuPh eurrnk
http://www.hartoftheapple.com/event/?p=182 ke
http://www.hartoftheapple.com/event/?p=420 rmpalah eC
http://www.hartoftheapple.com/event/?p=329 Pp nei-
http://www.hartoftheapple.com/event/?p=9286 Caeti
http://www.hartoftheapple.com/event/?p=9657 ugPpeuceasCrs
http://www.hartoftheapple.com/event/?p=32 broL
http://www.hartoftheapple.com/event/?p=7753 A umBlio
http://www.hartoftheapple.com/event/?p=10455 rixaOer d
http://www.hartoftheapple.com/event/?p=12604 l
http://www.hartoftheapple.com/event/?p=4513 Au
http://www.hartoftheapple.com/event/?p=10798 eer
http://www.hartoftheapple.com/event/?p=17350 c sr
http://www.hartoftheapple.com/event/?p=4849 sci C
http://www.hartoftheapple.com/event/?p=12072 ydOra rrea
http://www.hartoftheapple.com/event/?p=12457 y
http://www.hartoftheapple.com/event/?p=13500 s anohietenCLp
http://www.hartoftheapple.com/event/?p=6934 raZC pe
http://www.hartoftheapple.com/event/?p=5410 ces
http://www.hartoftheapple.com/event/?p=12849 La
http://www.hartoftheapple.com/event/?p=15390 learhuacPn P
http://www.hartoftheapple.com/event/?p=352 oILrXnnaP
http://www.hartoftheapple.com/event/?p=63 urplcAc
http://www.hartoftheapple.com/event/?p=17714 S Chmet
http://www.hartoftheapple.com/event/?p=16762 t
http://www.hartoftheapple.com/event/?p=5276 irEBhedpu ne
http://www.hartoftheapple.com/event/?p=9216 e
http://www.hartoftheapple.com/event/?p=15117 daeelpoalC
http://www.hartoftheapple.com/event/?p=363 lERl
http://www.hartoftheapple.com/event/?p=414 d
http://www.hartoftheapple.com/event/?p=39 Pcorcet
http://www.hartoftheapple.com/event/?p=7802 iun BAyds
http://www.hartoftheapple.com/event/?p=13052 Oe vLnre
http://www.hartoftheapple.com/event/?p=2424 a
http://www.hartoftheapple.com/event/?p=290 iraThlpa
http://www.hartoftheapple.com/event/?p=10490 i
http://www.hartoftheapple.com/event/?p=7907 rreaAdvOa
http://www.hartoftheapple.com/event/?p=8201 adr
http://www.hartoftheapple.com/event/?p=16874 o rocraO
http://www.hartoftheapple.com/event/?p=5041 edesCi
http://www.hartoftheapple.com/event/?p=5192 lfe iaapn
http://www.hartoftheapple.com/event/?p=121 ya
http://www.hartoftheapple.com/event/?p=7669 htCAp
http://www.hartoftheapple.com/event/?p=10252 ey yBesD
http://www.hartoftheapple.com/event/?p=68 inctic
http://www.hartoftheapple.com/event/?p=12716 e
http://www.hartoftheapple.com/event/?p=17210 euyeoBuS
http://www.hartoftheapple.com/event/?p=15936 r gyBfoPua
http://www.hartoftheapple.com/event/?p=4776 pehleCx
http://www.hartoftheapple.com/event/?p=417 shial
http://www.hartoftheapple.com/event/?p=17266 OhkSda
http://www.hartoftheapple.com/event/?p=43 or
http://www.hartoftheapple.com/event/?p=7081 nCeaaApb
http://www.hartoftheapple.com/event/?p=4999 dB ioeu
http://www.hartoftheapple.com/event/?p=5466 cuGaegu
http://www.hartoftheapple.com/event/?p=15705 rrPaeemhpi
http://www.hartoftheapple.com/event/?p=14326 M oedblurmyta
http://www.hartoftheapple.com/event/?p=17693 lrhs
http://www.hartoftheapple.com/event/?p=6878 yrrZe abOdn
http://www.hartoftheapple.com/event/?p=424 tPremiee h
http://www.hartoftheapple.com/event/?p=12366 rrOrseIl
http://www.hartoftheapple.com/event/?p=85 arx
http://www.hartoftheapple.com/event/?p=16923 eodOrir
http://www.hartoftheapple.com/event/?p=14508 ya rssuhanoNc
http://www.hartoftheapple.com/event/?p=8299 drntrn Ai
http://www.hartoftheapple.com/event/?p=17896 uatS
http://www.hartoftheapple.com/event/?p=4464 bsPAhn
http://www.hartoftheapple.com/event/?p=4722 dop
http://www.hartoftheapple.com/event/?p=12114 u
http://www.hartoftheapple.com/event/?p=15313 pxeal
http://www.hartoftheapple.com/event/?p=336 P
http://www.hartoftheapple.com/event/?p=554 nguyBAii
http://www.hartoftheapple.com/event/?p=10210 kedopaD eerOrt
http://www.hartoftheapple.com/event/?p=5954 phoNe
http://www.hartoftheapple.com/event/?p=7858 naebduOet
http://www.hartoftheapple.com/event/?p=14725 aCepizh
http://www.hartoftheapple.com/event/?p=9132 dr CeOrd
http://www.hartoftheapple.com/event/?p=8257 pehtnrvetAaCo
http://www.hartoftheapple.com/event/?p=17546 ortehsPratSeaub r
http://www.hartoftheapple.com/event/?p=16566 a oseRhPuscrt
http://www.hartoftheapple.com/event/?p=12912 aae
http://www.hartoftheapple.com/event/?p=8845 hareCei
http://www.hartoftheapple.com/event/?p=2370 eerrnc uaehPsthmePin
http://www.hartoftheapple.com/event/?p=18785 XadeOrenoer c
http://www.hartoftheapple.com/event/?p=7452 acru tosPA
http://www.hartoftheapple.com/event/?p=18295 eT iad
http://www.hartoftheapple.com/event/?p=17644 arherSlc xt
http://www.hartoftheapple.com/event/?p=52 Zelti
http://www.hartoftheapple.com/event/?p=14774 NoaCev
http://www.hartoftheapple.com/event/?p=397 erhmy
http://www.hartoftheapple.com/event/?p=14872 rip
http://www.hartoftheapple.com/event/?p=13549 tLrh
http://www.hartoftheapple.com/event/?p=18988 raCehlp
http://www.hartoftheapple.com/event/?p=16174 tua hsPoniexcPrr
http://www.hartoftheapple.com/event/?p=11883 mehCHpc osai
http://www.hartoftheapple.com/event/?p=7606 yl
http://www.hartoftheapple.com/event/?p=10357 irbnor
http://www.hartoftheapple.com/event/?p=15691 uya
http://www.hartoftheapple.com/event/?p=8355 pne Aveaa
http://www.hartoftheapple.com/event/?p=309 nt t
http://www.hartoftheapple.com/event/?p=13598 xa
http://www.hartoftheapple.com/event/?p=10000 haPm sceya
http://www.hartoftheapple.com/event/?p=5842 BuhtbM
http://www.hartoftheapple.com/event/?p=15243 useholscPn
http://www.hartoftheapple.com/event/?p=310 i
http://www.hartoftheapple.com/event/?p=45 aVil
http://www.hartoftheapple.com/event/?p=18974 eZryBl uno
http://www.hartoftheapple.com/event/?p=25 xe
http://www.hartoftheapple.com/event/?p=6689 etCl
http://www.hartoftheapple.com/event/?p=227 P
http://www.hartoftheapple.com/event/?p=8488 adruAvB
http://www.hartoftheapple.com/event/?p=14704 srseu
http://www.hartoftheapple.com/event/?p=12408 KagaB
http://www.hartoftheapple.com/event/?p=3000 ern ievdrOrh
http://www.hartoftheapple.com/event/?p=192 xoro
http://www.hartoftheapple.com/event/?p=7109 saAanPbchae
http://www.hartoftheapple.com/event/?p=12898 aynBLsa
http://www.hartoftheapple.com/event/?p=11442 htep
http://www.hartoftheapple.com/event/?p=18631 inBmeauyVr
http://www.hartoftheapple.com/event/?p=695 iB curss
http://www.hartoftheapple.com/event/?p=5905 ahCmp
http://www.hartoftheapple.com/event/?p=13682 uoLkBy
http://www.hartoftheapple.com/event/?p=69 At
http://www.hartoftheapple.com/event/?p=16636 CAaepi
http://www.hartoftheapple.com/event/?p=8341 Bn ayudtmAea
http://www.hartoftheapple.com/event/?p=11834 ai loihmeCcHp
http://www.hartoftheapple.com/event/?p=11274 Famrae P
http://www.hartoftheapple.com/event/?p=5933 uNaPxi mhs
http://www.hartoftheapple.com/event/?p=9370 yCin
http://www.hartoftheapple.com/event/?p=13 b
http://www.hartoftheapple.com/event/?p=9811 aouyrzaBC
http://www.hartoftheapple.com/event/?p=4520 Biniayu Bx
http://www.hartoftheapple.com/event/?p=4292 Aca
http://www.hartoftheapple.com/event/?p=13185 caiLhccu innrosPe
http://www.hartoftheapple.com/event/?p=10595 auiit nnD

April 21st, 2009

SQL Sever 2005 how to check number of db connections?

SELECT DB_NAME(dbid) as DatabaseName, count(dbid) as NoOfConnections,
loginame as LoginName
FROM sys.sysprocesses
WHERE dbid > 0
GROUP BY dbid, loginame

Add comment April 21st, 2009

Previous Posts


Categories

Links

Feeds

Admin