Category column in sysobjects

SQL Server Setup & Upgrade

Index ‹ SQL Server

- Previous
  - 1
    - Is there a KPI viewer outside the IDE ? I think Excel 2007, Performance Point and Business Scorecard Manager 2005 can do it. You can also query the KPI's using MDX functions like KPIValue(), KPITrend(), KPIStatus() etc. Tag: Category column in sysobjects
  - 2
    - Logon failed. (rsLogonFailed) Does the same thing happen when you do this: Code Snippet CredentialCache cc = new CredentialCache(); cc.Add(new Uri(Settings.Default.ReportServerEndPoint),"Basic", new NetworkCredential("uid", "pwd")); reportViewer.ServerReport.ReportServerCredentials.NetworkCredentials = cc; Tag: Category column in sysobjects
  - 3
    - Xpath/Xquery to exclude elements from XML You could create #temp table as copy of your table. Then use xml.modify() function with delete statement and then select from this update #temp table.Of couse, It isn't very scalable approach. Tag: Category column in sysobjects
  - 4
    - Update slow(5 Hrs, 14mil rows) on perm tables, however as part of SP using temp tables fast(45 mins 14mil rows) Kris: It would help if we could see the query plan for this update statement; please execute the following and post the results: set showplan_text on go update jkk_AllLogic_Allocation1_Work set ExpAllocValue = a.ExpFinValue * (a.SalesFinValue / s.TotSalesValue) from jkk_AllLogic_Allocation1_Work a, jkk_SumOfSales2 s where a.ID = s.ID go set showplan_text off go Tag: Category column in sysobjects
  - 5
    - Calculated Measure With Conditions I am guessing that you are not using [Material Pegging Plan - Dim].[Demand Prod Key] or [Material Pegging Plan - Dim].[Supply Prod Key] in your query If this is the case then both attributes are probably resolving to the name of thier default member which is probably "All" so [Material Pegging Plan - Dim].[Demand Prod Key] =[Material Pegging Plan - Dim].[Supply Prod Key] will always be true unless you drilldown to a specific member in either dimension. In which case this condition will always be false unless you select members with the same name in both attributes. There are probably ways of doing this in MDX using filter() or generate(), But what I would probably do would is to create a calcuated column in your DSV that returns the value of "Total Demand Qty Met - PMPI" when "Demand Type" = "F" and "Demand Prod Key" = "Demand Supply Key" Tag: Category column in sysobjects
  - 6
    - Import of Data from Access DB Does the access column contain only time Tag: Category column in sysobjects
  - 7
    - Exception Handling Hi Mannubhai, Which version of SQL server you are using.. if you are using SQL05, try using Try..catch block. If you are using SQL2k.. then in above script there is no variable declared and there is no rollitback lable.. And YOU SHOULD GET THE ERROR SAYING THAT THE TABLE DOES NOT EXISTS.. AND THIS ERROR HAS THE SEVERITY LEVEL OF 16.. which says that the error can be fixed by the user and terminates the batch.. so you are not able to catch it. Have a look on the severity levels for more details. Regards, Tag: Category column in sysobjects
  - 8
    - Converting the string value to data format Hi Code Snippet select cast('20070730' as datetime) Note : beware of collation used in your SQL instance or your database. -- Jean-Pierre Tag: Category column in sysobjects
  - 9
    - How to drop a user defined database role in 2005? i think the DB_Owner schema is owned by this role run this statement to see the schema and owner ... check whether this role is the owner of any schema SELECT s . name SchemaName , d . name SchemaOwnerName FROM sys.schemas s INNER JOIN sys.database_principals d ON s . principal_id = d . principal_id if this role owner of DB_Owner Schema run the below statment to transfer the owner ship.. ALTER AUTHORIZATION ON SCHEMA::[db_owner] TO [db_owner] Drop role test1 Madhu Tag: Category column in sysobjects
  - 10
    - Accessing a report. Going off memory here... and it's been a little while... ReportPath should be "Phishing/WF/Country+Report" and the Url should be http://bdsvr16/reportserver/ HTH BobP Tag: Category column in sysobjects
  - 11
    - Export SQL Server 2k/2k5 DB to SQL Mobile 2k5? Express will not work. There is a great third party product that can do what you want: www.primeworks.pt Darren Tag: Category column in sysobjects
  - 12
    - Is there tranasction operation when EventCollector.Write() or EventCollector.Commit() is occurring There is only one event will be submitted from more than one client at one time. So I think I need to run a transaction, is that right But I'm not sure if the EventCollector.Write() or EventCollector.Commit() method has transaction operation. Thx for tell me the answer or how can I make sure about it. Tag: Category column in sysobjects
  - 13
    - Tabbed Reporting Hello, No, this is not a feature that was added in SQL 2008. If you would like to file this as a feature request, please do so at http://connect.microsoft.com . Thanks, Chris Tag: Category column in sysobjects
  - 14
    - Log File Full How much frequency are you taking backup of transaction log For example, if you are taking transaction log backup every 30 minutes, change it to every 15 minutes. Thanks Naras. Tag: Category column in sysobjects
  - 15
    - using 8.0 DB on SQL 2005 Yes, restoring a SQL 2000 (v8.0) database on SQL 2005 is a supported process. Tag: Category column in sysobjects
  - 16
    - function executed as part of a stored procedure? Torsten: What exactly are you meaning by 50,000 - 200,000 result sets Do you mean records or do you mean 50,000 -200,000 multi-record datasets To me it sounds like you are talking about a record-based process instead of a set-based process. If so, then yes, you should by all means convert the stored procedure to a set-based process and call your function only one time. It would help if you could provide the main part of the process you are doing and important elements of your data schema. Tag: Category column in sysobjects
