content of REPLDATA directory

Hi!
There are collecting snapshot agents (SQL7.0) generated files in the separate directories (named like 20030923020007, 20030716020008, and so on) in my ReplData directory.
Why does count of such directories increase without interruption?
Can I delete directories with old date of modifying from my C:\MSSQL7\REPLDATA\unc\ directory?When a snapshot is recreated, SQL will make a new subfolder with datetime stamp as its name to put the data in Repldata folder. There should be a clean up job to delete the subfolder once the snapshot is delivered. My guess is the process has been interrupted so the cleanup step was not completed. You can delete the subfolder since it's no longer being used.

Content Manager Security

I have a user I have given permission to folder and reports as a
Content Manager, but when the user clicks on the security tab for a
folder or report they get an error of:
The permissions granted to user 'DOMAIN\USER_ID' are insufficient for
performing this operation. (rsAccessDenied)
I am an administrator on the machine and fall into the
BUILTIN\Administrators who are Content Managers, and have no problems
whatsoever in viewing and setting security.
What can I do to get this user permission short of making them an
administrator on the machine? Any help would be greatly appreciated.jdcamp,
Did you try wiggling the power cord on the server? Another one that
works for me is to open and close the CD-ROM drive 5 or 6 times then
restart the machine.
Hope I could help!
Mickey|||Are you kidding me? Does anyone have a serious answer on this matter?

Content Management System where everything is read from a database

Most content management systems I've seen have data from a database, and fixed template and background information held in ASP and XML files. Surely it would be easier and more centralised to have everything stored in a database?

I've created a simple content management system that does this using SQL Server 2003, and it does work, albeit a little slowly.

My intention is to develop this into a "proper" content management system that I could sell.

My question is is this a sensible idea to persue, from a technical perspective? Does SQL Server have the capability of supplying large amounts of data to web browser clients? Are there any other issues?

I've also just noticed that Microsoft appear to have added something similar to this type of functionality in the latest version of SQL: SQL 2005. Maybe I'm too late?

More details on my fledgling system are on:

http://dohat.com/dohatcms

Which itself is hosted on it.

Cheers.

Hi Neil
There are several content management systems commercially available. I believe some of them serve everything off a database. SQL Server 2005 has capability to provide results to requests via SOAP and also contains Reporting Services. I'm not sure if these are the capabilities you refer to.

- Christian Kleinerman
Program Manager
SQL Engine

Content Management System where everything is read from a database

Most content management systems I've seen have data from a database, and fixed template and background information held in ASP and XML files. Surely it would be easier and more centralised to have everything stored in a database?

I've created a simple content management system that does this using SQL Server 2003, and it does work, albeit a little slowly.

My intention is to develop this into a "proper" content management system that I could sell.

My question is is this a sensible idea to persue, from a technical perspective? Does SQL Server have the capability of supplying large amounts of data to web browser clients? Are there any other issues?

I've also just noticed that Microsoft appear to have added something similar to this type of functionality in the latest version of SQL: SQL 2005. Maybe I'm too late?

More details on my fledgling system are on:

http://dohat.com/dohatcms

Which itself is hosted on it.

Cheers.

Hi Neil
There are several content management systems commercially available. I believe some of them serve everything off a database. SQL Server 2005 has capability to provide results to requests via SOAP and also contains Reporting Services. I'm not sure if these are the capabilities you refer to.

- Christian Kleinerman
Program Manager
SQL Engine

Content in MSDE

We have installed a application with MSDE distributed. Is
it possible for us to have a look of the content in the
databases stored in MSDE ?
It is a standalone PC. Is it necessary for us to get the
SA password for accessing the data ? However, if the
vendor hasn't told us, what is the best way to handle it ?
Thanks
Hi,
If you are the Administrator of the OS then you could try accessing SQL
Server using Windows Trusted connection.
Login into OS using an admin account and from command prompt try this
OSQL -S servername -E
This will allow you to to sql prompt . There you can type all TSQL commands
to see the data.
Thanks
Hari
SQL Server MVP
"Daniel" <anonymous@.discussions.microsoft.com> wrote in message
news:0e2701c53fc4$d68d94f0$a501280a@.phx.gbl...
> We have installed a application with MSDE distributed. Is
> it possible for us to have a look of the content in the
> databases stored in MSDE ?
> It is a standalone PC. Is it necessary for us to get the
> SA password for accessing the data ? However, if the
> vendor hasn't told us, what is the best way to handle it ?
> Thanks
|||"Daniel" <anonymous@.discussions.microsoft.com> schrieb im Newsbeitrag
news:0e2701c53fc4$d68d94f0$a501280a@.phx.gbl...
> We have installed a application with MSDE distributed. Is
> it possible for us to have a look of the content in the
> databases stored in MSDE ?
Thats what databases are designed for

> It is a standalone PC. Is it necessary for us to get the
> SA password for accessing the data ? However, if the
> vendor hasn't told us, what is the best way to handle it ?
No not nocessarily, you can also use Windows Authentification to connect to
the database. As a local administrator you are autom. in the system
administrators group (if you didnt change it so far).
try using OSQL connection with the Parameter -E, there you can fire all your
Statements you want to:
If Windows Auth is not activated try changing it via EM or if not applicable
though registry:
http://groups.google.de/groups?q=reg...phx.gbl&rnum=1
HTH, Jens Smeyer.

> Thanks

Container content edit wierdness

I attempted to move some tasks into a new sequence container. It failed saying element cannot be found in a collection. Now I find that visually the tasks do not appear in the container. But in some ways they are. I can not try to move the tasks to the container, or I get the same "element can not be found". If I execute the container, the tasks outside the container run.

I thought to CUT and PASTE my tasks, but then it says "The package contains one or more event handlers for this task. Deleting the task will also delete the event handlers and the event handler context."Good luck with this one. I hope others have found a solution, or perhaps SP2 fixes it. Which version of SSIS are you using? I have the same problem and fight with that all of the time.

(Sorry, I know that's not what you wanted to hear.)|||

Closing and reopening BIDS usually fixes it for me!!

-Jamie

|||Opening and closing BIDS did not help me.

I took a chance, and ignored the cut/paste failure. I am back in business now.|||Yet another problem is SP2 update fails for me. Hoping this might fix it, but I was forced to look for a work around instead.

Thanks for sharing your experience.