Search results for query: *

I am trying to replace a process that outputs to a text file using osql. The requirement that I have been given is that the text file must exactly match the format & content of the file that osql produces. An example osql command that is used to generate the file is osql -h-1 -w 1100 -s "^" /E...

I'm newbie to Reporting Server. I have 2 Matrix report items on my report, side by side horizontally. I know that these will always have the same number of rows & I want to make the rows across these two items line up. In the design window they do because they are snapped to the grid & you...

Hi, I've just started using SQL2005 & I see that there is now a set of statements: BEGIN TRY ... END TRY BEGIN CATCH ... END CATCH Has anybody got any tips/experience on the best way to use this? I'm calling one procedure from inside another one & I want to get the transaction contol correct...

Dear all, I have a database, its recovery model is full. For reasons I wont bore you with, the transaction log back up was not set up, but a full back up has been running daily. The transaction log is now very large. I have tried to do a back up of the transaction log, to allow it to...

When I go into enterprise manager & open up the databases folder the whole thing freezes up. However if I take a look at the contents of sysprocesses I can see that the process is blocked by an IO_Completion task waiting for access to one of our databases. The database has the status...

I'm new to pivots with olap & need to check the OLAP source of a sheet that was created by somebody else. If I go into the pivot table wizard the back button is greyed out so I can't see how the OLAP is defined. Is there another way I should be looking or I'am I missing something? Thanks

Hi there, I found the answer for how to do <page number> of <pages> in impromptu, but I'd like to do this in powerplay. Can anybody enlighten me? Sorry if this is a noddy question but I haven't been able to find it in the online help or documentation. Thanks

As a relative newcomer to impromptu can any of you gurus tell me if (& how) it is possible to do a report like this: week 1 week 2 week 3 PR Bk 12 34 23 Sh 10 34 24 NPPR Bk 3 4 6 Sh 3 3 6 So in the query popup crosstab...

Dear All, I am having an intermitent problem with BCP'ing data into a MS SQL 2000 database. If I use dbcc inputbuffer to check what is happening with the process I can see the following: SET FMTONLY ON select * from <owner>.dbo.<tablename> SET FMTONLY OFF I think this should just return the...

Hi there, I'm new to Cognos - so pls forgive if this is an easy question. We want to have price in our cube - but this information is valid only at the lowest level granularity of the cube. If we make the price a measure how can we prevent aggregation occuring when reporting at higher levels...

Normally, I make table changes using alter table statements. I am planning to make a change to a table via Enterprise Manager (EM) as I wish to control where the new columns appear in the table. I have read that when you make changes via EM a copy is made of the table whilst the change is...