Answer Questions

• cycle Back-up DB but keep the files for 3 days?

  Hi I have created a job to backup all our database. It works fine and creates .bak files in default folder. I have scheduled the task to run every 4 hours. My question is how can i modify or program this backup plan to keep the backup files for only last 3 days and delete older backup files Mits That's simple. I assume you are using SQL Server 2000. If so, in Enterprise Manager, Expand Management node ...Show All

• SX How to flag a row and allow max one row flagged in the table.

  Hi, I am new to SQL. which is the best way to flag a row Create a bit column IsFlagged Additionally, I want to create a table-level constraint that allows max 1 row flagged true in the whole table. I can't nest a select expression in the CREATE TABLE statement CONSTRAINT clause that counts flagged rows. So how do I do this Appreciate the help.   However, I now face havin ...Show All

• Steve Nesbitt Changing collation in SQL 2000

  I have a database in SQL 2000 on which I am trying to convert the collation to case insensitive from case sensitive.  I am trying to use DTS to do this.  The master database is already case insensitive.  I have created a new database on the same server with the proper collation.  I am then trying to use the DTS to import the data by replacing all objects.  I am essentially trying to copy all the database objects changing ...Show All

• PGI Dev Howto upload programaticaly SMDL file&

  Hi. I need upload smdl file in setup. Howto do it Hi, I am confused about the step of " copying the code from .dsv file and then pasting into the .smdl file". how can I avoid this manual step Please let me know Regards, bala Once you upload the report model to the server, you must call the SetItemDataSources() web service to set the data source ...Show All

• mdegi Is there transactional consistency across multiple publications?

  Hi, Currently, I have Server A which has Publication P1. Server B is subscribed to P1. Let's use 'T1' as the name for the set of tables/articles included in P1. Now I need to add serveral new tables to Server A. Let's call the new set of tables 'T2'. There is a Server C that needs to sync with the data in both T1 and T2. But Server B cannot have T2's data for privacy reasons. One of the solutions I'm thinking about is to create another pub ...Show All

• Farid_Z Reporting server Activation Error.

  I got following message while activating a report server instance. "Failure verifying the current state of the web service: the web service is already in a valid state or the state can not be determined" When I run report manager( http://localhost/reports ) its working fine. but when I try to create the data source I am getting "Page cannot be displayed" error.  During Installation I saw warning message that As "windows sharepoint serv ...Show All

• anomolous Upgrade SQL Express to SQL Server 2005

  Hi, I have VS 2005 running nicely with SQL Server Express.  I have now been asked to trial SQL Server 2005, and wondered how I go about installing it.  Do I need to replace the SQL Server Express, will it upgrade it, or can I have both up and running. Please advise on best method for a seamless installtion and experience. Thanks for the speedy response. You have a ...Show All

• MEK_GDM Error that has nothing to do with my cube

  I right click on my AS cube and click "Process".  It tells me the server content is out of date would I like to build and deploy first.  i say yes. I get this error Error 1 File system error: The following file is corrupted: Physical file: \\ \E:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\Adventure Works DW.0.db\Dim Product.0.dim\1.Start Date.(All).sstore. Logical file . Errors in the metadata manager. An error occu ...Show All

• RanA Connecting to SQL 2005 from a client pc

  I am getting this message. On the actual server I can pull up the report builder, but from a client on the network when trying to connect to the sql report builder I get this message: PLATFORM VERSION INFO Windows : 5.1.2600.131072 (Win32NT) Common Language Runtime : 2.0.50727.42 System.Deployment.dll : 2.0.50727.42 (RTM.050727-4200) mscorwks.dll : 2.0.50727.42 (RTM.050727-4200) dfdll.dll : 2.0.50727.42 (RTM.050727-4200) dfshim.dll : 2.0 ...Show All

• Yoni_Nijs Variables Not Seen In Custom DataFlow Destination

  I have run into a HUGE problem (possibly a BUG)! I have a custom XML Destination script which uses a FILE Conn to send to another path using the original file name. (found in my foreach container (varFileNm) The problem is that my destination will not use the value found for the varFileNm. I can see the value just fine in the Flat File Receive, but I can't see the value in my custom XML Destinati ...Show All

• khiemvo Can not Subscribe a Report

  Hi, I just create a report using Whidbey and deploy it to the Project reportserver. And I can access that report correctly, but I can not subscribe that report, what's going on Additional, I create that report using Shared Data Source (connected to Analysis Service of my TFS DT) which I created in Whidbey. The exception info is below: The current action cannot be completed because the user data source credentials that are required to execute th ...Show All

• Kunj Limitation for UDAs

  When user-defined aggregates are discussed, there are two usage scenarios that are often mentioned. One is calculating the median value of a set of numbers, and the other is concatenating a set of strings into a comma-separated list. However, I can not see how it would be possible to create an aggregate function for either of these problems. Because MaxSizeBytes can never be more than 8000 bytes these functions would only be able to operate on ...Show All

• czetsuya Advenced select

  Hi, I have 3 tables. 1. TableValues with MainID, FieldID and value 2. TableFields with FieldID, FieldName, FieldTypeID 3. TableFieldsTypes with FieldTypeID, TypeName I want to create select that returns me columns as fields names and values taken from TableValues and types taken from TableFieldsTypes. How can I do this Thank's Alexei Switch so you select from the table that contain the rows you must have in the output, lef ...Show All

• BHDev Names of the collumns

  Hello! I need to make a query that returns the names of the collumns. Could you help me Thank's Ronaldo Thank you, Gail. I will use system catalog views from now on in SQL 2005. Vincent Hi Vincent, Your example will work in SQL Server 2000, but if you're using SQL Server 2005, it would be better to use the new catalog views instead of the old (and deprecated) system tables. Here's th ...Show All

• Bakhytzhan SQL 2005 bug?

  Windows 2003 + SP1 + SQL 2005 CTP + Visual Studio 2005 Not sure if someone else is suffering the same problem. When I use SQL Server Manaement tool, create a new query and retrieve the result from other server running SQL 2000. Select any row/column in the result window and move around by press arrow (up/down/left/right), my computer will freeze and I will have to reboot it. I was very exciting when installed SQL 2005, but now I am too scar ...Show All