- Next
  - 1
    - Cannot deploy reports to default website get error msg.. A couple of troubleshooting steps: Does the computer you are running Visual Studio on have IIS service started Can you hit your deployment URL above through your web browser directly You should see a ReportServer header and a list of your folders if the ReportServer is configured correctly. Tag: Category column in sysobjects
  - 2
    - How do I jump to another report based on a value Right-click on the field you wish to link, select Navigation, select jump to report, and specify the report and any parameters required. Here are a couple of links that may help. http://msdn2.microsoft.com/en-us/library/aa964132.aspx http://www.codeproject.com/useritems/InputParmReport.asp df=100&forumid=290297&exp=0&select=1472409 cheers, Andrew Tag: Category column in sysobjects
  - 3
    - Very Large dimensions, more than 4GB needed for store file. There's no way around it that I know of. There are a couple of hints to let you squeeze every last ounce of the 4GB you can: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=2009710&SiteID=1 The other thing I would try is doing a ProcessFull on the dimension occasionally if you regularly do ProcessUpdate. (If you do ProcessUpdate, any deleted members don't get physically deleted, just flagged... so ProcessFull will get rid of those deleted members.) The only possible workaround I know of is the following, but it's a bit desperate and makes it hard for end users to use that dimension: http://cwebbbi.spaces.live.com/Blog/cns!7B84B0F2C239489A!777.entry Tag: Category column in sysobjects
  - 4
    - Backup Error:Set property Devices to accomplish this action. Some components cannot be installed on an alternative location and have to be installed in the %programfiles% directory. If this one is located on the system drive you will not be able to install it on an alternative drive. Jens K. Suessmeyer --- http://www.sqlserver2005.de --- Tag: Category column in sysobjects
  - 5
    - What is the best Backup strategy The normal questions to answer are: How much data can you afford to lose How much time can you afford to take to restore By making daily backups, you have decided that you are willing to lose an entire days work if a failure occurs. If there is light activity, that may be a reasonable plan. If handling other folks data, and those other folks wouldn't be so understanding if their data was lost, then you should consider other options. A reasonable secure plan is: Full Backups -weekly Differential Backups -Daily Transaction Log Backups -Hourly Tag: Category column in sysobjects
  - 6
    - How do I get the Table Name the column belongs to in SMO? col.Parent will return you a SqlSmoObject which you can cast as a Table (or View). Hope that helps. Thanks, Kuntal Tag: Category column in sysobjects
  - 7
    - Sharepoint 2007 Report Services Addin Install Problem When you run the SharePointRS.msi, it creates a log file - RS_SP_<number>.log. It should be @ <Drive>:\Documents and Settings\_AWTEST\Local Settings\Temp folder. Can you cut-paste the contents of the latest RS_SP_<number>.log file into your reply thanx, Prash Tag: Category column in sysobjects
  - 8
    - Best Practices: Recording Error Information (Beyond ErrorCode and ErrorColumn) If you want to identify which component produced an error then simply hook a derived column component up to the error path that adds the name of the component producing the error to the data path. Thats that one taken care of! "Do I really have to create a separate "add useful information to the error output" component, and use it on each error output " Whats the problem with doing that Granted you could argue that this information should be included anyway but the rationale for it NOT being there is that it could potentially take up A LOT of memory - a rationale that I agree with. hence you have the opportunity to do it yourself. Note that if youre using a UNION ALL to collate all of your error rows into one place then you only need to do this once. -Jamie Tag: Category column in sysobjects
  - 9
    - Visual Studio 2008 and SSIS This GUID is not related to MSXML, it belongs to SQLTaskConnections.dll. I don't know why installing VS 2008 would break it, but you may try to register SQLTaskConnections.dll using RegSvr32. Tag: Category column in sysobjects
  - 10
    - UPDATE: Email Report in Outlook 2007 not the same as Outlook 2003 I still haven't found a fix for this, however, the user has found that opening the email message in a browser window displays it as expected. I wouldn't consider this a fix, unless all Outlook 2007 users are supposed to open all email messages in a browser window. If not, then it still would be nice to send an email report that is formatted correctly when the message is opened as a regular email message as it used to do in earlier Outlook versions. Tag: Category column in sysobjects
  - 11
    - One DB machine for Two WebSites For pure performance and simplicity, one instance of SQL Server with two databases will work better. With multiple instances of SQL Server, your available memory is split between the instances. Tag: Category column in sysobjects
  - 12
    - Unexpected BIGINT conversion behavior A known issue. Look for a fix in SQL Server 2008. https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx FeedbackID=260967 Tag: Category column in sysobjects
  - 13
    - SQLServer auto-add Null terminator at the end of the field through network Any ideas Tag: Category column in sysobjects
  - 14
    - Using a stored procedure variable to define a Where clause Here you will find the answer. Arrays and Lists in SQL Server http://www.sommarskog.se/arrays-in-sql.html AMB Tag: Category column in sysobjects
  - 15
    - Check 3 occurrences of double characters. Thre is no predefined expressions available, Following approach is one of the way to achive this, Code Snippet Create Table #data ( [Numbers] Varchar ( 100 ) ); Insert Into #data Values ( '1242432' ); Insert Into #data Values ( '242423423' ); Insert Into #data Values ( '2332232' ); Insert Into #data Values ( '828289' ); Insert Into #data Values ( '99887766' ); Insert Into #data Values ( '92829299' ); select numbers from #data cross join ( select '00' n union all select '11' union all select '22' union all select '33' union all select '44' union all select '55' union all select '66' union all select '77' union all select '88' union all select '99' ) as d group by numbers having sum ( case when patindex ( '%' + n + '%' , numbers ) <> 0 Then 1 Else 0 End ) >= 3 Tag: Category column in sysobjects
  - 16
    - Issue with OLE DB Command while writing to DB2 database Some thoughts on this: 1. It is better to use the OLE DB Destination to insert data into a table instead of the OLE DB Command with an insert statement. You should give that a try. 2. Are you using the Microsoft OLE DB provider for DB2 from our SQL Server 2005 Feature Pack That's the provider that's been tested with SSIS. 3. I don't understand what you mean by not able to get input columns. What are the error messages when the package fails Tag: Category column in sysobjects

Tim Mitchell

Everyone,

Is there a reference to describe the relevance of the Category column in the sysobjects table I'm trying to track down stored procedures that are set to automatically run at startup and the only thing I can find that is consistent about those that are set to autorun is that they have a value of 16 in the Category column. Is this consistent What else may I glean from this column

Thanks

Tim

Top

Re: Category column in sysobjects

Madhu K Nair

this will give u the sps which run at startup

Run this in Master db.

SELECT * FROM sysobjects WHERE xtype IN ('X','P') AND ObjectProperty(id, 'ExecIsStartup') = 1

Madhu

Top

Re: Category column in sysobjects

Tim Mitchell

Thanks, that is exactly what I needed.

I'm still curious, though, what the category column in this table represents.

Top