Hi Steve,

Yes it is added to the group IIS_WPG (windows) group on the IIS Server. I have made the changed via Reporting Service Configuration tool.

Thanks Steve.

The document talks about the Window service account details.

Here we have changed the Web service identiry to run under a domain account which is same as the windows service...

SQL Logins works as I mentioned earlier. But I cannot use SQL logins as it depends on some other stuffs.

So when I use windows login, how do i make it...

any answer for this prblem?

Any idea on how to resolve this issue as in the shared server the login is coming as NT AUTHORITY\ANONYMOUS LOGON using NTLM

I have used my windows account to do the xp_cmdshell which succeeded. but using the same account for bulk insert it failed

Yes I am able to view the file in the network share using

exec master..xp_cmdshell 'Dir \\servername\sharename\' and test if that can "reach" the file.

But the Bulk insert is giving the...

It could be like during your maintenance task (reindex might cause your data file to grow during the reindexing, but it will not shrink the datafile but will show as...

If both the databases are in the same machine, loopback situation arises and it will not be supported..

am i right ?

OK agreed.

But the fill factor which we used to specify during the index creation or index rebuilding is for the index pages right ? not for the data pages

am...

so, i am understanding that, Non clustered index will have an index page, which they will refer to find the location of data page in the heap.

Clustered index will not...

Thanks a lot

ok thankx,

but if the index is already created , we need to drop the index and recreate it right ?

ok thanks

OK, thankls

Actually my aim is to provide a search facility for our Web Server.

Microsoft Index Server and ASP Search is not meeting our requirement. so i thought of taking all...

i want to read the text only