SQL Server Tools General Forum

Componets

Sat, 28 Nov 2009 00:09:24 Z

Hi Every body,

I had instelled MS SQL ERVER 2005 In my system
but how can i started these components in my system could you please suggest me how can we start all the serverices step by step

because i have to prepare some docs for this could any body plz sugest me

Database Engine Services

Analysis Services

Reporting Services

Integration Services

Service broker

Replication

Full-Text Search

Notification Services.

subu

Stored Procedure

Fri, 27 Nov 2009 07:42:45 Z

I am trying to excute the following stored procedure but i am getting error "Incorrect syntax near 'GO'. "
CREATE PROCEDURE InsertEmployee
@EmployeeID int OUTPUT,
@FirstName varchar(10),
@LastName varchar(10),
@Title varchar(10)
AS
INSERT INTO Employee(title,lastname,firstname,hiredate) VALUES(@Title,@LastName,@FirstName,GETDATE());
SET @EmployeeID= @@IDENTITY
GO

Could anyone help me out and let me know where exactly the problem is...

would appreciate your help
Thanks,
Pradeep

[264] An attempt was made to send an email when no email session has been established

Wed, 14 Dec 2005 05:26:18 Z

[264] An attempt was made to send an email when no email session has been established

is the error I get when I try to send mail on the database.

It is a SQL Server 2005 Standard edition. I have configured database mail and tested it and it works there, then I configured a database operator. then I just created a test job to notify the operator of the job completion, and the email fails.

Any ideas?

Ryk

Maintenance Plans fail with errorcode -1073548784

Wed, 25 Nov 2009 19:28:34 Z

Hi everyone,

We've a problem when we want to do a reorganization of indexes, it give us the following error:

Error Number: -1073548784

Error message:

Executing the query "ALTER INDEX [ARFCRDATA~0] ON [qas].[ARFCRDATA] REORGANIZE WITH ( LOB_COMPACTION = ON )
" failed with the following error: "The index "ARFCRDATA~0" (partition 1) on table "ARFCRDATA" cannot be reorganized because page level locking is disabled.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

We're using SQL Server 2005 with SAP ECC 6.0.

Have you any idea to solve this??
I'm created the plan with the wizard, and manually, and the same error occurs.

Thanks in advance

Changing to Mssql and using Mysql

Wed, 25 Nov 2009 13:33:08 Z

Hi,

I have been using Mysql. We are changing to Mssql. We have an important load of customer data on Mysql.

Could you help me on this change?

Thanks for the feedback.

SQL Server 2008R2 Nov CTP - Output in sqlcmd truncated after 512 characters

Thu, 26 Nov 2009 19:55:42 Z

I have been doing some tests with the SQL Server 2008 R2 November CTP.

I think that I have run into a bug in or related to sqlcmd. It's like the output is truncated after 512 characters. I noticed it because some of my log files looked strange. I did this test.

sqlcmd -E -S .\Test -d master -Q "PRINT REPLICATE('A',1000)" -b -o C:\Test.txt

It is truncating the line after 512 characters. It hasn't been like this before. Does anyone know if it's a bug or some changed behaviour by design? I have reported it on Microsoft Connect.

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=510344

Ola Hallengren

http://ola.hallengren.com

Event ID: 1101

Wed, 25 Nov 2009 04:49:22 Z

Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 1101
Date:  11/25/2009
Time:  1:15:16 AM
User:  BOK\FOREFRONT
Computer:

Description:
Could not allocate a new page for database 'SystemCenterReporting' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.

For more information, see Help and

Support Center at http://go.microsoft.com/fwlink/events.asp.

How to expand or add tablespaces or data files ?? There are some other tables that we need to add spaces. Please I need step-by-step guidelines !!

Event sequence column are missed when use profiler to save a trace file into .xml file

Thu, 26 Nov 2009 06:04:23 Z

I use profiler (katmai version) to open a Yukon trace file, then store the trace file into a .xml file. When i open the .xml file, all events' sequence are 0!
Is there profiler's bug? Are there any work around ways to reserve the original sequences when save one Yukon trace file into .xml file?

