Answer Questions

• ncjks FlatFile connection and security

  My DTS package, deployed and run from the file system, works just fine for me, but fails when someone else runs it. The only explicit error from the dtexec command is: Error: 2005-06-24 12:35:03.33    Code: 0xC0016016    Source:     Description: Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this informa ...Show All

• Pieter M sp_dropsubscription, article

  Hi There I needed to change a column definition for a published table. I did the following. sp_dropsubscription for publication specifying the one article. sp_droparticle for the specific publication/artcile BOL is not very clear here, i presume this drops the subscription ONLY for the 1 article , correct Secondly i then altered the table accordingly then ran sp_addarticle for the publication/article then sp_addsubscription for the newly define ...Show All

• Tim Pedersen Deployed files reduced size

  I am wondering why deployed packages are so much smaller than built packages. What is removed and why isn't it removed when the packages are built I have a package that goes from 3Mb to 1.5Mb We don't remove anything from package during deployment. The things that may affect package size: 1) XML encoding. UTF-16 (usually called just "Unicode") may take twice as much as UTF-8. I think we use UTF-8 in most places, but not sure. 2) Encryp ...Show All

• dlevine SQL express on pc / svr questions

  I have a few questions about SQL express. Will SQL express make my workstation (regular PC on network) act as a server Or does it just allow VB express / Web Developer Express to write code that will work on an actual My SQL server The goal is to make a simple DB that will then be used on a website on a live server which has My SQL on it. I don't need SQL express on that server also do I MY knowledge about SQL is next to null. Thanks ...Show All

• crescens2k Smart App to Endpoint Kerberos Authentication

  We have a smart app client application that leverages SQL Server Endpoints for data access. Clients use this application from several cities in the US across a corporate WAN. The endpoint is secured using kerberos authentication. Users of the application are added to a domain group which is granted rights to the endpoint. Procedures in the database are granted to a SQL role, and the domain group has been added to the database as a login and adde ...Show All

• C# nb rollback of transactions to a point in time

  Is it possible to replicate a database back to a point in time using the current data and transaction log files. for example we have the data files and transaction logs as of today and we want to replicate the database and roll it back to where it was yesterday at 10:00 PM. Is there any way to do this ...Show All

• cgraus SMO

  hi everybody, I want to add the Microsoft.Server.smo.dll to my VS 2003 .net project. However, when I try   to do just that, I get an exception (A reference to Microsoft.SqlServer.Smo.dll could not be added.  this is not a valid assembly or COM component etc). Any idea Ozbourn SMO requires the .NET 2.0 framework.  VS 2003 uses the version 1.1 .NET framework, so the project references in VS 2003 refer to the ...Show All

• Fabricio11 SQL Server Express Security?

  We are releasing an application built on SQL Server Express in the next few months.  Our clients are mostly small companies with little technical knowledge, and they will be using our application on desktop computers where everyone likely logs in as the same user.  As such, my thinking is that we setup SQL Server Express as in SQL Server Authentication mode.  This way they could select an Administrator password upon first installa ...Show All

• pvphuc Selecting only databases in which user has a role

  I have a user in SQL Server 2000 with public, datareader and datawriter roles on several databases. I need to select all those databases, how can I do that. I have tried sp_databases but I get ALL databases. I also tried sp_MShasdbaccess but I still get all databases. Well, it looks like you're on the right track with sp_MShasdbaccess, but there's a catch. If 'you' want to know which db's that 'someonelse' ...Show All

• nittany92 Issue with URL Encoding report's hyperlink value.

  Hello, I've created a hyperlink in a report.  The hyperlink action is 'Jump to URL'   The URL is http://ServerName/SomePage.aspx AccountCode=####&InvoiceLevel=1 The hyperlink works just fine in the designer, it's value becomes http://ServerName/SomePage.aspx AccountCode=%23%%23%%23%%23&InvoiceLevel=1 , however when I run from the web the report's URL is not properly URL encoded.  It's value is http://Server ...Show All

• GeorgesZ Number of printed pages vs number of pages shown in browser

  Help! ! I'm going grazy! I have several reports. In the browser the report browser says there are 10 pages. But when I hit print there are 16. What can I do to get te number of pages in the browser the same as there are actually printed (A4). I've tryied to resize my report etc.. Nothing changed.. Anyone Grtz, Jorryt de Vries The Hague I guess that is the weird thing about HTML reporting, for me this i ...Show All

• cc3078 Auto Create trigger after re-initialization completed

  Hi all, Is it possible to create a trigger after creation of table during reinitialization   if so, how can I do that   Thanks in advance! The table is re-created after re-initialize but the trigger didn't be created.  I found that the agent job is keeping 'running'... Just want to confirm that the distribution job with the 1step 'Distribution agent startup message' , right Thanks in advance     ...Show All

• Jason92 How can I move the system databases?

  I have been attempting to detach and reattach the model database.  I tried to set the Trace Flag 3608, but it is having no effect. Just to be sure I am setting the flag correctly, here is the startup parameters string in my Configuration Manager: -dD:\MSSQL.1\MSSQL\DATA\master.mdf;-eD:\MSSQL.1\MSSQL\LOG\ERRORLOG;-lD:\MSSQL.1\MSSQL\DATA\mastlog.ldf;-T3608 Has the process of moving system databases changed in 2005 ...Show All

• marla Report Project and Report Designer

  When we want to create reports for report server, we create a report project in Visual Studio.  However, is it possible to add a report project as a sub-project or a nested project in a Visual Studio solution   Does it matter Thanks! These are the options: * VS 2005 by itself contains a report designer that allows you to design RDLC files (i.e. reports used by the report controls in "local" mode without report server ...Show All

• Crunchie XmlSerialization with CLR

  Hi,   I have created the CLR Trigger Project. In that Project i'm refering one external.dll which is also deployed in the same database. This external.dl uses one method to serialize the data and send it  to the server through socket.(The connection for the socket is already established). For this to work i know i need to turn on the Generate serialization assembly from the Build of Project Properties. After i ...Show All