Answer Questions

• Your Neighbour How insert more then 4000 characters?

  I need insert many dates from tables to XML file, I use T-SQL, everything is OK, but in one step I can insert maximally 4000 character in uni-code. Is there another way Thanks' a lot. I use such sequence T-SQL: Declare @doc XML , @ixml nvarchar ( 4000 ) SELECT @ixml =( SELECT * FROM SAMPLE "d:SAMPLE" for XML AUTO ) SET @ixml = 'SET @Doc.modify('' declare namespace dfs="http://schemas.microsoft ...Show All

• MarTim Need help with User Defined Function

  I am accustomed to doing most of my function work in Access, but the boss would really like it if I could shedule some cubes to do the stuff that takes forever when you run it live. To that end, I have an Access function that I call to get a field value for a query. I would like to be able to create an User Defined Function on the SQL server and call that function as a field value in a view. I have searched the forums and have not really foun ...Show All

• deanvanrooyen DB Mirroring Monitor and querying the "other" db?

  So I successfully got the mirroring to run and now I'd like to see what's going on between the two servers ( i'm not using a witness). I launch the Database Mirroring Monitor and its showing the two servers but when I go to the history column I'm not seeing any data movement. I've done a an update on a db with 1500 rows so I was expecting to see this show up. Also, is there anyway to query the database thats acting as the mirrored db ...Show All

• Wayne Ligon Problem with Hyphen in server name?

  Hi all, My sql server has a hyphen in its name, and I've noticed I can't use a fully qualified reference, server.database.owner.table. Is this a known bug , what's the fix apart from renaming This is standard version, not a beta. Hi Meltdown, this is anugly things having a hyphen,or any other character in the server name, but putting brackets around that should solve the problem. [server].database.owner.tab ...Show All

• Gu1234 Installing Management Studio on Separate Computer from SQL 2005

  I'm trying to install Management Studio on my dev box (separate from my server). But it won't install. Can someone give me a pointer or two why won't it install   telling us the error would help. It's basically complaining that SQL Server is not present on the machine. I've already read however that if you install SSExpress 2005, the Management Studio won't install. Hopefully that gets address ...Show All

• ghostd0g_ BEGINNER'S QUESTION: SORTING IN ALPHABETICAL ORDER

  Hi I am trying to convert an Access back end into a SQL Server back end and cannot work out how to convert a query that sorts addresses that start with numbers into alphabetical order. In Access I defined a function that converted the full address to one without the initial numbers eg: 66 Acacia Gardens to Acacia Gardens I then used this function as an expression in the field column of the query and set it to sort by this field. This ...Show All

• wardw Export Access Memo field to SQL Text field

  Hi, Can anyone point me any solution how to export a MEMO field from an Access database to a TEXT field from an MS SQL Server 2000. The import export tool from SQL server doesn't import these fields if they are very large - around 9000 characters. Thanks. You can use the TEXTCOPY utility in SQL Server 2000. You can find it in the BINN directory of the server instance. This is a DBLIB utility to impo ...Show All

• Ricky A Jones Integrating KPI in Reporting Services and drill down reports

  I'm interested to implement KPIs from Analysis Services 2005 in Reporting Services 2005 in a graphical way as it is seen inside Analysis Services. how can I archieve this and what is the best way for drilldowns in reporting services Thanks for your help, Roger One way to do support AS2005 KPI's is to place an image control within your data region (e.g. table) and use separate images ...Show All

• mxale SSIS ODBC Source Component

  I need to create an ODBC source script component that outputs into SQL Server. When I debug I get the following error message: Error at Data Flow Task [Script Component [1]]: System.InvalidCastException: Unable to cast object of type 'System.Data.Odbc.OdbcConnection' to type 'System.Data.SqlClient.SqlConnection'. at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.HandleUserException(Exception e) at Microsoft.SqlServer.Dts.Pipeline.S ...Show All

• Ira at AIB Cognos to RS

  Hi all! I am taking a cognos report and created an identical one in RS. Can anyone tell me what this means and help figure out how to do it in RS cognos TO_DATE(SUBSTR(DATE_TIME_STAMP,1,14),'YYYYMMDDHH24MISS') RS (i am guessing) CONVERT(SUBSTRING(DATE_TIME_STAMP,1,14),yyyyMMddhh m ss) can anyone help Thanks in avance,  Kerrie   Is this a SQL function or a function in the report If it is the latter, the function for S ...Show All

• Rami Awad another backup quick question

  Hi What does Backup set expiry do Apart from mark the set as "Not being allowed to restore", does it delete the file cheers ICW If you're backing up to tape it sets the date the backup expires so the tape can be overwritten on the next cycle. I personally recommend you back up to disk, then back up those disk files to tape along with your regular network backup. ...Show All

• JustinRC Customising Dimension Security

  HI, I'm having problems specifying customised security in the Advanced tab (allowed members). I'm fairly new to mdx script and am trying to restrict access to a STAFF dimension which contains a loginname member which I want to restrict access to based on username matching the loginname DIM. Have tried the following which didn't work: [STAFF_DIM].[Login Name].members(MID( USERNAME, INSTR(1,USERNAME, "\") + 1, 128 ) ) I read somewhere that this c ...Show All

• mbtrost Inserting custom data

  Can html be inserted into a report. For example if you generate an html page that has Chart image and table data is there a way to insert the html int the generated report. Could this be done by a accessing a custom assembly or some other way CA  No, you cannot "inject" HTML into the output. You would need to implement your own custom rendering extension (which is a lot of work). -- Robert&n ...Show All

• Stebet Ad hoc reporting with SSRS 2000?

  Does anyone know if SQL Server Reporting Services is capable of any ad hoc reporting Thanks!! SSRS 2000 does not have end-user client (similar to Report Builder in 2005) for report authoring. ...Show All

• Aplus191 Dummy dimension for passing parameters

  Hi, I'm just having a little problem... I have a calculation, which is a non-trivial formula. This needs input from some dimensions (no problem with that...) and some information, which is independant from the data itself. The idea is to have something like a dimension but which is not connected to the data itself. You can't slice anything using it, it's just used to provide some input for the formula. Just imagine you have some amounts and y ...Show All