Problem in sql server 2008 reinstallation issue in windows vista

Thu, 26 Nov 2009 15:35:34 Z

I hace problem when reinstalling my sql server 2008 express edition, !its give error message like "This version is not compatible with the version of Windows you are running.

Check the system on your computer to find out that you can use a x86 version (32bit) or x64 version (64 bit) program, and you can then contact the publisher of the software."

Im using Windows vista service pack 1 .

pl help!!

Calculating table size

Fri, 21 Apr 2006 17:03:25 Z

I have a BIG database with 8 tables growing rapidly. I would like to estimate the size of a row in disk space so I can predict how big my bd will grow in time. I know the math to calculate this but I'm look for a tool to automate this task. A tool that takes into accout calculating index size aside from table size.

I would really apreciate any help on this.

regards

A network-related or instance-specific error

Wed, 25 Nov 2009 14:20:27 Z

Data Source=SERVER\SSGSQL;Initial Catalog=myDatabase;User Id=sa;Password=abc123;

I am trying to install SQL SErver 2008 Express on WIndows Server 2008 64-bit. Installation was successfull and i am able to use the sql sever on the server with no issuie but when connecting from another machine using the above connection string I get this error though I enabled the TCP/IP and Name Pipes and the login method is Mixed and Firewall is accepting 1433 port:!

TITLE: Connect to Server
------------------------------

Cannot connect to SERVER\SSGSQL.

------------------------------
ADDITIONAL INFORMATION:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 1326)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=1326&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

Jassim Rahma

Management Studio, Save as... dialog before running External Tools

Tue, 14 Nov 2006 12:21:21 Z

Hi.

In Management Studio I have defined some external tools. When I call my external tool from Tools menu and I have query scripts that are not saved I get "Save File As..." dialog for EVERY not saved script before running my External Tool. This is frustrating because sometimes I have a lot of not saved scripts and my External Tool doesn't need saved script files. How to run External tool in Mangement Studio without this frustrating "Save File As..." dialog box?

Kamil

SSMS - Getting NULL from procedure output in SSMS output grid window

Mon, 23 Nov 2009 17:08:30 Z

hello,

Version is SQL Server 2005.

One of procedure which is returning xml output, was working fine since long. No patch applied recently.

Only in SSMS, getting null instead of xml. Can see a portion (not all) of output in text output window and file.

Tools=>Options=> Query result to grid output for xml is set to Unlimited.

I wonder why i am not getting xml for this in grid output ?

Any reason ?

Think BIG but Positive, may be GLOBAL better UNIVERSAL.

script and query from another machine?

Thu, 26 Nov 2009 03:57:26 Z

I am new to MSSQL
I brought home some scripts from work to try and duplicate the DB I am working with. I have sql server 2008 installed on my server at home.
I have no idea how to run them!

I don't see any command line type client like I got with oracle.
Nor do I see any options when I put the install disk in my other machine, aside from installing another instance of sql server.

I googled and found that "query analyzer" might be what I need. However, I do not see that installed on either machine from the sql server 2008 cd.

What do I need to do in order to get this rolling?
I tried just using visual studio, which connects, but it doesn't allow me to create tables using its query builder (it gives a message saying create is not supported)

Error while expanding "tables"

Tue, 24 Nov 2009 13:28:12 Z

Hi, I've recently joined a company and they've posed me a very interesting question. They can log on to a database server using the sa account. They can expand "Databases" and thats fine. However, when you attempt to expand the "Tables" or the "Stored Procedures" folders, an error occurs. I have never seen this before. Can anyone offer some assistance in this?

Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)

ADDITIONAL INFORMATION:

A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The specified network name is no longer available.) (Microsoft SQL Server, Error: 64)

Kind Regards

Andy

Maintenance Plan Failed

Tue, 24 Nov 2009 01:29:36 Z

Hi.

We have a SQL Server 2005 Standard Ed SP3, our Maintenance Plan has been working fine till last week it failed doing Full Back up, Check Database Integrity, Rebuild Index and Shrink Database and all producing the similar below errors: -

