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...

Yes both offline and online activity cause transaction log activity http://msdn.microsoft.com/en-us/library/ms190981(v=SQL.100).aspx

Hi have you tried checking the protocols you have enabled on the server. Look in SQL Server configuration manager under SQL Server Network configuration.

Hi A colleague of mine found a curious example where 0 rows of data are inserted into a table but still gets the issue http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=145450

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...

Hi thanks for your help, but we are looking to a fix or easier workaround than users using excel to run query s. We want them to still run through management studio it will cause more issues than resolve if they start using excel.

We have many users that run lots ad-hoc queries through SQL server and save out as CSV files, its not ideal to go through this process if there is some way of setting a default. They tend to currently just open the file validate the data from a folder. Excel doesn't seem to workout its UTF-8...

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...

Dont think you need a password if you are running from SQL. This works on my local instance SELECT * FROM OPENDATASOURCE ('Microsoft.Jet.OleDB.4.0', 'Data Source=c:\dump\test.xls; extended Properties=Excel 8.0')...sheet1$

Not 100% sure what your trying to achieve, but if its an average for the total count, you need to use a sub query, your code doesn't seem to be doing that. I have shown a simple example below hopefully you can see how the subquery has been used to give an average against the total count and...

It could be collation issues, are both database the same collation. In each DB run SELECT DATABASEPROPERTYEX(db_name(),'COLLATION')

The history is kept in select * from msdb.dbo.sysjobhistory If you want to keep specific history for a longer duration copy the data from here on a regular basis

Do you have a backup Database task? Can you not right click and edit or is this option N/A?

It really depends on your string length and number of rows you are likely to use. For example if you had a 10 char string, you could populate a table with values 1 through to 99999 and then convert this to a string and add to the 10 char value. Then you would have a 15 char string that was...

I am assuming your not using SQL2008 else you can use resource governor to split out resource, other than that there is no way to give processes more resource / less resource.

Right click SQL Server agent within Management folder and select properties, click job system tab and there you will find the setting you want, as default it will be set to 1000 rows.

Righty click SQL Server agent within Management folder and select properties, click job system tab and there you will find the setting you want, as default it will be set to 1000 rows.

Is it not SQL Server your running on? It will work on SQL 2000/05/08, I imagine it would need to be tweaked for Oracle but I am unsure. I thought it was SQL being in the SQL forumn.

One potential option is, use a derived table and COALESCE to bring back either the bid price or if it doesn't exist ( NULL) then the price of the product. If you see what I mean SELECT * FROM Products MainProducts JOIN ( SELECT products.idproduct...