10. Using VRDP to view VirtualBox virtual machines remotely Rick Vanover has put together a useful tutorial for Sun’s xVM VirtualBox. 9. How to reset the Cisco Catalyst Switch to Factory Defaults Yasir Irfan offers some advice for those needing a fresh late on Catalyst switches. 8. Independent clauses and semicolons Margaret Rouse offers up…

My developers create MS SQL Stored Procedures on a development server. What is the best way to move/copy those SPs to the production server (different machine)?

How To get first record means last entry record of a from crystal report 10

How To get first record means last entry record of a from crystal report 10

Error 91 Description: Object variable or with block variable not setExecuting sql statementRetrieving division information from the sql data store. Checking for the core database. Source: AFWSvDataServices3Converter.ConvertergetSQLDivisions, converter.convertergetdivisions, converter.convertergetDatabaseSTatii, converter.converter.Initialize, converter.converterStartIIconverter.converterStartCommandLine.

I’m trying to get a rewriteCond & rewriteRule to work. I want the command to check for a file(image) and if it doesn’t find it to use a default image. Not having any luck getting the command right. example: RewriteCond /doc/route/%{REQUEST_FILENAME} !-f RewriteRule ^(.+) /dir/images/dir/00000000.JPG [L]

In SSIS 2005 I use Execute SQL task to execute a proc that returns an xml resultset using these clauses (For XML Auto, Type within a For XML Path, Type). I return that resultset into string variable User::vSelectedClients. When I look at that variable within a breakpoint, I see all the doublequote marks are escaped…

How can I change my SSRS to allow exporting into EXCEL and eliminate the header portion of report which includes merged cells. These prohibit my user from being able to sort a column in the table data.

Hallo community, 70-448 Microsoft Certification Practice Products 70-432 70-433 have you purchesed this software ? what is your experience? I want to prepare for these exams. Thank you very much in advanced for the Answer. DeshRaja

I have a table in SQL Server named CustInfo that is as follows: table CustInfo ( startdate datetime enddate datetime CustomerCode int address nvarchar(200) ) I want to define a range constraint to insure that only one address is allowed for a specific customer in a specific range of dates. For example: 2008-01-01,2008-10-27,11,’13 Lexington st’…

I need to determine what is the best (practices) method for scanning of files/documents (.DOC, .XLS, .JPG, .TIF, .PDF) before they are dynamically uploaded into an SQL 2005 db as BLOBs..Thanks

Hi All, I was wondering if it was possible to change the collation of the format file created by the BCP utility from CS to CI, than import the data? The reason I ask this is I want to import the data from one column to another column using a different collation using bulk insert.…

I’m looking to develop a new strategy for our web hosting farm. Currently I’ve got  set of standalone IIS 6 web servers and sql 2005 database servers sitting in a network behind a kerio winroute proxy (which handles our nat’ing and intrusion prevention and VPN to our office location) which in turn sit behind a…

I have a exsiting crystal rpt that passes 5 parameters to a stored proc.  We have added 1 more parameter to the procedure now when attempting to run the crystal rpt it errors out with proc expects parameter “new” (new being the added parameter).   I have been unable to get around this. Can anyone help.…

Hi, anyone has idea of any freeware centralize backup solution or low cost best centralize backup solution. i have 12 lcoations with File and print servers. SQl server Database server 2 web serevrs 1 Domain controller i want to backup the files at my central IDC. locations backup has only Excel, word, pst, jpg files.…

How does oracle avoid dead lock when we create an idex on the foreign Key column ? Found many experts say this, but i never really found what is the logic behind this. So any replies provided are appreciated . thanks in advance gangadhar

How does oracle avoid dead lock when we create an idex on the foreign Key column ? Found many experts say this, but i never really found what is the logic behind this. So any replies provided are appreciated . thanks in advance gangadhar

I was wondering if someone can offer some code or a site that would show some code examples of what I am trying to do on my LPARs. I’ve created a DB file using command CVTWRKSBS so I could create an IBM query over it to see what subsystems are active on the LPAR. However,…

I am working in SQL 2005 and would like to parse an address filed such as “1234 N CLARK ST APT 111 ” into seperate fileds like House Number/Street Name/Street Type ie LN ,ST, or Cir/Apartment Number

here’s the coding for my crystal report display The above code is written in the report viewer form’s load event method. ‘this is the query for my dataset (used in objItemSale.GetSaleData(string) function) SELECT ItemSale.BillNo, ItemSale.IncomeID, Income.IncomeDate, Income.IncomeValue, ListItem.ItemID, Item.ItemName, ListItem.SaleQuantity, ListItem.SalePrice, ItemSale.SaleItemListID FROM Income INNER JOIN ItemSale ON Income.IncomeID = ItemSale.IncomeID INNER JOIN SaleItemList ON…