Date        23/11/2009 11:00:00 PM
Log        Job History (Maintenance Plan - Architect.Back Up ALL Database)

Step ID        1
Server        ARCHITECT
Job Name        Maintenance Plan - Architect.Back Up ALL Database
Step Name        Back Up ALL Database
Duration        00:13:17
Sql Severity        0
Sql Message ID        0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted        0

Message
Executed as user: ARCHITECT\SYSTEM. ....00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved.    Started: 11:00:01 PM Progress: 2009-11-23 23:00:36.04     Source: {69346A4B-4963-4E17-B626-68F0825CCD3F}      Executing query "DECLARE @Guid UNIQUEIDENTIFIER      EXECUTE msdb..sp".: 100% complete End Progress Progress: 2009-11-23 23:00:37.29     Source: Back Up Database (Full)      Executing query "EXECUTE master.dbo.xp_create_subdir N'E:\Backup\ma".: 2% complete End Progress Progress: 2009-11-23 23:00:37.31     Source: Back Up Database (Full)      Executing query "EXECUTE master.dbo.xp_create_subdir N'E:\Backup\mo".: 4% complete End Progress Progress: 2009-11-23 23:00:37.32     Source: Back Up Database (Full)      Executing query "EXECUTE master.dbo.xp_create_subdir N'E:\Backup\ms".: 6% complete End Progress Progress: 2009-11-23 23:00:37.34     Source: Back Up Database (Full)      Executing query "EXECUTE master.dbo.xp... The package execution fa... The step failed.

Any advised or suggestion would be appreciated. Thanks!

sql server/windows performance monitor counter

Mon, 23 Nov 2009 21:00:51 Z

i want to monitor windows server performance using sql server..for that i m using performance monitor..
can u guys tell me the exact value for each counter..so i can make change...
like

Object: - Paging File

Counter: - %Usage

Preferred Value: - < 70%

Description: - The peak usage of the Page File instance in percent.

Reference: - KB 889654

i want all the values for all counters....

thanks

SQL Server Managment Studio Express 2008 - can't see connect to server dialog

Fri, 20 Nov 2009 03:34:57 Z

I am running Vista Home Premium with SQL Server 2008 Express and Management Studio Express 2008.

I have three monitors. The primary monitor is vertical and the other two are horizontal.

When I start SSMS, it launches on the last monitor used.

If the last monitor used was the vertically oriented monitor, the "Connect to Server" dialog launches in the center of the screen.

If the last monitor used was one of the horizontal monitors, the "Connect to Server" dialog launches off the top of the screen. I need to hit ALT-SPACE, M, then use the down-arrow key to move the dialog down to where I can see it.

I know this is an unusual configuration... three monitors isn't the norm, neither are vertically oriented monitors. But this is a PITA and I'd love a fix.

This only happens when I set the vertically oriented monitor as the "main" monitor under "Display Settings". If I set one of the horizontal monitors as the "main" monitor, SSMS launches with the "Connect to Server" dialog visible on all monitors.

regards,

Marc

(BTW: Why three monitors? I write a lot of client/server and multi-tier code. I like having the specifications or running applications on one monitor, the SSMS on a second and code/debugger (Visual Studio at work, Visual Basic Express at home) on the third. Vertical orientation for writing code... code is taller than it is wide, so as long as I popped for large monitors, I may as well use all of the available viewing area)

Cannot access local sql server 2008 instance via "localhost" ???

Wed, 25 Nov 2009 12:27:25 Z

Hi,

I have a local instance of SQL 2008 installed called ComputerName\SQL2008.

When I try to for example connect to this local instance of SQL 2008 using management studio etc.
I have to use "ComputerName\SQL2008"
I cannot use "localhost"
why not?

I.W Coetzer

SQL Server 2005 Development with SQL Server Management Server.

Tue, 24 Nov 2009 04:31:40 Z

If I have purchased a Microsoft licensed copy of SQL Server 2005, and wish
to handle coding of my database with a Microsoft CASE tool,
if coding in a Commercial (Professional) context,
must I use the full SQL Server Management Studio,
or may I use the Express version and not purchase
a license for it?

