SQL Server Archive
view full version:
back to formated view
Question/remark about "Referenced relation"
Excel 2003 cube analysis fee-form
Setting columns = to months
Wat's the effective way to improve performance in table using indexing?
Execute a query inside dataflow and use the fields returned to continue dataflow... how?
Append data to a column
Eventhandlers for DataFlow task events
Does SSRS have to create its own database? Or can it use an existing empty one?
with Readpast changing isloation level
Data Type Range
Bulk Insert Task with LastRow = 1
INSERT INTO woes
exporting to excel
Auto Data Extraction through ODBC
Secondary file on encrypted drive path
Reportviewer Toolbar hidden behind Window Titlebar
Page breaks in PDF don't match page breaks in HTML
Incremental process based on Action Code
Excel Source from Variables and data type Issue
Searching multiple tables/columns with containstable
Error sending mail SQL / Hotmail
Connect SQL server 2005 with ODBC drive ¡°SQL Native Client"
Convert SQL Server into DBF or Excel
How to get the Training Error from the Model?
How do I determine a measure's data type in an ADOMD cellset?
Freeze and Thaws functions in SQL server
Running total for Cell Reference in SQL Reports
unattended upgrade of SQL Server 2005 Express SP1 to SP2 not succeeding
Database Mirroring Error
Backward compatibility with AMO clients
Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path
Dynamic Dimension Security using something else than ROLES
SQL 2005 Linked Server connection issues
How do you handle this control flow issue, asked Mr. Newbie
Early issues with Compact Edition
converting varchar to int
MBSA 2.0/SQL Server 2005
Questions about bulk copy insert using 'Memory Based Bulk Copy Operations'
Permissions issue- a previous windows group still has full cube rights
RS2000 Error Impersonating User
How to convert 2005 package to 2000
SQL2005--How to prohibit BackupOperator to restore the database to local workstation server
Number/size of packets at a network level for a MSSQL query Vs oracle vs DB2.
how alter only datatype for existing column
using Case with stored procedure
Output to text file
Alter table is greyed out
SQL Server Reporting Service -Reporting Parameter
Out-of_process error when trying to process a dimension
Issues with Logging option in SSIS
How can I print a field that is in the dataset on each page and show the table hearder on each page?
"...report server cannot access internal information..."
Error converting data type DBTYPE_DBTIMESTAMP to datetime
SQL Server Business Intelligence Development Studio - install
Group Header Alternating color
Package taking 100% of the CPU when it is opened for editing in visual studio
HELP!! Pivot table in SQL2k
Execute SQL Task gives varying errors.
want to block all other db activity while my archive process is running...
Restart SQL Service with a query?
Connecting to another server
sum up number on the time line
Database is read-only.
Column Group Footers in a Horizontal Report
Rounding Modes and .NET Runtime Consistency
Installation failed: error 0x6DDE
BI Studio shuts automatically
Using SQL Server CE in a NON .NET Delphi Application
Cannot Run on this Edition of Integration Services Error Message
Shrinking log file
package 'Microsoft sql management studio package' failed to load.
How to align the text in justify format with SQL Server Reporting Services?
SQL Server 2000 and Internationalization
Writing ETL Error records to a common table
Variable column widths?
SQL Server 2005 Express runtime
Joining two tables with repeating rows
Can columns be added to an error output?
Drop Database failed as already in use - how do I close existing connections as per Management Studio
How can I get back the lost view?
SSIS Flat File Connection Manager Max Columns
User Credentials are getting lost when using shared datasource
connection not found error
How to accomplish this?
SQL 2000 SP4 to SQL 2005 upgrade blocked.
SSIS variable in openquery stmnt
Viewing TSQL queries?
WMI Config Error Installing SQL2k5 Standard Edition
SSIS Error while pulling data from Oracle server
I need assistance please
SQL Agent Job to refresh Analysis Services Cubes
use the reporting services web reference dynamically
INSERT to Text column losing \ characters at the end of lines
Automation of SQLWB
Copy and Past a row
Statement failed not fully quailified
SQLServerAgent cannot start
How to recover from dropped tempdb?
SQL 2005 Licensing
Server DDL trigger event for Database Restore??
failed because T-SQL and CLR types for return value do not match. Need help.
Memory not being used by SQL 2005 EE 64 bit instance
Anything new to expect with SQL Fulltext searching?
Making Reports Customizeable for Users on a .NET site
How do I do "If statement" in SSIS?
An error when instantiating C#-based COM object in OLE DB provider linked to SQL server express
Install error MS SQL SERVER2005
Web Synchronization Licensing?
Joining on a pivot table is sluggish
how to change Windows Auth. to SQL Server Auth. in SSIS packages
SQL 2005 cluster slow installation
creating composite primary keys via sql management studio??
Creating a unique constarint on a multiple null column
Report Manager - Blank Reports Page
DateAdd() in Default Value
How to process partition as processReaggregate in SSAS 2005
Microsoft SQL Server 2005 SP2 Issue
Get the Top 3 record in same table.
can't load SSIS dtsx package
Database Mail Error "Invalid Parameter"
Execute SQL task
xp_sendmail with @query parameter in scheduled job?
Make duplicate db?
How to de-normalize one to many relationships?
Weird SQL Sorting Behaviour
Insert only non-existing values
Package execution stability ?
Changes to data not replicated
restarting SSAS nightly improves query performance
How to do SUM of Average in subtotal cell for the entire matrix
Reinstall problem with Report Services
DTS and xp_cmdshell
Flat File Data Flow
SSIS SQL Server Agent Job Task
HOW TO: Print a report directly to a printer
Stack around the variable 'scriptFiles' corrupt
Some Questions about SQL Express Edition
Programming with c#.NET and variables
How to avoid deadlock with simple update statements
error: Could not find SP upd.sp_MSrepl_xxx_xxxxxx_1
ODBC DSN Issue - Take 2
MS ACCESS SSIS Fails on bad date in ACCESS
How to get data from Primary
USING BI Studio how to create Dynamic Connection String in SSIS Package
Permissions Enable Disable Trigger inside a store procedure
sql server is very slow
problem while creating an ENDPOINT
AttachDBFileName option in Connection String
No New Data Source Option in SSAS
How to get the resulting XmlaWarningCollection in AMO Process?
update and delete query run very slow, why?
Direct vs. Indirect Package Configurations
Semi additive Measures across non time dimensions
Problem with MDX calculation
SQL Server Express 2005 and a Remote Data Source
Error: 1105, Severity: 17, State: 2
Continuous Priniting - PDF (NEVER EVER USE SUB REPORTS IF YOU WANT TO PRINT)
cant add stored proc with "select top @varname..."
AS 2000 DSO loses connection
.net version of Detect Anomalies in Excel
Exception from DBComms.receive.method
Connection issue to SQL 2000 AS using ADOMD - Urgent
Use variable as "IN" list for OleDB command
Simple authorization problem
Install SQLServerExpress Advanced Service with Visual Studio Express
Backup plan for a SQL2005 mirrored database.
ISNULL in SSIS
The database file is larger than the configured maximum database size.
How to get the value of number of rows in groupfooter
Log reader internal
SetComponentProperty - Possible Key / Value Combinations
"Login failed for user 'username'. Reason: The account is disabled. (Microsoft SQL Server, Error: 18470)"
SQL Server 2000 Server: Msg 18456, Level 14, State 1, Line 1 Login failed for user 'sa'.
Web Controls Sample Build Fails
What is the separator of sql statements
Dataconversion: STRING (yyyymmdd) to DATE
Problem Viewing Reports on Server
XML columns failing to Replicate
xml data type query() method return incorrect value
Database Mail - Status sent but email never received
Connection Error: (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.
New to MDX. How to use "links" between dimensions
Where can I find the "Visual Studio Command Prompt" ?
Composite Keys on Dimensions
XML query tuning
Parse xml with declaration problem
Forwarding RS Generated Mail
Can I retrieve a result set from a sp into a variable within a Execute SQL Task?
SSAS - Default Member on Day Date Dimension
Live communication Address book service
Getting data from remote databse
Select the values which are not already in the table
C# and SQL Server 2005, Same Query Different Results (More Rows)
Custom Report Item and Parameters in c#, how do I get them
Report - preview looks fine, but exporting to PDF splits controls!!!Help!!
Query problem involving DateTime column
running packages in a job PROBLEMS!!!
How to create a TVF with a string input parameter longer that 4000 character
Proclarity Installation using SQL Server 2005
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON
Dynamically set different font weight for each text in the textbox
ODBC Driver (for SQL Server 2005) unable to retrive CRecorset's fields values
Auto Update Statistics Asynch and sporadic blocking of throughput
Basic Security Question for remote app
Microsoft Access Database Synchronizer (ADS) RTW
Framework 2.0 changes - TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.
Need to lookup an Oracle Sequence value within a dataflow
Cannot display database properties windows in Sql server management studio.
Problem with Precedence Expression
Some General SQL Questions
Slow Growing Dimension
Switch Simple to Full Recovery Model
Same sql server instance, 2 different DB: messages are inserted into initiator's sys.transmission_queue?
Can you reference a Package using ActiveX Script Task?
Generate Script Wizard takes FOREVER (SQL 2k5)
Sum 2 matrixes
Precision and Scale in a calulated column
how to order by non-key fields in related union tables (For XML EXPLICIT)?
Error while trying to modify one Maintenance Plan
want to calculate business hours
Problem in Drillthrough report
paradox to sql server 2005
Feasibility of Filtering in this Scenario...
Calling SSIS packages from ASP.NET - Packages with file system tasks end abruptly
TSQL - Avoid duplicated rows - using distinct / Group by
SQL Server 2005 Express on Vista Business x64
Sql Express Data on SBS 2003
how to sum up this thing?
How to Capture the ResultSet of EXEC Command in Stored Procedure
"Not a string " error
Grand Total Needed
ODBC bcp_init run time dynamic link library
SQL BULK Copy Problem using C#.NET 2.0
Controlling export formats based on user role
How to create a report using multiple databases
SQL Bulk Export without BCP?
Large database growth out of control
reportserver is asking for username and password everytime i call http://servername/reportserver
SQL Server Management Tools Not Installed
ssis, How to connect to Access database?
Character is not valid
Dynamic Flat File Destination Name!
There has got to be a way to do this - dealing with bad rows in a file
Importing text files into SQL Server - some problems
Dynamic File Names for Raw files created by conditional expressions
Filtering on a date comparison in a dimension table
Dynamic Destination Table Issue - Can't find solution in archives
MSSQL_REPL55012: An unspecified error had occurred in the native SQL Server connection component.
OUTPUT - help with please
get rid of an anonymous subscription
Passing MDX queries to ReportViewer reports
Error when attempting to backup to a second disk file
Unable to Edit or Create SSIS packages or Maintenance Plans
How to select a different Member Name when transfering data from AS400 to SQL
Unable to install SQl Server 2005 SP2 - Unexpected error
space requirements for mirrored server in a Terabyte environment
Newbie Need help with tsql query
split the existing MDF file into Mutliple files as a File Group?
Using Stored Procedures in SSIS
Query to retrieve list of hierarchies in a dimension
Issue in Ipmorting and Exporting Database
SQL Server or SQL Server Agent service account ?!
Setting expressions in dtsConfig
Variable Value: How do I set it from value in flat file at runtime
Does SSRS have to create its own database? Or can it use an existing empty one?
SqlCeParameter.Size limited to 255 characters for char types
Help required using Variables and Comparing them in SSIS
Jumpt To or Subreport Feature Question
Cant show anything in the AS's Cube Data Explorer
Reinstall SQL Server 2005 Problem (cannot connect to <server>)
Connection String and VB.NET
Understanding Error Handling in SSIS
SSIS package failing
Create Table with current date as part of the table name
Problem with Database Mail: ExternalMailQueue missing
I am unable to access Analysis Server with AMO
SQL server 2000 memory problem
Cannot connect to SQL Server 2005 April CTP from remote computer
Porting data to another sql server
How to Refresh database using SQL
Empty multi-value parameter
I need assistance please
mdx script context execution
Flatfile output truncating after 255 characters
NULLS in Execute SQL Task to Foreach container
Index Creation Before Bulk Insert
ACCESS PARAMETER (ssrs) urgent
Invalid object name 'OlapObjects'
Question on moving packages to another server
This message could not be delivered because its message timestamp has expired or is invalid.
Inline table column pass as a paramter for User Defined Function?
the error of the SMTP in Sql Server 2005 notification services
Data Conversion Numeric to date
CAST in SELECT or Data Conversion in SSIS
View database & cubes size
Next CTP date?
Results from Aggregate() are wrong
Prints Everything Big in Direct Printing
SSRS GROUP PAGE BREAK
Analysis Services 2005 Performance Guide goes live!
SQL Server Agent Question
Need drillthrough for just one month--but cube goes back two years
Faster way to do this?
The total is not correct by multiplying measures.
Login failed for user '' ..... Sql Server, Error: 18452 (The user is not associated with a trusted SQL Server connection)
Sql server 2005 Setup fails on Windows XP SP2
Inner join performance
Team Foundation server SP1 installation issue
Integrate more than one SSIS packages into one package
Configuring SQL server express for VWD
Selecting data from SQL table based on a time period
Error in Merging partitions in AS 2005 Sample (Adventure Works DW)
excel export footer is a literal?
Time Parameter expression needed
Dimension Design using attributes?
Sql server Error : 233
Error opening VSA from Script component and Script Task
SQL Server Product Key
Populate flatfile source from variable
Newbie Question: Correlating members across dimensions
SSIS with excel source faile to execute from SQL agent
Keep records that contain certain attributes
SQL data file encryption
Microsoft##EESS and MSDE SQL 2000 on Windows 2003 Small Business Server
Detect Missing Records in Flat File