Answer Questions

• Falken null + nvarchar = null?

  I am trying to concatenate nvarchar fields and I have a problem. Lets say I have a table called People with nvarchar fields FirstName and LastName. Lets say that there is only one row in the table and FirstName is set to null and LastName is set to "Smith". When I run this query FullName will be null: select (FirstName + LastName) as FullName from People But I want FullName to be "Smith". Also if LastName is null and FirstName is "Bob", then Ful ...Show All

• asamper Usage-based optimization in AS 2005

    Hi,   It is easy to use usage-based optimization in AS 2000.   There is alyways a error message when I use usage-based optimization wizard in AS 2005.   The error message as following:  Invalid object name 'OlapQueryLog' .   It seems like somewhere must to be set.   Anyone could tell me where the problem is thanks, Well, maybe users didn't actually ...Show All

• DanMeyers Encrypted DB -- Restore Question

  Hi, I have a DB in which I encrypt a few columns in a table.  I am using a Symmetric key to encrypt and decrypt the data.  When I take a back up of this DB and restore on another server ... my decryption doesn't work.  I have dropped the master key and recreated it with same password and that didn't help either. What are the rules to follow when we restore a db on a different server that has encrypted data   Thanks. ...Show All

• SergeiU SQL Express Eventlogs?

  Hi. Is it possible to prevent SQL Express for logging in the EventLog It fills my Eventlog very fast with messages like: Starting up database 'PosDB'. etc... Other application crash becuase the eventlog got filled. I know I can change eventlog settings but the problem is that our customer don't wonna do this and if the SQl Express stop logging all the time the log will get mush smaller :-) So is there any settings I can do in the dabases ...Show All

• bgreen Could anyone attach the AdventureWorksDW to their SQL Server database engine?

  Hi, all here, I got a problem when trying to attach the AdventureWorksDW sample database to the SQL Server database engine. Error occured as: could not find row in sysindexes for database ID 21, object ID 1, index ID 1, Run DBCC CHECKTABLE on sysindexes . The sample database was downloaded from http://www.microsoft.com/downloads/details.aspx FamilyID=e719ecf7-9f46-4312-af89-6ad8702e4e6e&DisplayLang=en . So could anyone help me to so ...Show All

• BKrishnakumar Sql Server 2005 not starting

  Hi,       I have my web application with backend  as Sql Server 2005 CTP(Yukon). Initially It works well. I updated some security settings to the OS Windows Server 2003 and restarted the machine. Now the Sql Server is not starting.When I manually started  It logs error as follows. 2005-10-13 03:39:57.85 Server      UpdateUptimeRegKey: Operating system error 5(Access is de ...Show All

• DB2Question Proactive caching - Polling interval

  Hi, If a cube partition is set to custom settings in Proactive caching, and setting only rebuild interval of 1 day in General tab and in the Notifications tab if scheduled polling with incremental updates and 1 day interval is given, what does that mean Does the polling setting bring only data into molap or does it do cube processing also If there is a polling interval of 15 mins with incremental updates and rebuild interval of 1 d ...Show All

• atulverma82 SMO & DMO FAQ

  I have posted common questions on my blog. Take a look at the FAQ before posting questions in this forum. I will continue to add on answers for common questions as I go. I hope this helps finding answers faster! http://blogs.msdn.com/mwories/articles/smoindex.aspx Comments, let me know! Thanks, Michiel the link is broken . . . Which link THe link with the components works for me. Jens K. Suessmeyer - ...Show All

• The_Nerd Bug in the OLE DB command?

  This command has no error: update art_anz set anz = anz where artnr = 'xxxxxxx' declare @artnr as varchar(10) set @artnr =   But this command has an error: --update art_anz set anz = anz where artnr = 'xxxxxxx' declare @artnr as varchar(10) set @artnr =   The difference is the first line. When you use parameters ( )  in the OLE DB-Command, the very first line has to be a Non-Select SQL-Statement. The S ...Show All

• TassosTS Passing Parameters to the ReportView

  Here is the problem. I have a report that accepts multiple parameters. Two of them are "hidden" from the user. I don't want them prompted for these values. I set up the parameters so that it says Hidden but I get the following message. The report parameter 'CustomerID' is read-only and cannot be modified. (rsReadOnlyReportParameter) Here is the source in my ASPX page: ReportParameter [] parameters = new ReportParamet ...Show All

• S Nehra Determining the number of Active users logged into a SQL Server Database

  How does one Determine the number of Active users logged into a SQL Server Database I want to use the info to control concurrent licensing for my Application Yes the data is real time, the server connection will disapear once the connection times out or the connection has been removed from the connection pool. Thanks, I will. I believe this is exactly what I am looking for. Is it safe to assume that t ...Show All

• sshetty Fixed Width Flat File Destination

  Currently we're working on an SSIS package to extract data from a SQL Server database to several fixed width flat files. Some of the data needs to be formatted/converted in a certain way DateTimes need to be formatted in ISO8601 Booleans need to be 0/1 instead of False/True ... Has anybody any idea what the preferred approach (best practice) would be to do these conversions Convert everything in the select query What about readability ...Show All

• Andrewxxxy After Install of 2005 still 2000 Engine!

  I have installed the new SQL Server 2005, but I see my local database as version 8.9.193, means SQL Server 2000. I do not know why setup did not upgrade it. What do I need to do now  I think some new options are now working because of that... Thanks. I have executed the SQL: Microsoft SQL Server  2000 - 8.00.194 (Intel X86)   Aug  6 2000 00:57:48   Copyright (c) 1988-2000 Microsoft Corporation&nb ...Show All

• MSDN Dev genral network error on .net framework 1.1 using system.data.sqlclient in asp .net

  hi i am using asp .net 1.1 i have deployed my application on server where sql server 2005 exists but if i try to connect to sql server from my development machine then it is not connecting and gives me error when conn.open() in my sql server it is windows authentication. the error is general network error check network docs. i have tried timeout=0 and pooling=false but neither works please answer. what should my connection s ...Show All

• J Smith error on server

  TITLE: Microsoft Report Designer ------------------------------ A connection could not be made to the report server http://localhost/ReportServer2005 . ------------------------------ ADDITIONAL INFORMATION: Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'. The request failed with the error message: -- <html> <head> <title> SQL Server Reporting Services </title><meta ...Show All