Windows Tech >> SQL Server >> Archive Page 126

view full version: back to formated view

43751: Processing Mining Models & Structures via SSIS
43752: Prevent backup and restore on different system
43753: Update Gone Wrong
43754: Installing SP2 directly over SQL Server 2005 without sp1
43755: How to select maximum of year-month in Reporting Services ?
43756: "loop" a package in script task?
43757: SSRS and ASP.Net and Windows Integrated authentication failure in Internet Explorer
43758: MDX - Remove a certain member from the total
43759: Strange Problem with IBMDA400 OLE DB Provider
43760: Trigger for history evend
43761: Access connection count at the same time
43762: The semantic model is not valid. Details: The element 'Entity' in namespace
43763: OLEDB Destination Error in SSIS Package not returning error column/desc
43764: What is the SQL Server 2005 Dynamic Port Range?
43765: Multiply measure by dimension members in MDX
43766: MDX TopCount
43767: subtracting values in columns
43768: Conditional Report Parameters
43769: I cannot log in with sa user (error 18452)
43770: create views in stored procedures?
43771: Dimensions, Table Joins, and Missing Elements
43772: SSIS - Data Source password lost when imported into Integration Services
43773: SQL Server 2005 how to improve performance for inserts
43774: " 'Variables' is not a member of ScriptTask..."
43775: linear regression with nested explanation variable
43776: Subquery returned more than 1 value but work FINE (field_xxx=subquery)
43777: Fuzzy Grouping performance issue
43778: How: Force aggregation design on the lowest levels of dimensions in a cube
43779: Schedule Monthly Job -Skip first friday of every mon- Run on Mon
43780: Job failing
43781: Report Server (MSSQLSERVER) cannot connect to the report server database
43782: Creating a Report to PDF in a folder?
43783: SQL Construct
43784: Invisible controls durig runtime
43785: How to Remotely Connect to SQL Express using SQL Authentification across a LAN.
43786: SQL server 2005. Please advise on license
43787: Question on the Dimension Wizard
43788: row data cannot be set
43789: SQL 2005 - Migration from SQL2000 / LEFT OUTER JOIN
43790: Query does not use aggregations when role playing dimension is added
43791: Dimension Properties and Dimension Attributes not found
43792: error (rsAccessDenied) - 'NT AUTHORITY\NETWORK SERVICE' are insufficient
43793: Parameter in the Report Url to Print
43794: Import and Export Data Wizard missing in SQL Server 2005 Express Edition
43795: Error running script: 80sp4-tools.sql installing sql 2000 SP4
43796: using native code to synchronize
43797: Permision denied performing FTP Task
43798: Do SQL Analysis service needs a separate database ?
43799: Displaying the dates in a column.
43800: SSIS FTP Task Variable Remote Path invalid
43801: Cursor @@rowcount returns 0 everytime
43802: one-time data flow lookup
43803: Move Log Files From C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\LOG To E:\MSSQL Logs
43804: cmd.ExecuteNonQuery question..help please
43805: How to use a stored procedure inside select query (sql server version 8)
43806: Matrix grouping
43807: Lookup on input
43808: SQL Server CE 3.0 performance lost.
43809: Need a task that will zip a file prior to upload via FTP
43810: Trouble with Transfer SQL Server Objects task
43811: to change the database name in all my SQL jobs
43812: In a typical organization who would supprt SSIS
43813: Query to find table updated in last one hour
43814: how to make query run faster?
43815: Invalid URI: The format of the URI could not be determined
43816: Counting connections
43817: snowflake dimension - Role-Playing table
43818: How do I drop a restored database named "distribution?"
43819: Removing Rich Text formatting from a field
43820: Problem with SP_Addlinkedserver when used in stored procedure
43821: Is there ever a need for more than one TRANSPORT route
43822: VS2005,ASP.NET licenses
43823: Passing value to a variable
43824: Reporting Services & Sharepoint Intergration (License query)
43825: restore databases 7.0
43826: Common Table Expression Issue
43827: Executing Dynamic SQL larger than 8000 characters
43828: RMO: Replication between SQL Server 2005 amd SQL Server 2005 Express
43829: Vista IIS7 and asp.net reporting services wont deploy
43830: XQuery returning too many rows
43831: Using declare statements and converting dates
43832: Transaction log full out of disk space
43833: Need help with bit value tables!
43834: Copying database using "Copy Database"
43835: Flat file produced but need line returns
43836: scripting db_datareader
43837: SQL Looping, join, and max select
43838: How to restore SQL 2005 DB to SQL 2000
43839: wizard for creating interface to ssis package?
43840: GRAPH WITH SOME COLUMNS STACKED
43841: sql server 2005 backup schedule
43842: Place results in Colmn rather than rows
43843: SSAS - Semi-Additive measure
43844: Need basic guidance on massive access to sql conversion
43845: Slow inserts
43846: Urgent - No mapping between account names and security IDs was done error !
43847: Sequence Clustering - sample_cases output appears incorrect
43848: error message "Run Repair Utility" when using sqlceengine.repair
43849: What solutions make returning from a disaster easier?
43850: odbc problems with Linked server in sql 2005
43851: XML DML
43852: SQL 2005 50% Slower Than SQL 2000
43853: Update slow(5 Hrs, 14mil rows) on perm tables, however as part of SP using temp tables fast(45 mins 14mil rows)
43854: When to DROP the temporary table?
43855: Is there anyone who was able to successfully retrieve a full result set in Execute SQL Task?
43856: ADO seems to ignore initial catalog
43857: SP's and their content
43858: Default DATE and uniqueidentifier parameters?
43859: Snapshot replication failure
43860: toggled & interactive sort
43861: Hyperlink is not working
43862: Table set to repeat header rows on each page but they don't
43863: Assigning unique sequence numbers across different tables
43864: Time Formats
43865: Using the Command Prompt via SQL Server Agent
43866: WAITFOR (RECEIVE... Causes System.Transactions.TransactionAbortedException?
43867: How to delete or drop a cursor?
43868: ExceptionMessageBox
43869: Doing calculations in Stored Procedure
43870: Variable to pass in the datatype to CONVERT function
43871: Basic SAS Question on aggregation
43872: Invalid Column Error - Any ideas
43873: How do I return data from 2 seperate tables into 1 table?
43874: Time To Execute?
43875: could not upload sqljdbc driver
43876: SQL Server 2005 slows down after a large number of queries
43877: SQL 2005 collation set / sort order
43878: HELP! sp_send_dbmail error
43879: Unable to back up database in MS SQL SERVER 2005 Express Edition
43880: Foodmart 2005
43881: Ad hoc updates to system catalogs are not allowed.
43882: SQL Server Reporting Services Error
43883: please help on creating xml from table
43884: dynamically change the color of the line on a line graph
43885: transferring DB2 data to sql server using ssis
43886: Multiple Items and currentmember
43887: not showing groups when a field value's 0
43888: Load Testing
43889: working with indexes
43890: Dates get alphabetized when report is shown
43891: SQLSTATE 28000] (Error 18452)
43892: SharePoint add-in, deploying ReportModel
43893: A severe error occurred on the current command
43894: FTP Connection problem with "The Password was not allowed" error message
43895: Sql Query to create nested XML Sitemap
43896: Handling merge replication foreign key conflicts
43897: Error: SQL Server Requires Encryption On
43898: Cannot start SQLEXPRESS
43899: SQL Mail sent email appear ??? instead of Chinese characters and foreign accents in SQL 2000
43900: can't connect the database engine
43901: Printing--Font changes
43902: Tables ,sizes, quanity
43903: OLAP, DTS and SQL
43904: IMMEDIATE ATTENTION PLEASE.....
43905: Programmatically Data Conversion component creation
43906: upgrade from 2000 MSDE to 2005 Express - Enable TCP/IP by default & Current Version of SQL running?
43907: Cannot restore my .ABF file...with no meaningful error message.
43908: Data Conversion
43909: Select
43910: This is probably pretty easy....
43911: trigger to count words in field on update,insert
43912: Problem with order by expression
43913: How do i measure bandwith usage for merge replication SQL 2005 to Sql server mobile 2005?
43914: Defining the Scope of SCOPE_IDENTITY
43915: Restart SQL Service with a query?
43916: SSIS package works, but not in SQL Server Agent job
43917: Lookup Component Error: Statement(s) could not be prepared.
43918: Unable to open User Instance type database after attaching and detaching in SQL Mgmt Studio
43919: executing a dymamically built string with an OUTPUT parameter
43920: Return the Last 3 months Data
43921: Maintenance Cleanup task not functioning properly???
43922: SQL Table Import/Export
43923: Import issue for CSV file with quotes around all data fields
43924: Distribution of SQL Server 2005 DB with Full-Text Search
43925: Is it possible to restore from a database backup without a transaction log backup?
43926: SQL Ram Usage Problem
43927: Excel 2007 DataMining Add-in Database on SQL Server 2005 destroyed by using SQL Server Managment Studio?
43928: sql enterprise shortcut
43929: Using Openrowset to retrieve data from a server under windows authentication
43930: Report Layout
43931: encrypting URL
43932: Unable to create subscriber
43933: SQLsvr.exe Process
43934: Universal Indirect configuration file, can it be done?
43935: Join 2 table with our relation
43936: locked cube
43937: Interface-less SMO?
43938: Reporting Services 2005 on Windows 2000 server
43939: is a dynamic user specified connection possible
43940: Rolling back transaction
43941: Error: 26014, Severity: 16, State: 1.
43942: Format date and number!
43943: Log shipping in workgroup environment
43944: Is 64 bit excel driver (of office 2003 or office 2007) available now?
43945: HELP: How do I pass variables from Control Flow to Data Flow
43946: Script Tasks don't run 64 bit Server
43947: No ResultSetGenerator on devices?
43948: Choose the data in a line chart
43949: HELP, error report, Setup Bootstrap\Log\SqlSetup0017.cab
43950: Help with Query
43951: Connect to DataBase
43952: Find Non-Matching End Points
43953: SQL 2005 Database Mirroring - AD required?
43954: HH:MM:SS Format
43955: Unable to open connection string..please help urgent
43956: @@FETCH_STATUS Reset
43957: Truncate and foreign keys
43958: Connection Manager Property Expression Editor
43959: LAG MDX statement
43960: Data transfer from ODBC to Sql Server
43961: The configuration of the AdminConnection\TCP protocol in the SQL instance SQLEXPRESS is not valid
43962: [URGENT] Problem to Restore Database from backup
43963: How to Refresh a Data Source View and autogenerate/Re-Deploy the corresponding Report Model
43964: Strange Remote Connect Issue
43965: Get XML node as 'text' data type
43966: Restricting access to certain folders?
43967: Package Configurations not so portable?
43968: Why is the index not being used?
43969: Error in SSIS package after upgrade to SP2 release
43970: Subreport inside List
43971: "Using Object Data Sources in a Report" - for Web Apps? (VS 2005)
43972: Reporting Service seems to "go to sleep" after a while...
43973: why not TCP/1433?
43974: Deploying Report via Visual Studio to Sharepoint - error
43975: help needed for a query.
43976: Add events as one batch
43977: Help Needed
43978: Need HELP
43979: Changing database collation problem in SQL Server 2000
43980: Load XML files into tables via SSIS
43981: export to excel question
43982: SSAS - Get the diference for a value between date and date-1
43983: Create a new user
43984: SQL Server not visible
43985: Microsoft Access Database Synchronizer (ADS) RTW
43986: Analysis Services Step by Step - connection problem
43987: Calculated Members
43988: Deadlock problem
43989: Deployment Failed
43990: Secure SQL Server + IIS 6.0 Setup - System DSN Problem
43991: best option when master db is not available
43992: Strange Data ( ? )
43993: Rebuild does not appear to change % index fragmentation
43994: Slow Running Insert After Changing OLE DB Destination Data Access Mode
43995: looping through table tom exec an SP many times
43996: Deep copy of child rows + referential integrity?
43997: Compare row values
43998: Connecting (ODBC) to SQL 2005 Express from different domain with trust
43999: How to use switch - case statement in T-SQL..?
44000: Link Server Error: Login failed for user 'Domain\user'. (Microsoft SQL Server, Error: 18456)
44001: can't log in to reporting services
44002: Maximum number of columns in an index
44003: HTTPS access to SQL 2005 cubes
44004: Message --"Configuration option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install."
44005: Permissions for linked server
44006: RS 2005 SP2 in Sharepoint integrated mode
44007: Transaction Log Backup taking a long time
44008: Large AMO-based batch jobs hanging?
44009: Computed measures and role-playing dimensions
44010: Microsoft OLE DB Provider for DB2 in SSIS vs. ODBC in DTS
44011: Why are buffer locked...
44012: Excel Numbers format
44013: indexed views and SQLServer 2005 standard
44014: enable Analysis Services Server encryption for share point to acess SSAS2005
44015: Use SQL Varriables with the "use" command.
44016: Iterative Sql statements / Update operation row by row using ssis
44017: Can I add a named calculation to a measure group
44018: DT_STR error message?
44019: Shouldn't the order of records be based on the key or primary index?
44020: connect using perl (solaris platform)
44021: SQL 2005 SP2 Cluster install
44022: Need some initial direction
44023: VISUALTOTALS SSAS 2005 SP2
44024: Questions about Named Set
44025: Can't connect to Express Edition
44026: Triggers and the transaction log
44027: temporary table
44028: Error Code
44029: DateAdd() in Default Value
44030: Display hirearchy data using data region
44031: MDX Query never finishes
44032: Select (13*5/100) is not 0 it should be 0.65, how?
44033: The page cannot be displayed or downloaded
44034: Prior Year Calculation
44035: ssrs 2005 integration problem with windows Sharepoint server 3.0
44036: Post Back In MS Reports 2005
44037: job retry
44038: Active Directory Helper service aborting upon startup
44039: 2005 replication outside my Domain errors
44040: FTP Task - Delete remote files always fails
44041: OLE DB Source using table name variable
44042: Cube Deploy Error
44043: unable to create Integration services project
44044: How can i split the rows in 2 textboxes - Urgent
44045: Odd behavior (Pagebreaks & Visibility)
44046: IBMDASQL OLEDB linked server "access denied" using Windows Authentication
44047: Error 5172
44048: Add control in TreeView control
44049: Thread safe question on insert
44050: Many-to-many Relationship Issue/Question
44051: pass filename to flatfilesource inside foreach loop
44052: How do i pass a parameter from a SSRS report to the sql stmt in a SSIS package
44053: How to generate any report that the user selects from a list
44054: Data lost after INSERT command
44055: list parameterized dates
44056: phantom error?
44057: Maximum Columns in a Matrix?
44058: Newbie Advice Installing SSRS
44059: Which method to use for synchronization?
44060: Dervied Column - Expression?
44061: URGENT:How to show a appended string to the query results?
44062: Enabling full text search on existing sql server instance
44063: What is the separator of sql statements
44064: First Time Installation of SQL Server 2005 Developer Edition
44065: Invoking a batch file from Report
44066: Microsoft SQL Server 2005 Express Edition Service Pack 2 ..Failure
44067: Native compiler return value: [BC30494] Line is too long
44068: SSAS 2005. x86. Memory Allocation Errors during processing.
44069: Still can't Install SQL 2005 Eval
44070: Crosssell in cube? How?
44071: Compact Edition 2005 Subscribers - Merge Agent failed after detecting that retention-based cleanup has deleted metadata
44072: Help with Creating Models for Multiple Locales
44073: Questions about memory based bulk copy operation(InsertRow count,array insert directly,set memory based bulk copy option)
44074: ReUse common surrogate key pipeline
44075: Oracle Syntax Error.
44076: Datetime format for dimension Please help me
44077: Access to TaskHost from derived Task class.
44078: Loop throught columns of an Excel file using dtsx package!
44079: Newbie question: table polling and select query in a loop
44080: Parameter to pull 'All' on int field
44081: Testing a Custom DPE in Visual Studio Report Designer
44082: Report from SSAS with two different date column
44083: HOWTO Insert into ACCESS linked table via OLE DB Destination Task
44084: Execute SQL Task Error
44085: SCD Type II - Doubt
44086: xml/c# class definition
44087: Performance Difference: Query Window v. Stored Procedure
44088: Query Results to Text
44089: SSIS and datasources
44090: full text indexing
44091: Insert into where data doesnt exist
44092: Disable excel rendering from export button
44093: Returning Results based on Dates
44094: How to re-establish subscriptions DB using Backup of Subscriber Db?
44095: error when attempting to configure a local distributor
44096: Any idea why OpenRowSet to open Excel file doesn't work well in SQL 2005?
44097: Maintenance plans not deleting old transaction log backups
44098: Got an error when trying to import multiple tables from one SQL Server 2005 database to another
44099: Trigger- dump 'inserted' table to temp table
44100: Import Data Form Access To Sql Server 2005