Answer Questions

• LarryB GUID in Mobile SQL

  I have been trying to setup the GUID new GUID when I add a row into a Pocket PC WM 5.0 Mobile SQL (*.sdf) utilizing C# through Visual Studio 2005 - targetting Pocket PC Smart Device Any help would be most welcome... Thanks From what I understand your mail thread is that you are able to publish and also able to subscribe to it. Can you do quick check on the column properies of the subscribed table on the device using the followi ...Show All

• frieste Getting Started

  hey, I am 100% new to useing SQL server 2005 express/SQL server, and when I installed it I only had 3 options I could chose from in my start menue for this program: Server configuration manager, SQL server and error usage reporting, and SQL server serfuace area configuration. And what I want to do is make a database for a website I am making, with files that can be downloaded and user account info(passwords and usernames) but ...Show All

• Miguel Angelo Task to create and drop tables

  I have a package that i want to move between enviroments. Therefor i need to create a package that creates all my tables on the new server. like -- "if exists (select * from dbo.sysobjects where id = object_id(N'[table]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [table] GO" The case is that i have around 30 tables, and my question is therefore I know that you can create the drop and create script for one table ...Show All

• Bobby123 Can't Create New Database on Device via ActiveSync

  In VS2005 RTM using Server Explorer --> Right Click DATA CONNECTIONS --> Add Connection --> Datasource=Microsoft SQL Server Mobile Edition--> Data provider = .NET Framework Data Provider for SQL Server Mobile Edition--> ActiveSync  Connected Device when I hit Test Connection I hear ActiveSync's connect sound and I get this error Microsoft Development Environment Microsoft 5QL Server 2005 Mobile Edition and/or NET C ...Show All

• Patrick Baker -MSFT- Launching Reports on Browser with Custom Assembly

  Hi friends, We have developed the Reports using SQL Server Reporting Services 2005. In order to make our all reports dynamic we are refering DLL in all our reports. That DLL we have pasted in C:\Program Files \Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\bin C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PublicAssemblies So when we observer the reports from Preview tab then we can see the effect of ou ...Show All

• SARay Newbie Question

  I've just started messing around with SQL2K5 and Reporting Service. I loaded SQL Server Reporting Pack for IIS. I can't seam to find any detailed details on the pack. Is there an easy way to repoint the 12 reports from the template db to my live IIS ODBC db Or is it better to just start from scratch and build the reports Thanx I'm not quite sure what you mean here Are you saying you have 12 reports po ...Show All

• jennitro Using Reporting Services 2005 on SQL Server 2000?

  Is it possible to use Reporting Services 2005 on licenced SQL Server 2000 without a licence of SQL Server 2005 Thanks for your answer, Andreas The answer is yes, you can install a valid SQL 2005 license on a SQL 2000 box (and use the 2000 instance as the database). They are seperate licenses. Here's an article that might be helpful on side-by-side deployment: Roman's Weekly SQL Server Tip - How to run Re ...Show All

• matilda16 Partition Processing component with Data Only feature

  Hello Can anyone please tell me how can I use the Partition Processing component of SSIS 2005 for processing a partition for updates When i tried this it refresh the partition with new [updated] data only and i am loosing the unchanged data. To explain this further; let say a partition contains 100000 records and out of this 100 get updated. In SSIS 2005 i have separated these 100 records and tried to use “Partition Processing" comp ...Show All

• Brian Cordell Execute SQL Task Error

  I have a stored procedure that accepts an integer as input and sends a value out as type varchar(600). When I use Execute SQL task with ADO.Net or ADO Connection Manager and assign proper values for the parameters and their direction, the execution of the task returns ONLY 1 character (first character)for the output parameter. Sounds like a bug since I can't set the string length anywhere in the data type. Any help/work arounds would be greatl ...Show All

• Adcoe How can I migrate all objects alogwith all constraints,SP,Triggers etc from Development instance to Production instance

  Hi fellows, I have to migrate all objects alogwith all constraints,SP,Triggers, indexes etc from Development instance to Production instance of a DB, all those things are created through wizard ie. Sql server 2000 Enterprise Manager. if i use DTS it only mirates data along with tables and views but constraints,SP,Triggers, indexes etc not yet copied. can any body help me how can I solve this problem by copying all objects alogwith all cons ...Show All

• bigbluesky Oracle Connection String Stored in SQL Server Configuration Not Working

  I'm trying to store connection information in a SQL Server SSIS Configuration.  I can see the information in the SSISConfigurations table and it appears to be reading the data as the package loads in the designer, but I'm getting connection failure messages (The AcquireConnection method call to the connection manager "APPLPROD" failed with error code 0xC0202009. MTL_SYSTEM_ITEMS.dtsx 0 0).  Do I have to do any ...Show All

• DaveyC11111 Windows XP Home Edition

  According to the feature matrix for the various SQL Server 2005 editions, basic Reporting Services are available from the Express edition. However, trying to access the Report Manager proves fruitless on Windows XP Home Edition, I suspect because IIS is not available on this edition of the operating system. Can someone confirm this is the case, and if so, is there is an alternative way of accessing this feature, say for example through a configu ...Show All

• CharlieDigital ETL using SSIS

  Hi guys, I have been able to put together a simple SSIS package and familiarize with how it works. Now as I am trying to put together this ETL job I am stuck and am looking for some recos: I need the source system to be able to do a join on my Datawarehouse table and push thru only those rows which I am interested in. Can this be done using one of the Data flow task Presently we do it by using staging area, creating temp tables, doin ...Show All

• FredK5813 Communications to the remote server instance failed before database mirroring was fully started

  command in principal server ALTER DATABASE database name SET PARTNER = 'TCP://<mirror_server_name>:5022' return: Msg 1413, Level 16, State 1, Line 1 Communications to the remote server instance 'TCP://<mirror_server_neme>:5022' failed before database mirroring was fully started. The ALTER DATABASE command failed. Retry the command when the remote database is started. This problem is only in production dat ...Show All

• HillCalif Cannot select "Server Database Engine" when installing SQL Server Sep 2005 CTP

  I am trying to install SQL Server Sep 2005 CTP - ENTERPRISE, there are  check boxes on the Components to Install page of the Microsoft SQL Server Installation Wizard to select component groups for your SQL Server installation, they are all disabled , except " Workstation Components, Development Tools, and SQL Server Books Online". I tried installing and after it finishes, there are no SQL instances.... What am I doing wrong Please he ...Show All