Do not allow users direct access to tables by creating views.

Create groups, assign group permissions, assign users to a group.

Use only stored procedures, and when expecting user input use Stored...

For a good series of freebie tutorials

SSQL Tutorials

http://msdn.microsoft.com/en-us/library/ms169620.aspx

A specific subject matter tutorial (SQL Server Management Studio)

Try this amongst many others

SSMS

http://msdn.microsoft.com/en-us/library/ms166547.aspx

If your company is willing to pay try this...

Sorry I am not even a novice with reporting services, and this is a manual solution but could provide what you want.

In the second sheet of the Excel workbook if...

Try something like this:

DECLARE @new AS INT

DECLARE @NewScode AS VARCHAR(150)

DECLARE @Len AS INT -- number of characters to be used

SET @Len = 5 -- assumed to be 5...

First of all this input data

INSERT INTO [dbo].[propbut_pr] ([HCODE],[SCODE],[STITLE],[SEMPLOYEE],[DHOURLYRATE],

...

If you do not want to spend many $$$ for SQL 2005 ... try using the DEVELOPER version.... available from Amazon for 45 to 50 USD depending on what...

To have someone guide you to the proper answer, it would help if you posted your question in a meaningful format Please follow the link in my signature and...

Jacob Pressures

Here is my code to use a stored procedure to return a Record set.

Public Cnn As ADODB.Connection

Public Cnn_String As String

Public cmd_Param as ADODB.Parameter

Public Rs as ADODB.Recordset

Set Ado_Cmd = New...

Jacob what are you using .. VB6 w/ADO, VB dot Net w/ADO dot Net or C# , or C++, VB2005 or?

Using dynamic SQL as:

DECLARE @cmd VARCHAR(4000)

DECLARE @currentdate VARCHAR(10)

select @currentdate = convert(varchar(8),getdate(),112)

SET @cmd = 'INSERT INTO OPENROWSET(''Microsoft.Jet.OLEDB.4.0'',

...

Read GSquared's reply carefully it says

and

. What is meant is 10 to 20 rows as a representative sample....

Start your reading here:

Data Transformation Services (SQL Server 2000)

DTS Import/Export Wizard

URL: http://msdn.microsoft.com/en-us/library/aa176528(SQL.80).aspx

From BOL

The arguments of OPENROWSET and OPENDATASOURCE do not support variables. The arguments must be specified as string-literals. If variables must be passed in as arguments, a query string...

If your log file was created without a growth factor (either percentage or maximum size )-- a most unusual configuration. That said unless your database has undergone a significant...

Would suggest you

First download SQL Server 2005 Express - a free version of SQL 2005 with enough capability to get you started and keep you learning for a substantial period...