Click here to Skip to main content
14,736,050 members
Home » Discussions » Database
   

Database

 
GeneralRe: Selecting multiple columns from several tables without using JOIN Pin
AnnieMacD15-Jul-11 3:44
MemberAnnieMacD15-Jul-11 3:44 
AnswerRe: Selecting multiple columns from several tables without using JOIN Pin
smcnulty200015-Jul-11 0:20
Membersmcnulty200015-Jul-11 0:20 
QuestionTemp and variable table cannot be created. Pin
Groulien10-Jul-11 23:27
MemberGroulien10-Jul-11 23:27 
AnswerRe: Temp and variable table cannot be created. Pin
Shameel11-Jul-11 2:42
professionalShameel11-Jul-11 2:42 
AnswerRe: Temp and variable table cannot be created. Pin
DaveAuld11-Jul-11 3:57
professionalDaveAuld11-Jul-11 3:57 
AnswerRe: Temp and variable table cannot be created. Pin
Corporal Agarn11-Jul-11 7:00
professionalCorporal Agarn11-Jul-11 7:00 
AnswerRe: Temp and variable table cannot be created. Pin
S Douglas11-Aug-11 11:07
professionalS Douglas11-Aug-11 11:07 
QuestionRestoration of publisher database to another system (merge replication) Pin
Abd.Jabbar9-Jul-11 22:39
MemberAbd.Jabbar9-Jul-11 22:39 
Hi , I'm doing log shipping for publisher database (Marge Replication).
I configured my publisher db for log shipping its doing work well. All transaction logs are getting restore after a time.The publisher Database is readonly/Offline mode.I then activate/Online this db.
As we also need master,Msdb and distributor (if same publisher is the distributor) databases to make secondary server as publisher, i am backing up these system dbs using maintenance plans. I have no all four latest databases (i.e. publisher,distributor,msdb and master db).
My publisher database is online and latest,I restored latest backup of msdb and distributor that is backed up by maintenance plans.When i restore master database my publisher database is no more available , i can just see its name icon in management studio but when click on it nothing to expand/attached with this database.
Both Primary server and secondary servers have SQL server enterprise with sp1 installed on same path. I wanna to just rename secondary server SQL instance name & computer name and it should works just like my primary server as a publisher. Help will be appreciated.
Thank you
AnswerRe: Restoration of publisher database to another system (merge replication) Pin
Corporal Agarn11-Jul-11 4:28
professionalCorporal Agarn11-Jul-11 4:28 
QuestionWho owns the data/database? Customer or vendor? Pin
kmoorevs9-Jul-11 6:55
Memberkmoorevs9-Jul-11 6:55 
AnswerRe: Who owns the data/database? Customer or vendor? Pin
Mycroft Holmes9-Jul-11 14:13
professionalMycroft Holmes9-Jul-11 14:13 
AnswerRe: Who owns the data/database? Customer or vendor? Pin
PIEBALDconsult10-Jul-11 7:32
professionalPIEBALDconsult10-Jul-11 7:32 
GeneralRe: Who owns the data/database? Customer or vendor? Pin
kmoorevs11-Jul-11 10:14
Memberkmoorevs11-Jul-11 10:14 
AnswerRe: Who owns the data/database? Customer or vendor? Pin
jschell12-Jul-11 12:08
Memberjschell12-Jul-11 12:08 
GeneralRe: Who owns the data/database? Customer or vendor? Pin
kmoorevs13-Jul-11 6:03
Memberkmoorevs13-Jul-11 6:03 
GeneralRe: Who owns the data/database? Customer or vendor? Pin
jschell13-Jul-11 10:05
Memberjschell13-Jul-11 10:05 
GeneralRe: Who owns the data/database? Customer or vendor? Pin
smcnulty200015-Jul-11 0:04
Membersmcnulty200015-Jul-11 0:04 
AnswerRe: Who owns the data/database? Customer or vendor? Pin
smcnulty200015-Jul-11 0:01
Membersmcnulty200015-Jul-11 0:01 
GeneralRe: Who owns the data/database? Customer or vendor? Pin
kmoorevs15-Jul-11 7:06
Memberkmoorevs15-Jul-11 7:06 
GeneralRe: Who owns the data/database? Customer or vendor? Pin
kmoorevs15-Jul-11 8:11
Memberkmoorevs15-Jul-11 8:11 
Questiondeploying an SSIS package to server Pin
Alaric_7-Jul-11 9:23
professionalAlaric_7-Jul-11 9:23 
AnswerRe: deploying an SSIS package to server Pin
Alaric_7-Jul-11 17:09
professionalAlaric_7-Jul-11 17:09 
AnswerRe: deploying an SSIS package to server Pin
thatraja8-Jul-11 17:49
professionalthatraja8-Jul-11 17:49 
GeneralRe: deploying an SSIS package to server Pin
Alaric_11-Jul-11 3:24
professionalAlaric_11-Jul-11 3:24 
QuestionHow to store audio, vedio, Image file in SQL server Pin
monulove2u7-Jul-11 5:21
Membermonulove2u7-Jul-11 5:21 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.