Nothing is off topic, and as long as someone responds, might as well keep it going here.

I agree with Jack, too much loosey-goosey activity with retirement funds. I tend to...

You performed a striped backup. The backup of master went to two files, not one and you are only specifying one file.

Unless you find the other file, you cannot restore.

Have you checked permissions? the server might not have the rights to get to the Access file.

The thing you need to determine is why your log files are getting so big? Perhaps they need to be big, perhaps you do not have a proper schedule for...

It may or may not help. You have to examine execution plans and look to tune each part of it. There's no way to answer a general question like this....

What do you mean "trace"? Do you mean debug? there is no debugger in 2005. You can put the values or result sets into a table somewhere or you can...

Views cannot be created from stored procedures. They are created from tables.

http://msdn.microsoft.com/en-us/library/ms189918(SQL.90).aspx

http://msdn.microsoft.com/en-us/library/ms187440(SQL.90).aspx

Andy has the right idea, but why can you not just grant db_owner to a user as a role. This is the same as dbo.

They certainly need to evolve. They've been mismanaged for years, counting on cheap oil, big, expensive cars that they want people to buy every few years, a bad model. Not...

http://www.sqlservercentral.com/articles/Security/freeencryption/1980/

I'm not sure what you mean here. You haven't provided info that would help us write a query. Is this the salesman field? What should the result look like?

Also, why...

Yes and no. SP3 is a rollup of hotfixes, but because of the delays in testing it, there were fixes that got into CU 10 and CU 11 that didn't...

Hey, JOIN was capitalized. That should have been easy. Sounds like perhaps too much egg nog over there before answering the question 😛

Sure. Well, industry might be a strong term, but there sure are lots of used cart lots, parts dealers, insurance companies, etc. 😛