Answer Questions

• berlin_zhou SQL Server 2005 Replication and views

  Hi, I read that views can't be published with SQL Server 2005 replication. Is this planned for the future If not what alternatives are there for this Simple collecting the data needed in a new table ain't a solution for us (memory consuming). And joining the data on the PPC ain't a good solution either (memory and time consuming). We only want to pull the data. Greets, Ivo Klerkx Is there no solut ...Show All

• Wybren Koelmans Restore a database

    Hello Please, help me I need to know, how to restore the database (base.bak) on MS SQL Server 2005 Ex. Ed. from my WinForm Application I programming on C#. Please, if you can, give me a code on C#. Thanks     Try the following info found at http://www.csharphelp.com/archives2/archive345.html SQL Server Backup/Restore Through SQLDMO and C# ...Show All

• Bob_Dineen Using SQL Server 2005 as a front end to a SQL Server 2000 database

  I really like the tools in SQL Server 2005. Especially the upgrade for Enterprise Manager/Query Analyzer, the SQL Server Management Studio. Is it possible to use the Management Studio against a SQL Server 2000 database without damaging it The database is still run on a SQL Server 2000 instance with SQL Server 2000 clients. E.g. could I run simple sql-statements like queries and updates against a SQL Server 2000 database with the 2005 SQL S ...Show All

• pavvu_kk sql server management studio nov ctp

  I have vs2005 prof. installed along with sql express RTM I installed management studio nov ctp when I try to launch it, nothing happens any Ideas Thanks I have the same problem. When I launch it from start menu nothing happens! I installed SQL Server 2005 Express and Management Studio Express (CTP November). When I try to launch the management studio nothing happens....I'm very confused about it, because I tried to search a solution ...Show All

• amar_soul creating a database, tables, records, and fields in a Sql server 2005 express

  I am at my wits end as to how to do this. I have downloaded Sql server management Studio and tried to create a database but I can't figure it out. There is an almost nonexistant help file so I am lost as to how to start. I have succeeded in looking at some system databases but that is about the extent of it. Can someone show me the proper procedure Am I using the wrong tool Thanks, Paul p3aul, your statem ...Show All

• Naveen Yajaman - MSFT Pkg Execution Works in VS but not in SQL

  I'm able to execute a package in VS Pro on my machine. However when I upload it to the sql server and try to execute the package directly it fails with: Error: The product level is insuficient for component "...." (3129) Error: The product level is insuficient for component "...." (5411) The first component is a DataReader Source which is consuming an ODBC (Noble Systems ATOMIX Driver) connection and the second componen ...Show All

• David Stout Can it be a bug in SQL CE?

  Hi! I use SQL CE with VS.NET 2003. I find the following bug second time. The table has an " ID int IDENTITY(0,1) PRIMARY KEY,". That is my row identity. I add rows to the table, then I made some select and update queries. Then I realized that the ID order not in the general order (from 0 to ........) For example: 6,7,8,0,1,2,3,4,5. Of course row 6,7 and 8 was added the very last. The content of each row is not mixed, ...Show All

• sdjennad Image Property from Business object in Reporting Service 2005

  Hi I have a question from Reporting service 2005 I use Business Objects in My Report and one of My object's property's type is "Image" or "BitMap" when i Drop that property in my report and set value in "Fields!MyPicture.Value" and Run that then i see "#Error" when i drop an "Image" from Toolbar and set that in "Database" and set value in "Fields!MyPicture.Value" and ...Show All

• DJT_UK SQL2005 equivalent of the data import task in SQL2000

  I had to upgrade to SQL2005 when my customer did so. Everything went OK until I had to load additional data to the datamart. The SQL2000 task to load data from flat text files was straight forward and literally took me seconds tyo set up and execute and has never given me problems. I have now spent 3 days straight trying to do the same in SQL2005 going in ever wider circles. I have got SSIS up and going, I saved a dtsx package that won't run wit ...Show All

• Ridge Progress

  I have some SP's I run once a month and each SP takes a few mins to run and when I batch em together in one shot, I hate sitting there waiting for them to finish whats the easiest way to report back the status of the exec Ex: Set NoCount ON EXEC StatesUpdateZipTableUpdate 'AE' EXEC StatesUpdateZipTableUpdate 'AK' EXEC StatesUpdateZipTableUpdate 'AL' EXEC StatesUpdateZipTableUpdate 'AP' EXEC StatesUpdateZipTableUpdate 'AR' EXEC StatesUpdateZipTa ...Show All

• testie DB Mirroring Monitor and querying the "other" db?

  So I successfully got the mirroring to run and now I'd like to see what's going on between the two servers ( i'm not using a witness). I launch the Database Mirroring Monitor and its showing the two servers but when I go to the history column I'm not seeing any data movement. I've done a an update on a db with 1500 rows so I was expecting to see this show up. Also, is there anyway to query the database thats acting as the mirrored db ...Show All

• g2506 Complex SQL Query

  Well, at least I think it's complex! It might be easy for you! I have the following 3 tables: ContentPages (Primary Key is PageID) stores information about pages, such as where the file is on the server, who created the page etc. ContentProtocols (PK is ProtocolID) stores the names of "protocols". In my content management system, a protocol is made up of a sequence of pages. So " Ben's Protocol " could be a seque ...Show All

• Tim Stall how to solve Syntax error or access violation?

  Hi, any one can help me to solve this problem i run sql statement in RS to get the dataset i want. but it show me this error. below is the sql statement that having error (1). --------------------------------------- SELECT MAX(Weekday) AS Mweekday, MAX(AveScore) AS MScore FROM (SELECT DATENAME(dw, dtAnswer) AS WeekDay, AVG(bScore) AS AveScore FROM Answer WHERE (iMinutes BETWEEN 570 AND 1020) AND ( ...Show All

• MOK123 Upper Limit for a SQLProvider query in ADF?

  Is there an upper limit to a Query for a SQLProvider in the Application definition file In terms of lines/characters. Regards Ahh...Yes, I misunderstood. I was referring to the Action element for the rules. The EventQuery argument should be limited to 4000 characters. This can be determined by looking at the ApplicationDefinitionFileSchema.xsd in the XML Schemas folder of the install folder. HTH... -- Joe Webb SQL Server MVP ht ...Show All

• DPVic FailParentOnFailure not working?

  I have a script task inside a sequence container with the FailParentOnFailure = 'false' and the FailPackageOnFailure = 'false'.  However, when I deliberately fail the task ("Dts.TaskResult = Dts.Results.Failure") the sequence container and the package still report failure.  Any thoughts Thanks Change MaxErrorCount to something higher. An error doesn't equate to failure. Establishing if a t ...Show All