Answer Questions

• ra00l Newbie: sql 2005 encryption --- or where do I put that key?

  I can encrypt columns in sql 2005 but where do I store the key to decrypt the columns I can store the key in the database (or server on which the database resides) but I think that offers little security. I could store the key on another server that the sql server accesses only upon startup (though I don't know exactly how to do that). Or I could store the key on a removable drive that is read (and only needed) when the sql server starts up. ...Show All

• RezRaider Network access to Sql Server 2005 Express

  I have an application written in VB Express and uses SQL Server 2005 Express that runs on my local machine (name JERRY).  I published it onto a CD and installed it on another computer (JKNETWORK) on my home network. I've already modified SQL Server Configuration Manager to enable TCP/IP and Shared Memory . I have also added sqlservr.exe to the exceptions in the Microsoft firewall exceptions list. The application opens with ...Show All

• Nadav74 Executing MDX queries from inside SQL Server Stored Procedures (SQL Server 2005)

  Hello all, Does anyone have any idea how to access a cube from stored procedures in SQL Server 2005 My idea was to use SQLCLR and write a function in .NET that accessed the cube through ADOMD, but there are problems with that. See the following code sample: using System; using System.Data; using System.Data.SqlClient; using System.Data.SqlTypes; using Microsoft.SqlServer.Server; using Microsoft.AnalysisServices.AdomdC ...Show All

• Calvin Ho SQL Server 2005 data export wizard did not transfer stored procedures

  OK, I got the data transferred, but now  SQL Server 2005 data export wizard did not transfer stored procedures. .. I am transferring from SQl Server Express 2005. Just trying to get the starter kit working, it used to be easier... Please help Now after exiting SQL Management Studio, all my registered servers are gone. Any idea When I try to register one, it does not allow me to select SQl Server authentication . This option is gr ...Show All

• Meatball SQL Server Project

  All, I'm getting ready to write a major conversion program. It will be taking extracted data from VSAM files and load them into a new SQL Server data structure. My question is should I write this as a SQL Server Project in VS2005 Should I write it in SQL Server managed code Or just create a windows app using ADO.NET I'm thinking that since it is so DB intensive that SQL Server Project is the way to go. If so, where  can I find documentatio ...Show All

• Cha Chunchadatharn How to troubleshoot intermittent lockups

  Hi, I'm an accidental DBA and I was wondering how to troubleshoot what causes Sql Server to lock up some times. When I say “lock up”, I don’t mean completely. I’m talking about a situation everything’s working fine and all of a sudden we start getting complaints that users can’t get into or use SuchAndSuch application which uses Sql Server. So it's not to the point where I have to use the dedicated administratrive connection...but it is simp ...Show All

• THE_BAT Where is the tutorial File: "Customers.xls"?

  In Lesson1 of SSIS Tutorial, section "Running the Wizard to Create the Basic Package", is stated "Specify the data source. You will use the Excel workbook, Customers.xls, as the data source..." I have both AdventureWorks databases installed on my box as well as a host of samples but I can't find that file. Any pointers much appreciated. TIA, barker H ...Show All

• SriDirectX SQL Mobile query hangs PPC 2003 device

  I've written a query to pull data from a SQL Mobile database which seems to completely hang the device when I run it (I waited several minutes before warm-starting). Yes, it's a bit complex, but it works fine on the desktop version--completes pretty much instantly. Are there any limits to SQL Mobile that might prevent me from writing such a query There are not very many records in any of the tables (all are <20, except one which is ~2500) ...Show All

• Mentz What is SQL Everywhere?

  Hi Just downloaded the SQL Everywhere CTP and installed it. I don't get it at this point It is supposed to be a desktop database right I realize it is based off of the SQL Mobile edition but are you going to have to use a different namespace System.Data.SQLServerCE to access SQL Everywhere. And will SQL Server Management Studio be able to access to at least create tables, etc. Please tell me that I can access SQL Everywhere through System.Dat ...Show All

• mr. robot cursor problem

  Actually My proble is DECLARE @SNO INT DECLARE CURS_FOR_SNO CURSOR FOR SELECT * FROM MACB where cntrl_no='DC000429' and isnull(listed,'')='U' AND ISNULL(SNO,'')='' ORDER BY SNO OPEN CURS_FOR_SNO FETCH NEXT FROM CURS_FOR_SNO WHILE @@FETCH_STATUS = 0 BEGIN SET @I=@I + 1 SET @SNO=@X + @I UPDATE MACB SET SNO=@SNO where CURRENT OF CURS_FOR_SNO FETCH NEXT FROM CURS_FOR_SNO END CLOSE CURS_FOR_SNO DEALLOCATE CURS_FOR_SNO it gives read ...Show All

• YJMark How connect SQL server 2000 with c#.net .....?

  Hello masters, help me yaar i am using dotnet 2003 and SqL SERVER 2000. BUT UNABLE TO CONNECT DATABASE using dataAdaptor(design time ) or sqlconnection any can help me gs Jens Suessmeyer wrote: Guess you don’t have the right connection string, look at www.connectionstrings.com for appropiate connection strings. HTH, jens Suessmeyer. the connection string is properly formed. whether that user/pw is correct and has per ...Show All

• Sugar SQL Authenfication

  Hi, i m trying to connect to msssql 2005 with SQL Authentication .but without success. "Server authentication is set to SQL Server and Windows Authentication mode". on connect i recive this error "Login failed for user ''. The user is not associated with a trusted SQL Server connection. [CLIENT:]" any help would be nice Luka I have not so many ideas left. Have you t ...Show All

• Druso ---sergio removing duplicated rows

  Hi, Need to remove the duplicated rows from a table which has text/ntext/image type columns. The table does not have any PK/Unique column. (I accept its a bad data model). But currently changing the data model is not possible. Hence doing changes in application. I couldn't do 'SELECT DISTINCT * from table', since the table has text columns. Though there is no PK constraint, If I know that col1 and col2 are join PKs in the table, Is that possib ...Show All

• technobia Setting up Sql Mobile subscription

  I am working on settin up a subscription to a publication that i made of the AW database. when running the subscription wizard i get an error on the sycronization of data part. the error states "A request to send data to the computer running IIS has failed HRESULT 0x80072EE7(28037)" i have the URL on the Web Server Authentication page of the wizard set to http://localhost . can anyone help me out on this one thanks ...Show All

• Joseph Creech Online Data Transform

  Dear All, I am new to SSIS, and just watched some of the webcasts and take a look at SSIS Hands on Lab on the MSDN site. I want to handle an online data transformation scenario which has some data mappings between. I want the SSIS to add each new record in source table, insert in the destination tables online. If this is possible, please let me know where can I find a sample package and configurations. Happy new year, Sassan ...Show All