How Do I Join A Role?

How do I configure myself for the fixed server sysadmin role? I'm learning
all about SQL Server and would appreciate your advice. Thanks.You need to use an account that is already a member of the sysadmin role.
Maybe the sa account. Then go to Security, Server Roles, System
Administrators and add your account to the sysadmin server role.
Hope this helps,
Ben Nevarez, MCDBA, OCP
Database Administrator
"Dominick D." wrote:
> How do I configure myself for the fixed server sysadmin role? I'm learning
> all about SQL Server and would appreciate your advice. Thanks.

How do I insert a word doc into a varbinary(max) field for full-text indexing

Need to start learning to use full-text and need to know how to insert word docs, emails, into the database. How is metadata retirieved from these sources and are they loaded into separate tables fields?

Thanks

Looks like I got my answer:

USE AdventureWorks GO CREATE TABLE myTable(FileName nvarchar(60), FileType nvarchar(60), Document varbinary(max)) GO INSERT INTO myTable(FileName, FileType, Document) SELECT 'Text1.txt' AS FileName, '.txt' AS FileType, * FROM OPENROWSET(BULK N'C:\Text1.txt', SINGLE_BLOB) AS Document GOThanks