Beginning Administration

Question

Beginning Administration

Viewing 15 posts - 16 through 30 (of 36 total)

You must be logged in to reply to this topic. Login to reply

TIMOTHY A. JUMONVILLE Newbie Points: 7 More actions · Answer 1

I'M NEW TO THIS...

HAVE MSACCESS DATABASE SPLIT INTO DATABASE AND DATABASE_BE. GETTING TOO BIG FOR ACCESS. WANT TO PUT THE BACK END INTO SQL SERVER AND USE THE FRONT END TO MANIPULATE, ETC.

HOW DO I GET THE BACK END INTO SQL SERVER?

THANKS =)

Frank Kalis SSC Guru Points: 111183 More actions · Answer 2

http://msdn.microsoft.com/sql/default.aspx?pull=/library/en-us/dnsql2k/html/sqlbackend.asp

http://www.support.microsoft.com/?scid=kb;en-us;237980

http://support.microsoft.com/default.aspx?scid=kb;EN-US;884457

http://support.microsoft.com/default.aspx?scid=kb;EN-US;241743

should get you going. A search here in the fora might also be helpful.

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

David Thayer SSChasing Mays Points: 622 More actions · Answer 3

Pretty easy to DTS the data into your SQL Server and link to it through Access (ODBC).

mikal r. pippins SSC Rookie Points: 28 More actions · Answer 4

Better do it with a copy first when you have plenty of free time. Things are about to get real different.

We have met the enemy and he is us.

MegaDBA Hall of Fame Points: 3518 More actions · Answer 5

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 Grasshopper Points: 15 More actions · Answer 6

All thats here is very useful hope u keep updating this....

Loner SSC-Insane Points: 21279 More actions · Answer 7

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 SSCarpal Tunnel Points: 4244 More actions · Answer 8

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 SSC Veteran Points: 290 More actions · Answer 9

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 Newbie Points: 3 More actions · Answer 10

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 SSC Enthusiast Points: 188 More actions · Answer 11

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 SSCrazy Eights Points: 9333 More actions · Answer 12

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. Grasshopper Points: 11 More actions · Answer 13

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 SSC Guru Points: 110209 More actions · Answer 14

See "PERMISSIONS function" topic in BOL.

And topics linked from there.

_____________
Code for TallyGenerator

Sergiy SSC Guru Points: 110209 More actions · Answer 15

They must by log files for other databases.

Check the file names and try to find out which database(s) create(s) it.

_____________
Code for TallyGenerator