yea, my higher ups definably wouldn’t go for that. We house sensitive bank information, so any chance of a data leak is out.

I did get a response from another site,...

I will look into the links provided.

Thank you all for your assistance,

David92595

@SSCoach

Can you please provide a resource that shows that full backups do not truncate transation logs? I was under the impression that a full backup does truncate the transation...

yes, we are running in comparison to most sql database a rather small and staic database. I was told that a full backup once a day was all...

@fluffydeadangel

yes it is in Fully Recovery mode

We run two backups a day, one as I'm leaving the office and one at midnight.

Thank you all for your suggestions. I have decided not to run this on start up, and I understand all of your concerns as to running it.

I inharited a...

Can Fields B, C, and D still be manually changed after the fact if need be? or are fields B,C, and D locked as computer values at that point?

okay, so for starters I'm not brand brand new to SQL. Maybe I should have been a bit more clear about that. I've got about a year of...

Either one works, I prefer to define/ know the exact time the query will be using. Which include the time being 11:59:59...

I created it as a stored procedure in SSMS so I could use it for multiple reports and then just add it as a dataset in SSRS.

First Day of Previous...

Thank Anthony,

My issue was an inconsistency in usernames.

Thank you both,

David92595

Never mind, we figured it out. How do I close one of these threads?

ah, I think we have hit a key point.

Half the tables are linked to one DB and the other half are set to another DB, and I now need to...

I'm logging onto the server as the sysadmin, so I should have access to everything. But I am unsure how to confirm that.

I'll do that. Your advise was helpful, but I've been having trouble with the SQL permissions. I've found them, I've given myself permission, but still have had no luck.

David92595