.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Post New Web Links

syscolumns language equivalent in sys.columns sql 2008

Posted By:      Posted Date: August 30, 2010    Points: 0   Category :Sql Server
 
Hi - I was looking for the equivalent field of language in syscolumns, in SQL 2008 sys.columns catalog view. Can some one help? thanks in advance!


View Complete Post


More Related Resource Links

Sum of 2 columns in sql server 2008

  
Hi, I have a SP which calls 2 UDFs. These UDFs returns an interger value each. I would like to add the UDF values and display them row wise. The following is the code I have used:   SELECT dbo.fnc_IsConformanceCount(OBS.Behaviour_Id, @company_id) AS 'Is_Conf_Count' , dbo.fnc_IsNonConformanceCount(OBS.Behaviour_Id, @company_id) AS 'Is_Non_Conf_Count' , ("Is_Conf_Count"+"Is_Non_Conf_Count")   Please suggest. -- Thanks Debashis    --- Best regards, Debashis http://debashis80.spaces.live.com/

Folders or folder like equivalent in SQL Server 2008 ? for packages & stored procedures ?

  
Hi,      Currently running SQL-Server 2000.  We have hundreds of stored procedures and DTS packages. We have so many it's becoming a serious challenge for names and such.  We were wondering if SQL Server 2008 has a way to 'nest' both the equivalent of DTS packages (SSIS) and stored procedures in something akin to 'folders'.  We know we have to upgrade one of these days but a version that would handle these would be much more attractive. Just getting this functionality would be worth whatever effort would be required to upgrade.   Thanks in advance for any help on this.

Equivalent of Solution generator 2008 in SharePoint 2010

  

Hi all,

Do we have some kind of Equivalent of Solution generator 2008 (SharePoint 2007 to generate list definitions and site definitions via SharePoint 2007 UI and use it in our WSP)  in SharePoint 2010?

Thank you.

Cheers,
--aaroh

 


SQL Server 2008 R2 Installation Problem - The language ENU is not supported by this setup package.

  
Hello,

I am trying to install SQL Server 2008 Standard R2 on a Windows Server 2008 R2 64bits machine (all updates applied)... 

I run the setup.exe on the command line and I get the following error :

The language ENU is not supported by this setup package.
An error occurred during the SQL Server 2008 R2 Setup operation.

Error result: -2067529698
Result facility code: 1220
Result error code: 30

For more information, review SQL Server 2008 R2 Setup logs in your temp folder.

.............
There is no log generated.

My regional settings + locale are all English-US



Any ideas?

Thanks,

Alex


does the sql server 2008 R2 support movable columns in a tablix (in Reports)

  

hi,

is there a way to build a report with a tablix and let the columns movable for the users?
from another post i figured out, that this feature is not supported in sql server 2008.
is it featured in  2008 R2 or in 2010? :)

thanks Johnny

 


Windows XP, Visual Studio Express 2010 and SQL Server 2008 Express - How can I save modified columns

  

Hi,

I am using c# in VS 2010 Express. I have a MDF database that I connect to through "Database Explorer". Database Explorer will not let me SAVE columns that I have modified. As I know in SQL Server 2008 full edition you can change the setting "Prevent saving changes that require table recreation" in Management Console to prevent this. I haven't got Management Console and can't see it in install.

How do I change this setting if I haven't got management console? Is it in Registry or Config File.

Thanks.

John.   


Will SSRS 2008 eliminate white space due to hidden columns?

  

I have many reports that hide/show columns based on either parameters or user input.  When columns are hidden the body size is not recalculated and also cannot be set through expressions.  This leads to at best extra blank pages when reports are printed, at worst reports that cannot be embedded as subreports into other reports because they off-set the elements around them when the area into which they are inserted automatically resizes in rendering.  This should be considered a bug in the current release (2005).

 

Is there any chance of this making it into the new version (either that the renderer recalculates the body width or that expressions could be used in fields such as body width)?

 


Looking for Client Query Analyzer (SQL Server 2008) or Equivalent Reporting Tools

  

I've recently upgraded from SQL Server 2000 to SQL Server 2008.  My accounting and marketing team is skilled and has been using SQL Query Analyzer for years to run smaller queries and build small Crystal Reports.  Unfortunately Query Analyzer is now bundled into the management studio.  That's a bit too much software for this level of power users.

Is there a client-side query analyzer for SQL Server 2008?  I'd rather use a Microsoft product than a 3rd party tool, but I suppose I could do that too.  Looking for something simple that will:

1.  Show users the database tables and/or views

2.  Run queries

Perhaps query analyzer isn't the way to go and my team needs a different reporting system.  If this is the way MS is heading, could you direct me towards a product or service that allows power users to get the information they need?  They will still need to look at raw data to build Crystal Reports though.


SSRS 2008: How to build a total of two columns depending on their contexts

  

Hi guys,

I've got following issue. I have a matrix like this

         Months
Sales  January  February  March  April  May ...     January + February   February + April
         10         20          15       5      30                      ?                          ?

I have a row group "Sales" and a column group "Months". Now i need to build different subtotals oh the column group, for example January+February. Which would be 30 in this case.

Any ideas how ideas how i can build these totals???

Thank you

Alina  


