Search results for query: *

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

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

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

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

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

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

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

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

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

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

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.

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

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

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

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

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

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

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

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

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