Ms Sql Server Technology Discussions

[littlemoon]

[quote name='Kaarthikeya' timestamp='1365514197' post='1303570262']
adi sattire ani ardham kaaleda neeku inka? [img]http://lh3.ggpht.com/--o7mXz3u-j4/T9VVBGzBJAI/AAAAAAAAGo0/kmj8a1-XW2g/s150/PK-1.gif[/img]

thanks littlemoon for ltt...ippudue vethukutunna oka question post cheddam ani
[/quote] naa q ki emaina ans vasthudni ani ltt chesa
[quote name='kumargadu' timestamp='1365451560' post='1303566373']

talent a , bokka a ,andaru fake experience batch e
[/quote] pardhuu.. [img]http://lh3.ggpht.com/--o7mXz3u-j4/T9VVBGzBJAI/AAAAAAAAGo0/kmj8a1-XW2g/s150/PK-1.gif[/img]

[deals2buy]

[quote name='littlemoon' timestamp='1365514472' post='1303570290']
naa q ki emaina ans vasthudni ani ltt chesa
pardhuu.. [img]http://lh3.ggpht.com/--o7mXz3u-j4/T9VVBGzBJAI/AAAAAAAAGo0/kmj8a1-XW2g/s150/PK-1.gif[/img]
[/quote]

Did u try what I posted yesterday?

[stewiegriffin]

for scripting logins and permissions:
create sp as mentioned in master db
[url="http://support.microsoft.com/kb/918992"]http://support.microsoft.com/kb/918992[/url]
& exec sp_help_revlogin..The resultset will have logins script..

[deals2buy]

[quote name='stewiegriffin' timestamp='1365515297' post='1303570339']
for scripting logins and permissions:
create sp as mentioned in master db
[url="http://support.microsoft.com/kb/918992"]http://support.microsoft.com/kb/918992[/url]
& exec sp_help_revlogin..The resultset will have logins script..
[/quote]
pre-SQL Server 2000 login ante endi mama? eppudu vinale?

[stewiegriffin]

[quote name='Kaarthikeya' timestamp='1365515615' post='1303570355']
pre-SQL Server 2000 login ante endi mama? eppudu vinale?
[/quote]
confirmed ga teleedu mama..sql2000 or earlier versions nundi transfer cheyalem ee process tho..

nenu sql2005/2008 to 2008 databases ki logins transfer cheysa, ee link lo sp tho
(windows and sql authenticated logins with permissions gets transferred)

[deals2buy]

[quote name='stewiegriffin' timestamp='1365516339' post='1303570395']
confirmed ga teleedu mama..sql2000 or earlier versions nundi transfer cheyalem ee process tho..

nenu sql2005/2008 to 2008 databases ki logins transfer cheysa, ee link lo sp tho
(windows and sql authenticated logins with permissions gets transferred)
[/quote]ok... SQL Server 2005 below versions annitki Microsoft vaadu support aapesadu anukunta kadaa?

[Doolanagi]

[quote name='kumargadu' timestamp='1365450539' post='1303566282']
welcome bud where are you working ?
[/quote]

Thanks dude.

[Doolanagi]

[quote name='Kaarthikeya' timestamp='1365450613' post='1303566293']
[img]http://lh3.ggpht.com/--o7mXz3u-j4/T9VVBGzBJAI/AAAAAAAAGo0/kmj8a1-XW2g/s150/PK-1.gif[/img]

welcome to the league mama
[/quote]


Thanks Mama

[deals2buy]

[quote name='Doolanagi' timestamp='1365516974' post='1303570441']

Thanks dude.

[/quote]

house address, employer details anni cheppu inka

dont get into trouble by posting ur details here

[Doolanagi]

[quote name='Kaarthikeya' timestamp='1365517073' post='1303570447']
house address, employer details anni cheppu inka

dont get into trouble by posting ur details here
[/quote]


New to DB.. Thanks for letting me know bro. will be careful from next time

[deals2buy]

[quote name='Doolanagi' timestamp='1365517245' post='1303570460']


New to DB.. Thanks for letting me know bro. will be careful from next time
[/quote]

BI or DBA?

[littlemoon]

[quote name='Kaarthikeya' timestamp='1365517073' post='1303570447']
house address, employer details anni cheppu inka

dont get into trouble by posting ur details here
[/quote] GP
[quote name='stewiegriffin' timestamp='1365515297' post='1303570339']
for scripting logins and permissions:
create sp as mentioned in master db
[url="http://support.microsoft.com/kb/918992"]http://support.microsoft.com/kb/918992[/url]
& exec sp_help_revlogin..The resultset will have logins script..
[/quote] Thank you... it did help
e sp run chesaka vache logins anni default database master ki unayi, what if there is a user whose default database is some user db ?

[Darling999]

[quote name='Kaarthikeya' timestamp='1365514311' post='1303570278']
DARLING bhayya u around?

ninna nuvvu Task Level lo variables Package Level lo Variables annav kadaa? u mean that in Script task?

naa daggara package lo Global variables lo set chesa kotha value....and when I open a script task in the same package, list of global variables I can see the new value I've added....but package run chesinappudu matram adi pick cheskovatle
[/quote]

Not in Script task, SSIS lo ayitey direct ga create cehstaam kada Variables, right Click on control Flow Empty area and click on variables you should see them.

hmmm Nee second question naaku clear ledhu inka, as nenu DTS face eppudu chodaledu, DTS anaganey [img]http://lh4.ggpht.com/-IUiGpNShg_k/USWWVxdHwwI/AAAAAAAAKHU/afUAws2RugE/s150/Brahmi-17.gif[/img]

[Darling999]

[quote name='Doolanagi' timestamp='1365517245' post='1303570460']


New to DB.. Thanks for letting me know bro. will be careful from next time
[/quote]
Doola-nagi aah sarey [img]http://www.nandamurifans.com/forum/uploads/gallery_8818_2_281352.gif[/img]...Welcome to the SQL Pamily...

[deals2buy]

[quote name='DARLING...' timestamp='1365540264' post='1303573142']

Not in Script task, SSIS lo ayitey direct ga create cehstaam kada Variables, right Click on control Flow Empty area and click on variables you should see them.

hmmm Nee second question naaku clear ledhu inka, as nenu DTS face eppudu chodaledu, DTS anaganey [img]http://lh4.ggpht.com/-IUiGpNShg_k/USWWVxdHwwI/AAAAAAAAKHU/afUAws2RugE/s150/Brahmi-17.gif[/img]
[/quote]

em ardham kaaledu...nuvvu SSIS lo cheppinatte DTS lo untundi...