You need to create a user defined function which will return the lastest date and Access Level.

Someting like

Select distinct User_Id, UserName, dbo.getmaxDate(User_Id), dbo.GetMaxAccessLevel(User_Id) From Users

Order by MaxDate desc

dbo.getmaxDate and...

try this

select LEFT(CONVERT(VARCHAR(8), GetDate(), 8), 5)

if you are not using Microsoft Indexing Service then stop it from the services panel

Create a table with queries and conditions,

Loop through the cursor and match the condition with the condition value from the table and get the query

something like

declare c cursor for...

I started the database with 200 tables and usually it happens when your system is in production more and more tables have to be created every month, i execute campaigns...

Due to security bcp is disabled on machines so you need to use SSIS packages.

Use script command and write code in VB

The example i have is to write in...

Due to security bcp is disabled so you need to use SSIS packages.

Use script command and write code in VB

The example i have is to write in excel from...

try this

INSERT INTO IMAGESTABLE

(CUSTOMER_ID,IMAGEFIELD)

SELECT 1000001, BulkColumn

FROM OPENROWSET(BULK N'\\SERVER\DOSCAN\Testing\10987553578387.tif', SINGLE_BLOB) AS Document

When specifing from cold fusion, the request time out is set by default. Timeout property can be implemented and value can be expanded to aviod timeout problems.

i was getting timeout...

as the server is the same then it will be a manual process.

So you have to give read only right for the producttion database and dbo rights for the test...

i dont know if you can create 2 database with the same name on the same server. you can create the database with differnet name and use different sql user...

i found the fix. i use \\servernameetwork_path and give appropriate permissions.

did you solve the problem?

I am getting the same error. I am trying to open the file using OLEDB

i suggest using the update command as an alternative to cursors.

UPDATE T_TEMP SET

...