by jeremy@bondbyte.com | Apr 23, 2014 | Uncategorized
Problem: When attempting to open documents on our sharepoint portal we are being prompted for credentials. cancelling the prompt allows the document to open. Later if the user clicks on “Edit Document” from the menu above the credential prompt reappears....
by jeremy@bondbyte.com | Apr 23, 2014 | Uncategorized
After Configuring SQL Reporting Services you may receive and error HTTP failure 400 when navigating to http:///reports. This may happen if the Default Web Site in IIS is disabled/stopped.
by jeremy@bondbyte.com | Apr 23, 2014 | Uncategorized
1. Create a Visual Basic Class for your project by right clicking the project and select add. 2. Change the language to Visual Basic and select Class from the list of Installed Templates. 3. Name the class clsNotify. Add the code below to the class.(You...
by jeremy@bondbyte.com | Apr 23, 2014 | Uncategorized
SELECT t.NAME AS TableName, p.rows AS RowCounts, SUM(a.total_pages) * 8 AS TotalSpaceKB, SUM(a.used_pages) * 8 AS UsedSpaceKB, (SUM(a.total_pages) – SUM(a.used_pages)) * 8 AS UnusedSpaceKB FROM sys.tables t INNER JOIN sys.indexes i ON t.OBJECT_ID = i.object_id...
by jeremy@bondbyte.com | Apr 23, 2014 | Uncategorized
Lets see if I can explain how to rename a files using the File System Task in BIDS or SSIS. First you will need to add a File System Task to your Control Flow. (Drag and Drop it to the Form) Open the task and change the Opertaion to Rename File. Set the...
