Answer Questions

• Eric Liprandi sp_helptext in select statement

  Hi, I need to get one trigger script and save it into a table or files....anyway this works well exec sp_helptext 'triggername' But, how can I save this rows into a table because I cannot execute this Insert into mytables select sp_helptext 'triggername' Can I work around this cheers, You can do: Insert myTable exec sp_helptext 'triggername' Assuming that myTable is defined properly. If your goal is to get the trigger definition for saving, you can reverse engineer in query analyzer or the management tool, depending on your version. If you are putting the values into a table, for some reason, you need to be aware that sp_helptext returns a number of rows and only a single column. If yo ...Show All

• P.H. Alternate color on groups.

  How would you alternate the color in a grid based on a grouping. IE. (the 1000 Users should have background color of White and 2000 background would be WhiteSmoke) ColumnUser ColumnNote 1000 Note1 1000 Note2 2000 Note1 2000 Note2 nice...thanks! Try using the following expression for the BackgroundColor property. =iif(RunningValue(Fields!ColumnUser.Value,CountDistinct,Nothing) Mod 2, "White", "WhiteSmoke") ...Show All

• Pramod S Kumar Can we allow NULL value to nested key?

  Hi, all here, I am having a problem with NULL value for the nested key of the nested table. Is it possible to allow '' null' ' value to nested key If so, how can we deal with that As the column I am using for nested key contains null values, thus the process failed. Could please any expert here give me any advices for that Really need help for that. With best regards, Yours sincerely, Hi, Bogdan, thank you very much for your guidance. With best regards, Yours sincerely, You cannot have a NULL value as nested key. The simple way to work around is to replace your nested table, in the data source view, with a named query which filters out the NULL columns. I think replacing the table with a query is an op ...Show All

• dzimmy Copy a database with copy the .mdf file and attaching it with a new name?

  Hello, if i have a given database (a model) and i want to copy this database in the same database instance. Is it ok to copy the mdf and ldf file and attach the files with a new database name in the same instance. Or is the datebase name part of the .mdf file Regards Markus I tried this - and it did not really work. I could attach the copied database after renaming it and the original database, but then it would still point to the first physical database, i.e. the original .mdf-file ... Later the database wasn't recognized anymore ... etc. There is a much easiere way that I finally figured out: - right click on the database you want to copy - select "Tasks" and subseque ...Show All

• Umati Simple Workgroup (Like Access) use of SQL Express ??

  Hi all, In the past if we wanted to provide an application with simple (multi-user) database facilities, we would use an Access mdb database which we could basically xcopy deploy to the client. Share the folder across the network and apart from the limitations of mdb databases it would work !!! With all the advancements in databases ! we have moved on to SQL Express - touted as the thing to use and the replacement for MSDE and MDB databases. But hang on a minute !! It doesn't work like that ! You can't deploy Express like we used to with MDB databases - the default Express database doesn't allow multi-access and if you can't xcopy deploy the Express database. The 'user Instance' thing is useless - basically every user gets their own ...Show All

