Answer Questions

• *itguy* Build dynamic restore script by executing restore filelistonly

  Hi My requirement is as follows. I have a backup file (full backup of SQL Server 2005 database), say TestDatabase.bak I execute the following command to find the list of logical file names in my .bak file. restore filelistonly from disk = 'H:\SSSOL001\Backup\TestDatabase.bak' I would like to build a restore script from the results displayed from the above command , meaning have something like below :- In other words how can ...Show All

• _ross Database Sort Order / Collation

  I have an O2 Xda IIs Pocket PC running PPC 2003 SE, WWE (Worldwide English) edition. I want to create a database which contains all Chinese characters that have been mapped under the Unicode Standard. I already have a similar database on my desktop PC. On my desktop PC, I have used the collation Chinese_Hong_Kong_Stroke_90_CI_AS. However, on my Pocket PC, I do not see any Chinese or even Unicode sort orders. The best I get is "General". ...Show All

• Freakie Calculated Measure Aggregation Seems to differ from MSAS 2K5 and 2000

  I'm in the process of upgrading a cube in MSAS 2000 to MSAS 2005 (SP 1). In the existing MSAS 2000 cube, I have the following calculated measure defined: SUM(Descendants([Term].[Term].CurrentMember, [Term Name]), SUM ( PeriodsToDate ( [ActivityDate].[Std].[(All)] ,strToMember ( "[ActivityDate].[Std].&[" + Cstr([Term].[Term].CurrentMember.Properties("CensusDateValue")) +"]" ) ) , [Measures].[Activity Hours ...Show All

• Gamb INSERTs given me the BLUES

  cstring = cstring + "VALUES('%" + txtWatchID.Text + "%','%" + txtcenter + "%'" & _ cstring = "INSERT INTO tblNEW (watch_id, service_center_num, repair_envelope, store_number" cstring = cstring + "date_purchase, transaction_num, cust_fname, cust_lname, product_code" cstring = cstring + "value_watch, failure_date, service_date, failure_code, repair_code" cstring = cstr ...Show All

• 5letters Database Mirroring: Cannot set the Mirror Server instance as the partner on Principle server

  Hi,   I’m trying to get database mirroring working but having problem when principal and mirror are not on the Domain. (I got it working once if both principle and mirror servers are on the domain.) Both servers have fully qualified domain names. Both have Windows server 2003 SP1 and SQL Server 2005 June CTP.   I used Local System Acct/Mixed mode and follow the Setting up Database Mirroring using Certificates article i ...Show All

• PaulWong Questions about SQL Express

  What is the user limit for SQL Express Is there a free way to convert Access files and import them into SQL Express Is there any way to take databases offline without have to detach them Answer to question 1: There is no hard-coded limit to the number of users that can attach to SQL Server Express but their CPU and memory limits impose practical limits on the number of users that can achieve accep ...Show All

• azuomar [DBNETLIB] 2147467259(80004005) [Connection Write (Send()),] General Network Error

  HI all I am facing a problem on sql server 7 Desktop Engine with front end VB6 and ADO 2.8 my OS is windows 2000 Professional. ie. I am doing appendchunk to add image files on SQL Table it works fine for Approximately 130 MB, But i am trying to add 249 MB size file it will be showing these error Message. [DBNETLIB] 2147467259(80004005) [Connection write(send()),] General Network Error check your network documentation. I do s ...Show All

• Aggag Aggregate function is missing when scripting database objects (SQL2005)

  I installed the 'StringUtilities' assembly using the Microsoft clr integration sample. The functions work fine, however, when I script out all the objects in the database, the Aggregate function is not scripted and does not appear in any of the selection lists. The other functions (Scalar and Table-valued) scripted fine. I can right click on the Aggregate function and script it out by itself, I was just wondering why it doesn't appear when I scr ...Show All

• HCL Deploying .Net / SQL Server 2005 replication

  Hi, I am experiencing a problem with deployment of a VB .Net application which carries out merge replication, and would greatly appreciate any assistance. I am currently struggling to find stuff about my problem on the net, which probably means either (a) I'm missing something really simple or (b) I shouldn't be trying to do this in the first place. :) The story so far: 1. I added the SQLMergXLib.dll COM to my Visual Studio project, allowi ...Show All

• DLGrubb Cached Report and Windows Authentication

  I want to use cached reports with Reporting Services 2005. But when I edit the execution properties of a report, an error message answser that I can't use cache because it has a connexion to Analysis Services with Windows Authentication. I understand why I can't do that, but I still want to do so, because the reports take too much time to load. How can I do that Thanks. Query the ExecutionLog table in the report server catalog dat ...Show All

• Clemens Vasters - MSFT Problems with Stored Procedure Call

  I have developed an application that interfaces with SQL 2000 via stored procedure calls. The execution time of a particular stored procedure takes approximately 2 seconds on average, but we see spikes every so often up to 150 ~ 200 seconds. The timing of the spikes are erratic and do not correlate with any blocking or maintenance job runs. We have reviewed the stored procedure and optimized it to the nth degree and still no improvement. A ...Show All

• R_Bohning Insert with condition

  Hi, what i am trying to do is, reading from an array which has the column name and value and then insert that value to the column which is fetched from that array.And on the other hand i should use select to get the data's which have the same ID. more detail: what i have >> (VARID,columnName,Value) what i want>> insert to table (columnName) values (Value) while ID =VARID any idea how i should do that tnx ...Show All

• naijacoder How can I make reports and hide columns at run time with my aspnet app?

  Hello. I did a report that has many many columns. I should give the user the possibility to choose which columns to use with my asp.net program. Is that possible to do The only columns that must be shows are the ones that the user has choosed. Is that possible. ! !Please help me  with links, code, books anythin neccesary. You can parameterize the report and set the visibilty property on the column to be dependent on the parameter valu ...Show All

• Teodora Reporting Services - Changed com objects after installation

  Hello I have a serious problem on one of my Windows 2000 Terminal Server. I tried to install Reporting Services standard on this server. The installation failed because of problems verifying the login against the SQL Server. Then i cancelled the installation. After the installation there has beed problems with network services not starting on the server. It seems like there has been a change in some of the com objects on the server. ...Show All

• Mat M Skipping startup of clean database...

  Hello guys, Please, somebody could say me what it means these messages in my errorlog Skipping startup of clean database id 4 Skipping startup of clean database id 5 Skipping startup of clean database id 6 Skipping startup of clean database id 7 Skipping startup of clean database id 8 I looked for some article but not meeting nothing. thx Nilton ...Show All