Search results for query: *

Hi, I need to programmically return capacity statistics on each analysis services database and ideally each cube in the same way sp_helpdb did for a database. This is so I can write some capacity planning reports. Any help would be greatly appreciated.

Hi, Does anyone know where I can download the DEP for use with the SharePoint Report Pack. The url in the readme points to a site (godotnet) that has been shutdown? Any help to find this would be really appreciated or perhaps a work around or alternative product.

SQL Server 2005 enterprise

Hi, I'm setting up a new data extraction process which will allow the user to pick certain columns, tables and databases to extract data. I have a stored procedure that brings me back a format like this ProjectName AccountSpecific SchemaName TableName ColumnName Test Project N...

Thanks SQLDenis, you've confirmed my suspicions.

Hi, I BCP'd some data out from a table into a ~ delimited text file. I now want to Bulk Insert the data back into the original table structure. BULK INSERT amastact FROM 'D:\Downloads\AssetTables\amastact.txt' WITH (FIELDTERMINATOR = '"~"') However the first column in the table is a timestamp...

Hi mrdenny, It doesn't even create a log entry and sending the test mail. Previously it states 3 entries The mail queue was stopped by login "mylogin" The mail queue was started by login "mylogin" Activation succesful

Hi, I'm trying to setup database mail using SQL Server 2005 enterpriwse edition sp2. I can configure the profile and accounts correctly and the messages become queued but not delivered. I intially thought that a virus scanner was preventing Databasemail90.exe from running or it was being...

Thanks Paul I see them now, have they moved the menu option between service packs or something?

Hi, I'm running SQL Server 2005 Enterprise edition sp2. My account has the sysadmin role. The problem is I can't seem to find the custom reports menu via the summary tab. I have selected "Open Object Explorer" on Startup. I can't even see the summary tab. Does anyone know why this might be?

Thanks MrDenny, thats fantastic.

Hi MrDenny, Sounds Good, I presume this is an undocumented sp. I need it in the SSIS solution as its a step in one of the packages I need in the datawarehouse ETL. I'm guessing I could put this in a simple execute SQL task. Have you an example how I would use it in this scenario? Also do you...

Hi, I want to update statistics against every table using the for each container. I've dragged the foreach object on to the control flow page and set the enumerator to be for each table and added a variable to capture the table name. I've then dragged the execute SQL task into the middle of the...

Thanks Mo for the reassurance I'm not going crazy. I'm starting to think this is a bug with Reporting Services, I couldn't even input the dates at development (before deployment) until SQL Server service pack 2.

SQL Server settings British and the logins again English British

Hi, Have you looked at the tables within the ReportServer database within the SQL Server Management Studio?

Hi, I'm running SQL Server 2005 Reporting Services version 9.00.3042. When setting the default values of date parameters its passing the date through as an american date so 31/12/2006 would be 12/31/2006 causing an error. The regional settings are uk on the client operating system, the visual...

can you sum a unioned result set, the answer is yes easily with a derived table select sum(amount) from ( select amount from tablea union select amount from tableb )a

Excellent, thanks for this MrDenny

Hi is it possible to replicate from a SQL 2000 table to a SQL 2005 table?