Viewing 15 posts - 5,416 through 5,430 (of 9,253 total)
hi thanks for your comments, hope you found it useful
Regards Pez
June 27, 2012 at 8:21 am
to be clear this details the types
catalog views
compatibility views
dynamic management views (which also includes functions)
June 27, 2012 at 8:19 am
what does the following registry branch show
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\ConnectTo
June 27, 2012 at 4:55 am
for info, sys.master_files is a catalog view not a DMV
June 27, 2012 at 4:01 am
the declaration you have made for@Data1 is only relevant to the internal part of the procedure. You are attempting to pass a parameter @Data1 from outside the procedure and would...
June 27, 2012 at 3:43 am
DPM takes backups in a completely different fashion to Redgate SQLBackup. SQLBackup will most likely, if standard config, be generating .SQB files and these are the SQL Server backups.
As Jeffrey...
June 27, 2012 at 3:25 am
the message gives you all the info you need. The task is not an editable SSIS object, rather, it has a set of properties that define the execution context. Right...
June 27, 2012 at 3:19 am
go into sql server configuration manager and check the alias section. Someone has setup an alias for the named instance probably
June 27, 2012 at 3:10 am
Scott i don't disagree with you, we know that multiple arrays are ideal but all we're saying is in this case you have to go for something a little less...
June 26, 2012 at 4:12 pm
Lynn Pettis (6/26/2012)
RAID (any form) is no replacement for backups. Anyone who thinks so is planning to fail instead of planning for a failure.
I concur
To add to Kevins comment,...
June 26, 2012 at 1:35 pm
ScottPletcher (6/26/2012)
If you do somehow lose the (4-drive) RAID 10 here, all the dbs are also lost.
That's why you take backups. You're more likely to lose a complete RAID1 mirror,...
June 26, 2012 at 9:18 am
Lowell (6/21/2012)
you'd have to get a model from another instance with the same service packs applied (and maybe CU's as well...i'd have to double check on that)
Same collation too 😉
June 26, 2012 at 1:12 am
tamil.selvanmca (6/23/2012)
I want to secure the backup file so it can't be restored elsewhere by any One.I want to protect my backup file.
Ensure you understand the effects and requirements of...
June 26, 2012 at 1:06 am
rherrera 67295 (6/25/2012)
I got the same issue. You need to add the parameter:
PCUSOURCE="The path for your software"
Use the path for the SP that you're installing.
Example:
PCUSOURCE="C:\install\SQL_Server2008R2\SP
or
Generate the file by running the...
June 26, 2012 at 12:56 am
Why not just buy a copy of developer edition?
June 26, 2012 at 12:49 am
Viewing 15 posts - 5,416 through 5,430 (of 9,253 total)