Viewing 15 posts - 1,681 through 1,695 (of 7,498 total)
I would create a synonym in the database, referring to the table in the other database.
Check "CREATE SYNONYM" in books online
ps I prefer still leaving a trace in the naming...
September 16, 2011 at 1:23 am
SQLRNNR (9/15/2011)
Tom.Thomson (9/15/2011)
Steve Jones - SSC Editor (9/15/2011)
I'm going out of town for a few days....
September 15, 2011 at 11:55 pm
SQLRNNR (9/15/2011)
WayneS (9/15/2011)
SQLRNNR (9/15/2011)
Just saying that we only need 98 more posts for 30,000how many?
Ummm - 96
Make up your mind. No guessing 😉
September 15, 2011 at 1:22 pm
Jeff Moden (9/14/2011)
ALZDBA (9/14/2011)
jcrawf02 (9/14/2011)
Grant Fritchey (9/14/2011)
mtillman-921105 (9/14/2011)
Grant Fritchey (9/14/2011)
I'm tasked with writing another article....
September 15, 2011 at 12:26 am
jcrawf02 (9/14/2011)
Grant Fritchey (9/14/2011)
mtillman-921105 (9/14/2011)
Grant Fritchey (9/14/2011)
I'm tasked with writing another article. This one is...
September 14, 2011 at 2:58 pm
Grant Fritchey (9/14/2011)
I'm tasked with writing another article. This one is all about the scary,...
September 14, 2011 at 2:55 pm
Perry Whittle (9/14/2011)
sqlbuddy123 (9/13/2011)
Right, Mirrored DB is not accessible at all times.Thank You,
Best Regards,
SQLBuddy
Unless you're using...
September 14, 2011 at 4:45 am
This is a great recognition and thank you for all time, energy en knowledge Jeff developed and shares !
Congratulations, Jeff
September 14, 2011 at 12:54 am
We get to hear "Ho, ho, hoo" at SQLPASS 2011 !!!!
http://www.sqlservercentral.com/articles/Exceptional+DBA+Awards/75988/
Congratulations Jeff !!
September 14, 2011 at 12:49 am
Jan Van der Eecken (9/13/2011)
ALZDBA (9/13/2011)
SQLRNNR (9/13/2011)
Steve Jones - SSC Editor (9/13/2011)
New building looking good for the horses:
Now we know where Steve will be sleeping when in the dog house.
I...
September 14, 2011 at 12:45 am
just saying ..
Would your business clients appreciate the apps not working whilest some one consumes historic data and scans all your lovely large tables pushing regular oltp stuff out of...
September 13, 2011 at 4:14 pm
SQLRNNR (9/13/2011)
Steve Jones - SSC Editor (9/13/2011)
New building looking good for the horses:
Now we know where Steve will be sleeping when in the dog house.
I think he's expecting to host...
September 13, 2011 at 10:17 am
kapfundestanley (9/13/2011)
Are you saying is the principal has been changed to mirror,it will be still accessible?
Only "transparent" when you specify failover partner in the connection string !
September 13, 2011 at 10:15 am
Chad Crawford (9/12/2011)
September 13, 2011 at 7:40 am
... All we need is sample data... waiting on you to provide, and then there will be some awesome sql learning going on in this thread!
That wouldn't need to be...
September 13, 2011 at 12:14 am
Viewing 15 posts - 1,681 through 1,695 (of 7,498 total)