SSRS 2008: How to build a subtotal of two columns depending on their contexts

  

Hey guys,

I've got following issue. I have a matrix like this

         Months
Sales  January  February  March  April  May ...     January + February   February + April
         10         20          15       5      30                      ?                          ?

I have a row group "Sales" and a column group "Months". Now i need to build different subtotals oh the column group, for example January+February. Which would be 30 in this case.

Any ideas how ideas how i can build these totals???

Thank you

Alina  


Does the 2008 R2 Data Alignment in the columns (Domain Scope) work with multiple tablix's

  

Does the 2008 R2 Data Alignment in the columns (Domain Scope) work with multiple tablix's or only with one Tablix with different groups?

 

I have been trying to use it for a report that has 3 tablixs (the same dataset and same format) but it doesnt seem to work. All the examples i find are for a single tablix.

Anyone know?


Can I use the Dynaqmic Language Runtime (DLR) in SQL Server 2008 R2?

  

Hi All,

Sorry if this is a total newbie question.  I've searched all around and it would seem like the answer would be 'no'.  The point of confusion is that visual studio lets me write the code in a sql project but then barfs with this error:

"One or more types required to compile a dynamic expression cannot be found. Are you missing references to Microsoft.CSharp.dll and System.Core.dll?"

System.Core I can actually reference.  Microsoft.CSharp I cannot and I understand that this is a security issue.  Fine.  But is DLR usage considered dynamically compiled code?  Seems a little weird since all it really is is a hashtable lookup and some late-bound dereferencing (yes, it could take down your server, but there you go.)

Anyway, is there a way for me to use a 'dynamic' object in SQL server 2008 R2 or am I just out of luck?

thanks!

-denny-

 

 


Renaming or modifying columns in SQL Management Studio 2008

  

I have recently upgraded to SQL Management Studio 2008. The first thing I noticed is it wouldn't allow me to save changes to my table structure at all. I fixed this by disabling "Prevent Saving Changes that requre table re-creation" under Tools..Options...Designers...Table and Database Designers. Now it lets me save. However, if I rename a column in a table that has data in it, I get a warning telling me my data will be lost since the old column will be gone and the new column has no data in it. Since when does renaming a column require a table to be recreated? Is this some sort of setting in SQL Management Studio? If I can't don things like rename clolumns (even change column data types) without losing all my data, then what is the point of using SQL management studio?


SSRS 2008 - Excel Export adding unwanted total columns to spreadsheet

  

Hi

I have a SSRS 2008 report which has 3 column groups which when i export to Excel the resulting excel spreadsheet has an additional total column for each of the groups.  I dont have this displayed in the report and dont want it displayed in teh excel export, is there anyway to turn this off?

I've had a search of this forum but so far i've been unable to find a solution(or someone else having the same problem)

Cheers


Reporting Services 2008: Columns get shifted on Tablix after hiding a field.

  

 Hello,

I have a report implemented on SSRS 2005 that for the purpose of hiding the toggle sign (+/-) when there is no detail data has an expression on the Hidden property of the text box.

Now when migrating to 2008, the table has been automatically upgraded to a tablix with the undesired behavior that, when a field is hidden on a row, the remaining fields are shifted to the left to occupy the space of the hidden field.

This happens only when the report is rendered on the web. On Visual Studio it works as in 2005.

Is there a way to avoid this kind of shifting? Why will I want to render a field on a space designated to the field on the left that it may not even fit?

Regards,
Daniel.

 

 


Key Columns property when creating dimension hierarchy in Analysis Services 2008

  

HI All

I have 3 dimensions in our Data Warehouse, dimCampaign, dimCampaignList and dimCampaignTarget
Think of dimCampaign as a marketing campaign, that contains one or more Campaign Lists (offers) for which many customers (dimCampaignTargets) receive.  The are foreign key relationships between these 3 tables, and it is the dimCampaignTarget ids that are written to associated fact tables

I have created a single dimension in Analysis Services 2008 that contains these 3 tables and their respective relationships were set up in the DSV so that I could do this.  Rather than use the 'referenced' dimension method, I wanted a 'single' dimension containing the 3 tables and their snowflake relationships in order that I can create a hierarchy that contains attributes from differing tables (namely the Campaign Description from dimCampaign, and Campaign List Description from dimCampaignList). 

My hierarchy has those 2 levels, top level is Campaign (description), and the 2nd level is Campaign List (description).  The Campaign Targets are not shown in the hierarchy, their attribute is only used in the dimension as the join to most of the fact tables.

Problem is when I set up my hierarchy, I go to change the Key Columns property of the Campaign List attribute to make it a collection of keys (Campaign and Campaign List) as I did in

How to print more than 15 columns of data in SSRS 2008?

  

Hi,

I have a report with 15 columns of data (each column is approximately 1inch~2inch), when I preview the report and click PRINT icon (which is very next to refresh icon) then save it as Microsoft xps document writer, it shows only first 5 columns of data, even data is truncated at end of each page in .xps.

I have selected A4 paper type in report properties, So please assist me how to print all 15 columns (along with header and footer) of data ? If I change the width and height in report properties then it affects rendering to PDF, DOC etc ..

Any suggestion is also welcome


Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend