Click here to Skip to main content
15,388,998 members
Home / Discussions / Database
   

Database

 
GeneralRe: ERD fee management system keep the record of whole year Pin
Haidar ali24-Jan-15 7:55
MemberHaidar ali24-Jan-15 7:55 
GeneralRe: ERD fee management system keep the record of whole year Pin
Richard MacCutchan24-Jan-15 8:06
mveRichard MacCutchan24-Jan-15 8:06 
GeneralRe: ERD fee management system keep the record of whole year Pin
Haidar ali25-Jan-15 0:04
MemberHaidar ali25-Jan-15 0:04 
GeneralRe: ERD fee management system keep the record of whole year Pin
Richard MacCutchan25-Jan-15 1:03
mveRichard MacCutchan25-Jan-15 1:03 
QuestionNeed a Select query that filter illegal characters Pin
nainakarri21-Jan-15 19:14
Membernainakarri21-Jan-15 19:14 
AnswerRe: Need a Select query that filter illegal characters Pin
Eddy Vluggen22-Jan-15 0:28
professionalEddy Vluggen22-Jan-15 0:28 
AnswerRe: Need a Select query that filter illegal characters Pin
Umer Akram29-Jan-15 18:58
MemberUmer Akram29-Jan-15 18:58 
QuestionLet sql server code works for all SQLServer versions Pin
MrKBA19-Jan-15 23:10
MemberMrKBA19-Jan-15 23:10 
Hello,

The code below works fine with SQL Server 2008
But it seems to be deleted from newer versions of SQL Server.
How can change it so it works fine for all versions ?

Thank you

SQL
IF  EXISTS (SELECT * FROM sys.server_principals WHERE name = N'sac_manager')
exec sp_droplogin 'sac_manager';
exec sp_addlogin @loginame = N'sac_manager', @passwd = N'', @defdb = N'SAC_DB';
USE [SAC_DB]
exec sp_adduser 'sac_manager'
exec sp_addrolemember 'db_owner', 'sac_manager';

AnswerRe: Let sql server code works for all SQLServer versions Pin
Eddy Vluggen22-Jan-15 0:26
professionalEddy Vluggen22-Jan-15 0:26 
Questionchanging the field of database based on changes in repeater Pin
Armi.R16-Jan-15 21:21
MemberArmi.R16-Jan-15 21:21 
AnswerRe: changing the field of database based on changes in repeater Pin
Mycroft Holmes19-Jan-15 23:57
professionalMycroft Holmes19-Jan-15 23:57 
QuestionDB2 Store procedure error in VB.NET Pin
sudevsu16-Jan-15 2:59
Membersudevsu16-Jan-15 2:59 
QuestionRe: DB2 Store procedure error in VB.NET Pin
GuyThiebaut16-Jan-15 3:10
professionalGuyThiebaut16-Jan-15 3:10 
AnswerRe: DB2 Store procedure error in VB.NET Pin
sudevsu16-Jan-15 3:22
Membersudevsu16-Jan-15 3:22 
GeneralRe: DB2 Store procedure error in VB.NET Pin
GuyThiebaut16-Jan-15 3:46
professionalGuyThiebaut16-Jan-15 3:46 
GeneralRe: DB2 Store procedure error in VB.NET Pin
sudevsu16-Jan-15 3:55
Membersudevsu16-Jan-15 3:55 
AnswerRe: DB2 Store procedure error in VB.NET Pin
sudevsu16-Jan-15 3:21
Membersudevsu16-Jan-15 3:21 
GeneralRe: DB2 Store procedure error in VB.NET Pin
GuyThiebaut16-Jan-15 3:59
professionalGuyThiebaut16-Jan-15 3:59 
GeneralRe: DB2 Store procedure error in VB.NET Pin
sudevsu16-Jan-15 4:30
Membersudevsu16-Jan-15 4:30 
GeneralRe: DB2 Store procedure error in VB.NET Pin
GuyThiebaut16-Jan-15 4:41
professionalGuyThiebaut16-Jan-15 4:41 
GeneralRe: DB2 Store procedure error in VB.NET Pin
sudevsu16-Jan-15 4:43
Membersudevsu16-Jan-15 4:43 
GeneralRe: DB2 Store procedure error in VB.NET Pin
GuyThiebaut16-Jan-15 4:48
professionalGuyThiebaut16-Jan-15 4:48 
GeneralRe: DB2 Store procedure error in VB.NET Pin
sudevsu16-Jan-15 4:50
Membersudevsu16-Jan-15 4:50 
GeneralRe: DB2 Store procedure error in VB.NET Pin
GuyThiebaut16-Jan-15 5:05
professionalGuyThiebaut16-Jan-15 5:05 
GeneralRe: DB2 Store procedure error in VB.NET Pin
sudevsu16-Jan-15 5:09
Membersudevsu16-Jan-15 5:09 

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.