Thanks for all the ideas. I found that I will have to split the job into two applications. The embarcadero tool is great for the sql side. On the application...

Just an idea you may want to try.

Access a different server and set up a link to the server causing you problems. You can then run a command to free...

Thanks, Steve. Luckily I will be the only person working with the stored procedures. Unfortunately, the bar was raised late on yesterday when the system functionality requested was expanded to...

See the post on this site:

Jobs - embed TSQL or Call Stored Procedure??

Posted 3/15/2004 7:12:00 AM

Looks like someone with the same problem but I don't think they attained a complete...

I have written a lot of posts lately on this issue. My recommendation would be:

1. Set a realistic fill factor for the indexes so that you do not have to...

Your question cannot really be answered at it is too vague. You need to decide what functionality you require, the possibility of expansion of datasources, output formats, report sharing, page...

Books on line says:

QUOTE: Unlike DBCC DBREINDEX (or the index building operation in general), DBCC INDEXDEFRAG is an online operation. It does not hold locks long term and thus will...

Steve. The number of indexes will definitely contribute to growth. The only way I have ever found out the main culprits is by taking a copy of the database BEFORE...

I am guessing that the log is filling up because of a mainteneance job you are running. Namely under "Optimizations tab" of the Maintenance plan, the job reorganize data and...

If you do backup the transaction log, maybe you have another job running in a maintenance plan. Look to see if you are running DBCC DBREINDEX regularly under the Optimisation...

Was not on the version I was given. I will download a new version and see. Thanks, Colin. May be some dreams do come true.

If you want something easy to use that even a an average pc user can handle, then you can't go wrong with :

http://www.topshareware.com/SQL-Server-Comparison-Tool-download-10628.htm

I found redgate a bit awkward...

Thanks for that Bill. I will revisit a couple of apps set up before I got here and use in future myself on my vb apps.

I could have phrased the question a little better me thinks.

I was able to come up with a solution:

I use the

select * from mytable where datediff(mi,create_datetime,getdate()) < 120

I thought...

I am not the worlds best when it comes to error handling I am afraid. I have had users have timeouts happen when connecting to a database using ADO and...