How to transfer Microsoft Outlook data into SQL Server 2000 \ 2005

Hello,
I am looking for a process where by I can transfer Outlook data (Emails)
into SQL Server 2000 \ 2005 for certain urgent analysis.
Can some one please explain me how to accomplish this task?
Thanks in advance.
SurajitDo an EXPORT from Outlook into some sort of CSV file - and then do an IMPORT
into SQL Server via the import/export function
Jack Vamvas
___________________________________
Receive free SQL tips - www.ciquery.com/sqlserver.htm
Make SQL Server faster - www.quicksqlserver.com
___________________________________
"surajits" <surajits@.discussions.microsoft.com> wrote in message
news:FBA08A4D-3094-428C-8B87-56C47DA98C84@.microsoft.com...
> Hello,
> I am looking for a process where by I can transfer Outlook data (Emails)
> into SQL Server 2000 \ 2005 for certain urgent analysis.
> Can some one please explain me how to accomplish this task?
> Thanks in advance.
> Surajit
>sql

How to transfer Microsoft Outlook data into SQL Server 2000 \ 2005

Hello,
I am looking for a process where by I can transfer Outlook data (Emails)
into SQL Server 2000 \ 2005 for certain urgent analysis.
Can some one please explain me how to accomplish this task?
Thanks in advance.
SurajitDo an EXPORT from Outlook into some sort of CSV file - and then do an IMPORT
into SQL Server via the import/export function
Jack Vamvas
___________________________________
Receive free SQL tips - www.ciquery.com/sqlserver.htm
Make SQL Server faster - www.quicksqlserver.com
___________________________________
"surajits" <surajits@.discussions.microsoft.com> wrote in message
news:FBA08A4D-3094-428C-8B87-56C47DA98C84@.microsoft.com...
> Hello,
> I am looking for a process where by I can transfer Outlook data (Emails)
> into SQL Server 2000 \ 2005 for certain urgent analysis.
> Can some one please explain me how to accomplish this task?
> Thanks in advance.
> Surajit
>

how to trace the file activity???

Dear all,
It urgent, can anyone please tell me how to race
the activity which the user have done to the file. e.g.
When the user delete a record from the file, when the
user edit a record from the file and when the user add a
new record to a file from the EM.Please, help.. Thanks.
Regards
Sharon
.There are several ways. One is to add a trigger to every table you wish to
audit that keeps track of all this activity. Of coarse this doesn't help
for any activity that already happened. Another much easier way is to use a
3rd party product such as Log Explorer from www.lumigent.com to look at the
log files and see the history. Of coarse if you have already truncated the
logs you may not have the information.
Andrew J. Kelly
SQL Server MVP
"sharon" <anonymous@.discussions.microsoft.com> wrote in message
news:130a901c44390$4ac6a320$a601280a@.phx
.gbl...
> Dear all,
> It urgent, can anyone please tell me how to race
> the activity which the user have done to the file. e.g.
> When the user delete a record from the file, when the
> user edit a record from the file and when the user add a
> new record to a file from the EM.Please, help.. Thanks.
> Regards
> Sharon
>
> .
>sql

How to trace the database activity

Dear all,
It urgent, can anyone please tell me how to race
the activity which the user have done to the file. e.g.
When the user delete a record from the file, when the
user edit a record from the file and when the user add a
new record to a file from the EM.Please, help.. Thanks.
Regards
Sharon
Please don't post independently in multiple newsgroups. You can add the
other newsgroups in the "Newsgroups" section in the header and it will show
up in all those simultaneously as will the answers. See my reply in the
other newsgroup.

Andrew J. Kelly
SQL Server MVP
"sharon" <anonymous@.discussions.microsoft.com> wrote in message
news:1329601c44387$f1f0c2b0$a501280a@.phx.gbl...
> Dear all,
> It urgent, can anyone please tell me how to race
> the activity which the user have done to the file. e.g.
> When the user delete a record from the file, when the
> user edit a record from the file and when the user add a
> new record to a file from the EM.Please, help.. Thanks.
> Regards
> Sharon
>

How to tell version difference between 2000 Enterprise vs. Standard

I have kind of an urgent need here. I need to know if there is a dll file or registry key or something of that nature that I can query on to find out if my SQL 2000 installations are Enterprise or Standard.

I understand I can do this using query analyser, but that will not work with my reporting tool (this is for reporting numbers of SQL installations in our very large enterprise for Microsoft license compliance).

Thanks for any guidance!!

Cheryl Marland

cheryl.marland@.va.gov

In SQL 2000 that information is not written to the registry in a readable format.

If you can't run osql in the discovery process, you could create a windows batch file that's scheduled to run every night at midnight - the batch job could run

select convert(char(20), serverproperty('edition'))
go

and dump the results to an output file. If you can't read the file you could author the script to update a reg key with the information so you're reporting process could pick it up.

Cheers,
Dan

|||

Dan,

Is this info more readily available in SQL 2005?

How to tell version difference between 2000 Enterprise vs. Standard

I have kind of an urgent need here. I need to know if there is a dll file or registry key or something of that nature that I can query on to find out if my SQL 2000 installations are Enterprise or Standard.

I understand I can do this using query analyser, but that will not work with my reporting tool (this is for reporting numbers of SQL installations in our very large enterprise for Microsoft license compliance).

Thanks for any guidance!!

Cheryl Marland

cheryl.marland@.va.gov

In SQL 2000 that information is not written to the registry in a readable format.

If you can't run osql in the discovery process, you could create a windows batch file that's scheduled to run every night at midnight - the batch job could run

select convert(char(20), serverproperty('edition'))
go

and dump the results to an output file. If you can't read the file you could author the script to update a reg key with the information so you're reporting process could pick it up.

Cheers,
Dan

|||

Dan,

Is this info more readily available in SQL 2005?

How to store images in sql server 2005? Urgent Please....

Hi Every 1

Please tel me How to store images in Sql Server2005?

please send me a solution.

Thanks in advance..

I don't know anything about this but since you seemed in a hurry and no one has responded...have you checked the following pages? It may have the information you need...if no - sorry for wasting your time.

http://www.eggheadcafe.com/articles/20030624.asp

http://www.codeproject.com/aspnet/PicManager.asp

-hth-

Smitha

|||

Hi,

You can find the solution at

http://chiragrdarji.wordpress.com/2007/03/05/storing-and-retrieving-image-in-sql-server/

If you want I can explain you in detail.

How to store images in sql server 2005? Urgent Please....

Hi Every 1

Please tel me How to store images in Sql Server2005?

please send me a solution.

Thanks in advance..

I don't know anything about this but since you seemed in a hurry and no one has responded...have you checked the following pages? It may have the information you need...if no - sorry for wasting your time.

http://www.eggheadcafe.com/articles/20030624.asp

http://www.codeproject.com/aspnet/PicManager.asp

-hth-

Smitha

|||

Hi,

You can find the solution at

http://chiragrdarji.wordpress.com/2007/03/05/storing-and-retrieving-image-in-sql-server/

If you want I can explain you in detail.