You can many tools to migrate data from SQL Server to Oracle or other data platforms and vice versa. Since it is 2000, you could use DTS. if you have...

What is the issue you are having?

NULL represents a value that is "Unknown" or "Not Known".

If you add something to "Unknown" the result will be unknown so 1+NULL = NULL.

In the case of SUM function, I...

Adding indexes on columns in general depends on a lot of factors.

Adding an index on a foreign key column would make sense if both the parent and child tables have...

Can you elaborate on your question? Its very vague. Report should never be used to update data.

Here is a link that explains UAC and a step by step guide.

http://technet.microsoft.com/en-us/library/cc709691(WS.10).aspx

Really dumb of me. In the Browser, security options for Intranet sites, i set it automatic login using current username and password fixed the issue.

Thanks GP for your help. All...

What is the content database reference? Is it sharepoint content database?

Thanks

The backupset table has the necessary information. Try running this query. You can exclude the where criteria for all database backup operations.

select TYPE, media_set_id, first_lsn, database_backup_lsn, backup_start_date, database_name, differential_base_lsn

from msdb.dbo.backupset

where...

Interesting article. I used to wonder why companies dont do that. Few years ago I was trying to fill a position at the company I was working. I went through...

Permissions are set. The Report Manager URL is part of the trusted sites.

The user is an administrator on the machine. Have set the services to run using the specific user...

I know you can limit the total number of concurrent user connections to a max of 32767 but dont believe it can be limited for a specific user.

GP,

I reviewed stuff on the link. I have checked everything and still dont have the issue resolved.

Anything else I can check.

Appreciate the help.

Thanks

Try this one. I had to use this open source on of my projects.

http://www.sqlpower.ca/page/architect#reviews

You could use SSIS to accomplish that. Without spedning too much time, you could use a combination of Script Task and FTP Task in SSIS to do what you need.

Assummption...