Viewing 15 posts - 27,631 through 27,645 (of 39,769 total)
Use the COPY ONLY option for backups. This won't break the backup chain.
July 28, 2008 at 9:32 pm
When you created the backup, you striped it across two files. This is a common mistake and the interface doesn't really alert you to this fact.
When you do the backup,...
July 28, 2008 at 9:31 pm
With files you can create new ones without issue. With tape I think you are always appending or overwriting the entire tape, not something you want to do.
July 28, 2008 at 9:11 pm
There are arguments either way. It's obfuscation at best, and will fool some automated tools. If you expose to the Internet, I'd do it.
Internally, easy for someone to port scan...
July 28, 2008 at 1:28 pm
I somewhat like the solution above, but honestly this is something you'll run periodically to check on space, files, sizes, etc.
I'd schedule this to run on each server, make it...
July 28, 2008 at 1:27 pm
Not sure if this is still true, but once I had edited maintenance plans in pre-SP2 servers with SSIS, I couldn't open them in the maintenance plan designed and had...
July 28, 2008 at 1:24 pm
Thanks for the update and glad things are working.
As an FYI, auto close isn't recommended in production because it causes delays when accessing the database. Typically the resource savings isn't...
July 28, 2008 at 1:24 pm
sp_change_users_login is a way to sync logins to users.
If you are moving databases, typically you move the logins once, then each time you restore, you might have to re-sync things.
July 28, 2008 at 1:21 pm
I might agree the question is vaguely worded, but arguing that once you supply a seed you don't have to supply one the second time seems nitpicking.
Also, getting multiple records...
July 28, 2008 at 10:02 am
Exams are given at Prometric or VUE testing centers. There's no real difference between them.
July 28, 2008 at 10:01 am
Why would adding a select or a parameter seem like a bad idea? Does the extended property somehow imply less resources are used? It's likely a select in and of...
July 28, 2008 at 9:55 am
Please don't cross post.
Discussed here: http://www.sqlservercentral.com/Forums/Topic541955-146-1.aspx
July 28, 2008 at 9:53 am
You'd have to use firewalls/routers to handle this at a network level. I'm not sure that SQL Server can do anything here. hostname/IP can be easily spoofed.
July 28, 2008 at 9:53 am
Can you explain what you are trying to do or what your scenario is?
This seems like an interview or test question. Please show some effort to work on the problem...
July 28, 2008 at 9:51 am
Viewing 15 posts - 27,631 through 27,645 (of 39,769 total)