There is so very much more that SQL Server can do for you. I use the SQL Books Online, that is the very Best in my opinion. It uses the...

I would recommend using stored procedures for all your queries. SQL Server is so much different than Access. You will want to use the SQL Data types, and re-think all...

This is the code that I use. I have a DatabaseMaintenance Database that all my maintenance code is stored and runs form

------------ Backup Database ----------

BACKUP DATABASE [<DatabaseName>]

TO DISK...

I use C# as my script language. This is from SQL 2008

But in C# the DTS variables use brackets not parens.

Dts.Variables["FileName"].Value = FileName.ToString();

Place some of the other variables into your...

Sure, write your code in a sproc and execute the sproc from a SQL Job. Very simple.

Andrew SQLDBA

SQL Server can very easily pump all that data in. You would not lose any data if done correctly.

You cannot go renaming objects once they have been created. There are...

I have been using SQL Server for close to 25 years, I am still learning. It is every changing for the good.

I am certain that if you think about a...

Yes, SSMS and you use stored procedures for your queries.

There is also something that you may want to use. Schemas. Create a different schema name for each distinct item. Perhaps...

First thing, always use the correct data type to store data.

You could query the column and use ISDATE()

UPDATE <TableName>

SET <ColumnName> = NULL

WHERE ISDATE(<ColumnName>) = 0

You could then CAST or CONVERT...

for one thing, Database Design does not change depending on the application, to a point.

You use a fully qualified name

Database One has one Table named Person with one Column named...

for one thing, Database Design does not change depending on the application, to a point.

You use a fully qualified name

Database One has one Table named Person with one Column named...

Jack

I did not design this database, I would never use char data types. For this, and many other reasons.

Andrew SQLDBA

They are CHAR data types. I want to be able to trim the blank spaces that are generated in the Insert scripts without modifying the data types.

I Never use International...

Thank you for your advice, I found it.

I feel silly asking now. LOL

Do you know of a way to NOT script all the blank spaces from a char data type?...

I have not been able to every find that SSMS will do that. I was hoping that someone had found a way.

I have the SSMS Tools. So how would I...