Click here to Skip to main content
15,886,919 members
Home / Discussions / Database
   

Database

 
GeneralSage Accounting Version 10 Pin
Kryptos Sol29-Apr-04 4:43
Kryptos Sol29-Apr-04 4:43 
Generalexec two stored procedure in a main stored procedure Pin
manasrahfantom29-Apr-04 2:27
manasrahfantom29-Apr-04 2:27 
GeneralRe: exec two stored procedure in a main stored procedure Pin
Jeff Varszegi29-Apr-04 3:11
professionalJeff Varszegi29-Apr-04 3:11 
GeneralRe: exec two stored procedure in a main stored procedure Pin
manasrahfantom30-Apr-04 21:33
manasrahfantom30-Apr-04 21:33 
GeneralRe: exec two stored procedure in a main stored procedure Pin
Jeff Varszegi1-May-04 6:49
professionalJeff Varszegi1-May-04 6:49 
GeneralADO.NET Deletion from SQL DB problem. Pin
Member 105947128-Apr-04 19:52
Member 105947128-Apr-04 19:52 
GeneralTransferring Data Pin
ibok2328-Apr-04 5:40
ibok2328-Apr-04 5:40 
Generalcheck login exists Pin
Dpriya28-Apr-04 2:50
Dpriya28-Apr-04 2:50 
Hi,
How do I check whether a login exists for a particular database in MSDE?

Code:
SqlConnection objConn = new SqlConnection(strCon);
objConn.Open();
SqlCommand objCmd = new SqlCommand();
objCmd.Connection = objConn;
//eg: if login 'priya' does not exist in database PRIYA how do i do it
objCmd.CommandText = @" EXEC sp_addlogin @loginame ='abb',@passwd ='abb',@defdb = 'ABB' EXEC sp_grantdbaccess N'abb', N'abb' EXEC sp_addrolemember N'db_owner', N'abb'" ;
objCmd.ExecuteNonQuery();

Thankx in advance
Priya
GeneralRe: check login exists Pin
Mazdak28-Apr-04 3:47
Mazdak28-Apr-04 3:47 
GeneralRe: check login exists Pin
Jeff Martin28-Apr-04 5:33
Jeff Martin28-Apr-04 5:33 
GeneralRe: check login exists Pin
Jeff Martin28-Apr-04 5:32
Jeff Martin28-Apr-04 5:32 
Generalcheck database exists Pin
Dpriya27-Apr-04 2:56
Dpriya27-Apr-04 2:56 
GeneralRe: check database exists Pin
Jeff Varszegi27-Apr-04 7:51
professionalJeff Varszegi27-Apr-04 7:51 
GeneralRe: check database exists Pin
Jeff Martin28-Apr-04 5:35
Jeff Martin28-Apr-04 5:35 
GeneralRe: check database exists Pin
Jeff Varszegi28-Apr-04 7:08
professionalJeff Varszegi28-Apr-04 7:08 
GeneralRe: check database exists Pin
Jeff Martin29-Apr-04 9:02
Jeff Martin29-Apr-04 9:02 
GeneralRe: check database exists Pin
Jeff Varszegi29-Apr-04 9:38
professionalJeff Varszegi29-Apr-04 9:38 
GeneralInstalling ole db provider for microsoft project without installing microsoft project Pin
vinay_mat26-Apr-04 20:39
vinay_mat26-Apr-04 20:39 
GeneralLinked server from SQL Server 2000 to Sybase 12 Pin
Janya26-Apr-04 14:30
Janya26-Apr-04 14:30 
QuestionHow to create linked tables using ADOX? Pin
Santanu Lahiri26-Apr-04 12:06
Santanu Lahiri26-Apr-04 12:06 
AnswerFollowup: How to create linked tables using ADOX? Pin
Santanu Lahiri29-Apr-04 10:13
Santanu Lahiri29-Apr-04 10:13 
GeneralRestore database Pin
tmcafee26-Apr-04 8:40
tmcafee26-Apr-04 8:40 
GeneralRe: Restore database Pin
Mazdak26-Apr-04 20:52
Mazdak26-Apr-04 20:52 
GeneralImport Oracle *.DMP into MS-SQL (without Oracle DB Server) Pin
johncogan26-Apr-04 3:45
johncogan26-Apr-04 3:45 
GeneralRe: Import Oracle *.DMP into MS-SQL (without Oracle DB Server) Pin
RichardGrimmer26-Apr-04 3:56
RichardGrimmer26-Apr-04 3:56 

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.