Answer Questions

• gren Superscript

  I need to add superscript to my textbox. Something like 1 st prize. I have been searching around in other forums and the only thing any one has come up with to implement it is to add a seperate text box with a small font and shifting the text up using paddings. That is not very practical and wont work for me because my line of text is always changing and written in code. if any one knows how to do superscript for reporting server text box, enlig ...Show All

• aendey How to identify which version we have?

  How do I tell if I am running SQL2K Enterprise Edition or Standard Edition We have a 2-node cluster. Does that imply Enterprise Edition, or could Standard do that as well Thanks for any info. If it's SQL 2000, only Enterprise is supported in a cluster configuration...if SQL 2005, Standard is also supported. You can run the following to find your the edition of the server you are running...just connect via ...Show All

• experttech What use ScdStartDate/ScdEndDate/ScdStatus/ScdOriginalID?

  Hi, In AS2005 one can set the Type property of attributes to ScdStartDate/ScdEndDate/ScdStatus/ScdOriginalID for type 2 slowly changing dimensions. What, if any, effect does this have I can not see that it does anything in either the VS cube browser or in Panorama 5. Are there any other clients that make use of these settings, or am I missing something Thanks!Kristian These properties are used for slowly changine dime ...Show All

• warelock How to check if the file exists or not before bulk insert

  How to check if the file exists or not before bulk insert. I would like to skip the bulk insert if the file doesn't exist. Information: I use Stored Procedures to run Bulk insert statement. The stored procedures is call by package. ****************** I test it at query analyzer and show the error when file don't exists. Error message Server: Msg 4860, Level 16, State 1, Line 1 Could not bulk insert. File 'E:\POLL41.fmt' d ...Show All

• Larry K. Moore what is [SQL-DMO]

  in computer management, when i expand the branch of my sql2005 express, i got a error message. it seems i cant register my server, but i cant login in sqlcmd i also installed sql2000, and it works fine... could anybody help really strange What order did you install SQL Server 2005 and SQL Server 2000 Installing SQL Server 2000 after installer SQL Server 2005 is not supported. has sql2k5 got a management studio i only find a sqlcmd.e ...Show All

• aschreiber Basic Connection

  Ok. Basically I do not know how to access any database files from the SQL Server. Can someone help me please. How do I access the files from another computer. Hi,   you can easily upload files using the import/export wizard in sql server...and it can be done either on the system database i.e. usually master database or you can create a new database by right click on the system database-->new database and lets say we name it as Nov ...Show All

• Mukul Gandhi SQL Express - Creating Tables etc using Visual Studio.

  Hi, I am new to sql server. I downloaded sql server express edition and created a database. I now have the default SQLExpress instance and the new one I created. I looked up online and found that I could do most activities like creating tables, views, stored procedures etc. from within Visual Studio (where a SQL Servers node is displayed). I don't see this node. All I see is Crystal report services, Event logs........and Services. I hav ...Show All

• Bakl console apps only work if user is SA

  Hi When I try to use a user other then SA my console apps don't work. I can run the Stored Procedures used in console application from Query analyser when logged in with the username/password that I'm attempting to use for the console applications. Under Users in Enterprise Manager Database access is 'permit' for my user. By the way my web application which uses the same user name and password as in console applications is working . I al ...Show All

• Eduardo Sobrino Printing SQL Diagrams, row header boxes resize incorrectly

  http://www.alfware.com.au/sqlerror.pdf This is an example of what is happening whenever I print an SQL Diagram Any ideas why the row header boxes resize incorrectly Regards, Michael Proctor I had the same bug and managed to figure out how to fix it; turn on "visual styles" in windows! I know, mad stupid but it works. Evidently microsoft never tried SQL management studio on a windows machine with visual s ...Show All

• Akhilesh083 CURSOR/FETCH Issue

  Hey Everyone, I have an issue with pulling data out of one table and concatinating it into another table. There is a table with a list of Work Orders (tblWorkOrders) that has a one-to-many relationship with a table that contains a list of Work Order Comments (tblComments). I want to concatenate all the work order comments together into one Text field in the work orders table for each work order. For example, if tblWorkOrders.ReqNum matche ...Show All

• IMoL Rotate table?

  Hi, I'm searching how I can 'rotate' a table in Reporting Services. Now I have drawn a table like this: ---------- header ------------ ---------- detail -------------- -----------footer-------------- This will result in vertical grown when there are more details found. I want that the table grows horizontally, like this: | | | H D F E E O A T O D A T E I E R L R | | | (Pffw, talking about ASCII art :) ...Show All

• C4702 What happens during connection manager validation?

  Hi, I have an issue at the moment regarding a proprietary data source that we are accessing using a proprietary OLE DB Provider. The validation phase when the package starts up takes AGES but when I set DelayValidation=FALSE on the connection manager and the data-flow then this validation phase takes no time at all - as normal.  (I still have a delay when the data-flow runs of course because validation occurs then as well) So, it seems ...Show All

• mostaf surface area configuration won't run

  Just completed new install of SQL 2005 Std, replacing a working default instance of SQL 2000 on a Windows 2003 Server.  All maintenance applied.  Things seem to work alright until I attempt to launch the SAC tool: Message is "specified aregument was out of range of valid values. parameter name: index(system.windows.forms.TreenodeCollection.get_item(int32 index) at Microsoft.SQLSAC.Mainpanel.form services and protocols". Should also men ...Show All

• Jfarran Unable to install SQL Server 2005 Standard

  I am trying to install SQL Server 2005 Standard Version on my IBM Thinkpad running Windows XP (SP2). I am installing from the CD that was given out to attendees at the Visual Studio 2005 Launch Event. The install is failing on the SQL Database Services with the following error: SQL Server Setup failed to execute a command for server configuration. The error was [Microsoft][SQL Native Client][SQL Server]. The default full-text language is no ...Show All

• spbsmr URGENT: Insert and Update in a transaction is getting blocked

  Hello, I have the following situation: -Package A begins a transaction (TransactionOption="Required") with IsolationLevel=Serializable -PackageA calls PackageB -PackageB has 2 data-flows. The first one inserts into TableA. The second one updates TableA. They run serially. They both have TransactionOption="Supported". The update is blocked in SQL Server by SPID=-2   (which I know is MSDTC). I tried setting RetainSameConne ...Show All