Windows Tech >> SQL Server >> Archive Page 128

view full version: back to formated view

44451: Re-Engineer an Existing CUBE
44452: Parent Package Variables and SQL Package Store
44453: EnterpriseLibrary 2006 DATA ACCESS LAYER
44454: Comparing Rows in a table
44455: SSIS - migrating mainframe data to SQL 2005 only mainframe group level exposed
44456: SSIS Capacity
44457: Log Shipping Failover Situation
44458: expression syntax behavior
44459: Great new Learning Resource
44460: Problem with Accessing Unix Share Drive When a SSIS Job Runs
44461: configuring dataset dynamically
44462: Concurrent Cube Processing
44463: Hiding Rows in Matrix
44464: Passing Multi-Value parameters to a Data Driven Subscription
44465: IF statement for task failure
44466: Custom conflict resolver example code in C#
44467: SQL Server Reporting Services - Error
44468: Connection problems using Standard Security
44469: Why is Unique Constraint is prefferd over Unique Index?
44470: The total is not correct by multiplying measures.
44471: How to get sql server name with a vb-script?
44472: insert or update statement depending on existance
44473: DB2OLEDB Query Parameters in OLE DB Sources
44474: calculated measure problem(ssas 2005)
44475: Can not connect to SQL server 2000 on windows authentication mode
44476: Is there query I can write to remove empty tags from a xml field?
44477: Error message "Interface not registered"
44478: Which version to buy
44479: Derived Column / Change date format
44480: SSIS Error
44481: query large database
44482: Miscrosoft Integration services gives an error of Sript Task Failed
44483: Check data before insert
44484: Converting database from 32-bit SQL Server 2005 to 64-bit version of SQL Server 2005
44485: TNS Alias name changed
44486: DTS package help needed
44487: how do I get the name of the table that fired a trigger?
44488: Office 2007 and SSIS
44489: Encrypt argument does not work in SqlConnection.ConnectionString??
44490: Can not replicate DDL changes
44491: SQLDiag on 2005 64bit
44492: SSIS licensing question
44493: connect to foxpro v6.0
44494: Error encountered while starting the SSIS service
44495: Connection question
44496: Can exec select but can't exec sp
44497: How to diagnose broken input on Union All transformation
44498: Accessing One's ReportServer Homepage from Other's Machines
44499: Trouble with trigger: doesn't seem to work at all and no error messages.
44500: Advanced Join???
44501: One Account and one product result
44502: SSIS Execute SQL Task
44503: SSAS MDX issue
44504: Select from table not in another table
44505: XML Variable has no data
44506: SQL Server and .Net framework
44507: Parent Package Variables and SQL Package Store
44508: comparing hours
44509: Creating Full-Text Index
44510: SP2 CTP November 2006 installation failed
44511: Rebuilding System Databases on a cluster
44512: UPDATE statement differences between 2000 and 2005
44513: Backups to a backup device
44514: DTS package help needed
44515: Cannot Install SQL Server 2005 after running Uninstall
44516: SSIS Job Failed
44517: Connection manager permission issue
44518: Running value
44519: Access C# code from Integration services
44520: 3rd party app supported on 32-bit sql, but not 64-bit?
44521: Inline table-valued function with multi-value parameter
44522: Retrieving XML Datatype to a Record Set
44523: Aggregate error on calculated measure with time range
44524: Report with model in VS
44525: Primary Key Auto Increment
44526: Report Viewer webpart did not work in wss 3.0
44527: How to get the percentage presentation of a returned value in MDX?
44528: SET QUOTED_IDENTIFIER Question
44529: What is the best most efficient performant way to do a Control break in SSIS?
44530: Server: Msg 3136 Restore Differential Database Backup Fail
44531: Query Plan in SQL Server 2005 SP2
44532: sql update
44533: A potentially dangerous request.form value was detected from the client
44534: Cannot register notification services
44535: How to automatically generate HTML Visualizations of Mining Models using Visio?
44536: How to view DTS Pkg in 2005
44537: Moving Reports from 2000 to 2005
44538: Executing MAXL Scripts in Execute Process Task
44539: Error 28092 when upgrading from Express to Workgroup Edition
44540: Data Conversion supported on Standard Edition?
44541: authentication to SQL Server 2000 from ASP
44542: Compare database version
44543: Loop Through Flat Files Based On A Date Range
44544: Inserted Rows count from SSIS not like table Rows Count
44545: Can you do a lookup that has an indirect key?
44546: Generating Script
44547: sp_publication_validation
44548: Backup to non domain member using UNC
44549: Who's the idiot that designed the file destination?
44550: AMO: Only need to use ProcessData?
44551: Transactional replication & Snapshot Agent
44552: Generate/Export Chart
44553: Automatic failover... help
44554: drop user
44555: Analisys Manager Vs SQL Server Management Studio
44556: How to get data from Primary Server
44557: The maximum number of articles allowed in a merge publication is 246.
44558: DataReader source output help
44559: "Transaction Manager not Available" error using July 2005 CTP
44560: help with sql server express :S
44561: Browser Role not performing as expected
44562: Whereis the AdventureWorks and MaxMinSales sample projects/.mdf files (server databases)?
44563: SSIS competition on the market
44564: Unable to display Server Reports in Report viewer control
44565: Implementing paging using store procedure
44566: OLE DB Source
44567: Analysis Services 2005 is not getting connected
44568: How to convert 2005 package to 2000
44569: Transfer database from SQL Server 2000 / 7.0 to SQL Server 2005 Express Edition
44570: Using 4 CPU by SQL Server 2005
44571: delete table1 from openxml
44572: Complex Query question. Using Sum and CAST operation.
44573: SSIS Package not running under proxy
44574: Usage Based Optimization - Problem
44575: Table transpose
44576: SSIS BULK INSERT error: File Format doest not exist
44577: How to encrypt store in sql2005?
44578: creating login2 with same password as login1
44579: Bug report - reporting services sql 2000
44580: Adding Button in Report
44581: Inserting values intoto only column based on a condition
44582: convert a date specified as an integer (e.g. 20070101) to a date
44583: How to avoid deadlock with simple update statements
44584: Problems Creating Database on SQL Srvr. 2005 Ent. Edtn.
44585: Vista IIS7 and asp.net reporting services wont deploy
44586: A significant part of sql server process memory has been paged out
44587: How do set send mail task?
44588: MDX's ORDER Function
44589: Generate Alter Script
44590: SP2 and embedded click once installations
44591: Display tiff in Reporting Services
44592: Although Job was running in background cancelled due to power shut down
44593: HOWTO Read Transaction Log files from Previous days.
44594: How to dynamically map the coloumn to a flat file destination?
44595: Replace Non-Numeric Values With Zero
44596: calculating frequencies on the fly, without knowing in advance the total number of occurencies required to compute the frequency
44597: Financial Periods YTD & Date Ranges
44598: Help importing file with varying column widths
44599: SSIS Dependencies
44600: Lookup as Inner join ??
44601: Hiding a subreport SSRS
44602: SQLAgent doesn't cycle log gracefully
44603: Question about OLE DB conn mgrs
44604: Using OPENROWSET for csv files
44605: Passing a Multivalued string to Stored Procedure
44606: Smart Trigger...
44607: Generating a daily statistic report SQL
44608: How to send a dynamic files attachment by send mail task?
44609: primary key error with INSERT INTO
44610: jdbc refuses connection with 'user not associated with a trusted SQL Server connection' message
44611: No "Existing" word... How?
44612: The network path was not found
44613: grouping on date without time
44614: Is Report Manager a myth?
44615: Understanding Error Handling in SSIS
44616: about security
44617: Rectange within subreport will not repeat on every page
44618: Unable to backup database in UserInstance
44619: generate report from data warehouse
44620: Second Y axis
44621: Using T-SQL to find if a table is published
44622: First time use of Analysis Services
44623: How do I use INNER JOIN with three tables?
44624: sp_send_dbmail "Mail Queued." Message
44625: create table from select result
44626: Easy Insert Statement ... Hopefully!
44627: If WCF can communicate with ServiceBroker?
44628: Report runs on Visual Studio but not in the server
44629: Query not returning proper data (date related) in 2005 after upgrade from 2000...
44630: SQL 2005 SP2 Cluster install
44631: How to get total page count for individual groups
44632: Custom Order By
44633: Users are unable to connect to SQL Server 2005 unless they are in the sysadmin group
44634: Which edition and which licensing to use?
44635: Report Manager Virtual Directory
44636: Transact-SQL: word "sample" reserved in SQL2000??
44637: Create HTTP request in Stored Procedure
44638: Difference of two datetime columns caused overflow at runtime.
44639: Mirroring Verification
44640: The specified network name is no longer available. Communication link failure
44641: step by step to publish/deploy the report project to the user pc ?
44642: Incremental Proccessing
44643: Anyone else have errors when checking out SSIS package from SourceSafe or TFS?
44644: SQL Server 2008 June CTP Declarative Management Bug
44645: Sql server2005 databad and login creation
44646: Ordering columns in data flow (simple?)
44647: User dependent security
44648: Conditional format within matrix, depending on subtotal?
44649: Data different in Olap Cube Analysis Service 2000 and Olap Cube Analysis Service 2005
44650: Why aren't win32 management studio tools on x64 disks?
44651: sp_xml_preparedocument
44652: Forms authentication - Object reference not set to an instance of an object
44653: SQL Server 2000 - MSDN - AWE memory
44654: Percentage not being calculated
44655: How to get name which has id ?
44656: Difference between CONTAINS and LIKE
44657: join condition taking too much time with certain where conditions
44658: SQL Server Express SP1 Setup failed
44659: Formatting dates on a chart when sourced from SSAS2k5
44660: SQL Server 2005 Enable Sa login & Disable Windows Authentication
44661: Choose between Merge or Transactional with updateable subscriptions?
44662: Failed to acquire connection message on SSIS packs from within Integration Services
44663: Analysis Service Manager
44664: Help. Serious problem with error redirection
44665: Locking Issue
44666: Security Audit
44667: Table Report Item in SSRS
44668: How to Use NOT IN
44669: Trouble Enumerating SQL server instances 32 bit and 64 bit mode
44670: Question about the 64 bit CDs/DVD
44671: Different result between using query and call from ASP
44672: Performance problem MDX, dependent on location in the code
44673: How can I login to my MS SQL Server 2005 if I forgot my login password
44674: How to migrate a DB in SQL Server to MySql
44675: Stored Procedures
44676: Could not create an user to SQL Server 2005
44677: ? Embed PDF inside of SQL Server Report Servics Report
44678: Problem With reportviewer while refreshing
44679: Problem with SQLAgent Running SSIS Package "...package execution failed..."
44680: no problem...
44681: Question about IRowsetFastLoad::Commit(FALSE)
44682: Help on a 'Spread' kind of Ranking...
44683: Deadlock and lock mode questions
44684: When do I need to drop column statistics when doing an alter?
44685: Insert Syntax
44686: Stored Procedure
44687: SSIS Logging Problem
44688: Declaring Public Variables
44689: How to check the existence of a column in a table
44690: Upgrade from SQL Server 2005 Express to 2005 Enterprise fails
44691: SP - Strange problem
44692: Allow null in a field in Flat File Source
44693: Help: MS Access to SQL Server 2005 using SSMA
44694: How to Add Subtotal in a matrix which shows all colunms nut seletd vales of total
44695: Insert Stored Procedure
44696: Join table and function
44697: Report Viewer to Get Data from RS Deployed on separate Network.
44698: Use Visual Studio VB to import/copy an Excel spreadsheet to an Access db
44699: Query to report database user role membership
44700: Update ID field of all records
44701: Report Grouping
44702: Select statement to output a date
44703: Increase the Rendering Timing of Reports
44704: Differences between Enterprise and Standard editions.
44705: SQL Server Replication License Requirments
44706: Import from Excel with IMEX=1 still gives probs
44707: Accessing variables collection from a custom log provider
44708: how to find out the collation in sql 7???
44709: Simple Query on one table
44710: change value type from Int64 to Int32 ?
44711: Column mappings from TXT file to Tabel columns using SSIS package and tools.
44712: Date output to flat file
44713: How to detect overlapping Time Entries
44714: Memory question
44715: How to use SqlFacet in VB .Net (for parameters)
44716: Temporary table
44717: Can't figure out this error!
44718: SQL 2005 Express
44719: Commit Error
44720: Weird behaviour of TSQL on Query Analyzer vs SP
44721: SSIS - Connection String Issue
44722: Augent Pls help::::Is_Member() function returns 0 instead of 1 in sql2005
44723: Error message occurs when closing IE7 tabs
44724: SQL task ERROR: End tag 'Doc' does not match the start tag 'D��??oc'.
44725: variables in data flow OLE DB
44726: One or more subscriptions have been marked inactive. Drop and re-create all subscriptions for this node...
44727: please help me fix this SQL query
44728: How can I speed up extracting data from Oracle?
44729: Lookup transform - incompatible data types mistery
44730: Best practice for WMI Event Watcher task
44731: Select Statements in SQL 2005
44732: SQL is using up all my system resources
44733: Need help with UDF useage. Trying to get away without using cursor.
44734: Can't install SQL Server Express 2005 on VISTA
44735: user data source credentials error
44736: call function for inner join
44737: [SS2K5] : Populate a CTE from stored procedure result set
44738: How will i know the rows being saved by SSIS package into tables
44739: Hard Coded parameters
44740: Creating a 4-4-5 Time Period table
44741: Error: 18456, Severity: 14, State: 16. Login failed for user
44742: Unable to start T-SQL debuging.
44743: Question
44744: restore msdb - MSDE 2000
44745: Distributor cannot connect to subscriber
44746: Need to lookup an Oracle Sequence value within a dataflow
44747: SSIS Higher Level Edition error when run in a Sql Job
44748: adding subreports to master report at runtime
44749: Report Builder - Data Model Filter
44750: Can't install 2005 SQL Server Management Studio, it doesnt show up. What a joke!
44751: Expression - Compare dates
44752: IMMEDIATE ATTENTION PLEASE.....
44753: Turning off validation
44754: Best practice for WMI Event Watcher task
44755: TNS Alias name changed
44756: searching a Unicode data within a Image data type
44757: DB Backup Failure
44758: SQL ODBC Errors
44759: Help with retrieving string data
44760: Is it common to have CPU usage at 50% Constantly.
44761: Using UDF together to ADO.NET
44762: OVER (PARTITION BY ...) How Complex?
44763: help in displaying data from cursor.
44764: Displaying traffic lighting images using MDX query
44765: I can't get this view faster
44766: database creation
44767: Upgrade SQL Server Express 2005 to Standard Edition
44768: Creating a view to retrieve data from more than one database sql server 2000
44769: Automatic failover failure
44770: xp_getfiledetails
44771: Error running openquery(mdx) through a linked server
44772: File Task Moving with variables...
44773: Strange grouping behavior
44774: Writing Full Result Set from Execute SQL Task into a File using Script task
44775: A transport-level error ................
44776: SSIS doesn't drop table?
44777: PK still shows fragmentation after ALTER INDEX.. REBUILD
44778: Simple Data Flow Hangs
44779: Summing sums from a Union
44780: Save a large string in database
44781: Paging and Sorting Using ROWNUM()
44782: sql server lockup after strange error in log, help please.
44783: How to restrict editing of SQL Server 2005 data via ODBC link?
44784: SqlCeParameter error
44785: Can't connect to SQL Sever 2005 after upgrading from SQL Server 2000
44786: Cannot access Expression Builder via Variable Properties Window (no ellipsis)
44787: Why I got the message as you need to create the many-to-one relationship between the case table and the nested table?
44788: SSAS - Calculated Member Performance
44789: Data migration MSDE -> SQL Compact
44790: Invalid object name 'OlapObjects'
44791: how to create key time column and key column for a case table and a nested table for time series algorithm?
44792: Radio button
44793: Help in Case statement
44794: SQL 2005 Configuration Manager permissions
44795: WITH keyword
44796: Does SQL Server 2005 run on Red Hat Linux?
44797: bcp and ntext SQL 2K
44798: convert integer to string
44799: Access to SQL Error
44800: Snapshot files obsolete?