How can you create a Users and Roles script from old database. There is no way to create a User and Roles script on the database.

Thanks for the reply. I have to create SQL login for some other reasons. I don't know if we can transfer access password to SQL login password

I used sp_spaceused stored procudure and got following result. I check the transaction log file on EM and it did not reduce the size.

eXpress739.38 MB15.55 MB

182544 KB169440 KB3224 KB9880 KB

My...

when I check the transaction log file on the folder I see reduction in size but when I see transaction log in the enterprise manager, there is no reduction in...

I use dbcc log(dbname) and get following result. I don't know what these values represent for.

0003a9f0:000000a4:0001LOP_BEGIN_XACT LCX_NULL ...

Thanks Allen,

I checked the transaction log backup and it's working fine but when I see size of the log file in Enterprise Manager it's still same even after the backup....

Thanks a lot. I tried select command but it seems to me that there is a limit using fields in the select command. I am using following syntax.

SELECT ' '+CHAR(13)+CHAR(10)+

...

Thanks for your reply

I mapped the network drive and still getting an error.

Lets say that I have two sqlserver. SQL1 and SQL2.

SQL1 server is my local machine and I registered...

Thanks Frank. You are the man.

I modified your script according to my requirement.

Can you please let me know how to add more columns in excel file. your script will add...

Thanks for the reply but how can I pass the input parameter from the client side.

Actually, I have created stored procedure which accept two parameters and returns the result and...

Thanks for the reply.

Actually, I have created a stored procedure with two parameter which return data and I want that data should be transfer to Excel file whenever the stored...

There was only one group EVERYONE in the security tab of two files MSMDREP and MSMDQLOG and have full control. I then added OLAP administrator group in the security and...

I checked those two files which you have mentioned by right clicking on the file and then click on properties option and then click on security tab. I see all...

Thanks for your reply.

I already added user in the OLAP administrator group but still getting the same error.

Thanks for your update on the issue. I will do that.

Yes, I am talking about both application and technology. I was told to implement Dashboard technology. I have no idea...