I recommend using xcopy. We have several bat files to do similiar things.

you would put something like the below in a bat file.

There are many options with xcopy and I...

It is likely just becuase I am stuburn and stuck in my ways but when you are talking about such a small amount of changes. I still prefer to write...

The only way I could think to do it would be to script all the veiws with drop and then do a search and replace assumig that you are fairly...

I had to use MySQL for a project and I generally find it stable and a reliable way of storing and accessing data. If you are looking for this...

add a forth single quote on each side and that will result in a quote around the date.

select 'EXEC Sproc '

...

I assume at this point you are using the Access database as a front end. The data resides on SQL but you are using Access for the forms and...

No it does not take any time. Ultimatley I would advise moving away from Access all together if possible. we have one ourselves that I can not get...

Here is a link that provies detailed explanations and examples.

http://support.microsoft.com/kb/169960

in access you would actually need to go to the linked tables manager and update that linked table. That should add the index from SQL.

On Sql server an index should be added on the field you are doing the search on. This may not alone be enough to speed up the entire search...

I would try running the dro table seperately. If it is truly not in the tempdb then you will get an error stating the table does not exist but...

I dont see a drop table section to drop the temp table on completion so if you have run this in testing and then you are trying to run it...

Something like this

DECLARE @tableHTML NVARCHAR(MAX);

SET @tableHTML =

N'<H1>Hot Item(S) out of Stock <H1>' +

N'<table border="1">' +

N'<tr><td>Brand Name</td><td>Category Name</td>' +

N'<td>Product Name</td><td>Color Name</td>' +

N'<td>Color Code</td><td>Sizes</td></tr>' +

CAST ( ( SELECT td = categoryname,...

If the 500 GB log file is a result of alot of autogrowth then performance could be impacted.

I would recommend reading the following article.

http://www.sqlskills.com/blogs/kimberly/post/8-Steps-to-better-Transaction-Log-throughput.aspx

Declare a varialbe as int

set the variable to count of records with your where clause so something like this.

Select count(*) from yourtable where column=cluase

then add an if statement before the...