dat_girl

74 reputation

bio	website
	location
	age
visits	member for	1 year, 8 months
	seen	May 22 '12 at 19:52
stats	profile views	26

	74 reputation	bio	website		visits	member for	1 year, 8 months
14 badges		location			seen	May 22 '12 at 19:52

summary answers questions tags badges favorites bounties reputation activity

21 Actions

suggestions reviews revisions comments badges posts accepts all

Mar 10	awarded	Notable Question
May 25	awarded	Popular Question
Apr 13	accepted	Is there any benefit to having one sql server login for multiple users?
Apr 13	accepted	Is there an easy way to trigger automatic failover of a single mirrored database?
Apr 11	comment	Is there any benefit to having one sql server login for multiple users? There are actually 3 BDAs
Apr 11	comment	Is there any benefit to having one sql server login for multiple users? @swasheck That is correct. Everyone opens up SSMS or VS and logins in with the same credentials. I was also surprised.
Apr 11	comment	Is there any benefit to having one sql server login for multiple users? @swasheck For all work. The connection string uses another sql-login.
Apr 11	asked	Is there any benefit to having one sql server login for multiple users?
Dec 16	accepted	Sql profiler replay table
Nov 21	asked	Sql profiler replay table
Oct 14	comment	Is there an easy way to trigger automatic failover of a single mirrored database? That didn't work either @shark, same error. I think I would have to stop mirroring before any 'state' changes can be made to the db.
Oct 14	comment	Is there an easy way to trigger automatic failover of a single mirrored database? this is the solution i had hoped would work but I get a msg 1468, the database is involved in mirroring, alter statement failed.
Oct 14	comment	Is there an easy way to trigger automatic failover of a single mirrored database? Thanks @vorax, but I already have mirroring setup and it works fine. I also don't want to stop the service as that would bring down all the databases on the instance. I just want to stop 1.
Oct 12	asked	Is there an easy way to trigger automatic failover of a single mirrored database?
Sep 28	awarded	Supporter
Sep 27	awarded	Scholar
Sep 27	accepted	Migrating from one SQL Server 2008 R2 instance to another
Sep 19	awarded	Student
Sep 19	comment	Migrating from one SQL Server 2008 R2 instance to another Thanks @rohan. I'll check that article.
Sep 19	comment	Migrating from one SQL Server 2008 R2 instance to another @Surfer513, this is a flexible environment. downtime can be scheduled.