Greetings everyone, I am seeing a particular problem in the XML Source Editor "Columns" configuration where it is not persisting the "Output name" selection.

Hello, i need some help on this... I need to make a job that execute a procedure at 7 am , and other at 8 pm, can any one give a hand with this Regards

We have about 150 SQL servers and basically we're considering the pros and cons of installing SSIS on a central SSIS server - that is responsible for all DTS jobs - as opposed t

I have an MDX statement to return a prior period result ([Dim Time].[FullDateAlternateKey].CurrentMember.Lag(1), [Measures].

Hi Edward, I have tried to go to the Partition tab of BI Development Studio. When i click the partition tab of the Development Studio, it discards an error that " An error pr

About a week and a half ago I started having problems with SSMS on my local machine. (Prior to that SSMS had been working mostly without issue.

I have seen other places where this question is asked, but I am still not seeing the answer clearly. If I have many groups that are collapsed and I want to expand them all at the same time, it there

Hi, I have 2 separate clients experiencing this problem, Both systems are Win 2000 Server with Small Business Server 2000 (SP4)

Hi! I have a HttpConnection with an url to an existing webservices f.ex. http://myweb/ws/ssis.

Hello Let me refine this with an example: Date Location Horz. Group Horz.

HI, would like to know how to give execute permissions for all the stored procedures in a database at one shot. please advise.

I started getting this error when I tried to start my local SQL Server yesterday and nothing I do seems to help: Error: 17182, Severity: 16, State: 1.

I have a database that stores date and time in the Unix time format (seconds since 01/01/1970). I need to develop many reports where a DateTime parameter is converted to the Unix timestamp

Hi Guys, I am having a little problem with databinding with multiple tables. I have two tables in my db - Categories -----------

hi all i have created a store procedure that works fine on sql server 2005 exprees, it uses the temporary table #TEMP.

i am migrating access database to sql server2005. there is field with datatype "MEMO" in access. can anebody tell me what is the compatible datatype for memo in sqlserver2005 I tried w

I've got an application that's supposed to use a combination of Windows authentication and Custom authorization, here's how.

I have a column that contains a field I use for grouping. The field prints in both the page header and footer, but not the detail section.

I am trying to open reports through an existing application. When I click the button to run the report, the new window opens, appears to be trying to load (the windows logo in the

I have an SSIS package where I have directed the error output to a Flat File Destination. The issue is that there are some bad entried in a set of log files, where the source

Hello, I would like return in a file the duplicates lines from a table. Is it possible with a composant Or must I use a sql request.

Hi all, I have two servers one is 32-bt SQL 2005 with sp1 and ther other is 64-bit SQ: 2005 Sp2.

On random occasions, our SQL Server instance will just hang and the users will not be able to use the application until we restart the SQL Server 2005 Service.

Every time I try to remove 'condensed type' from the custom table view (working in database diagrams) the MSE crashes on me, as soon as I push the < button to remove it from the list of column

Does anyone have a routine that returns results like DBCC MEMUSAGE used to return in older versions of SQL Server

Hi How can i eliminate duplicate records from a single table There is a surrogate key in the table and i just can't seem to wrap my head around the layout.

I have this line in my script component and it's not producing the number with dashes. Row.TAXIDNO = String .

Hi , I have a SQL Server 2000 database on my C drive. Over the weekend my C drive got full due to my transaction log files ballooning up.

I just upgraded an existing sql server 2000 installation with the RTM sql server 2005 (developer). I went to work on a database that I've been working on for a couple of weeks before the upgrade, and

hi friends i have build a cube upon a database say xyz1 now due to business requirement i have to rename the database as xyz.

Hi Folks, I'm having a problem showing my boolean default parameter on report server in our test environment.

Is there any recommended way to format and export a report so that it can be modified in Word if purchasing SoftArtisans OfficeWriter is not an option

I had to uninstall SQl Server 2005 Developer Edition because of hardware requirements, and reinstall Express Edition download version.

Hi all--I am writing a DTS package looking to back up all databases in sequence. I am calling CDOSYS in a stored procedure from support.

Hello. I have a SQL table with one column that has the type = image. I have a Stored procedure that inserts an image into that table.

Hope this is the right thread, When you backup with Mirror Is that concurrent to those devices and if so, what happens if one fails does the entire backup fail

Anyone else had this problem I think I had a beta installed at some point. After a dozen attempts, I got SQL Server Express to install, but I had to change from the default service name

We've installed the Oracle provider for OLE DB on SQL Server 2005, which has the default collation (SQL_Latin1_General_CP1_CI_AS), and we've created a linked server for the Oracle 9.

I have an excel report, with 10 columns on it. And each column has auto filters on it in Excel. When I develop this report, in SQL Reporting services 2000, how do i get the auto filters on the re

Hello I'm just learning SQL, here's my problem. I have two tables. I'm trying to extract information from table 1.

How do I use the execute process task I am trying to unzip the file using the freeware PZUnzip.exe and I tried to place the entire command in a batch file and specified the working directory as