SQL Server Express Edition (DTS wizard)

Fri, 09 Sep 2005 14:12:45 Z

Hi
I have a quick question. where I can find DTS wizard in SQL Server Express (Evaluation version).
Actually I want to transfer data from Excel sheet to database. Please let me know.
Thanking You
Anshu

SQL 2008 Management Datawarehouse. Data Collection, Query Statistics, collection_set_3_upload job failing

Tue, 10 Nov 2009 22:24:46 Z

The Data Collection jobs which uploads the Query Statistics information errors continually due to a bigint calculation which leads to "Arithmetic overflow error converting expression to data type int."

The data collector log has the following messages:

SSIS error. Component name: DFT - Create Interesting Queries Last Snapshot, Code: -1073450982, Subcomponent: SSIS.Pipeline, Description: component "OLE DB Source" (1055) failed the pre-execute phase and returned error code 0xC0202009. .

SSIS error. Component name: DFT - Create Interesting Queries Upload Batch, Code: -1073450982, Subcomponent: SSIS.Pipeline, Description: component "ODS - Get current snapshot of dm_exec_query_stats" (16412) failed the pre-execute phase and returned error code 0xC0202009. .

Does anybody have a workaround for these errors? ... This was already posted to connect.microsoft.com but nobody gave any solution.

New install does not show anything but Database engine

Fri, 20 Nov 2009 21:17:19 Z

Hi, I just installed the Developer edition of SQL Server 2008 on a Windox XP machine SP2. I previously had the express version installed. I installed using a new instance and installed everything (except Replication and Full-Text search, which failed). Normally when I do an developer install it allows me to see Analaysis Services and SSIS and Reporting services under the Management Studio, but they do not appear, I can't see them anywhere. Reporting Services did install as I can get to it through the Reporting Services manager. I went back to the CD and it has all of these checked as being installed but I can't find them? Is this a problem with having installed express? Thank you.

Import excel spreadsheet into SQL Server 2005

Tue, 24 Nov 2009 19:47:21 Z

I'm trying to import an Excel 2003 spreadsheet into SQL Server 2005 Enterprise edition

My code is the following:


SELECT * INTO [dbo].[_Servers]
FROM OPENROWSET
('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=c:\_servers.xls;HDR=Yes','SELECT * FROM[_server$]')

I'm getting the following error message.
"Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)"."

Any ideas why I'm getting this message?

Kevin Scott

SQL server 2008 compact editioin: can we change the table name after creating table has been saved?

Tue, 24 Nov 2009 18:59:20 Z

we have use SQL server 2008 compact database, can we change the table name after creating the table has been saved?
thx!

Publish provider option SQL Server Management Studio

Mon, 23 Nov 2009 21:02:40 Z

There is publish provider option in Sql Server Management Studio Express?

Actually, I have used this option in Visual Studio 2008 (Serves explorer) and is very easy for scripting Schema and Data.
I just saw this option in Visual Studio. In SQl Server Management Studio, there is the option to generate scripts but only to attach the schema objects and I also need data.

Unable to monitor .NET CLR SQL Data Provider perf counters

Mon, 23 Nov 2009 22:37:12 Z

I'm unable to see the value of any of the performance counters for SqlClient in the '.NET CLR Data' category in Reliability and Performance tool on our web server. When I open up performance monitor, select Add Counters..., and look at the counters for localhost, I see the SqlClient performance counters under the '.NET CLR Data' category, but for every one of them there are no instances -- in the 'Instances of selected object:' section there are two greyed out items: <All instances> and <No Instances>. Adding the counter to the view has no effect.

I would like to see the values of these counters to determine whether or not some issues are related to the application's handling of database connections.

Installed framework version: 3.5sp1 ([System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089], file version=2.0.50727.3053)
OS: 2008 server standard

nick

Excessive Log File Growth

Mon, 23 Nov 2009 15:29:19 Z

Have a SQL 2008 Server running an Infor SunSystems database.

