Hello,

Cechk if yor data source is valid. In your FoodMart database, goto Data Sources and Right Click for Edit. and then test connection.

U can select the columns from table and use FOR XML clause to get data in XML format

E.g.

SELECT Customers.CustomerID, Orders.OrderID, Customers.ContactName

FROM Customers, Orders

WHERE Customers.CustomerID = Orders.CustomerID

FOR XML AUTO

Regd storing data...

SQL server doesnt support encryption for storing password in user tables.

Pl. have a look at following articles for reference

http://www.sqlservercentral.com/columnists/rsharma/comencrytptpw.asp

http://www.sqlservercentral.com/columnists/lsmith/usingjavatoencryptpasswords.asp

http://www.sqlservercentral.com/columnists/bknight/encryptfunction.asp

You can create a maximum of 16379 security accounts for a database. The maximum number of roles that you can create for a database is 16367.

You use the sp_addrole stored...

Your update statement should be

SQLStmt = "UPDATE helpdesk SET progress = '" & txtProgress & "' where SupportID ='" & LogNo & "'"

The DTS package can be modified by the owner only, you cant share it. Steves solution will also do.

I guess this might be useful for you.

http://www.sqlservercentral.com/columnists/sjones/tamethosestringspart7.asp

u can give him OLAP Admin rights. The OLAP admins can't change the data from database. They can create cubes only using data.

Have u tried processing the cube?

if it processes successfully and still u r unable to browse pl. use the workaround given in KB document

http://support.microsoft.com/support/kb/articles/Q259/2/88.ASP

I guess u forgot to quote the message above Unspecified error. Service pack might not be an issue. But if you have installed .net studio on the machine then u...

Microsoft is releasing a Type 4 JDBC driver for SQL Server 2000. It's based on code licensed from Merant.

http://www.microsoft.com/presspass/press/2001/Sep01/09-25MerantPR.asp

Download the beta here:

http://www.microsoft.com/sql/downloads/default.asp

There is no way to copy/export DTS package. U can use Save As from Enterprise Manager option to Save package to other server or on to file which u can...

Hi

Just check if the Full text search is enabled or not.

In Enterprise Manager go to Support services and start Full Text Search.

I think this will solve ur problem.

Do u mean to say using browser? ..Not possible..

What I considered is atleast user can do telnet/connect through pcanywhere and run the script.

quote:

---