SQL Server

Page 2118




  • Topics
    Replies
    Last post
  • Questions (and suggestions) on HierarchyID datatype
    by Anders Borum
    11 Replies
    Last post by Michael Feng Wang
      • Hello! I have a few questions (and suggestions) related to the new HierarchyID datatype in SQL Server 2008 (Katmai). In general, I'm really pleased to see a native hierarchical datatype. Having tested various tree operations using the new datatype over the weekend, it looks like a sound replacement for our adjacency lists and nested set models (tree structures in relational databas
  • User 'dbo' without a login name
    by Hando Riisikamp
    7 Replies
    Last post by Raul Garcia - MS
      • Hello, how to get rid of login name for database user 'dbo' It is: Login name: something User name: dbo It should be: Login name: <None> User name: dbo As there is another database on my server with this setup ('dbo' without associated login name), this should be possible. Rgds, Hando
  • SQL Server 2005 - Management Studio - Alphabetical Project List?
    by hshot_rooke
    6 Replies
    Last post by David Frommer
      • Hi everyone My company just recently started using the MS SQL Server 2005 Management Studio IDE to manage the front end of our SQL database. Problem I'm having is that after creating a solution and project and adding my stored procedures to the project, the list of queries (stored procs) is sorted based on the order I've added the procedures.  Is there ANY way of getting the solution/project
  • Connecting to a local instance from a remote computer
    by dreameR.78
    6 Replies
    Last post by dreameR.78
      • Greetings friends, Not sure if this is the right place for my question but here goes anyway. I have an instance of SQL Server 2005 installed on my DEV PC. A colleague of mine wants to access my server from his machine which connected to the same network. I logged on to SSMS and added him as a new login. Will he be able to connect to it now or do I have to do more than j
  • JOIN Question
    by SynergyNT
    13 Replies
    Last post by SynergyNT
      • Good Morning, I'm attempting to pull information regarding the orders placed over the last week for all of our customers. I want my result set to show a listing for each customer and any orders they have placed, or if they have not placed any orders, just a line with a NULL value or something similar. Ultimately, I may use a COUNT on this information, but for right now, I am just trying to work ar
  • Deployment the Project of VB.net express And SQL 2005 Express
    by princehaq
    1 Replies
    Last post by Madhu K Nair
      • I have problem after deployig the setup project. when I install it on other computer it show error that an error has occur whil establishing connection to server. plz tell me how can I deploye a project and how can I handle this problem..
  • Save Me From a CURSOR
    by Fanbladeus
    14 Replies
    Last post by Fanbladeus
      • Ok, I have a solution for this but it involves a cursor that will take 3 days to run. Please someone save me from this! I have a table that contains 700,000 records. I need to update a field in this table with an integer to denote what set of records it belongs to. Basically if you look at the table in order by RowID, everytime the AcctNUM changes, the fieldtofill is incremented. The AcctNu
  • Select To clause
    by maatthias
    4 Replies
    Last post by maatthias
      • I'm having trouble using the To clause in my select statement. The following errs out with Incorrect syntax near the keyword 'to'. use pubs select * from view_Rates to 'c:\test.csv' I also tried this and got same error: use pubs select * to 'c:\test.csv' from view_Rates
  • in what situations principal database might become unavailable ?
    by Alex_UTL
    1 Replies
    Last post by Satya SKJ
      • Is it correct to say in any case exept when data or log file not available pricipal db will be availabe and manual failover could be done only from from principal
  • Limit on Nested Tables
    by Brian Knight
    2 Replies
    Last post by Brian Knight
      • I have a decision tree mining model that has two nested tables and that amount of inputs processes in under a minute. When I add a third nested table in what I think is exactly the same way (I've tried two different ones), it never returns from counting the cases. Is there a limit on the number of nested tables one can have in a DT model It does process the rest of the objects and measure groups b
  • ReportServer DB and ReportServerTempDB databases
    by bluemoon2181
    4 Replies
    Last post by bluemoon2181
      • Hi all, Is it possible to cleanup ReportServer DB and ReportServerTempDB by setting the time interval For example, I want data in these two dbs to be deleted automatically after 5 or 10 minutes. How can I do that because as new reports are added and executed data goes on increasing in very short time and hurts performance. Thanks, Prashant
  • Cascading Parameter not working
    by Novin Jaiswal
    3 Replies
    Last post by Novin Jaiswal
      • Hi Friends, I have 2 parameter One is Office (Listbox) another Account(list box) , where Account list box filling is dependent on the Office selection. In published report when I select the office from list box the page got refreshed but it not updating the account list, the account list box looks diabled I have define the two parameter and for the second parameter here is the query ="SELECT
  • how to create key time column and key column for a case table and a nested table for time series algorithm?
    by Helen999888
    5 Replies
    Last post by Helen999888
      • Hi, all experts here, Thanks for your kind attention. I want to use time series algorithm to mine data from my case table and nested table. Case table is Date table, while nested table is the fact table. E.g, I want to predict the monthly sales amount for different region (I have region table related to the fact table), how can I achieve this Thanks a lot and I hope it is clear fo
  • Emailing Report
    by shah_hs
    4 Replies
    Last post by jwelch
      • I need to export a view into excel and mail to my manager daily morning. Is there a way i can automate this process. I know how to convert view to excel but i need a better solution to automate this process with emailing to my mgr. Please suggest a better approach of doing this. Thanks,
  • Using patterns in CASE nested in SELECT
    by JDWise
    3 Replies
    Last post by Arnie Rowland
      • Hi all, Arnie, you had helped me with the query last week. Now another question (for anyone). I need to create a table and keep rows based on patterns of text in the varchar(1000) column in the source table and putting CASE within a SELECT that follows the INSERT while trying to use the LIKE comparison. Troublesome, to say the least. DECLARE @add DECLARE @cancel CREATE tabl
  • Does it seem right?
    by Arnie Rowland
    1 Replies
    Last post by Arnie Rowland
      • That a person can respond to their own question and then take credit for the answer Or that a person can respond and acknowledge someone that helped them, and then also take credit for the response OR does that seem like a 'flaw' in the system... Inquiring minds are curious...
  • Access Permissions on server scoped objects for login
    by John_Enters
    14 Replies
    Last post by Asvin Ananthanarayan MSFT
      • We are having problems with the response times from UPS WorldShip after switching from SQL Server 2000 to 2005. I think that the problem can be fixed from the database end by setting the permissions correctly for the user/role/schema that is being used by WorldShip to connect to the server but, I'm not sure how to do it. The Setup Client UPS WorldShip 8.0 running on XP Pro SP2 Connecting
  • Cube role permissions not working
    by Neerajjsr
    3 Replies
    Last post by Neerajjsr
      • Hi Experts, I have build a SSAS cube and have assigned a role to it. The role grants permission to a specific user to view limited dimensional data. The problem is when the user generates any report from the report builder he is able to see the restricted data also. Please suggest what may be the problem. Regards Neeraj
  • Is local admin required for C# express/SQL express?
    by George Merriman
    9 Replies
    Last post by George Merriman
      • I have been trying to get Visual Studio Express w/C# to work with SQL Express. If I run with my normal local privs set to Debug User, I get a Login Failed message when I try to add a SQL database using the Add Item feature from the Solution Explorer. If I set my account to run as local administrator, everything works as expected. I am unable to connect to anything from the Database Explorer as wel
  • use of Hostname
    by KRISTER
    1 Replies
    Last post by KRISTER
      • Hello Can anyone explain how HOSTNAME works I have problem with identitys when subscriptions uploads new inserted data, I need somehow create a partitions for each user. All user need exactly the same data (now 10 user but in future about 100 users). In the database is 116 tables and still growing. Because this is a project i working with. My system is a one Server, o
  • sql query help
    by nasrene
    3 Replies
    Last post by richbrownesq
      • i hve three table like this books id year asd 1 1987 as 2 1967 sw 3 1981 assd 4 1987 table2 cd id year jfdh 1 1987 swe 2 1998 2ss 3 1967 zxc 4 1981 i want a query . the result is year no of books no of cd 1987 2 1 1967 1 1 1981 1 1 1
  • Import and Export Data Wizard missing in SQL Server 2005 Express Edition
    by rrudolph
    14 Replies
    Last post by rrudolph
      • After some weeks evaluating tools and platforms for developing an application, I decided to move to SQL Server 2005 Express Edition. Everything was fine till last night, when after creating my tables, I needed to populate them. I tried to find the Import and Export Data Wizard that SQL Server 7.0 and 2000 used to have, but great was my surprise when I found -  in this forum - a post that
  • Sharing an SSIS package with other developers
    by DanR1
    12 Replies
    Last post by DanR1
      • I have read a number of threads in this forum concerning SSIS packages and Protection Level. I regret to say that I did not manage to find one that covers the problem I am experiencing. I have saved a package that contains a SQL Server Authentication login and password. In Properties for the Package I have set ProtectionLevel = EncryptSensitiveWithPassword I then save my Packa
  • Cast COM object error on OleDb Destination (Access 2003)
    by Dave in US
    2 Replies
    Last post by Dave in US
      • Trying to do a update/insert from SQL 2005 query to Access 2003 linked table. In the Script Transformation I get this error. Unable to cast COM object of type 'System.__ComObject' to class type 'System.Data.OleDb.OleDbConnection'. Instances of types that represent COM components cannot be cast to types that do not represent COM components; however they can be cast to interfaces as long as th
  • Stored Procedures vs SQL Select Statement.
    by Sam Davis
    4 Replies
    Last post by Arnie Rowland
      • I have a question related to performance. Which would be better performance wise. Lets say I have a Stored Procedure which does a process, and within the stored procedure I need to collect information as it relates to the process. So this may require me to obtain data from several other tables in order to complete the process. Is it better performance wise to execute another stored procedure to