Windows Tech >> SQL Server >> Archive Page 168

view full version: back to formated view

58451: using 32 bit sql server for disaster recovery of 64 bit prod cluster
58452: Execute a query inside dataflow and use the fields returned to continue dataflow... how?
58453: SQL Server Business Intelligence Developer Studio new projects template missing
58454: Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path
58455: Unable to backup database in UserInstance
58456: code for multiple reports deployment
58457: specify type="datetime"
58458: Suggested Hardware spec
58459: nText Column Text Encoding/decoding
58460: Merge replication problem
58461: Replication Loop Back Detection Problems in SQL Server 2000
58462: How can we delete the time dimension and time intelligence created before?
58463: Using Variables with SQLCMD in SSMS
58464: SSIS package causes tempdb to run out of space
58465: Smart Trigger...
58466: Server Aliasing using script
58467: Dynamic Lookup
58468: sp_executesql bug? - @@error = 0 when @statement is null
58469: Problems during the installation of Integration Services
58470: Select
58471: Question on @child.IsDescendant(@child)
58472: Converting string to datetime
58473: Insall SSMS from 64 bit media on 32 bit workstation
58474: How to assign OR get Time value to a colum
58475: Pooling
58476: Problem with Print Button In Report Viewer(Only in XP)
58477: Report works fine stand alone, but fails when used as subreport
58478: sp_dbmmonitorupdate syntax error
58479: One Dimension - Several Hierarchies - For each hierarchy an own UNKNOWNMEMBER name
58480: newbie confusion: file vs server
58481: Optimization of query
58482: Data Conversion
58483: Is server downgrade possible?
58484: What is maximum database size in the SSCE?
58485: buffer is full
58486: Reporting services not an option on install.
58487: best approach for "trigger on commit"?
58488: Logging Query Messages From ExecuteSQL Task
58489: Transaction control always has deadlock by spid=-2
58490: Please put me out of my scoping misery
58491: COnverting Numeric data type (Oracle) to Date Data type using SSIS
58492: Parameters
58493: Execute SQL Task - Passing Variables
58494: Not able to connect to SQL SERVER 2005 from workstation m/c
58495: SELECT USER_NAME() !!!!! Urgent
58496: Setting the Legend color on a stacked bar chart
58497: Updatable Queued Transaction Replication Conflicts
58498: Has SELECT INTO with IDENTITY() function changed the way #'s are assigned?
58499: Error connecting to server
58500: I cannot get the SQL server compnent to install
58501: Manual uninstall of SSRS2000?
58502: Can I/Should I turn off logging on some tempdb transactions?
58503: overvue
58504: Using UPDATE CUBE in XMLA
58505: Problem with Case Statement and an Apostrophe in the Value
58506: Parameter problem
58507: SQL Query output to XML using BCP HELP!!
58508: WHERE clause upsets query
58509: Primary key vs Unique key
58510: has any one know about sql reporting services
58511: What is the easy way to do this?.
58512: SUM and Iif statements
58513: Analysis Services Installation
58514: URL accesses to .NET
58515: MDX - Get Cube Name of the CurrentCube
58516: sql 2005 cluster setup fails
58517: Object Explorer/Server Explorer Error
58518: Errors using multiple parameters in a SQL Statement
58519: strange lookup behavior
58520: Upper level members are not adding up correctly in SSAS - revised
58521: Conditional Expression quirk?
58522: Setting up encryption for large databases
58523: Count Loyalty
58524: multiple results query
58525: Processing AS 2005 dimension with Oracle data source
58526: How to create new database in sql server 2005
58527: sql server 2005 database tuning advisor how to use it on full database[not a single table or query].
58528: Where do User-defined Defaults show up?
58529: Remote connection to database on same PC?
58530: EBCDIC to ASCII conversion in SSIS
58531: Cannot process the object "SET FMTONLY ON EXEC DBName..StoredProc". The OLE DB provider "SQLNCLI"...
58532: SQL Server 2005 SP3 release date?
58533: Script Task scripts will not stop at breakpoints.
58534: Copy Database (SQL Management Object method)
58535: Hold group constant across time?
58536: Can not connect to a flat file
58537: Report Service 2005 parameter at Date
58538: Generating script per object
58539: JDBC Driver setMaxRows documentation error
58540: Odd report parameter issues
58541: No one can help me on this prolem??????
58542: Stored Procedure Hang the first time, the run the send time.
58543: Reporting Services Login
58544: Commit and Rollback?
58545: Parameter in the Report Url to Print
58546: Creating Multiple Charts
58547: Thanks-Automate process thru Notification Services
58548: Summing a product type by month and year .... can't get my head around it
58549: Using Array Variable in ForEach Loop Container
58550: Foreach Loop though all databases on a server
58551: Allow NULLS with the lookup transformation?
58552: How to get the first occurrence of a record from a table?
58553: SQL Server do host variables need rtrim
58554: Preventing access to SQL Server from other Servers
58555: Error: Could not find an entry for table or index with partition ID xxxxxx in database & Server Shut Down
58556: Using a dynamically created parameter in another dataset query
58557: Defrag or not to Defrag
58558: cursor + rounding?
58559: Receive "Must declare the variable" When Upgrading to Reporting Services 2005
58560: Accessing Values Parameter Values from another report
58561: SQLServer 2005 installation on Dell poweredge 2950
58562: JDBC and Temp Tables
58563: How to force 12 rows (1) per month
58564: denormalizing with a special need
58565: How can I convert font in database
58566: divide by infinity
58567: Conditional Control Flow element
58568: Parallel Processing of Partition
58569: Windows 2003 SP2 is NOT a supported OS for SQL 2005 SP2???
58570: challenging search task is not working as expected
58571: Receiving Cross Join Result in Error
58572: SQL 2005 __Back-Up automatation__
58573: dataflow task performance
58574: Quorum Disk again.
58575: Using Excel functions in AS 2005???
58576: How to connect MS AS 2005 with AMO in vb.net
58577: Can SSIS work with an XML web service? (Verisign Payflow Pro)
58578: A very frightning Query!!!
58579: Confusion in AWE
58580: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'
58581: How to move sql server 2000 database from one server box to server 2005 on another server box sql?
58582: Combining two table into a single table
58583: how to save xml document in database table?
58584: SqlCe Memory issue
58585: Report Manager Error
58586: search with datetime takes too much time
58587: Web front-end for SSAS 2005
58588: Report spanning multiple pages
58589: Stored Proc activity monitor
58590: Installation problem - Enterprise x64 on WS2K3 SP2
58591: SSRS 2005 - Speed Issues
58592: trouble with query for poorly normalized db
58593: calling multiple stored procedures from a stored procedure
58594: Use Adobe pdf files with Visual Basic 2005
58595: Bulk Insert Error
58596: delivering 300 reports at one time through DD - file shared option
58597: VB.net Samples?
58598: Number Format
58599: SQL Network Interfaces Error 26 on newly installed machine, every other machine connects perfectly.
58600: MS management studio and intergration services
58601: datetime convertion in SqlServer 2000
58602: Snapshot Agent missing files.
58603: Using generic function through Script Tasks
58604: Upgrade from MSSQL7 to 2005. [Import database to new server]
58605: Schedule and Delivery Processor errors
58606: Error Reporting in SSAS...
58607: Loop by passing variable into Query
58608: ODBC connection to SQL 2005 Express
58609: Connection Problem
58610: Replication scnerio
58611: how to overwrite the DB backup for multiple DB in a plan
58612: Conditional Sum?
58613: "Login timeout expired" prevents package deployment
58614: Combinations
58615: Locking Issue
58616: For each table in database dft?
58617: Connection problems
58618: XML Source doesn't validate external metadata properly
58619: How to enable "Force Encryption" for SQL Server 2005?
58620: Clustered vs Nonclustered PK
58621: Overhead for Aliases
58622: Using cassini instead of iis
58623: Using Service Broker with History/Audit triggers
58624: Character is not valid
58625: sysdtslog90 table creation issue
58626: Constant CPU usage on server when using SQL Server 2005 Management Studio
58627: help pls: procedure 'LoginListInput' failed because 'LoginListInput' is a table object
58628: Check if file is already open
58629: How to get the SQL from a Report Builder ?
58630: Sql Server Record Lock
58631: Time dimension MDX
58632: Reg: Query Performence
58633: OK button doesn't Work In Report Manager RS2005
58634: Placeholder Question...Simple (I think)
58635: ExtendedProperties Performance
58636: how to display 7/2 = 3.5
58637: Number of fields in a table
58638: Several Updates With One Store Procedure ?
58639: Join-Problem (select two columns out of one column)
58640: How to know what is the default sort order of a database
58641: Cumulative log
58642: SQL Server is unable to connect
58643: User Access Configuration
58644: Second opinion on how to build this cube
58645: TSQL - Trim string containing both Data and Value into 2 separate data fields
58646: triggers,constraints on the subscription side
58647: How to restrict certain Export options (Like Excel) for some users for a report.
58648: Monitoring/spying on the CE execution engine
58649: SSIS package storage in a UNC network share?
58650: Rectangle hides other objects
58651: print layout in Report Manager
58652: Error Importing using vista a comma deliminated file
58653: Connection string for PDA
58654: Evaluate a formula and calculate a variable value
58655: Defaulting Start and End dates to the previous month.
58656: Scheduling Montly Report
58657: SP2 loading does not give <select all> functionality
58658: An OLE DB record is available - Invalid column name
58659: Analysis Services Project - A connection cannot be made. Ensure the server is running.
58660: SQL Browser Error
58661: cannot connect to integration services
58662: Bulk Insert error file does not exist
58663: Debugging Woes
58664: error when attach to 2005 server from a 2005 server file
58665: ReportServer virtual directory doubt...
58666: Deploying Sub Reports
58667: Dimension just with Values in Fact Table
58668: Purging data off of an MSDE database.
58669: How to change the time out value in a EM?
58670: Top 10 orders by production
58671: Problem importing Excel data into SSMS
58672: Replace Cluster Disks
58673: Microsoft Access Database Synchronizer (ADS) RTW
58674: Please help me to clarify my Doubts related to report builder
58675: LIKE keyword in MDX
58676: SSIS - Package Performance
58677: Optimize sql statements / find usefull indices
58678: How do I do a like '%<string>%' equivalent in FTS
58679: SQL Server Agent Job Step Properties window loses Property values containing semicolon (;)
58680: Problems Creating Database on SQL Srvr. 2005 Ent. Edtn.
58681: Virtualization licensing: confusing and inconsistent
58682: Problem with linked server stored proc in a maintenance plan
58683: Importing Excel File in SSIS
58684: try catch does not catch exception
58685: Alpha Order in Management Studio
58686: DTS to VB
58687: Constant CPU usage on server when using SQL Server 2005 Management Studio
58688: Selecting detail based on a sum of the detail lines
58689: Trigger not being called
58690: Logging User Activity
58691: set primary key
58692: Publlish reports with web application
58693: Bilateral Transactional Replication Problem
58694: Getting "Attribute relationships do not exist between one or more levels in this hierarchy" message
58695: Cube from denormalized table: Several dimensions vs. one dimension with several attributes
58696: Turning Off Grand Total in a Cube Browser
58697: ETL Load ID
58698: xQuery requires QUOTED_IDENTIFIER
58699: Error installing SQL Server Express 2005 SP2
58700: Read one field in every row during SELECT
58701: ssis packages
58702: Which is more efficient to use: Joins or SubQuery
58703: Possible Validation Problem with Flat File Between Two Data Flows in a Package
58704: Using Excel functions in AS 2005???
58705: Reverting From MSSQL 2005 to 2000-Help please....
58706: How To Deploy SSRS To Production Server ?
58707: SQL Server Management Studio and Visual SourceSafe
58708: Need to get separate pages for each person..help
58709: what permission do I need to grant ?
58710: Levels in the date dimension below the granularity attribute.
58711: SSRS 2005 v SSAS 2000 Mutli-Select Parameters
58712: Googlebot and MSN bot causing sql login errors
58713: Lookup Transform
58714: MDX Issue - Bug?
58715: sql 7 database in DBO-user only\Read-Only\offline\Emergency mode
58716: Creating Test Data for a Table
58717: Can we drill down to details for calculated members?
58718: Proative caching not working for dimension in case of incremental update
58719: CLR procedure implementation
58720: INNER JOIN
58721: Using IN with a local variable
58722: Inserting in a partitioned table
58723: Reporting Services parameters not in correct order
58724: Grab set of records per Meeting#
58725: Orphans
58726: How can i get the 2nd, 3rd or N'th row from a table?
58727: Issues with removing replication
58728: Error Creating an Indexed View.
58729: Please help me...sql management studio 2008
58730: How to set credentials with AWReportViewer??
58731: Actual and Forecast as One Measure
58732: Problems loading SQL Server Management Express
58733: how to persist cookie through HttpWebRequest in CLR? thanks
58734: connecting to SQL DATABASE ENGINE
58735: Installing from command line and editing accounts.
58736: errors in the metadata manager. The dimension with the ID ...
58737: SQL DB Access fails on Vista when UAC on
58738: Unable to update variables within a package
58739: Problem backing up.
58740: Performance Comparision - Stored Procedures VS SQL (Inside SSIS)
58741: Adventure Works Cube
58742: HttpUtility.HtmlEncode & Full-Text Search...
58743: Update Package to save new property values
58744: SQL Server Express error when using NUnit
58745: Stored Procedure Logic Syntax
58746: CONTAINSTABLE inconsistency with phrase
58747: Possible to use ReportViewer to change connection strings of a report's datasources?
58748: Two questions around Date
58749: Report Builder model generation - how to create a key attribute along with the role?
58750: How do I use a stored procedure in a formula field
58751: adding a new data flow item calendar transformer
58752: Tracking connections
58753: Difference between procedure and function ?
58754: Full-Text Search Error - Server: Msg 7635 The Microsoft Search service cannot be administered under the present user account.
58755: make Count(*) return zero
58756: Obscure linked server error
58757: FTP from a mainframe (z/os)
58758: Login failed for user Domainname\computername
58759: SharePoint Services Report Viewer
58760: Join two text files in SSIS
58761: Thousand separators in AS 2005
58762: Association Questions
58763: Project Server DB
58764: Backup to network drive using Workgroup/Standard.
58765: Powerpoint Presentation on MDX
58766: Help with a query
58767: Tape not available as Backup Device
58768: Cannot connect to SQLExpress
58769: Renumber column....
58770: Strange SqlBulkCopy Exception with SQL Server 2005
58771: microsoft visual studio cannot shut down because a modal dialog is active
58772: Help on Script Component assignment of output variable
58773: flow layout in rs2005
58774: SQL Server Agent Properties - History
58775: WROX Execute SQL Example
58776: Cubes process error
58777: Results from Aggregate() are wrong
58778: Sample rows by criteria
58779: CREATEing a new db
58780: Date Format
58781: ordered update
58782: On SQL Mobile 3.5 NTEXT will not accept data above 4000 characters... this is serious and confirmed
58783: Microsoft Please help-Web Service Problem
58784: Filter, MDX and Precedence (or a better solution)
58785: Error 3: the system cannot find the specified path
58786: Custom Order By...Revisited
58787: Compare 2 char strings?
58788: top n sales per territory - easy one
58789: Create Time dimension Year, Week, day problem
58790: Is ProcessAdd done within a transaction mode?
58791: Walkthrough to Execute SSIS packages via Web Service
58792: Problems storing Exec functions into temp tables (new to sql so help appreciated)
58793: Hi Greg , Any Solution for Alter tables on publisher and subscriber end as well ....?
58794: SSIS - Excel Destination Column mapping Error
58795: Database Attach error encountered
58796: Get Return Value from Stored Procedure
58797: How to get MDX query that BI Studio generates in the Cube's Browser
58798: Update table with data calculated from the same table
58799: expression contains a function that cannot operate on a set
58800: Error with Subtotal and Grand Totals with Iff checking.