SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Beginning Administration


Beginning Administration

Author
Message
Vijay Dixon
Vijay Dixon
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
Points: 1 Visits: 1
All thats here is very useful hope u keep updating this....
Loner
Loner
Hall of Fame
Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)

Group: General Forum Members
Points: 3546 Visits: 3350

Thanks for all the information. It sure is very helpful to me.

I just start my job as SQL developer in a small company and I find out they don't have a DBA. My boss said the company was too small and could not afford a full time DBA so he expected all developers to learn to be a DBA. Even though I found it was very overwhelming at first to be a developer and DBA at the same time, now I find it very exciting. There is so much to learn and there is not a boring moment at work.


AMIT GUPTA-263376
AMIT GUPTA-263376
Old Hand
Old Hand (378 reputation)Old Hand (378 reputation)Old Hand (378 reputation)Old Hand (378 reputation)Old Hand (378 reputation)Old Hand (378 reputation)Old Hand (378 reputation)Old Hand (378 reputation)

Group: General Forum Members
Points: 378 Visits: 147

THE RESPONSIBILITY OF DBA IS LARGE.

YOU CAN BUY SOME GOOD BOOKS TO START YOUR Journey.

Care fully read all the aspects?


Muhammed Sajid Hussain
Muhammed Sajid Hussain
SSC Rookie
SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)

Group: General Forum Members
Points: 34 Visits: 48

Hi,

Kindly can you help me for the follownig question...

Whenever a user inserts a record into database(sqlserver), i want to write one trigger such that it fires on a particular date(suppose on sunday) and all the records which have been inserted from monday to saturday should be updated to the server on sunday when the trigger fires.

Please suggest me

Thanks in advance

Best Regards


Randy Barlow
Randy Barlow
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
Points: 1 Visits: 1
Dumb Question: Can someone direct me to something that tells me how to set up Windows XP to work with SQL. When I click on Query, up junps a box wanting a server name, etc. Where do I get that?
Belisama
Belisama
Grasshopper
Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)

Group: General Forum Members
Points: 20 Visits: 13
I'm only a beginner myself, but I think you would want to set this up with a Job rather than with a Trigger. Make a stored procedure that does what you want, and then set the job to run that stored procedure each Sunday. Someone please correct me if this is completely in error.
em

Jim Russell-390299
Jim Russell-390299
SSC Eights!
SSC Eights! (881 reputation)SSC Eights! (881 reputation)SSC Eights! (881 reputation)SSC Eights! (881 reputation)SSC Eights! (881 reputation)SSC Eights! (881 reputation)SSC Eights! (881 reputation)SSC Eights! (881 reputation)

Group: General Forum Members
Points: 881 Visits: 1403

I'd like to see a dummy's guide to assigning permissions to a (new) view for a new user. In particular, defining the logon, creating a group, adding needed permissions for tables/views in other dababases referenced by the view.

I look forward to your beginning administrators material.


Steve S.
Steve S.
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
Points: 1 Visits: 1
Newbie here, to SQL Server 2000 and the forum.

Prior post glitched/vanished somehow.

short version, this time:

SQL 2000.80.2039.0
Win2K3ServerSP1

SQL Enterprise Manager "Properties" on a db says that
transactionlogs for the db are writing to my D: drive,
but .TRN files (BIG ones!) keep appearing on my C: drive.

How to fix?


MANY Thanks!


- S.
Sergiy
Sergiy
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10326 Visits: 11961
See "PERMISSIONS function" topic in BOL.
And topics linked from there.
Sergiy
Sergiy
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10326 Visits: 11961
They must by log files for other databases.
Check the file names and try to find out which database(s) create(s) it.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search