Answer Questions

• Einat Schema changes and Merge replication

  Hi there, I wonder if I can ask for some advise I wish to use SQL 2005 and merge replication but I have a few concerns over the schema changes that I am allowed to do on the publisher. Ideally I want sql replication to push all my schema changes from the publisher to the subscribers but I don't know if it can. or even if it is recommended. I see the BOL suggesting that schema repl. was mainly intended for ALTER type of statemenets, but ...Show All

• Jane Wang instawdb.sql runtime errors

  I just downloaded adventureWorks database related files and ran script in instawdb.sql. It seems the database and tables have been created but some errors have taken place as well. I am working with Sept 2005 CTP SQL Server. *** Creating Data Types -- FINE *** Creating Pre-Table Database Functions -- FINE *** Creating Database Schemas -- FINE *** Create AdditionalContactInfo schema -- FINE ........ *** Creating Tables -- FINE *** Loading Dat ...Show All

• Alan_98 Upgrade Advisor and retrieving info on a cluster

  I have the Upgrade Advisor on Server2003 w/sp1 where I have sqlserver2005 installed. I'm trying to check DB's on a Sqlserver2000 cluster. I figured out that you have to use what I guess is the formal cluster name since when i click "detect", the "components" boxes click on. The problem starts when i next to the Connection Parameters. Doesn't matter what I use - windows authenication or sqlserver - i get Error 40. I test ...Show All

• Pedro Bernardo SSAS + Time Dimension and Hours

  Hi All, I'm very new to the whole Analysis Services scene and I'm stuck. I need to create a time table with the following attributes: TimeKey, Hour, Day, Month, Quarter, Year Trouble is, I can create a dimension, but without the Hour part... I've read through the tutorials and online help, but I cant find anything to help me. I've found a couple of articles that suggest having a Day and TimeOfDay dimension, but not how to create them. ...Show All

• tjtooj Newbie question, moving data between sql server 2000 and 2005

  Hi, I'm a newbie on SSIS and am trying to grasp my way through this. I am trying to copy data from a Sql Server 2000 database to a simplified table in Sql Server 2005 database. What I want is to move the data to a staging table, then drop the main table and rename the staging table to the main table, to minimize the down-time of the data. I can't get the workflow to work, because the staging table has to exist when I run the packa ...Show All

• Bharathi Timeout error while copying database (Sql Server 2005)

  I was trying to copy a database of about 200MB in size from source server to destination server, with a log file of around 5GB. I received a error message after I started executing with the Copy Database Wizard in SQL Server Management Studio. Part of the error message from log file is posted below. OnInformation,DestinationServer,DestinationServer\Administrator,SourceServer_DestinationServer_Transfer Objects Task,{AFFDEF09-37B1-472C-B ...Show All

• DOlmsted Replication Help...

  Hello I have a problem... I always work with merge replication and now i must tu make an estrange replication... so I need help... suppose the next situation I have 2 sql servers (A, B). In witch I have multiple tables but I will concentrate in table 1 and 2. I need that all data from server A pass to Server B, but if in table 2 are different data leave it alone, I make it but the replication overwrites the data... and I must to ...Show All

• ramprasad62406 MCTS Exam 70-431 Database Administration Study Documementation and Samples ?

  Hi, I am looking for good documentation and examples to use to 'study' for Microsoft exam 70-431. This has everything to do with nuts-and-bolts Database Administration of SQL Server 2005. The December BOL examples, do not cover enough topics. The topics that are covered are not in enough detail. The 70-431 exam requirements are very detailed. This seems to be a nuts-and-bolts test. I am looking for nuts-and-bolts study material. No b ...Show All

• DLDeveloper sseutil usage

  Cool tool. How the heck do you use it I can do a sseutil -l from command line to see my databases. Then I do a sseutil -consolewnd to get a window up that allows me to put in SQL commands. But how do I point the thing at a particular database Hi Jim, Once you're in the console window you can run any T-SQL command just as you would when using SQLCmd. For your specific question about how to point it to a specific database, you would t ...Show All

• nick0033 No mapping between account names and security IDs was done.

  No mapping between account names and security IDs was done. I received the following when trying to deploy an 2005 analysis services package over an existing database: The following system error occurred: No mapping between account names and security IDs was done. We have redeployed this solution several times over the last week and have never encountered this ...Show All

• jnickfl1 Print hardcopy of table structure

  I've just started working with SQL Server Express, and would like to print out a report listing the properties (Ie. field names, data ttypes, length, field description, etc.) of each of the tables in my database. How do I do this Thanks very much for your help! The best way would be to use the INFORMATION_SCHEMA views and in this case the one that presents the column ...Show All

• pdimarco Scrpting to genrate surrogate keys

  This is the code iam using to get the incremental surrogate keys: Imports System Imports System.Data Imports System.Math Imports Microsoft.SqlServer.Dts.Pipeline.Wrapper Imports Microsoft.SqlServer.Dts.Runtime.Wrapper Public Class ScriptMain Inherits UserComponent 'Declare a variable scoped to class ScriptMain Dim counter As Integer Public Sub New() 'This method gets called only once per execution 'Initialise the variable counter ...Show All

• Ritchie Hughes SSIS SCD Type I, Dim table Compound Key selection for Business Key

  Hai, I have been working in DW for a while, but using SSIS as an ETL tool is new for me. I worked extensively on Informatica. Coming to my question, right now I am trying to do SCD type 1. But my dimension table has a compound key. i.e more than 1 column makes a key for the table. But SCD wizard allows to select only 1 attribute as a business key. Does any one have any suggestions on how to implement SCD if the target table has compound ke ...Show All

• zoomkat how large is 4 GB

  Hi, All. New to SQL. Just downloaded SQL server Express 2005, Web doc says its max limit is 4GB, Need to know how large a 4GB can hold. The data shall be like holding company info, say: company names, locations, line of business, phone, etc. It needs full-text search on it. Is this Express is the choice to go Really BTW 4GB is 4 gigabyte, which equal to 4 billion characters, if character set is ...Show All

• Jason_OPIS Problem with simple subquery in SQL2005 AND SQL2000.

  When I use the simple query with a subquery shown below, this is the error message I get in SQL 2000 AND SQL 2005 "Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression." And here is the query I use: SELECT docSections . SectionID , ( SELECT docSectionText . colText FROM docSectionText WHERE ( docSections ...Show All