Rohan

505 reputation

114

bio	website	rohansehgalsoasis.blogspot.co…
	location	India
	age	23
visits	member for	1 year, 8 months
	seen	2 days ago
stats	profile views	36

I am a database engineer, with a flair for analytics and anything CS..

	505 reputation	bio	website	rohansehgalsoasis.blogspot.co…	visits	member for	1 year, 8 months
114 badges		location	India		seen	2 days ago

summary answers questions tags badges favorites bounties reputation activity

89 Actions

suggestions reviews revisions comments badges posts accepts all

May 13	comment	How do I refresh SQL server cross database references after a database is reattached with a different name? (Are there hidden synonyms?) @Andrew : I have explained the cause in an edit to the answer.
May 13	revised	How do I refresh SQL server cross database references after a database is reattached with a different name? (Are there hidden synonyms?) expanded answer
May 8	comment	How do I refresh SQL server cross database references after a database is reattached with a different name? (Are there hidden synonyms?) @Andrew: I was actually not able to reproduce the issue you are facing..
May 7	comment	Two-sided UNIQUE INDEX for two columns Those indexes are logically the same and will not enforce what the OP desires..
May 7	reviewed	No Action Needed Plugin 'FEDERATED' is disabled
May 7	reviewed	No Action Needed How do you version your Oracle database changes?
May 7	answered	How do I refresh SQL server cross database references after a database is reattached with a different name? (Are there hidden synonyms?)
Apr 29	reviewed	Reviewed Transfer 1 million records from one table to another
Apr 29	answered	checking number of occupied occupied neighbours
Apr 26	answered	How to create trigger on database that 'triggers' when mirroring role changes from mirror to principal
Apr 26	answered	tempdb logs on same drive as tempdb data or with other logs?
Apr 26	reviewed	Reviewed What could cause the wrong ID to be inserted?
Apr 26	reviewed	No Action Needed Login failed for user 'domain\username'. (Microsoft SQL Server, Error: 18456)
Apr 26	answered	Does a single, simple select query creates locks?
Apr 25	answered	How to get default locking hint of a table
Mar 13	comment	how do I insert a default row? Awesome merge tip!
Mar 13	accepted	how do I insert a default row?
Mar 13	asked	how do I insert a default row?
Jan 2	awarded	Custodian
Jan 2	comment	Tables not shown in SQL Server Enterprise Manager Any chance the login that you use to connect to the enterprise manager does not have permissions?