Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: SteveMe
  • Content: Threads
  • Order by date
  1. SteveMe

    We need to Append DateTime to filename in a data driven subscription?

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

    MetaData Standards for BI

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

    How to find what caused a HUNG Transaction?

    Does anyone have any idea? Steve
  4. SteveMe

    Can I make an inner join conditional?

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

    Please suggest a Log Reader tool and how it's helped you.

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

    Will the backup file pick up transactions that occur...

    after the backup kicked off? Please advise. Thanks
  7. SteveMe

    Will the backup file pick up transactions that occur...

    after the backup kicked off? Please advise. Thanks Steve
  8. SteveMe

    How to give create Stored permissions on a DB?

    Please advise? Thanks
  9. SteveMe

    sp_updatestats questions best practices

    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?
  10. SteveMe

    View: I need to change the DB in all views via a script?

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

    Wrapping 2 stored procedures into a select statement

    Exec checkk 'enrgy80' Exec checkk 'enrgy46' I need the records from this stored procedure into one dataset via a select statement
  12. SteveMe

    How do I get information from another computer using vbscript?

    CreateObject("WScript.NetWork") The above gets the local machine. Please advise
  13. SteveMe

    Best practices: If I backup a DB and restore the DB on..

    a different server should I immedicately re-index? Another question if the source server's DB was just re-indexed, then backed up, then restored on the destination server should I re-index the source servers DB? Please advise
  14. SteveMe

    Best practices: If I backup a DB and restore the DB on..

    a different server should I immedicately re-index? Another question if the source server's DB was just re-indexed, then backed up, then restored on the destination server should I re-index the source servers DB? Please advise
  15. SteveMe

    Backup failed across a network on a shared drive...

    Need help failed due to back up device. backup database mydb to s:\mydb.bak ...... It's failed on the s:\ which is a shared folder Source machine is windows 2003 server target is windows 2000
  16. SteveMe

    Is there a way to get the accurate file size for a particular DB?

    I need to be able to get the total file size of the mdf file size and the ldf file size for a particular DB and they have to be accurate. It appears that the sysaltfiles isn't accurate. Please advise. Steve
  17. SteveMe

    How can I script out the Database Maintenance Plans for a server?

    Please advise. Much appreciated
  18. SteveMe

    Easiest way to find the tables in a stored procedure?

    Any help would be greatly appreciated.
  19. SteveMe

    How can I remove all numbers from a string?

    DECLARE @Str as varchar(200) Set @Str = 'a123b432c' so that @Str will equal 1bc. I will not know how many numbers or if there are numbers in a string. The patterns will be different.
  20. SteveMe

    TempDB shrinkfile help! Please

    I've set the size of the tempdb to 100Gb. Every night I'd like to run a job that shrinks all contents of the data and log file and have it grow back or stay at 100gb. The reason for this is that I don't want the DB to grow out everyday. 100gb should be sufficient. The other day I was told to...

Part and Inventory Search

Back
Top