• bonnielee Asp.Net not finding the SQLServer for setting up Security problem

  I have just reciently installed and started upgrading the last beta code to this beta and am having a problem conecting to my sqlinstance with the WebSite Configuration Tool. The error indicates it is looking for a file in the app_data directory. (empty), but everthing else points to  SQLServer (express) as being the issue. I have run aspnet_regsql.exe (both on my default instance of sql (a sql2kas) and the beta2 instance that shipped with VS. Both created datasases and eveyting  looked good inside the db's. However when I click the "Securtiy tab" I get a message "Unable to connect to SQL Server Database." When I go to The Provider Tab, there is nothing to configure, just a test Hlink that generates the following when clicked. ...Show All

• C. Charpentier Arrows between tasks and components never remanis straight. Why?

  TIA ...Show All

• MoniDD Full-text method for SQL Express

  Hi, I have enabled full-text indexing for my database in SQL Express. I have also managed to select which column I would like to perform FT searching on in the 'Modify table' section. However when I run a Freetext/Contains query nothing gets returned. I have rebooted my machine as instrcuted in previous threads! Unfortunately I am totally new to all this and have no idea what the steps are to carrying out this task. Do I need to populate my full-text catalogue If so how can I do this Also Do I need to index this table as well again I'm mythed on how to do this. Any help / direction much appreciated! Cheers Hi Jon, You need to do the following for full-text to work: Enable the database for Full-text. Create a Full-tex ...Show All

• Kamalkanth Nayak Cannot insert duplicate key row in object

  The following quote is the exact error message that I get when I attempt to create a pull subscription. The STAppointment is one of a 15 databases that need to replicate inorder for the application SalonTouch to run properly. What is causing this error Is it user rights Is it a problem with sql2005 Am I missing a step Is there a problem with the database I am working with What else TITLE: New Subscription Wizard ------------------------------ SQL Server could not create a subscription for Subscriber 'D6LHWQ91\PORTSUN9'. ------------------------------ ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ Ca ...Show All

• Araki66 PeriodsToDate problem

  Hi All, I have created a calculated member which calculates the YTD. As a result I see this: Year Month Day CurrentPeriod YTD 2006 1 1 7543 7543 <- day level 2006 1 2 650 186134 2006 1 3 1837 224667 2006 1 4 486 257848 2006 1 5 1014 282021 ... 2006 10 3075 1593626 <- Month level 2006 11 1593626 2006 12 38 1593664 Total 1593664 1593664 I do not know why the ytd at day and month level are different compared to the current month but the totals are correct I tried to reproduce this by building a new cube on top of the adventureworks database but everything works fine there. I don't have any attribute relationships for the time dimension defined (yet) in both environments (develop and adventur ...Show All

• Snake_122 Smorgasboard of Encrpytion questions !

  Answer whatever part(s) you can! 1. "EncryptByKey" is commonly used to encrypt data but what is it Is it an extended stored proc or a .NET assembly or seomthing else 2. What are the minimum permissions needed for a user to encrypt\decrypt data (I'm testing encryption as the DBO and that's great for me but not good in practice) 3. The use of a MAC table is a great idea when one wants to search a single column of encrypted data. Can this idea be extended to handle multiple encrypted columns 4. Is this correct: JOINS on encrpyted columns (I hope we don't need to do that often!) would be handled using the approach mentioned in 3) 5. The t-sql funciton HASHBYTES is a hash function. Is CHECKSUM also a ha ...Show All

• Rames Gantanant Get Sql Documenter

  I need to see a total outline of my relationships on my sql database. Something besides database diagram. I need something like Microsoft access Documenter. I want to be able to print out a complete definition of the relationships. HEllllllllllllPPPPPPPPPP!!!!!!!! What's wrong with database diagram You could try SchemaToDoc ( http://www.schematodoc.com ). It creates a Word document that includes info about your database - primary keys, fields (type, size, nullable, defaults), indexes, check constraints, foreign keys, triggers, views, stored procedures, and extended properties. It also includes an interface that lets you annotate your tables and fields. ...Show All

• Mikx Sorting Data in a Table

  After you start adding data to a table can you resort it so when you open the table it is in ascending order Thanks No; the only way you can guarantee that you'll get your data back in a specific order is if you use an ORDER BY clause in your SELECT statement.   -- Adam Machanic Pro SQL Server 2005, available now http://www..apress.com/book/bookDisplay.html bID=457 --     < RayClark096@discussions.microsoft.com > wrote in message news:37d8d2a5-d53f-42e6-9ae7-7591b5f06514@discussions.microsoft.com ... After you start adding data to a table can you resort it so when you open the table it is in ascending order Thanks ...Show All

• SOTY_Programmer Derived Column Transformation Editor Question

  Help... I'm having trouble coming up with a valid expression in my derived column transformation editor that tests the input column for NULL and responds something like this: if[message] isNull then "NA" else [message] where [message] is the input column. Thanks! Try: ISNULL([message]) "NA" : [message] ...Show All

• gracias Getting Version of Database without convertign to SQL Server 2005

  Is there any way to get the version of a database without attaching it to the server. Or can I attach a database without converting from SQL Server 2000 to SQL Server 2005. The reason is that I have to ask the user before a convert the database from SQL Server 2000 to 2005. Hello, thanks for answers, but the problem is not to use the SQL2000 database in SQL2005. I have to know from which version the database file is - without any change in the database. I tried to open the SQL2000 database with a SQL2005 Server. But the database will implicit updateted from version 539 to 611 while attaching (Converting database 'Test_DB' from version 539 to the current version 611). I can not attaching the database ( ...Show All