Viewing 15 posts - 6,001 through 6,015 (of 9,253 total)
sqlfriends (2/10/2012)
Will 2008 version SSIS package still work on R2 SSIS?Thanks
Depends on what the package is doing! If its a basic package with no special features then probably yes. You...
February 11, 2012 at 3:28 am
pause mirroring and change the service account(s).
Ensure you change the mirroring endpoint(s) security and resume mirroring.
February 10, 2012 at 5:40 pm
Jeff Moden (2/10/2012)
February 10, 2012 at 4:54 pm
JC-3113 (2/10/2012)
another issue just cropped up with regards to database owners and need some advice
it seems that a majority of my databases were created by lets say Domain1\User1
User1 is...
February 10, 2012 at 10:47 am
David Benoit (2/10/2012)
I would have the following to be sure that I was able to catch what you want;SP:Completed
SP:StmtCompleted
SQL:BatchCompleted
SQL:BatchStarting
SQL:StmtCompleted
If capturing the objects in red above I would also capture...
February 10, 2012 at 10:43 am
Jinu43 (2/10/2012)
I have same issue.Where did you forced the restore option or which changes you made on primary server??
Thanks in advance.. 🙂
If you're having the same issue experienced in this...
February 10, 2012 at 10:27 am
sqldba4u (2/10/2012)
Is there any way or t-sql to find database name with corresponding certificate name in sql server 2008? I am referring with respect to TDE mechanism.Thanks.
Here you go
USE [YourDB]
selectdb_name(dek.database_id)...
February 10, 2012 at 10:10 am
Yes, fail all instances to one node.
Go into VCS cluster console and for all cluster groups place them into Freeze-Temporary
Once this is done reboot all passive nodes and then run...
February 9, 2012 at 1:04 pm
kellithompson (2/7/2012)
Nevermind. I finally got it working. Because of the failover cluster, I want to use high safety w/o auto failover (synchronous), right?
Offhand i'm not entirely certain, what...
February 9, 2012 at 8:11 am
Ok, which ports are you using for principal, mirror, witness?
what did this mean below
saidapurs (2/7/2012)
3):I am able to do telnet 5022 but “telnet SQLServerName 5023? not happening.
February 9, 2012 at 12:35 am
Let's start with basics
do the SQL server services on each instance run under the same domain account or a different domain user account?
February 8, 2012 at 1:03 pm
sql2k8 (2/7/2012)
you have to check for stripe unit size/ file allocation unit size and partition offset/stripe unit sizeif these values are not integer then the disks are not aligned
Could you...
February 7, 2012 at 1:04 pm
sql2k8 (2/7/2012)
when i format the disks the data will be gone from the disks .
Backup the data first??? 😉
sql2k8 (2/7/2012)
February 7, 2012 at 12:07 pm
sql2k8 (2/7/2012)
with the minimal impact on the current running cluster
There is no minimal impact. To change these you must delete and re create the partitions, period.
February 7, 2012 at 10:01 am
hayden_jones (2/7/2012)
February 7, 2012 at 8:33 am
Viewing 15 posts - 6,001 through 6,015 (of 9,253 total)