Recent content by SteveMe

Please any help would be greatly appreciated. We would like for the DateTime to be appended in the ReportingServices environment. Without manipulating the filename in SSIS or another tool. Thanks Steve

Does anyone know if there is a best practices or white paper on standards for MetaData for SQL Server 2005 BI. Please advise. Thanks Steve

Does anyone have any idea? Steve

Using static SQL and not Dynamic SQL. I'm thinking somehow someway a case statement would be used. I was able to get this inner join to work for me. However I'd prefer a case statement that would avoid this little trick I deployed. Any help would be greatly appreciated. Thanks INNER JOIN...

I'm looking to buy a log reading tool. I know that apex, red-gate, lumigent and log pi have a tool. However, I don't know which tool to buy. Please recomend. thanks

Denny I really appreciate the input. If after the backup completes and the log file is 30gb in simple recovery mode. Transactions more or less have not been committed to the DB. They are in a waiting mode. If staff where to do a dbcc shrinkfile. Would those transactions be lost or would...

Denny thanks... so while the backup takes place. All new transactions go into the transaction log file until the backup completes. Once the back up completes the transaction in the log file are then committed to the db. Am I right, wrong, partially or way off base? haha Please advise

I did that even gave them the dbo role and no luck

after the backup kicked off? Please advise. Thanks

after the backup kicked off? Please advise. Thanks Steve

Please advise? Thanks

If I re-index on Sunday. Would all I need to do is run sp_updatestats Mon-Sat or should I updatestats with 10% of the data?

Does anyone know how to do this? I'd be grateful. thanks for taking the time to look at my thread. Steve

gmmastros I get an error when trying that Server: Msg 8164, Level 16, State 1, Procedure Checkk , Line 29 An INSERT EXEC statement cannot be nested. (0 row(s) affected)

In QA