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


Beginning Administration


Beginning Administration

Author
Message
MegaDBA
MegaDBA
SSC Eights!
SSC Eights! (934 reputation)SSC Eights! (934 reputation)SSC Eights! (934 reputation)SSC Eights! (934 reputation)SSC Eights! (934 reputation)SSC Eights! (934 reputation)SSC Eights! (934 reputation)SSC Eights! (934 reputation)

Group: General Forum Members
Points: 934 Visits: 169

I would like to see some sample MS SQL server standards documentation writing guides or similar...Any guidance in that area would be idea...Also, product review to assist the newbie in different dB task would be awesome...like telling newbies about SQL Compare, etc...

Thanks,

Christine






Aurora
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
SSCertifiable
SSCertifiable (6.6K reputation)SSCertifiable (6.6K reputation)SSCertifiable (6.6K reputation)SSCertifiable (6.6K reputation)SSCertifiable (6.6K reputation)SSCertifiable (6.6K reputation)SSCertifiable (6.6K reputation)SSCertifiable (6.6K reputation)

Group: General Forum Members
Points: 6552 Visits: 3364

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
Ten Centuries
Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)

Group: General Forum Members
Points: 1018 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
Valued Member
Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)

Group: General Forum Members
Points: 50 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
SSC Rookie
SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)

Group: General Forum Members
Points: 38 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
SSCrazy
SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)

Group: General Forum Members
Points: 2331 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
One Orange Chip
One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)

Group: General Forum Members
Points: 26420 Visits: 12488
See "PERMISSIONS function" topic in BOL.
And topics linked from there.
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