Ms Sql Server Technology Discussions

[loveindia]

[quote name='Kaarthikeya' timestamp='1365446037' post='1303565509']
cheste em prob avutundi? okasari nenu indexes pettakunda/petto gurthu ledu kaani oka data load run chesa....oka 30 min ayye sariki DBA gaadu em chestunnav desk daggara...disk space ala aipoindi okkasare annadu
[/quote]

temp db full aindi ani shrink chestey evaranna active ga run chestunna connections alantivi anni bisket avtaai... plus 90% of the times databases corrupt avtai.. appudu ninnu boothulu titti bayataki tostaaru simple ga... try it once ya... feel the fireeeeeeeee.....

ur dba called u cos, may be nuvvu chestunna dataload dead lock create chesi migata anni resources ni eating emo.. or tempdb fill up aipotu undi emo.. indexes are good if correctly used, nightmare if played around with...

[deals2buy]

[quote name='loveindia' timestamp='1365446841' post='1303565680']

temp db full aindi ani shrink chestey evaranna active ga run chestunna connections alantivi anni bisket avtaai... plus 90% of the times databases corrupt avtai.. appudu ninnu boothulu titti bayataki tostaaru simple ga... try it once ya... feel the fireeeeeeeee.....

ur dba called u cos, may be nuvvu chestunna dataload dead lock create chesi migata anni resources ni eating emo.. or tempdb fill up aipotu undi emo.. indexes are good if correctly used, nightmare if played around with...
[/quote]

first line...naaku antha dhoola ledu maha prabho

second line

[littlemoon]

[quote name='kumargadu' timestamp='1365445733' post='1303565468']


I did that , Thank you !!!
[/quote] a day or two log files growth ela undo cheyandi also trn backup ni chk chesthundalii
[quote name='Kaarthikeya' timestamp='1365445406' post='1303565429']


both of u
[/quote] [size=4] [/size]

[littlemoon]

guys question...

In sql 2008 oka database logins and permissions script cheyali... evari degara aina script alrdy unte pls share...

also GUI nunchi cheydnaki emaina procedure unte chepandi.. [size=4] [/size]

[deals2buy]

[quote name='littlemoon' timestamp='1365448963' post='1303566126']
guys question...

In sql 2008 oka database logins and permissions script cheyali... evari degara aina script alrdy unte pls share...

also GUI nunchi cheydnaki emaina procedure unte chepandi..
[/quote]

GUI lo aithe...usually right click chesi aa script lo ye user ki kaavalante aa user name enter chesi run cheyyadame kada...I might be wrong

[littlemoon]

[quote name='Kaarthikeya' timestamp='1365449650' post='1303566199']
GUI lo aithe...usually right click chesi aa script lo ye user ki kaavalante aa user name enter chesi run cheyyadame kada...I might be wrong
[/quote]
permissions kuda generate avali... kani whn I do as you said only create user ani untundi

[innovative]

[quote name='littlemoon' timestamp='1365448963' post='1303566126']
guys question...

In sql 2008 oka database logins and permissions script cheyali... evari degara aina script alrdy unte pls share...

also GUI nunchi cheydnaki emaina procedure unte chepandi..
[/quote]
requirement clear ga cheppu javascript iythe rasipedtha ..

[deals2buy]

[quote name='littlemoon' timestamp='1365449735' post='1303566206']
permissions kuda generate avali... kani whn I do as you said only create user ani untundi
[/quote]

Thats what I've mentioned...but again I might be wrong

[CODE]
/****** Object: DatabaseRole [db_accessadmin] ******/
EXEC dbo.sp_addrole @rolename = N'db_accessadmin', @ownername = N'dbo'
/****** Object: DatabaseRole [db_backupoperator] ******/
EXEC dbo.sp_addrole @rolename = N'db_backupoperator', @ownername = N'dbo'
/****** Object: DatabaseRole [db_datareader] ******/
EXEC dbo.sp_addrole @rolename = N'db_datareader', @ownername = N'dbo'
/****** Object: DatabaseRole [db_datawriter] ******/
EXEC dbo.sp_addrole @rolename = N'db_datawriter', @ownername = N'dbo'
/****** Object: DatabaseRole [db_ddladmin] ******/
EXEC dbo.sp_addrole @rolename = N'db_ddladmin', @ownername = N'dbo'
/****** Object: DatabaseRole [db_denydatareader] ******/
EXEC dbo.sp_addrole @rolename = N'db_denydatareader', @ownername = N'dbo'
/****** Object: DatabaseRole [db_denydatawriter] ******/
EXEC dbo.sp_addrole @rolename = N'db_denydatawriter', @ownername = N'dbo'

