You need to move your module code into a asp file.

I've never seen a VB class module being used within asp.

If you convert your module to a DLL you...

You can disable the snap shot agent on the Publishing server

MW

For the type of date math you're performing I don't think you will

see much of a performance gain. But it make sense to use a varialbe

instead of calling a...

I used this simple script to generate working data

Create Table #Temp_Sessions (Session_Id INT Identity(1,1),

...

The only requirement is that you grant both local and domain accounts access

to login to the sql server (xp_grantlogin or manually using EM). Once the accounts have been granted access...

Exec Master..xp_fixeddrives will give you free space avail. in MB

MW

When you truncate the log file it should reclaim all the virtual log space allocated

for the log file, but not the physical disk space.

In order to reclaim actual physical disk...

Use system proc xp_msver

Exec Master..xp_msver

MW

It is better to let SQL handle resource locking for you since the it takes many

factors into account. Resolve resource contention issues at application

level. You can...

Look at your table column data types, if you're dealing with varchar or nvarchar

your table columns might not have enough room to store imported data.

MW

If I were you I would seriously consider splitting the table.

By that I mean if more than 60%-70% percent of your data is not being

used on a...

Use 2nd procedure stated by (fizzleme)

Steps:

1. Expand Data Transformation tab in Enterprise manager (source server)

2. Highlight local packages

3. Select the desired package, right click and select design package.

4. From the...

I'm not sure if I understood your example, but I think your question

can be answered using this query

Select Count(1) As Rec_Cnt, fld, Count(1) / 3.0 As Div_Result

From tblsample

Group By fld

MW

FOR SQL Server version 6.5

You will need to create a TEMP table as follows and execute sp_MSDBUserProfile proc.

Create Table #SQLOLEDbUserProfile (dbid int NOT NULL PRIMARY KEY,

...

I think bkelly has covered most of it, but I just want to suggest that I don't

think locking down extended proc. should be taken as a security measure.

The...