Search results for query: *

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.

We use Crystal Reports. Our users like it.

When creating a credential for a SQL server Agent job proxy, you can create it within Security->Credentials in the GUI and specify a name, windows login and password. In T-SQL the create credential command does not have parameters for linking a login and password to a credential name. How is...

Is there a GUI way of identifying the backup devices that make up a media set? I can see which devices are used as a media set for a database but not how a media set is defined outside of a database.

That explains it. The we ahve are a bit out of date and I could not find much info on books online.

We need to import lots of data to SQL server 2005. BCP is recommended everywhere as the fastest method. Triggers and constraints are not applied by default but does it improve performance to still drop constraints and triggers during the import? Various sites talk about turning on the 'SELECT...