Search results for query: *

Hi Does anyone know if its possible to change the alignment of text in a text box (header) to a custom alignment.This is part of a tablix object. The text header is horizontal, if I drag to 1 char spacing I get it vertical, but its not very readable, if i drag to > 1 char it goes back to...

Hi This ones a little weird, existing code that runs on a SQL2000 box fails when run against a SQL 2008 Server. Here's the scenario. SQL basically thinks the row size being inserted is bigger than the column being inserted into and its not. A query that joins several tables together returns a...

We have a data extract to a csv file from SQL server 2008 that when viewed in Excel changes all £ symbols to £ ( A with hat symbol and a £ just in case it does not display correctly) This was shown in Excel 2002 which I was able to replicate with against the user experiencing this issue. I...

Hi we are migrating one of our reporting servers to SQL2008 from SQL2000 and we have a new SQL server installed, of which we take a copy of the existing SQL2000 database each day. As part of the testing we have through Crystal Enterprise copied all our Crystal reporting folders to a test area...

Hi Got a peice of code that if you put the datetime value into a variable and use in a where clause you get a table scan on the cluster (column ID) (Code B below), but if you dont put the value into the variable as in code A below you get an index seek on the index on the createdatetime column...

We have a clustered SQL Server 2005 Enterprise SP2 instance where we cannot change the server collation using the following command start /wait Z:\setup.exe /qb INSTANCENAME=SERVERNAME\SQL2005 REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=****** SQLCOLLATION=SQL_Latin1_General_CP1_CI_AS...

Hi I need to copy and paste details from the resource usage sheet into excel, but dont want to take the d sysmbol. I.e it shows as 12d but want it to show only 12, using project 2003 Can this be done and how Cheers

Hi Anyone setup replication from a database in simple mode, I would assume it could have its issues but seems to work in a basic test and not found anything (yet) on the internet to say its a no one. theoritically if using transactional replication it should be replicating transaction in the...

Hi I have the following bit of code in a where clause (@BranchID is null or BranchID = @BranchID) This will cause a clustered index scan where (BranchID = @BranchID) does a clustered index seek. I am sure there is another way of doing the search so if a null @branchID value is passed it...

Hi anyone been on any decent SQL 2005 courses of late they rated,looking for high level 2005 courses any recommendations Mart

Hi I have 2 sections and I want to be able to un-suppress the 2nd on based on if the first is suppressed or not. Its not as easy as reversing the suppression logic as there are duplications involved, which work find for the 1st section. Ideally what I am looking for is the code to do this and...

Hi Does anyone know is all crystal reports information written to the SQL server backend. We have CE v 9.0 I am a DBA with a little knowledge of crystal. We are in the process of moving from one technology to another and need to check that there are no differences of the crystal reports output...

Hi This is a most bizzare one! A procedure called smABC019 runs for over an hour but if you rename it to anthing else smABC020 or smABC019db it runs in under 10 seconds. The following things have been tried DBCC DROPCLEANBUFFERS DBCC FREEPROCCACHE sp_recompile (procedure) Droping and...

Hi I am looping through some controls on a panel and want to know what the type is I think Iam close but just not there. For i As Integer = Panel1.Controls.Count - 1 To 0 Step -1 With Me.Panel1.Controls(i) If x=y and ***** Then .BackColor =...

Hi I have a datatable which has 18 columns and 5 rows, I need to access a particulair row and column and get the value for that column. I can loop through using For Each drow In dt.Rows and see all the columns and the values i could add a counter i=+1 so i know when I am at a particulair...

Hi I’ve several dynamic textboxs/combo boxes which can be added and deleted from the screen these are populated from a datatable and looped through each datarow populating the textboxes as below Dim drow As DataRow For Each drow In dt.Rows when I come to read...

Hi I have 2 combo boxs which are populated from a datasource and have sevaral text boxes on a couple of forms comboboxA populates ok and when choosing a value all text boxes relating to that value are populated ( i.e the record move to that record fine) the 2nd combo box comboBoxB same...

Hi Ive added several dynamic controls to a form via a button which creates for example combox1, textbox1 on click then combobox2 textbox2 happy as can be however I want to add another button which will remove the last set of objects created Creating as thus Dim cb As New ComboBox cb.Name...

Hi I have two forms, formA & FormB if i call form B from a button on formA with the following code Dim frmNew As New FormB frmNew.Show() formB opens up successfully,both forms are accessible I added a button on formB withthe following me.hide exspecting it to close formB...

Tabcontrols seem to be black art, there does not seem to be much usual info around for them I wanted to hide & show certain tabs thats been answered but when I hide and show the tab that has been shown does not get the focus I would have thought tabcontrol.focus() or even...