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.

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...

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, 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...

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?

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...

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...

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

Hi, I understand its not good practise to join fact tables using the surrogate key of a comformed dimension. What is the best practise to relate fact tables, is it storing the natural key on the comformed dimension or should I be storing the natural key on every fact? or is there another way...

Hi, I understand its good practise to grant execute permissions to your stored procedure rather than the base tables. However when using dynamic SQL in a stored procedure it runs in its own security context meaning you need to grant SELECT rights on the base tables. Does anyone know a way...

Hi, I'm trying to secure a sql 2005 server and setup appropriate logins and permissions. I can create a server login and map them to the databases I want. But how do I prevent the users granting themselves sysadmin rights? At the moment I haven't added them to any server role but they can just...

Hi, Please help I'm going mad! I currently have SQL Server 2005 version 9.0.1399 installed on a server and I want to install service pack 1 to upgrade the version to 9.0.2047. However when going through the installation wizard it will not let me select the option for MSSQLSERVER and on the...