Recent content by rebelknight

I found that I needed to backup to the UNC and share name. \\TargetServer\MyShareName\MyTargetFolder\

OK sorted it. Setting any level of password encryption does retain the password in the package. The pakage was falling over on a second error which I had not picked up.

I've read that setting a password against the package to encrypt it will save the password but it has not worked for me. Anybody managed to achieve this?

Thanks all.

Hmmmm. I had considered that but it semed less secure to store connection details in an XML file rather than include it in the package. However I suppose there is no difference but it seems a drag to now have to use two files to set up a T-SQL task that DTS could have done in just one .dts...

I have a straight forward BIDS developed package that performs an 'Execute T-SQL Statement' followed by a File System Task. It works fine when I run it in BIDS. I have imported the package to SQL Server as a File System package and set up an SQL Agent scheduled job to run it. The problem is...

There is a share on a seperate file server that my SQL Server machine can access. When I sign on to the SQL Server I can see the share in windows and copy files toi and from it within file explorer. However, when I browse for the drive letter assigned to the mapping from SQL Serverfor any...

I have inherited a set of Visual Studio ASP.Net pages that I have difficulty understanding. The key page is set to have a CodeBehind aspx.vb page which I understand. The aspx HTML page also has <% %> script lines that for the most part is client side code to do tasks such as set the first...

Yea thats what I guessed.

When creating a service broker queue you can specify the procedure to run when a message is received on the queue with the ACTIVATION parameter list. The default status is for it to be switched on. What is the default context for the procedure to run? You can specify EXECUTE AS but if you do...

I see. Thanks.

Are full text indexes backed up in a BACKUP command? I assume the are as they can be allocated a filegroup?

Ahhh hell. I misread the books online. Scratch this request guys.

If I create a snapshot database and then use it to revert the original database back to its snapshot state, does the snapshot get dropped or must I do that manually?

I don't work with it but if I remember correctly, Workgroup is the same as Express but with SQL Agent and Log Shipping capabilities. It also makes use of more CPU's and memory and does not have a databse size limit.