Click here to Skip to main content
15,305,430 members
Home / Discussions / Database
   

Database

 
QuestionTemp and variable table cannot be created. Pin
Groulien10-Jul-11 22:27
MemberGroulien10-Jul-11 22:27 
AnswerRe: Temp and variable table cannot be created. Pin
Shameel11-Jul-11 1:42
professionalShameel11-Jul-11 1:42 
AnswerRe: Temp and variable table cannot be created. Pin
DaveAuld11-Jul-11 2:57
professionalDaveAuld11-Jul-11 2:57 
AnswerRe: Temp and variable table cannot be created. Pin
Corporal Agarn11-Jul-11 6:00
professionalCorporal Agarn11-Jul-11 6:00 
AnswerRe: Temp and variable table cannot be created. Pin
S Douglas11-Aug-11 10:07
professionalS Douglas11-Aug-11 10:07 
QuestionRestoration of publisher database to another system (merge replication) Pin
Abd.Jabbar9-Jul-11 21:39
MemberAbd.Jabbar9-Jul-11 21:39 
AnswerRe: Restoration of publisher database to another system (merge replication) Pin
Corporal Agarn11-Jul-11 3:28
professionalCorporal Agarn11-Jul-11 3:28 
QuestionWho owns the data/database? Customer or vendor? Pin
kmoorevs9-Jul-11 5:55
Memberkmoorevs9-Jul-11 5:55 
We have an application that combines data from multiple business areas. (POS, Inventory, Accounting, Payroll, etc.) Most of the time, these sources are from different vendors and most of the time these vendors utilize SQL Server. For years, we have simply worked with the IT departments of our customers to create sql logins for these other databases (db_datareader role only!) in order to extract data used by our application. This usually involves the customer sending us a backup that we restore, analyze against a report set, and build queries against. The goal is to solve the business need of the customer who needs to have these many puzzle pieces in a single place...we are not competing with the other vendors, only making use of the data from their systems. The reason for this post is that last week, I got a call from an angry software developer for one of these vendors who wanted to know who gave us permission to connect to their sql database and blaming us for missing records. I expained the concept of the db_datareader role and expressed my opinion that the data belongs to the customer...the customer gave us permission for the connection in order to fulfill a business need. He said he will be contacting his legal experts on the matter. So, how would you feel if you found out another company was mining your database?
"Go forth into the source" - Neal Morse

AnswerRe: Who owns the data/database? Customer or vendor? Pin
Mycroft Holmes9-Jul-11 13:13
professionalMycroft Holmes9-Jul-11 13:13 
AnswerRe: Who owns the data/database? Customer or vendor? Pin
PIEBALDconsult10-Jul-11 6:32
professionalPIEBALDconsult10-Jul-11 6:32 
GeneralRe: Who owns the data/database? Customer or vendor? Pin
kmoorevs11-Jul-11 9:14
Memberkmoorevs11-Jul-11 9:14 
AnswerRe: Who owns the data/database? Customer or vendor? Pin
jschell12-Jul-11 11:08
Memberjschell12-Jul-11 11:08 
GeneralRe: Who owns the data/database? Customer or vendor? Pin
kmoorevs13-Jul-11 5:03
Memberkmoorevs13-Jul-11 5:03 
GeneralRe: Who owns the data/database? Customer or vendor? Pin
jschell13-Jul-11 9:05
Memberjschell13-Jul-11 9:05 
GeneralRe: Who owns the data/database? Customer or vendor? Pin
smcnulty200014-Jul-11 23:04
Membersmcnulty200014-Jul-11 23:04 
AnswerRe: Who owns the data/database? Customer or vendor? Pin
smcnulty200014-Jul-11 23:01
Membersmcnulty200014-Jul-11 23:01 
GeneralRe: Who owns the data/database? Customer or vendor? Pin
kmoorevs15-Jul-11 6:06
Memberkmoorevs15-Jul-11 6:06 
GeneralRe: Who owns the data/database? Customer or vendor? Pin
kmoorevs15-Jul-11 7:11
Memberkmoorevs15-Jul-11 7:11 
Questiondeploying an SSIS package to server Pin
Alaric_7-Jul-11 8:23
professionalAlaric_7-Jul-11 8:23 
AnswerRe: deploying an SSIS package to server Pin
Alaric_7-Jul-11 16:09
professionalAlaric_7-Jul-11 16:09 
AnswerRe: deploying an SSIS package to server Pin
thatraja8-Jul-11 16:49
professionalthatraja8-Jul-11 16:49 
GeneralRe: deploying an SSIS package to server Pin
Alaric_11-Jul-11 2:24
professionalAlaric_11-Jul-11 2:24 
QuestionHow to store audio, vedio, Image file in SQL server Pin
monulove2u7-Jul-11 4:21
Membermonulove2u7-Jul-11 4:21 
AnswerRe: How to store audio, vedio, Image file in SQL server Pin
Blue_Boy7-Jul-11 4:34
MemberBlue_Boy7-Jul-11 4:34 
AnswerRe: How to store audio, vedio, Image file in SQL server Pin
Ravi Sant7-Jul-11 4:47
MemberRavi Sant7-Jul-11 4:47 

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.