Viewing 15 posts - 12,271 through 12,285 (of 39,963 total)
hany.helmy (7/14/2013)
July 15, 2013 at 9:38 am
L' Eomot Inversé (7/12/2013)
July 12, 2013 at 5:29 pm
I'm not sure what you mean about insecure if you have the cert without the password. You could have a blank password, but in that case you'd technically have the...
July 12, 2013 at 12:47 pm
Sean Lange (7/12/2013)
Greg Edwards-268690 (7/12/2013)
Sean Lange (7/12/2013)
Steve Jones - SSC Editor (7/11/2013)
July 12, 2013 at 12:10 pm
Use the import wizard to get you started.
Or look through the Stairway here. It does an incremental load that might help
July 12, 2013 at 12:09 pm
It's worded poorly in BOL.
Essentially on the source you:
- create master key (protected by SMK) in master.
- create cert, protected by DMK (master key).
- you backup the cert, decrypting it...
July 12, 2013 at 12:06 pm
no need to apologize and glad you got it figured out.
you've got the right solution. Move backups, restore.
Also, script out logins (sp_helprevlogin) and move those. Watch out for linked servers,...
July 12, 2013 at 12:02 pm
I believe you need to drop and reconfigure replication with a new distributor. You should have scripted out replication as soon as it's set up since problems can result in...
July 12, 2013 at 11:58 am
the thing to do, IMHO, is have a series of passes in the data, with a few procs/functions, that handle different items. This one posted looks good, but I bet...
July 12, 2013 at 11:57 am
Good for you.
you might think about scanning a folder in the package for .bak files, working out the latest one, and then grabbing the name for use in the...
July 12, 2013 at 11:54 am
The case is that you don't have any instance logins, only contained ones in your database. You can migrate all your users (windows are easy) to contained, and then you...
July 12, 2013 at 11:52 am
You should get an error.
AFAIK, Windows 7 is not an acceptable OS for SQL 2008 R2 enterprise, or any version.
http://msdn.microsoft.com/en-us/library/ms143506(v=SQL.105).aspx
This is only supposed to run on Server OSes.
July 12, 2013 at 11:51 am
+1.
Set a max memory, but SQL will take all it can get if you let it.
July 12, 2013 at 11:49 am
I like derived (staging) tables as an intermediary, and I'd probably use SSIS to move the data regularly. No reason a stored proc can't work, but I tend to stick...
July 12, 2013 at 11:47 am
Is it way behind? Have you looked in BOL for the "Monitoring Mirroring Status"?
It could be always slightly behind, depending on how your system is setup and your network.
In a...
July 12, 2013 at 11:45 am
Viewing 15 posts - 12,271 through 12,285 (of 39,963 total)