I would just take it offline and then see if anyone screams. If no one does after about a month, then drop it.

But absolutely take a full backup just before...

Sounds like you spend a very large part of your job "putting out fires" instead of making sure that a fire cannot be started. What a waste of time and...

Why not simply use SSIS? It would save you many headaches and errors.

Andrew SQLDBA

Why did MS ever remove the Backup Log with Truncate_only command? This is just insane now.

Andrew SQLDBA

A normal full database backup will not truncate log while the database is in Full recover mode.

I found that once the database was put into Simple Recovery Mode, the trans...

The command Backup Log with Truncate_Only is no longer a valid command in SQL 2008.

I tries that first, only to find out that MS has done away with it. This...

You should Never, ever use an Admin level permission account to run a windows service, use only the least permission level.

And for your question on how should things look.... It...

There should never be an excuse to use a service account by a human.

A service account is meant to run the Windows Service(s), not to be used by a human.

You...

Service Account is used to start the SQL Service and all the other services that SQL Server needs to operate properly. Look at the services MMC, in there you will...

If this is an application that is accessing the database, you would need only one user to grant permissions. You should not have to grant permissions to each user when...

If you have the Counties and Cities in the same table, you need to look at the database design. Very poor design.

You need to place the County and the City...

You can easily use a T-SQL statement

GRANT EXEC on <sproc name>

TO <username>

Check the SQL Books Online, I sometimes get this one reversed.

If you have a large list of sprocs, query...

Question that I have is this:

Why in the world are you storing a string value in a single column in a table. You should NEVER, EVER, store string data in...

Thanks Grant

But not really what I am after.

Thanks

Andrew

I always create one package per task per database. So if anything were to change, I have to only delete the one package and the job that fires off that...