SQL Server Archive
view full version:
back to formated view
How do I run a macro in Visual studio or business Intelligence??
Add Reporting Services to Trusted Accounts
BULK INSERT "AccessDenied" on remote text file.
Hotfix sqlserver2005-kb933097-x64-enu.exe fails
Slowly Changing Dimensions
Restoring a backup of a Subscriber database to a new database
Data Conversion supported on Standard Edition?
IS Package doesnt ship with password
Need some help to understand T-SQL vs 'official' SQL standards
Automatic failover failure
Database with empty name
JOINs and ONs
Try Catch doesn't catch errors inside a Data Flow transformation Script Component
Cannot Install SQL 2005 Failed to compile the Managed Object Format (MOF) file
Change default zoom setting for reports viewed on Report Manager web site
stored procedures compilation
Scripting changes to the data source view
error reportings -- to except or not expect or return?
alert in clustering
SQL Browser Service EXE
TSQL runs differently in VB NET and Enterprise Console
How to verify if 64 bit client tools are installed
Geting errorT his message could not be delivered because the destination queue has been disabled
Data encyption using symmetric keys outside SQL Server
Sql query for Master Detail Record in One Row
DTS import text file
How to delete rows in tables...
Import flat file data
updates to system catalogs
Linked Server GUI not working in SQL 2005 SP2
Script Execution of Report with parameters
I can't debug my SQL Server project
database mirroring - between 2 production servers
Trouble creating Maintenance Plan
SQL Query to pickup selective columns based on parameters
Temp Table Insertion Problem
SQL2005 Tools don't work unless all components installed on C:
SSIS (DImension and Fact Tables)
Running SSIS package using .Net code
help me quick(very bad)
SQL Server 2005 remote connection failure
Management Studio Deployment
User Defined Date Range in Stored Procedure
Can't connect to linked SQL server: Cannot initialize the data source object of OLE DB provider "SQLNCLI"
Function is 10 times slower than SP
If I had any hair left I'd pull it out. How do I create a SSIS Package which creates a table that never expires?
IBM DB2 as Data Source
search for last non-null field in a row?
How to Query to get the Numeric fields Only in the Table
IBM DB2 as Data Source
Report Builder, limiting the Dimensions
I can't get this view faster
sql server express connection string and login
make Count(*) return zero
Problem writing data after upgrading
Checksum transformation is not detecting my change
the DB freezes for 5 or 10 minutes
Currency Conversion SSAS 2005
Can I do Regular Expressions using TSQL in SQL Server2005?
Will User's permission be overriden by database role?
Question on Deployment
How to Capacity Plan for CPU and Memory for a new SQL SERVER Setup
Can't connect to SQL Sever 2005 after upgrading from SQL Server 2000
Problem deploying 2005 OLAP cube to same server
How to return just any one row among so many?
BULK INSERT into a table variable
Keyword "Nothing" as the scope.....
Developer edition feature comparision
Foreach endless loop
Cannot restore databse from file
Help with Importing Interbase data
Question on fact(degenerate) type of fact table relationship
[DBNETLIB][ConnectionWrite (send()).] General network error. Occurs when SQL times out on new Windows 2003 sp2 server
nvarchar(max) gets truncated at 4000 chars(?)
Data Flow split
Sql Reporting Services 2000 Using VS.NET 2005
How to get Top 3 records in the group level?
Cannot fine the object ˇ°MSmerge_ctsv_... Because it does not exists or you do not have permission.
Full-text search does not automatically update index when CHANGE_TRACKING AUTO
Report Manager - Blank Reports Page
email from stored procedure
How to pass parameter value for Value_List in Where [ColumnName] In (@ParameterName) Clause
SQL Server does not exist or access denied
PIVOT with dynamic columns names created
complex query - need help
How to reset toolbox for SSIS visual studio Projects
A tough nut to crack
Very basic trigger question
Search for position of character in a variable length string.
Problem Processing Return Value of Webservice
Copy Database error: [LOG]Unable to read local eventlog (reason: The parameter is incorrect)
SQL Server Express Hangs
Important Catalog changes required : adhoc changes not allowed.
Dynamic updating of Parameters.
How can I convert DateTime to Date as Parameter??
not seeing end of record
I hate the maintenance CleanUp task :=)
invalid column name 'rowguid'
PROBLEM WIHT OPENROWSET FUNCTION
Encryption of trasaction logs
SQL Server 2005 SP 2 December CTP authentication fails
how can check the time?
retrieve 1st and last record of each customer
How-to expose SQL Server to the Internet from behind firewall?
Update on multiple optional criteria
Can you run 32-bit and 64-bit SQL Server simultaneosly on same 64-bit Server?
"Flat file"-connection: tuning of the data types
Basic business rules question
sql 2005 log file grow too much
SQL 2005 SP2 x64 full-text catalog
Determine Updatable Transaction Replication Mode from Client side
SQLVDI error in eventlogs, caused by ntbackup
Conditional page breaks in SSRS
Expression editor on Custom Properties on Custom Data Flow Component
Using a stored procedure to reinsert an image
Problems connecting to server using Management Studio
SQL Server Express SP2 disabling SA account
INSERT rows while SELECT returning large volumes of data against same table
Track Stored Procedure Changes
Unable to create a Login of Domain User Account on SQL Server 2005
Using reporting services for multiple clients (databases)
Outputting selected multivalued parameter to textbox
Creating SSIS package failed
SQL Agent Errors-- subsystem could not be loaded
HTML and Full Text Search
How to create a Folder using a SQL Query?
False "LIKE" hits
How to split one report into many file based on volume.
Report Designer Report that queries a Cube Model
update the same value always returns "one row affected"
SQLFetch and SQL_NO_DATA
Query that works in Management Studio, fails in Reporting Services
utility for sql server licensing
Cross Database Join in a Data Source View
Login failure issue with Crystal reports connecting to SQL Server 2005
Calculated Measure With Conditions
How to edit a asp.net2.0/C# project in VS2005, Plz HELP
SQL Execute Task
Sql error pertaining to @@Identity???
is it possible to specify the last value as a datallabel on a line graph
Copy Database Wizard Problem
Rollback for a demo database table
Create Instance of Notification Service
How to store OR get Time value in a column
How to access the data from a custom data mining plugin ?
No Summary page in Management Studio
XML Parsing Error in Package Execution
Help me convert date.. Urgent please
Consuming secured webservice in SSRS
Compressed snapshot with push subscribers
Question about IIF() function?
what is the best solution?
Setting Null values will '0'
Hundreds Of VIEWS
VS 2005 SQL Express Edition will not install
CONVERT DATETIME to VARCHAR with code 106 does not show long month
Fuzzy Street Address Search Code
Dynamic destination address in SSIS packages
Need help with query
Trying to return DISTINCT COLUMN data with varying information
Report Manager Virtual Directory
Cannot log into database
Error "Not enough space for temporal database" when processing Decision Tree model
How do set send mail task?
SqlServer 2005 full text search
HOW-TO Change "text" column to "ntext" that is NOT NULL
insert query results to "where in ()" query
Trigger(its very urgent)
SQL 2005 DB Error
There's just no escaping it... data containing quotes ruining CSV files
Weird behaviour of INSTEAD OF INSERT TRIGGER
SQL 2005 server is not showing in the network after installing SP2?
AS400 and SELECT *
SQL Reporting Services - Calculations between report matrices
Inserts taking longer time
Sql2005 standard to Sql2005 enterprise edition
Incorrect syntax near 'ISNULL'
Configuring Reporting Service Add-in for sharepoint - HTTP status 401: Unauthorized.
How does SQL Server 2005 work with old applications
Complete Idiot calling all intelligent lifeforms
SQL Server 2005 "Login failed for user" sa
SQL rebuild system databases
Initial Replication Setup - HELP!
Sequential Statement Processing
Partitioning tables and filegroup stuff
SQL Server 2000 job permissions
FAct TABLE LOOKUPs data
importing ArcInfo data
SQL Server 2000 - FOR XML EXPLICIT And XSD validation
SQL Server 2005 Developer's Version Installation problem -- No SQL Server 2005 Studio Manager gets installed.
SQL 2k with RS 2005
DISTRIBUTED TRANSACTION QUESTION...
can I monitor what goes in tempdb
Errors using multiple parameters in a SQL Statement
Mappings question in OLE DB Destination
Need protocol name for file transfer in SSIS
SQL Server DSN Configuration
How to Rebuild master database in SQL 2005 SP2?
Get Name of Column in Error Output
SQL Server 2005 SP2 'dirty' install results in SSIS failure
Table-value Function or View
Backup MS SQL 2005 -> Restore MS SQL 2000
Problem when using linked server
GO Makes things Hugley Faster
Microsoft's Connectivity White Paper is officially published
Noisewords during insertation and during query
Need help in matrix to find % diff.
What is the best most efficient performant way to do a Control break in SSIS?
Error downloading initial snapshot
Help in Case statement
what is different in the version I downloaded this week from the version I downloaded in March?
SQL Server Agent - Opening Existing Job vs. Creating New Job
Grouping Column Currency by Range
Flat File Connection Manager problem
Date(only) and Time(only)
If statement in Execute SQL task
scheduled task and .exe location
"for xml" statements behave differently under MSDTC
data load from the different server
Encryption using MS SQL 2005
Not enough storage is available to complete this operation
Delivering a large nu of reports together
The SQL Server Service Broker or Database Mirroring transport is disabled or not configured
Server Name Issues
Issue with OLE DB Command while writing to DB2 database
Mixed bag questions (only 13)
Provider String for linkedSrvr OLE DB Provider for ODBC (to Oracle RDB)
Login failed for localhost/aspnet - please help, been trying for week to solve
How to edit a SQL Server table from MS Access?
Datetime parameter problems
How much does SQL 2000 Reporting Services Cost?
SQL Server Developer Edition Upgrade
Many to many relationships
What can I do with garbage records in sys.database_files and sys.master_files?
FTP Task Send error
Too many table names in the query sql 2005 merge replication snapshot error
DB2 driver/connection issue
Merge Replication and Interactive Resolver
A Simple Problem. But....
Dimension with attribute that has value 0(zero)
VB database connection blocked
silly question please help
How to change the target table name in SSIS package(not designed from scratch but was migrated)
Deploying cube changes to multiple sites
Remote Executiong - SSIS
On a lighter note - What equipment do you use to develop?
SQL Server Beta V 9.00.0852
Conditional fields based on export type
Derived column not processing any records
Not able to open or edit a cube.
outstanding debts calculation
Merge replication problem
RESOLVED RESOLVED An attempt to attach an auto-named database for file <file string> failed >>> But ONLY after SSE reinstall
Cannot see network drive when doing restore from disk
Parse sting with quotes in SQL
Error "Connection Could not be made to the report server" when attempting deployment
Viewing RS 05 Native Mode reports in MOSS2007
Ho to make data source web method execute once per a report?
Long duration Pre-Execute phase
Report Builder: Date filter, Relative Date
SQL Server 2005 Developers Edition Upgrade to SP2
Archiving AS 2000 Database to a network backup server
(Newbie) Trying to get rid of NonEmptyCrossJoin
Mirroring without domain and using "sa"
Question with Flattening / Denormalizing a Hiearchy Dynamically
Help required using Variables and Comparing them in SSIS
Getting Data based on ordinal position of the column in the table
How SQL Server do syntax check?
how to target the file name with date variable
Where is the database selection dropdown in Management Studio?
Errors when going from AD Web Site to NON-AD SSRS
Private deployment of SQLCE for C++ app
Convert to float value
Adding empty space
Derived Column error:can't change datatype
A quick question
The problem of interface language of Management Studio
Stored proc in cache Permanently
Gap between header and Body
2005 Mirroring for Centralized Backup?
Trigger in the Subscription database - Transactional Replication...
Reporting Services e-mail delivery extension error
What is the fastest way to add new named instances to SQL 2005?
How to create nested sql scripts
2nd Post - Problem installing SQL Server 2005 Express SP2
Questions about 32- and 64-bit ODBC
Cant sort archar variable values in to ascending order
how to change visibility of a column group in a matrix?
Need all rows within each group to be shown on 1 page
Matrix - How to calculate % of row?
How to make a File Share Subscription running on Vista?
SQL 2005 to SQL 2000 Update takes forever
ReportViewer and HTTP 401
Sum values in a column
Can an authorized user like SA create a table which the owner is any users who use the application?
SQL Server 2005 connection error on Vista
failed to convert parameter value from string to guid
Get week number with changed @@datefirst question
How to Only Backup Principal, not mirror
bulk insert from text file
SQL Licensing in test lab
SSIS - OLE DB - IBM DB2 - SQLDUMP - more dumps than works....
A significant part of sql server process memory has been paged out
Question about connection pool from the servers point of view
User 'Unknown user' could not execute stored procedure - debugging stored procedure using visual studio .net
access denied to data source reporting services 2000
Methods to generate ER diagrams programmatically
Estimating growth of mdf file size...
how to solve this query
GROUP BY FUNCTION
Getting Items that were ordered alone
many-to-many parent-child relationship in the dimension hierarchy
Joins on 3 tables
Cannot insert duplicate key row in object 'dbo.blabla..' with unique index 'Idx_blablabl'. The statement has been terminated. at
Select count(*) "up to"
SQL Server Management Studio - "Save Results As" why no TEXT file option????????
Need help to prepare an OLAP dataset for a report
Null value threatment by SSAS
Excel 2007 Issue (KB 929766) for Cube Reports; Doesn't Make Any Sense
Enable User Instances in SQL Server
MDX Calculations Script updates
Insert statement from one table to another
processing knows dependencies within a Parallel tag?