Answer Questions

• Chitra SQL Connecting ODBC

  [Microsoft][ODBC SQL DRIVER][SHARED MEMORY][SQL SERVER DOES NOT EXIST OR ACCESS DENIED] This is the error i've encountered when im running my program (VB6) with SQL Server 2000... Anyone has an idea on this Thanks in advance... Make sure SQL Server is started and Shared Memory Protocol is enabled. HTH, jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Jay Hickerson MS How to give premission to a Active directory group?

  Guys,       Only admin group users are able to view the reports from my reporting services server and as we know its not good to add lot of people in that group. Is there a way I can create a separate group with limited previllage and allow them to view these reports My co. also have a active directory group for the people who would like to use these reports. Is there a way I can specify that group name somwhe ...Show All

• gerridi Error : Header information is either corrupted or missing.

  My config : 1 computer with win2000, IIS, McAfee Virus Scan, and all I need to develope. 1 computer with VS2005. When I try to make merge replication I have this Error :Header information is either corrupted or missing. I search on the web and find some information like that error is cause by NIS (Norton Internet Security) but I dont have it. I have another mobile software in VS 2003 and I don't have trouble whit im. It ...Show All

• Timiscool9999 unable to run SSMS with secondary login

  Hi there, when I try to run the Management Studio under a different login (run as) it fails to start with a message "The directory name is invalid" for sqlwb.exe. The whole SQL Server 2005 package was installed as "Local Admin". Does anyone know a workaround for this problem Thanks, Frank Hi, thanks for replying, It's a security policy, that we have a secondary account for de ...Show All

• BugOrFeature_quest Schema and principals (Sql Server 2005)

  Hello Everyone, There is something we don't understand on SQL Server 2005. We want to grant acces to the login MyUser in the existing database MyDb. We want this login to be known as MyUser in MyDB and being the owner of a new schema named MyUser. Here are the commands we are using: use MyDb go create user MyUser for login MyUser with default_schema = MyUser go create schema MyUser go grant Take ownership on schema::MyUser to My ...Show All

• caldo_123 How can I avoid using a CURSOR inside of another CURSOR

  I am trying to avoid using a CURSOR inside of another CURSOR. Here's what I have to do... I have 3 tables: Table1 has 500,00 rows Table2 has 25 rows Table3 is empty For each row in Table1, I want to INSERT 25 rows (from Table2) into Table3. Using a CURSOR inside of another CURSOR, my code looks like this... Define and open CURSORA for TABLE1 FETCH the first row from TABLE1 using CURSORA WHILE (@@FETCH_STATUS&l ...Show All

• Kapil_kaash Aggregation Question

  Let's say we have 2 attributes: a and b. Each consists of the defaulthierarchy of an all-level and a leaflevel consisting of the leaves 1 and 2. If I add an aggregation on (a,b) then questions such as SELECT [SomeMeasure] ON 0 FROM [Cube] WHERE (b.b.2) should yield an answer that is preaggregated, right I.e. the coordinates (a.all,b.1),(a.all,b.2),(a.all,b.all),(a.1,b.1),(a.1,b.2),(a.1,b.all),(a.2,b.1),(a.2,b.2),(a.2,b.all) shou ...Show All

• SALEEM Database Design Question

  Which of the following options is best Option A) One database with all the tables for all applications (HR, TechStaff, Inventory, Purchasing, etc.).  The bonus to this is all the data is stored in one place and the data is not duplicated, but when the database has to come down, all applications will be unavailable.  Plus, volume may be present an read/write row/column issue. Option B) Multiple databases... one for each application.&nb ...Show All

• BlaineX Feedback on CTEs

  When I first saw this feature I though "Yeah, that's a nice-to-have" Now that I'm actually using them for real my opinion has changed to "WOW. These solve SO many problems that I couldn't have solved otherwise". Specifically I'm using them to navigate hierarchies (which is of course what they are for). Kudos to the SQL Server team, and thanks very much!! -Jamie Add me to the List ;) This saves me from writing my own set based hierarc ...Show All

• pompeybob44uk How to Copy DataBases between SQL Express instances.

  I am developing an application that uses SQL Server Express. Everything is running great, except that I can't figure out how to copy a DataBase from my server at work onto my laptop so that I may test it at home... How can I copy the DataBase from my Server at work to my laptop I'm on the network at work, I just can't figure out how to copy it... Please help! :) Thanks, Jacob Do I need SQL Server 2005 (not ex ...Show All

• Elham_Dahwa Beware the UNION ALL - it can swallow rows...

  Just for all you June CTPers as a warning..  I have a UNION ALL that, at random, decides to swallow row count.... Tried deleting and recreating task Unable to Repro Along with the buffer leaks and the looping errors.. bring on the NEXT CTP.. ! ! ! Giri, Can you send me a package that reproduces this issue We're unaware of any UnionAll issues with CTP15 and I'd love to fix these. thanks ...Show All

• SergeiU Open query error: Invalid data for type "numeric".

  Hi guys.... I am upgrading from SQL Server 2000 to 2005 x64. I have made a connection to an oracle database.  In one of the Oracle tables, there is a field named "numID", which is Number(8). So, when I run this query: select numID from   Openquery(myConnection, 'select numID from OracleTable where numID > 100 and numID < 1000'); I get this message: Msg 9803, Level 16, State 1, Line 1 Invalid data for type "numeric". ...Show All

• Prabhu000 Sproc execution varies in profiler

  I had a sproc which was running slowly. did the obvious and saw an additional index would help things out no end, however, when called from QA, the sproc is now lightning fast, when called from the app (VB6) it still runs like a dog. When looking at it in Profiler, the line  exec spPDR1 param1,param2 i.e. the please execute my stored procedure line) has a duration of 0 when called from QA, but 12076 from the application. Th obvious question ...Show All

• Aggelos Petropoulos Bulk Insert from Mapped Network Drive

  Hi, I am trying to perform bulk insert using mapped network drive, but getting following error: Server: Msg 4861, Level 16, State 1, Line 1 Could not bulk insert because file ' F:\Download\MVY.b45 ' could not be opened. Operating system error code 5(Access is denied.). F is mapped network drive pointing to my SQL Database Server. While searching, i got the following link but not able to relate with my problem: http://support.microsoft.c ...Show All

• Krishna Sunkammurali MISSING FUNCTIONALITY???? PLEASE HELP

  I think I am missing something, and this something I could achieve with Enterprise Manager. How do I copy one object, lke a table, including primary keys, indexed and triggers, plus data, from one SQL Server to another, or a set of tables I am at a loss. Of I choose "Copy Data", that is not the same because the table data is copied, but nothing else, not even the primary key gets transferred. So the arriving table is --quite frankly-- usele ...Show All