I can only suggest that you hire a DBA. There is no step-by-step recipe or template for things a DBA has experience with. Also, every database on every server is...

Sorry, but I do not see any example using Dynamic SQL. I see the examples using straight Transact SQL.

I NEVER, EVER use Dynamic SQL. No matter what.

Andrew SQLDBA

Thanks Michael

No special need, was only curious with this database, since there are multiple filegroups.

Andrew SQLDBA

It is a problem with that service account that SQL Server uses. You are running the services as

That account has permission only on the...

Thanks Gila

I was reading about that. I don't always like surprises.

What about if the database were in Full Recovery Mode?

Thanks

Andrew SQLDBA

Thanks Michael

Those other options are what SSMS put there. I used the "wizard" and then did the "script to new window".

I did a test, but the size of the backup...

You would be much better using a UNC path, instead of a mapped drive. Create a share on the other box, and use the UNC path.

Andrew SQLDBA

Exactly Correct Ed

And it takes so much more time, code and processing power to convert all that string garbage into what you really want, if you only use the correct...

Great, now change the data type to the correct data type in the table. And if possible, change the column name to something much more descriptive. One should be able...

Why have the third form field at all? Why not use a label, since it is not a form field value that you want to be changed. I don't use...

Distance really to a point does not matter. All digital data packs travel at the speed of light. What matters, is what is in between the two points. How many...

Why would you bother, all the data is in the two tables, which you can select anytime. Why would you want to store a bunch of duplicate data. That means...

YES!

Anything that is Dynamic can be. Plus as everyone else has said, it is very poor practice. And poor performing.

I wish that it were illegal for a front-end programmer to...

I would make things easy on yourself. Change the SQL Service Account to an AD account, and not use a Local box Account name.

Was the share that you used first,...

Well, you can either search the table for one, or both.

SELECT

<ColumnName>

, <ColumnName>

FROM

<TableName>

WHERE

Sex = 'M' OR SEX = 'F'

That will select all rows with either M or F in the Sex...