Hi, this seems to be an easy question but I can't find a quick answer to it. I have an asp page that communicates with a database and I want the following example to work.

I wonder if anyone can advise, I currently have a replication set to 5 offices. Which has been working fine for some 18 months+, then the replication dropped out.

I am programming in VB6 using ADO 2.8. This connection and query works in MS access, SQL server 2000 and Sql Server 2005.

Hi all, I have a recurrent problem with Data Viewers, it happens quite often that the Data Viewer does not shows any data altought I can see that some rows have passed through as there is

I am in the final stages of testing 2005 for our upgrade path... I have 4 catalogs: 3 are attached to large tables but the columns that are indexed are small (varchar(500) or less).

Hi!! I have a report that is exported to a PDF file... Is possible to get an index in the beginning of the file I have the page number at the bottom of each page but i would need an inde

All, I have a file-deployed set of SSIS packages. Each of the packages is set to EncryptSensitiveWithPassword and I have the same password set on each Package.

System.Data.SqlClient.SqlError: The backup of the file or filegroup "CUSTBilling" is not permitted because it is not online.

I am running into this problem when I use sp_addmergearticle and the table contains an identity column. Steps I perform to add the article with identity support.

Hi - I've seen variations on this question in this forum, but none of the suggestions work for me, so any ideas would be greatly appreciated! I have a SSIS package whose functi

Hi I have written stored procedures to create a database with db name as input parameter I need to create a batch file to run the stored procedure with input value given in the comman

Hi all, i've a reasonable amount of experience with MS Access and less experience with SQL Server. I've just written an .

Hello, I finally could upload the package, and from the management studio interface I ran the package and it worked perfectly.

I'm getting the following error back when trying to process in a new measure group into an existing cube in 2005...

I saw a video on how its possible to create a local database so that when the application is being deployed, the mdf file will be deployed with it and will contain the enter data.

Hello, I have a package variable called LatestTableFileDate that is typed to DateTime. I have an Execute SQL Task that executes the following SQL statement against an MS Access 2000 databa

Are the Data Mining capabilities in Excel only available with Excel 2007 How does one implement the data mining in Excel 2007

Here's a weird one: We are setting up a job for the SQL Server Agent via SSMS. The Job Step Type is SSIS.

When i'm trying to install SP2 i always get an error for the Reporting Service. Here is the log for the error: Product: Reporting Services (MSSQLSERVER) Product Version (Previous)

hi guys, i need some help tp write code in order to search the string ( regular expressions) in t- sql. e.

Greg, Thanks for your posting. This is Ali! I have not used Replication monitor for almost 2 weeks and we did not open Replication Monitor.

I'm developing a matrix report with a 2-level drilldown for the rows i.e. parent - ITEM-A, child - ITEM-B. I have added a group to display ranks for the ITEM-B group, which displays the ranks bas

Hi, I have setup a SSIS package that takes a XML source file and imports the data via an OLE DB command(executing a stored procedure) into my database.

Hello, We currently are running SQL 7 Enterprise Edition on a Windows 2000 server. We are looking to move upto the 2005 edition but do not see the need for Enterprise edition as we use the data

Hi all, Can someone tell me where to download the SQL 2005 Reporting Service I looked all over the MSDN subscriber download site and could not find it.

To anyone that can help me we have a application written in straight ASP, we recently upgraded our SQL database connecting to the application from SQL 2000 to 2005

I linked two sql servers (one an x64 sql 2005 server the other a sql 2000 x86 server). The link is from the x64 box to the x86 box and I used Windows authentication to forge the links.

Hi, We have a query: delete from myTable ******* and we get the error: Msg 8624, Level 16, State 1, Line 1 Internal SQL Server error.

Hello, Is it possible to use existing data flow components (Merge Join, aggregation,.

My db is working in simple recovery mode, when I run "dbcc sqlperf(logspace)", I find the log file is very large and the log usage percentage is 98%.

Here is the alter statement that I am trying to use to create a relationship between 2 tables. This does not seem to work on mobile.

Hi, I recently bought my brother a book and installed him the Visual Studio Express Editions as well as SQL Server 2005 Express.

I am trying to understand the limits that are placed on SQL Server 2005 Express Edition. I understand that 4GB is the limit of the data files.

Hi experts, I 'm trying to get countNumber from a select statement in MySQL source. Something likes this: select @countNumber = count(*) from tableName where condition_1 = xxx I use

reference a parameter For instance, I have a table control and in the detail field I have an expression. =IIf(Parameters!Consignee.

i installed visual web developer and SQL server reporting services(sql server express with advanced services) and i already have my database setup).

Hi, I have a stored procedure with a few parameters. One of them is @ProviderParam and it defaults to Null. If a value is passed into that parameter when the sp is called, I need to includ

I was unable to use a local login based on Windows Authentication when adding a login mapping to a linked server using SQL Server Management Studio.

Hello All, I have a report which throwing this error: Cannot read the next data row for the data set ALERTSBYSERVERS.

I have the latest SQLEXPR and the Management Studio. Management installed no problem. I cannot install SQLEXPR due to beta versions of Visual Studio, etc.