I am trying to troubleshoot a problem where the log file has grown to over 700 GB in a 2 month period. Autogrowth for the database is set at 20% unrestricted for the data and 10% unrestricted for the log.

I am a novice DBA with some experience with managing databases, however I've never seen a problem like this one.

Any suggestions would be appreciated.

How to know size of log before truncated

Mon, 23 Nov 2009 18:25:51 Z

I got an error the other day on backup of log file, but then it ran next time successfully and truncated the log as it is supposed to every time, but it appears as if the log file was out of space when it failed. Is there a way to know how big a log file was before being truncated. I thought there was some kind of sys table that contains this info, but could be wrong

DBA

Strange Icon in SQL Server object explorer

Mon, 23 Nov 2009 13:58:55 Z

I am surprised with this icon appearing in my object explorer. Don't know what it indicates. My SQL Server service is up and running and there is no problem with it.
http://1.bp.blogspot.com/_-nKydy3QVrk/SwqTWp42QcI/AAAAAAAAACU/qH4A9kiYf-U/s1600/sql+icon.JPG

Would appreciate any help or suggestion towards this..

Regards
Biswajit

DBs Appear twice in SQL Server Management Studio

Tue, 17 Nov 2009 14:17:30 Z

I have a new installation of SQL 2005 Standard on a virtualized copy of Windows Server 2008. I updated the instance to Service Pack 3 after installation. I believe it's a pretty standard install, including Reporting services.

When I connect to the instance from a separate Vista desktop using SSMS 2008, I see double. The ReportServer and ReportServerTempDB both appear twice. The System Databases "folder" appears twice, as well as the Database Snapshots "folder." (Inside each System Databases "folder," the system databases are listed only once.) When I connect using SSMS 2005 from the host itself, I do not have the same problem. Everything appears as it should.

What on earth have I done? I have plenty of other 2005 instances at SP3 running that do not exhibit this strange behavior.

Any help is greatly appreciated. I don't know if I can trust the instance or if I should consider rebuilding it.

Thanks,

PJDiller

Cannot send emails

Sun, 22 Nov 2009 00:51:33 Z

Hi all,

I'm a SQL newbie so bear with me.

I'm trying to setup email alerts for when jobs fail. I have configured DBmail and when I try sending a test email I get:

TITLE: Microsoft SQL Server Management Studio
------------------------------

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------
ADDITIONAL INFORMATION:

Mail not queued. Database Mail is stopped. Use sysmail_start_sp to start Database Mail. (Microsoft SQL Server, Error: 14641)

**********

OK when I use sysmail_start_sp i get the following:

Cannot alter the queue 'ExternalMailQueue', because it does not exist or you do not have permission.

I'm pretty sure I have permissions. I am logged in as the admin of the server.
BTW I am running SQL 2005 SP3 on a Windows 2003 server. Any suggestions on how to fix it?

Thanks,

TKE402

Calling [sqlcmd] via PowerShell & Passing a Path like C:\Test\Test\ does not work?

Thu, 19 Nov 2009 12:23:15 Z

Hi,

I'm using a PowerShell script to execute a custom.sql script.

If:

$PathToMdf = "C\TEST"
$PathToMdf = "C\TEST\"

The this line works:

&'sqlcmd' -v PathToMdf = "'$PathToMdf'" PathToLdf = "'$PathToLdf'" -S $server -d $masterDatabase -E -b -i $script_01

BUT

If:

$PathToMdf = "C:\TEST"
$PathToMdf = "C:\TEST\"

Then the line:

&'sqlcmd' -v PathToMdf = "'$PathToMdf'" PathToLdf = "'$PathToLdf'" -S $server -d $masterDatabase -E -b -i $script_01

crashes with this exception message:

Sqlcmd: ':'' : Invalid argument. Enter '-?' for help etc.

Why can I not pass in a parameter that contains ":" ?

I.W Coetzer

Import/Export data with SQL Server 2005 Express

Mon, 05 Dec 2005 03:26:09 Z

Hello folks!
I have installed SQL Server 2005 Express and SQL Server Management Studio Express. Everything looks ok and works fine, but I can't find the Data Import/Export Wizard. Can anyone tell me how to Import/Export data?