/****** Object: DatabaseRole [db_owner] ******/
EXEC dbo.sp_addrole @rolename = N'db_owner', @ownername = N'dbo'

/****** Object: DatabaseRole [db_securityadmin] ******/
EXEC dbo.sp_addrole @rolename = N'db_securityadmin', @ownername = N'dbo'
[/CODE]

[deals2buy]

[quote name='innovative' timestamp='1365449945' post='1303566224']
requirement clear ga cheppu javascript iythe rasipedtha ..
[/quote]naaku javascript nerpinchu aithe

[innovative]

[quote name='Kaarthikeya' timestamp='1365450208' post='1303566249']
naaku javascript nerpinchu aithe
[/quote]
nerpinche antha time ledhu kaarthik ... emanna script kavali ante i can help ..

[Doolanagi]

Hi everyone SQL BI developer here

[littlemoon]

[quote name='innovative' timestamp='1365449945' post='1303566224']
requirement clear ga cheppu javascript iythe rasipedtha ..
[/quote] ikada vaddu le
[quote name='Kaarthikeya' timestamp='1365450142' post='1303566241']
Thats what I've mentioned...but again I might be wrong

[CODE]
/****** Object: DatabaseRole [db_accessadmin] ******/
EXEC dbo.sp_addrole @rolename = N'db_accessadmin', @ownername = N'dbo'
/****** Object: DatabaseRole [db_backupoperator] ******/
EXEC dbo.sp_addrole @rolename = N'db_backupoperator', @ownername = N'dbo'
/****** Object: DatabaseRole [db_datareader] ******/
EXEC dbo.sp_addrole @rolename = N'db_datareader', @ownername = N'dbo'
/****** Object: DatabaseRole [db_datawriter] ******/
EXEC dbo.sp_addrole @rolename = N'db_datawriter', @ownername = N'dbo'
/****** Object: DatabaseRole [db_ddladmin] ******/
EXEC dbo.sp_addrole @rolename = N'db_ddladmin', @ownername = N'dbo'
/****** Object: DatabaseRole [db_denydatareader] ******/
EXEC dbo.sp_addrole @rolename = N'db_denydatareader', @ownername = N'dbo'
/****** Object: DatabaseRole [db_denydatawriter] ******/
EXEC dbo.sp_addrole @rolename = N'db_denydatawriter', @ownername = N'dbo'

/****** Object: DatabaseRole [db_owner] ******/
EXEC dbo.sp_addrole @rolename = N'db_owner', @ownername = N'dbo'

/****** Object: DatabaseRole [db_securityadmin] ******/
EXEC dbo.sp_addrole @rolename = N'db_securityadmin', @ownername = N'dbo'
[/CODE]
[/quote] will try ... Ty

[kumargadu]

[quote name='innovative' timestamp='1365449945' post='1303566224']
requirement clear ga cheppu javascript iythe rasipedtha ..
[/quote]

SQL lo Javascript a ?

[kumargadu]

[quote name='Doolanagi' timestamp='1365450391' post='1303566269']
Hi everyone SQL BI developer here
[/quote]

welcome bud where are you working ?

[deals2buy]

[quote name='kumargadu' timestamp='1365450502' post='1303566279']

SQL lo Javascript a ?
[/quote][img]http://lh3.ggpht.com/--o7mXz3u-j4/T9VVBGzBJAI/AAAAAAAAGo0/kmj8a1-XW2g/s150/PK-1.gif[/img]

[quote name='Doolanagi' timestamp='1365450391' post='1303566269']
Hi everyone SQL BI developer here
[/quote]welcome to the league mama