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 derfloh 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: dmando84
  • Content: Threads
  • Order by date
  1. dmando84

    obsolete objects

    Hello, I need to find all of the SQL Server objects, (tables, procs, functions, etc.) in my database, that my application is no longer using so they can be removed from the system. Does anyone know how to accomplish this? Thank you, Dave
  2. dmando84

    SQL Server 2K5 Log file

    Hello, I wrote a stored procedure in SQL 2K5, and I would like to write to the sql log file when certain steps have succeeded. The only way I know how to do this is by using the raiseerror command, but I am not looking to exit the proc after writing to the log file. Any help would be...
  3. dmando84

    XP_CMDSHELL timeout

    Hello, Does anyone know how to disable or set the timeout option in XP_CMDSHELL? Any help would be appreciated. Thanks, Dave
  4. dmando84

    Installing SSIS package

    Hello, I created an SSIS package in Microsoft's BIDS studio and I need to load the SSIS package into the SQL Server. Currently, I have the package saved locally on my HD and when I need to execute it, I either execute it in BIDS or just click the executable package. However, I need the package...
  5. dmando84

    SSIS package moving very slow...

    Hello, I have an SSIS package that basically truncates all tables in a destination database, (over 250 tables) and reloads the same tables from a different, (yet identical) database. The database size is approximately 8GB. This process is taking over an hour to run. Does anyone know if there is...
  6. dmando84

    SSIS package is running slow

    Hello, I have an SSIS package that basically truncates all tables in a destination database, (over 250 tables) and reloads the same tables from a different, (yet identical) database. The database size is approximately 8GB. This process is taking over an hour to run. Does anyone know if there is...
  7. dmando84

    SSIS SQL 2K5

    Hello, I have a question... I am using BIDS to create a project that refreshes a test database with production data, and it seems that SSIS has a fundamental problem with dropping and recreating tables in a database, or deleting the rows in a table. Whenever I select drop and recreate tables...
  8. dmando84

    executing a stored procedure within a SQL view

    Hello, Does anyone know how to execute a stored procedure within a sql view, or if it is even possible? Any help would be appreciated. Thank you, David
  9. dmando84

    displaying error messages using the sqlcmd utility

    Hello all, I created a batch file that runs sql scripts in a specific order. The only problem is that the scripts continue to run even after it encounters and error in SQL. Does anyone know how I can stop the script from running when it encounters any errors? Any help would be appreciated...
  10. dmando84

    SSIS Data Connections

    Hello, I created a package in SSIS that reads data from a text file and loads it into a table. The problem I am having is that I need to change the connection property in the data flow task to point to a database that is different to the database I created the package with. Whenever I change...
  11. dmando84

    Like operator

    Hello, Does anyone know how to use a like operator with a column? e.g select name from table1 1 join table2 2 on table1 = table2 where name like ['%] + 2.name + [%'] I need something like this. Any help would be appreciated.
  12. dmando84

    executing a package in BIDS

    Hello, Does anyone know how to execute a SSIS package in BIDS? MS Books on line is absolutely useless when it comes to this subject. Any help would be appreciated. Thanks, Dave
  13. dmando84

    Sql Server newsletter

    Hello, Does anyone know if Microsoft offers a free monthly or weekly SQL Server newsletter, that is Emailed to your account? I found a few, but they are not Microsoft. Thank you...
  14. dmando84

    Date Functions

    Hello, Does anyone know how to change the time on a column of datatype datetime? I forgot how to do this.... Thank you
  15. dmando84

    Insert into select...

    Hello, I using SQL 2K5 and I am trying to use an insert into select statement between database servers. I have both servers registered and open in the object browser within Management studio. here is the syntax I have so far... Insert into ServerName.DatabaseName.dbo.TableName select * from...
  16. dmando84

    SSIS Trademark bug

    Hello, I am trying to import a text file that has some trademarks embedded after the company names. When I import the file I receive a truncation error. I am assuming that the trademark is being interpereted as a binary code of some sort. Has anyone had a problem like this, or is there a work...
  17. dmando84

    Finding a specific column in multiple databases

    Hello, I am trying to find a single column that could be in any of my 30+ databases. Does anyone know the syntax id for this. I tried this query, but it returns an error.... select * from information_schema.database.columns where column_name like 'ProductID%' Any help would be appreciated...
  18. dmando84

    sys_objects

    Hello, I am searching for a specific column name in a database. I am unsure what the syntax is. This is what I have so far, but it is returning an error... select * from sys_objects where col_name = 'ProductID' Does anyone know the correct syntax? Any help would be appreciated. Thank you, Dave
  19. dmando84

    MSFlexGrid

    Hello, I have a MSFlexgrid that I populated from a SQL Server database. I need to be able to add a row e.g. FName,LName,COName to the flexgrid without making a trip back to the database to refresh my grid. How do I add a row to a grid that is already populated? Any help would be appreciated...
  20. dmando84

    MS Flex Grid

    Hello, I have a Microsoft Flex Grid that I populated using data from SQL Server. I also have 3 option buttons that I am using to sort the flex grid... FName,LName,CoName. I have the grid sorting, but the problem I am having is that I am repopulating the grid everytime the user needs to sort the...

Part and Inventory Search

Back
Top