Thank you!!!

SQL Server Management Studio 2008 - intellisense

Wed, 30 Jul 2008 23:50:23 Z

Hi, I installed SQL Server Management Studio 2008 Enterprise but the intellisense is not working. I enabled it but still doesn't work. I'm using management studio 2008 to connect to SQL Server 2000 databases on the network.

Any ideas?

Thanks,

system error 126

Fri, 16 Sep 2005 17:24:01 Z

I'm getting this error when trying to run Query Analyzer

Server Msg 160, Level 16, State 1.
Specified driver could not be loaded due to system error 126 (SQL Server)

This is a new SQL Server 2000 install on a PC that has had different versions of SQL Server installed previously, including 2005. I'm assuming this has to do with an incomplete uninstall. Is there a fix or workaround for this?

How Can I Securely Call A Job Remotely

Fri, 20 Nov 2009 20:17:49 Z

How can I securely call a SQL Agent Job which Kicks off a SSIS package from an ASP.net web application. I've tried just using the included stored procedure but I can't figure out the permissions (I want the user to only be able to call specific jobs and packages). Any ideas?

MSSQL in WINPE

Thu, 19 Nov 2009 10:42:12 Z

Is it possible to run MSSQL Server in WINPE. I have need to run an application that is in compitable with VISTA but needs MS SQL Server Desktop Engine to work. I think it will be posible to install the application along woth MSDE in a WINPE environment and run it from there as a live CD. Please need advice

NEWSEQUENTIALID()

Fri, 14 Apr 2006 18:55:34 Z

I'm trying to modify my default value for GUIDs in DB, currently using newid() for default.

In management studio, click on modify and in the table designer for the default value I entered newsequentialid() and got the following error.

Error validating the default for column "xxxx".

I would like to have my tables that are using guids, have newsequentialid as the default value. When read on this new function it says can only be used with default value, but can't get that to work. Any ideas?

thanks

Query an MS Exchange store as a linked server?

Fri, 20 Nov 2009 16:28:18 Z

A business partner is emailing data to us, and I would like to extract it directly from the MS Exchange 2003 store via SQL Server 2005. I have my regular expressions in place to pull the data out of messages, but I still can't get to the messages themselves! I spent all day yesterday chasing down threads of information, but haven't yet put all the pieces together into a viable solution. Here's the pertinent information:

Exchange server: mail01.example.com
SQL Server: sql01.example.com
Exchange mail account: testresults@example.com

Using SQL Server Management Studio, I was able to create a linked server object to Exchange, as follows:

Name: EXCHANGE
Product: Exchange OLE DB provider
Provider: Search.Collator.DSO
Data_Source: ExOLEDB.DataSource
Location: mail01.example.com
Provider_String: Provider=ExOLEDB;Persist Security Info=True;Integrated Security=SSPI;Trusted_Connection=Yes;
Catalog: NULL

SSMS says that I have successfully connected to the linked server.

Here's where I am stumped: I have a test query to the Exchange store in SSMS as follows, just trying to retrieve sender addresses:

SQL Code:

SELECT
 Convert(
nvarchar(
50
)
, "urn:schemas:httpmail:from"
)
 Sender
FROM
 OpenQuery(
Exchange, 'SELECT "urn:schemas:httpmail:from" 

FROM ".\t
estresults\i
nbox"'
)

SSMS returns the following message:

SQL Code:

OLE DB provider "Search.CollatorDSO"
 FOR
 linked server "Exchange"
 returned message "Column does not exist."
.
Msg 7321
, Level 16
, State 2
, Line 1

An error occurred while preparing the query "SELECT "
urn:schemas:httpmail:FROM
" 

FROM "
.\testresults\inbox""
 FOR
 execution against OLE DB provider "Search.CollatorDSO"
 FOR
 linked server "Exchange"
.

Any thoughts as to what I'm doing wrong? I get the idea that I have not described the correct path to the user account\Inbox, but it could be ANYTHING else at this point.

Will probably cross-post in the Exchange Server forum, for which I apologize. :-) TIA for your help!