Answer Questions

• Colmeister how to search a database by paramaters

  Hi, Does anyone know how i go about writing a search query using paramaters, ive been using this as my template: Select Distinct Recipedata . Name , Ingredients . Ingredient , Directions . Directions from Recipedata , Ingredients , Directions Where Ingredients . Ingredient Like '%Chicken%' and RecipeData . RecipeID = Ingredients . RecipeID and Ingredients . RecipeID = Directions . RecipeID ; Problem is now that i want ...Show All

• Vishal Kalra Installing Quickstart DB-Samples

  Hello I just installed configsamples.exe with SQL Server 2005 Express Edition. Then I installed the Quickstart Databases "Northwind", "Grocer" and "Pubs". After that I tried to grant access to the ASPNET-useraccount with command (command copied and pasted from HTML-File "Configurationdetails for MS .NET Framework SDK-Quickstart (in german)): sqlcmd -E -S (local)\SQLExpress -Q "sp_grantlogin ...Show All

• Mbansal Configuration for Configuration Package? Is this Possible?

  Hi Guys, Here's the current scenario: I am creating a windows application to manage my ssis packages. My SSIS packages use package configurations, and by default connect to the "SSIS Configurations" table in sql server. However, I want it to connect to a view instead of this table, so i create a view "vwSSIS_Configurations" and point the package configuration to use the view in sql server. T ...Show All

• Karl Diethrick Package running other packages

  Hi everybody, I have to create a package that executes other packages I've already created... Every one of these packages run with the same Configuration File, but if I try to execute the main one, including the path of the file, I get errors from the other packages because they can't find it... How can I manage to pass this file and its content to the other packages Here a little explanation of te process: Main Package needs confi ...Show All

• Ruben S Salazar Problems with LOOKUP component (repost)

  Hello, Can anyone address these: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=142849&SiteID=1 http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=142837&SiteID=1 -Jamie Larry, Good point though even if parameterised queries could do the job I would still want to be able to use an expression. I seldom, if ever, use parameterised queries because expressions do the same job much much better. -Jamie I can't think o ...Show All

• celerno Evaluating String Content

  Our Business partners request me to read the field names from a SQL table dynamically so that my SSIS package will not get impacted if Web Service hosts make a change. Is there a way to evaluate a string at runtime that contains a field name Thanks, Gulden  Thank you for your reply. My problem is not storing them. Here is an example: UserName = 'John' --- in the databa ...Show All

• sureshsundar007 How can i secure my MDF file?

  If a user is a local admin of the box they can gain full access to the database via integrated security. They can create their own database and attach .MDF How can i secure the .MDF so that no one can gain access to it Wow This is a real let down. From an engineers perspective I can see that the only true way to expect encryption of data and structure is runtime implmentation of some integrated on the fly encryption. Seeing ...Show All

• Daniel Penalba Conditional execution of first task

  I have a situation where I'd like to conditionally execute the first task in a package based on the contents of a user variable. If user variable "Var1" is false I want to begin execution with the first task. If "Var1" is true I want to begin execution at the second task. My first thought of course was SequenceContainer, but the same issue would exist for the first task in a SequenceContainer. Is there a way to d ...Show All

• He Hua XMLDP documentation?

  Does anyone know where there is documentation on XMLDP and the query syntax necessary to process XML data sources in reports Check the following link: http://msdn2.microsoft.com/en-us/library/ms345251.aspx Additional documentation is in the works, but not yet available on MSDN. -- Robert Have a look here: http://msdn2.microsoft.com/en-us/library/ms345251(SQL.90).aspx Thanks, that URL got ...Show All

• marko2511 SQLSERVER 2005 Sept CTP BACKUP AND RESTORE Transactions

  Problems with Backup and Restore using WIN XP service pack 2, and the September CTP Standard Edition of SQL SERVER 2005. I have a empty database which is using the  full recovery model. To start with I run the following : backup database dbTO DISK ='E:\current\dbase.db' WITH INIT backup log db to DISK = 'E:\current\dbase.ldf' WITH INIT I then makes changes to my database, few inserts etc. Then backup the transaction log again using: b ...Show All

• IgorB Service Broker: Cross DB, Same Instance

  I'd like to set up a Service Broker queue in one database (dbRespond) on a server so that events in another database (dbEvent) on the same server instance can post messages to the queue. The problem I'm having is that: The BEGIN DIALOG CONVERSATION needs to reference a Contract that is in the current database, and I want to call BEGIN DIALOG CONVERSATION from dbEvent The target service is in dbRespond. Based on the "Hello World&quo ...Show All

• narayank MySQL function equivalent

  Hi, In MySQL, from_unixtime(lonvalue) returns the date format in 'YYYY-MM-DD HH:MM:SS'. Is there any equivalent available in SQL Server, to view the date in man readable format, when the input is an long value in milliseconds. Eg : SELECT FROM_UNIXTIME(875996580); Thanks, Smitha Take a look at the CONVERT function in Books Online. It has different styles that you can use. Optionally you can format the string using various datepart ...Show All

• BjornL How can i secure my MDF file?

  If a user is a local admin of the box they can gain full access to the database via integrated security. They can create their own database and attach .MDF How can i secure the .MDF so that no one can gain access to it The problem with this solution is that it's manual, if you try to automate it you will then have the problem of protecting the password you set for this account. See my reply to your original post: http://forums.microsoft. ...Show All

• ConfettiNet Null Problem

  Hi, i have this problem (I'm using analisys services 2000) i have a fact table Services with two dimensions Clasifications, and Prices. The fact table has three dimensions IdServices, IdClasifications and IdPrices, idclasifications and idprices are fk to the tables of Clasifications and Prices. I wan to count the services so i have measure on the field IdServices wiht count. The problem is that it doesn't count all the services, all the ...Show All

• Fredrik G SQL express ?

  I've been trying to figure out how to Auto Number my database entries in SQL Express and Automate certain parts of data entry for form entries in Visual Web Developer's SQL Express 2005 edition.  Could someone clue me in   Thanks in advance. DJ  I've tried a few different ways, my most recent attempt: INSERT INTO items VALUES ('','" + this.item.Text + "','" + this.item_ ...Show All