http://support.microsoft.com/default.aspx?scid=kb;EN-US;937531

Using your Windows Explorer from the server where SQL server is instaleld try to get to the folder you are specifying for the linked server.

If "A" is a name of...

bindueldo,

leave RMTUser name empty. If you are not using custom build security in Access, access user name should be omitted.

If your SQL server account is running under domain account security...

I guess there are two questions in one thread. However, to begin with: is it possible to clarify what version of SQL server are we talking about?

What is the nature...

Your security on the linked server should use authentication which will allow authenticated account accessing the file share of Access DB.

"Admin" is a default user of Access database, not a...

If it is for the reasons of an external SQL generator, can you substitute actual columns order by using extended properties on the columns?

This way, your solution will be flexible...

Here you go:

http://www.eggheadcafe.com/forumarchives/solomon/jan2006/post26005713.asp

BOL for sp_changedbowner:

[@loginame = ] 'login'

Is the login ID of the new owner of the current database. login is sysname, with no default. login must be an already existing...

I think (and I saw it somewhere on Crystal support Web site), that simply copying deleted DLL files from installation CD in to the dedicated folder will fix the problem.

When you are backing up or restoring - it is SQL server accounts that are accessing the share. If your SQL server accounts do not have modify rights on the...

jsheed,

the link I provided contains a chapter "Example of WMI Event Alert".

This chapter contains a step-by-step instructions and code that you need to run. That is the easiest and most...

Sorry. Here is the final version:

You have to make sure that the folder d:\Data exists.

declare @name nvarchar(200)

declare @month nvarchar(100)

declare @year nvarchar(100)

declare @filename nvarchar(900)

set @filename = N'D:\Data\'+@name+ '_Data.MDF'

set @month = month(convert(nvarchar(16),getdate(),112))

set...

Example of WMI Event Alert:

http://www.microsoft.com/technet/prodtechnol/sql/2005/newsqlagent.mspx

Several syntacs mistakes:

declare @name nvarchar(200)

declare @month nvarchar(100)

declare @year nvarchar(100)

declare @filename nvarchar(900)

set @filename = N'D:\Data\'+@name+ '_Data.MDF'

set @month = month(convert(nvarchar(16),getdate(),112))

set @year = year(convert(nvarchar(16),getdate()))

set @name = N'Weblog'+@year+@month

--print @name

print @filename

-- This step will take...

Can you please provide details on the notification requirements?

The easiest way would be to use SQL Server Agent and WMI providers with "net send" alert notification.