Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««1234»»

Beginning Administration Expand / Collapse
Author
Message
Posted Thursday, December 29, 2005 9:37 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, August 21, 2012 12:50 PM
Points: 416, 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
Post #247259
Posted Friday, January 27, 2006 5:37 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, January 27, 2006 5:02 AM
Points: 1, Visits: 1
All thats here is very useful hope u keep updating this....
Post #254041
Posted Monday, February 13, 2006 9:32 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, July 17, 2014 7:55 AM
Points: 2,805, Visits: 3,067

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.

Post #257947
Posted Wednesday, February 15, 2006 3:27 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, January 19, 2009 4:02 PM
Points: 223, Visits: 108

THE RESPONSIBILITY OF DBA IS LARGE.

YOU CAN BUY SOME GOOD BOOKS TO START YOUR Journey.

Care fully read all the aspects?

 

 

Post #258538
Posted Monday, March 20, 2006 9:17 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Saturday, April 14, 2012 8:28 AM
Points: 26, 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

 

 

Post #266993
Posted Thursday, March 23, 2006 3:37 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, March 24, 2006 1:25 PM
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?
Post #268085
Posted Friday, September 1, 2006 7:12 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, April 1, 2008 12:25 PM
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
Post #305641
Posted Tuesday, March 20, 2007 1:08 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, July 30, 2010 11:27 AM
Points: 435, Visits: 1,403

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.

Post #352774
Posted Thursday, April 26, 2007 9:27 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, May 4, 2007 10:08 AM
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.
Post #361430
Posted Thursday, May 3, 2007 6:55 PM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Sunday, July 20, 2014 5:23 PM
Points: 4,576, Visits: 8,341
See "PERMISSIONS function" topic in BOL.
And topics linked from there.
Post #363193
« Prev Topic | Next Topic »

Add to briefcase «««1234»»

Permissions Expand / Collapse