Answer Questions

• trogers creating users in sql eypress

  Hi, wanted to add a login in via c# to sql server express. Is this possible I treid this: String connString = "data source=xtrlt027;Initial catalog=master;Integrated Security=true;"; SqlConnection conn= new SqlConnection();; conn.ConnectionString = connString; try { System.Console.WriteLine("Opening Connection..."); conn.Open(); System.Console.WriteLine("Conne ...Show All

• nollsen Problem converting VS2003 code to VS2005

  Hi: I am trying to convert my VS2003 project to VS2005 beta 2. The actual conversion has gone fine, but some code that was working fine under to old IDE is now giving me an exception when run under the VS2005 generated code. The code is: using ( SqlConnection conn = new SqlConnection ("Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=GestionNET00001;Data Source=localhost" ) {   ... } And the error I'm getti ...Show All

• Fabio82 Mixed Mode

  After installing SQL Server 2005 I found that I inadvertantly used Windows Authentication Mode and I would like to change to Mixed Mode (Windows Authentication and SQL Server Authentication) - what is the best way to do this In Microsoft SQL Server 2000 you could simply go into Enterprise Manager, edit the SQL Server Registration Properties, edit the Properties of the SQL Server and edit the Properties of the SQL Server Agent. ...Show All

• ?封 sp_helplogins

  I tryning to program (in VB.net) sp_helplogins, assuming this is the correct sp to use to determine who is currently logged onto the database. Ive already programmed, in VB.net, the execution of sp_helpuser and get correct results, but don't seem to be able to program sp_helplogins. Any help would be appreciated. Thanks, /jerry Well, let me rephrase the question -- How can I determine who is ...Show All

• zeusmt Constants to Sets

  Hi, I guess that's an easy one... I'm quite sure that my brain is gone for weekend... And I'm still getting used to MDX... I'm using the min function to find out the minimum of two measures, so basically: min({[Measures].[MeasureA],[Measures].[MeasureB]}) This works perfectly. But what I need is to have something like that: min({[Measures].[MeasureA],[Measures].[MeasureB],0}) So that when A and B are both greater than 0 th ...Show All

• Anh2lua Restricting data in Report Builder

  Hi guys, I have a question on restricting a data using some kind of dynamic parameter when users are using Microsoft Reporting Services Report Builder. I saw that I can set permissions and restrictions for report model items like columns, but I want the users be able to see all the columns, but the actual data that gets pulled needs to be restricted using a database table (bridge table) that assigns the users to what they are able to see. ...Show All

• mrehpine Help !!! Database failed to restore

  I had to restore SQl Server v7 but the database has failed to reinstall.. sql statement restore database sebr from disk = "c:\Projects\EBR\Database" with norecovery, stats=1, replace Response after about 5 mins Server: Msg 3624, Level 20, State 1, Line 1 Location: upgraddb.cpp:214 Expression: tableIndex < ARRAY_LEN (upgradeMap) SPID: 7 Process ID: 800 Connection Broken Can anybody give any advice ...Show All

• Rafael Ignacio Dynamic Login & User Creation

  Hello. I'm trying to create a new login and username inside a trigger using variables. This code works: create login testUserName with password = 'testPassword' The problem comes when I try to use variables for the username and password like this. create login @username with password = @password Does anybody know how to get around this problem BTW, the error message it gives is this, but I really doubt that semic ...Show All

• achristov WMI Event Watcher for Windows Monitoring Service

  I would like to use SSIS Script for Monitoring Windows Service... If Windows Service Up / Down. I should be able to Notified by Using SSIS Script(SQL SERVER 2005). Please Help me You'd probably not need SSIS if you just need to monitor service status. Here is a script that could list name and status of running services (for more details see http://www.windowsitpro.com/Windows/Article/ArticleID/41670 ...Show All

• DDaniel SQL Server test to production database migration

  Hi, Is there any tool available to migrate the data from the SQL Server test database to SQL Server production database. Data Migration should be based on a condition which can be given as an input for a table by the user. The dependant tables also should be migrated based on the condition. i.e data subsetting based on the matching conditions. Ex : Salary > 2000 The rows of the table which matches the condition alone need t ...Show All

• smaillet SSIS thinks an invalid expression is valid

  I have put the following invalid expression: @[Metadata ::ValidStream == TRUE (note the lack of a closing square bracket) into a precedence constraint, clicked the "Test" button and got the message "Expression validated successfully". Can anyone replicate this -Jamie I'm also unable to reproduce this.  Sometimes I hate being crazy ;) Have you tried putting it into a precedence constraint P.S. I missed the rest of the expres ...Show All

• Victoria W Package Migration Wizard error -- Index was out of range

  I am unable to migrate any DTS packages, from a SQL Server 2000 package, from a structured storage file, or from a DTS package imported into SQL2005 (Developer Edition, 32 bit).  Running the Package Migration Wizard, every time I get to the List Package screen, i get the error below.  I haven't found any other mention of this so far.  Anyone else seen this error or have suggestions "Index was out of range. Must be non-negative and ...Show All

• RTS4ME how to enable Model item security ?

  Hi friends how to enable Model item security i found followin link that talks abt this http://msdn2.microsoft.com/en-us/library/ms156505.aspx extract from abv link Securing items in a model requires a report server connection in Management Studio. To secure model items, the report model must be deployed on the report server. In Management Studio, connect to the report server that stores the model. In Object Explorer, navigate to t ...Show All

• Mario barajas Optimize for CPU load

  What are the best practices to avoid CPU load in SQL Server It is hard to say one way or the other. It depends on the query plan, amount of data and the problem you are trying to solve for example. It is too open ended of a question to suggest specific things to do. Troubleshooting performance problems generally involves many factors and in case of SQL Server the interaction of the various systems (OS, disk, memory, sql server engine ...Show All

• Jo&amp;#227;o Gon&amp;#231;alo Bilhim Linking Tables

  my clients are in table1, all my repairs are in table2......If a client has a repair, how do i link the tables so that when i do Select Repairs From Table2, i want it to pull the repairs along with the client name, but i really am stomped on how to do it any help Can create a view for the same. Basically an INNER JOIN on Clients and Repair table should be good. thanks that inner join worked perfec ...Show All