Viewing 15 posts - 511 through 525 (of 2,636 total)
You can't right-click on a package in SQL 2005 Management Studio and create a job like you could in SQL 2000 Enterprise Manager. In SQL 2005, you have to...
February 13, 2009 at 10:51 am
What I like to do is open the package in DTS Designer and execute each step individually. Since it seems to export data to some of the .xls files,...
February 12, 2009 at 5:15 pm
If you have Enterprise Edition, MS log shipping is available and you can implement it using a wizard. If you have Standard Edition, these articles walk you through setting...
February 12, 2009 at 2:44 pm
Database mirroring isn't available before SQL 2005. Maybe you could use log shipping?
February 12, 2009 at 10:20 am
That would work, but remember that msdb also contains jobs and backup information. A less intrusive way to recover DTS packages would be to export them to files or...
February 12, 2009 at 10:14 am
You can't import SQL 2000 system databases into SQL 2005. IMO, the best option for moving logins and jobs is to script them out in SQL 2000 and run...
February 12, 2009 at 10:07 am
Maybe what you're experiencing is the ability in SQL 2005 to create a user without mapping it to a login. See CREATE USER in BOL and this article: http://blogs.msdn.com/raulga/archive/2006/07/03/655587.aspx.
I...
February 12, 2009 at 9:57 am
bisso21 (2/10/2009)
February 11, 2009 at 12:09 pm
I don't know what "$" means. I asked who the login belongs to because, if the connection manager in the package specifies Windows authentication, it will use the credentials...
February 10, 2009 at 9:04 am
It looks like a login failure one one of the servers. Is the login 'NDIMS\NDIMS-DB13$' you or the SQL Server Agent account? Does it have access to both...
February 9, 2009 at 4:11 pm
I don't have a script, but I can tell you that you'll find most, if not all, the data you want in two views in msdb: backupfile and backupset.
Also, some...
February 9, 2009 at 10:17 am
On way is to use the MS recommended method (see "deploying packages in BOL) and build an Integration Services project in BIDS to create a package depoyment utility that specifies...
February 9, 2009 at 9:54 am
See the post by Vinu Verma above where he lists the steps to open a package in Businees Intelligence Development Studio (BIDS; he transposed a couple of the letters).
February 6, 2009 at 9:37 am
raphi.levine (2/4/2009)
February 4, 2009 at 5:30 pm
No. A logical backup device isn't explicitly associated with a database. The only way to imply an association is by naming and by using the device in backup...
February 3, 2009 at 3:09 pm
Viewing 15 posts - 511 through 525 (of 2,636 total)